Database initialization failed after attach the database.

[Former Member]

Hello Everyone,

I have a problem after detaching the database and attaching it again (I moved the database to another partition because of shortage of disk space). Then, I find that the system can not start. (I've two systems and now neither of them could start). The error seems very similar.

In the pure java system(netweaver 04s) log: jvm_bootstrap.out,

com.sap.engine.bootstrap.synchronizationException: Database Initializtion Failed! Check database properties.

..........

..........

com.sap.engine.frame.core.configuration.configurationException: Error while connecting to DB.

.......

........

Caused by: java.sql.SQLException: [NWMss] [SQLServer JDBC Driver] [SQLServer] Login failed for user 'SAPBP0DB'.

...........

..........

In pure ABAP system(Netweaver 04s) log: dev_w12:

openoledbConnection: MARS property was not set.

openoledbConnection: line 23722. hr: 0x8000ffff login failed for user 'CNDT50083414\SAPServiceBE0'.

sloledb.cpp [openoledbConnection, line 23722]: Error/Message: (err 18456, sev 0), Login failed for user 'CNDT50083414\SAPServiceBE0'.

..........

sloledb.cpp [openoledbConnection, line 23722]: Error/Message: (err 0, sev 0), Invalid string connection attribute.

..............

Is this because the DB not started? In Windows Services, I found 'MSSQLServer' is started.

How can I trace down to this problem? I don't have much idea on DB...

All your kindly help is greatly appreciated.

Best Regards,

[Former Member]

Hi Dennis Wu,

i am in need of the procedures or the best practices for the sap running on sql server, to move the sap database from one partition to the different (other) partition ( we do have installed and implemented the new SAN storage, so i need to move the sap database to the san partition (LUNs) which in turn showing me as a local drive in the sap server) so kindly forward me the documents or the necessary links to find out the good resources to move the sql database to the other partition with out being sap fail. kindly send me on: sazaed at gmail dot com

thanx in advance.

regards,

saza.

[former_member227600]

Hi,

Please paste dev_w0 file here .

karan

[Former Member]

Hi Karan,

Thank you for your reply. I attach the dev_w0 file here:

-

---

trc file: "dev_w0", trc level: 1, release: "700"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, MJ

*

B

B Tue Sep 23 13:16:15 2008

B create_con (con_name=R/3)

B Loading DB library 'C:\usr\sap\BE0\DVEBMGS02\exe\dbmssslib.dll' ...

B Library 'C:\usr\sap\BE0\DVEBMGS02\exe\dbmssslib.dll' loaded

B Version of 'C:\usr\sap\BE0\DVEBMGS02\exe\dbmssslib.dll' is "700.08", patchlevel (0.158)

B New connection 0 created

M sysno 02

M sid BE0

M systemid 562 (PC with Windows NT)

M relno 7000

M patchlevel 0

M patchno 159

M intno 20050900

M make: multithreaded, Unicode, 64 bit, optimized

M pid 1704

M

M kernel runs with dp version 237000(ext=110000) (@(#) DPLIB-INT-VERSION-237000-UC)

M length of sys_adm_ext is 576 bytes

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1704) [dpxxdisp.c 1316]

I MtxInit: 30000 0 0

M DpSysAdmExtCreate: ABAP is active

M DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M DpShMCreate: sizeof(wp_adm) 21008 (1616)

M DpShMCreate: sizeof(tm_adm) 5912624 (29416)

M DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

M DpShMCreate: sizeof(comm_adm) 552080 (1088)

M DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

M DpShMCreate: sizeof(slock_adm) 0 (104)

M DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

M DpShMCreate: sizeof(file_adm) 0 (72)

M DpShMCreate: sizeof(vmc_adm) 0 (1864)

M DpShMCreate: sizeof(wall_adm) (41664/36752/64/192)

M DpShMCreate: sizeof(gw_adm) 48

M DpShMCreate: SHM_DP_ADM_KEY (addr: 0000000011080050, size: 6604928)

M DpShMCreate: allocated sys_adm at 0000000011080050

M DpShMCreate: allocated wp_adm at 0000000011082150

M DpShMCreate: allocated tm_adm_list at 0000000011087360

M DpShMCreate: allocated tm_adm at 00000000110873C0

M DpShMCreate: allocated wp_ca_adm at 000000001162ABF0

M DpShMCreate: allocated appc_ca_adm at 00000000116309B0

M DpShMCreate: allocated comm_adm at 00000000116328F0

M DpShMCreate: system runs without slock table

M DpShMCreate: system runs without file table

M DpShMCreate: allocated vmc_adm_list at 00000000116B9580

M DpShMCreate: allocated gw_adm at 00000000116B9600

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 00000000116B9630

M DpShMCreate: allocated wall_adm at 00000000116B9640

M rdisp/queue_size_check_value : -> off

M ThTaskStatus: rdisp/reset_online_during_debug 0

X EmInit: MmSetImplementation( 2 ).

X MM global diagnostic options set: 0

X <ES> client 0 initializing ....

X Using implementation view

X <EsNT> Using memory model view.

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M ThInit: running on host CNDT50083414

M

M Tue Sep 23 13:16:16 2008

M calling db_connect ...

C Thread ID:6104

C Thank You for using the SLOLEDB-interface

C Using dynamic link library 'C:\usr\sap\BE0\DVEBMGS02\exe\dbmssslib.dll'

C dbmssslib.dll patch info

C patchlevel 0

C patchno 158

C patchcomment Corrections of odbc-based dbsl: dsql: optype, DSN (1135165)

C np:(local) connection used on CNDT50083414

C CopyLocalParameters: dbuser is 'be0'

C

C Tue Sep 23 13:16:17 2008

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: MARS property was not set.

C OpenOledbConnection: line 23722. hr: 0x8000ffff Login failed for user 'CNDT50083414\SAPServiceBE0'.

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 18456, sev 0), Login failed for user 'CNDT50083414\SAPServiceBE0'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: line 23722. hr: 0x8000ffff Login failed for user 'CNDT50083414\SAPServiceBE0'.

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 18456, sev 0), Login failed for user 'CNDT50083414\SAPServiceBE0'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: line 23722. hr: 0x8000ffff Login failed for user 'CNDT50083414\SAPServiceBE0'.

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 18456, sev 0), Login failed for user 'CNDT50083414\SAPServiceBE0'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn to np:(local).

C Retrying without protocol specifier: (local)

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: line 23722. hr: 0x8000ffff Login failed for user 'CNDT50083414\SAPServiceBE0'.

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 18456, sev 0), Login failed for user 'CNDT50083414\SAPServiceBE0'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: line 23722. hr: 0x8000ffff Login failed for user 'CNDT50083414\SAPServiceBE0'.

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 18456, sev 0), Login failed for user 'CNDT50083414\SAPServiceBE0'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C Provider SQLNCLI could not be initialized. See note #734034 for more information.

C Using provider SQLOLEDB instead.

C OpenOledbConnection: line 23722. hr: 0x8000ffff Login failed for user 'CNDT50083414\SAPServiceBE0'.

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 18456, sev 0), Login failed for user 'CNDT50083414\SAPServiceBE0'.

C Procname: [OpenOledbConnection - no proc]

C sloledb.cpp [OpenOledbConnection,line 23722]: Error/Message: (err 0, sev 0), Invalid connection string attribute

C Procname: [OpenOledbConnection - no proc]

C failed to establish conn. 0

B ***LOG BY2=> sql error -1 performing CON [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> Login failed for user 'CNDT50083414\SAPServiceBE0'. [dbsh#2 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error -1 performing CON [dblink#5 @ 431] [dblink 0431 ]

B ***LOG BY0=> Login failed for user 'CNDT50083414\SAPServiceBE0'. [dblink#5 @ 431] [dblink 0431 ]

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

M in_ThErrHandle: 1

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

M

M Info for wp 0

M

M pid = 1704

M severity = 0

M status = 0

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 mode_cleaned_counter = 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 attachedVm = no VM

M

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

M *

M * LOCATION SAP-Server CNDT50083414_BE0_02 on host CNDT50083414 (wp 0)

M * ERROR ThInit: db_connect

M *

M * TIME Tue Sep 23 13:16:17 2008

M * RELEASE 700

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 10724

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 724]

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

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 1704) [dpnttool.c 333]