SAP CRM 2005 doesnu00B4t start: (DB-Connect 000256)

[Former Member]

Hi all

Everything was working fine until yesterday that I restarted. I haven't changed anything in the DB. I already upgraded the kernel (files sapexe and sapexedb). I did a R3trans -d and everything is right.

My dev_w0 log is the following:

M Thu Jun 12 16:06:26 2008

M calling db_connect ...

C Warning: Env(MSSQL_SERVER) [EOLO] <> Prof(dbs/mss/server) [<null>]. No value will be used.

C Warning: Env(MSSQL_SCHEMA) [cmr] <> Prof(dbs/mss/schema) [dbo]. Profile value will be used.

C Thread ID:3112

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'M:\usr\sap\CMR\DVEBMGS00\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 110

C patchcomment MSSQL: Connect error handling (1053754)

C np:(local) connection used on EOLO

C CopyLocalParameters: dbuser is 'dbo'

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C Provider Release:9.00.3042.00

C Using Provider SQLNCLI

C OpenOledbConnection: MARS property was set successfully.

C i'm dbo but there exists 1 users <> dbo with tables SVERS ==> connect terminated

M ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c 1426]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c 10283]

M

M Info for wp 0

M

M stat = WP_RUN

M waiting_for = NO_WAITING

M reqtype = DP_RQ_DIAWP

M act_reqtype = NO_REQTYPE

M rq_info = 0

M tid = -1

M mode = 255

M len = -1

M rq_id = 65535

M rq_source =

M last_tid = 0

M last_mode = 0

M semaphore = 0

M act_cs_count = 0

M csTrack = 0

M csTrackRwExcl = 0

M csTrackRwShrd = 0

M control_flag = 0

M int_checked_resource(RFC) = 0

M ext_checked_resource(RFC) = 0

M int_checked_resource(HTTP) = 0

M ext_checked_resource(HTTP) = 0

M report = > <

M action = 0

M tab_name = > <

M req.vm = no VM

M attachedVm = no VM

M

M *****************************************************************************

M *

M * LOCATION SAP-Server eolo_CMR_00 on host eolo (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Thu Jun 12 16:06:26 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10486

M * COUNTER 1

M *

M *****************************************************************************

M

M PfStatDisconnect: disconnect statistics

M Entering TH_CALLHOOKS

M ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c 720]

M *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c 260]

M Entering ThSetStatError

M ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M Entering ThReadDetachMode

M call ThrShutDown (1)...

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 2304) [dpnttool.c 327]

Please help!

Thanks,

Wadih

[Former Member · Accepted solution]

Hi,

you are running you system as dbo.

remove profile parameter dbs/mss/schema from DEFAULT.PFL

also remove MSSQL_SCHEMA from environment variable of your sidadm and SAPServiceSID users.

Check that it is removed by using the SAP MMC, right-mouseclick on the application server and choose All Tasks -> View Environment.

If necessary, remove value HKEY_LOCAL_MACHINE\SOFTWARE\SAP\<SID>\Environment\MSSQL_SCHEMA from the registry.

regards,

kaushal

[Former Member · Accepted solution]

Hi kaushal

I removed teh thing you told me but I'm having the same error. Also in the console in view tasks --> environment there's no schema on it.

What else I can do?

Thanks,

Wadih

[Former Member · Accepted solution]

Hi,

provide dev_w0 after removing parameter and restarting SAP server.

regards,

kaushal

[hanse_atik2 · Accepted solution]

Hi,

Have you got any solution to this problem: (DB-Connect 000256).

I have the same problem. It woudl be nice if you can share it with all this people here. Thanks

[Former Member · Accepted solution]

Hi!

In my case was a test system so the best solution was reinstalling CRM.

Sorry I couldn´t help more.

Wadih