DB is not getting restarted

[Former Member]

hi guys

'm installing nw2004s sr1 while installing in the 7 step DB downtime configuration it restarts My DB ( SQLserver) after that DB is not running..it's not getting started.. pls tel the solution..

thanks

kamal

[Former Member]

Hi ,

it seems that your mssqlserver is not installed properly try to uninstall it do it once again and try to run mssql server from sqlserver.sap.vbs which will install the automatically with the latest patch once the sqlserver is installed open the sqlserver and enable the sqlsever and windows authentication mode .and change the default password go to logins >sa> right click properties login and change the password.

hopefully this will resolve ur error.

Regards

Zia

[Former Member]

Hi Kamal,

You installed sqlserver before sap installation or at the time of installation.

Find that Services.msc in run, that sqlserver services is running or not. If it is running ok check the sapinst.log file, otherwise check causes for sqlsever log files.

Thanks and Regards,

Sridhar

[Former Member]

Hi,

Try if u can manually open the SQL Database Manager and connect to it manually

[JPReyes]

I don't think your java version is correct try using 1.4.2_12.

Also SAP runs with a very specific MSSQL collation so check that your installation was done correctly.

Regards

Juan

[Former Member]

Can you please check the following files for error

Keydb.xml - ie, if the installation fails.

Or check in sapinst.log for what happened during installation..

Normally this is ths path C:/program files/sapinst_instdir/ERP/SYSTEM/MSS/Central/AS/ sapinst.log

If this is problem after installation phase please check the following DB logs

knldiag

knldiag.err

knldiaf.old

they should be in sapdb/data/work/SID directory..

Hope this is useful

Thanks,

Ajith

[Former Member]

like in oracle, does a listener exist in MSSQL too ?

[sunny_pahuja2]

Hi Kamal,

without logs its very difficult to predict the error and solution.

thanks

Sunny

[Former Member]

hi sunny

Execution of the command "C:\j2sdk1.4.2_13\bin\java.exe -classpath C:\PROGRA_1\SAPINS1\NW04S\SYSTEM\MSS\CENTRAL\AS\install\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/lib/iaik_jce.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/jload.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/antlr.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/exception.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/jddi.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/logging.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/offlineconfiguration.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/opensqlsta.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/tc_sec_secstorefs.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/base.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/util.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/sqlserver.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/spy.jar -sec EP1,jdbc/pool/EP1,
home/sapmnt/EP1/SYS/global/security/data/SecStore.properties,
home/sapmnt/EP1/SYS/global/security/data/SecStore.key -dataDir "D:/setup/Java Component\JAVA_EXPORT\JDMP" -job C:\PROGRA_1\SAPINS1\NW04S\SYSTEM\MSS\CENTRAL\AS\IMPORT.XML -log jload.log" finished with return code 1. Output:

java version "1.4.2_13"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_13-b06)

Java HotSpot(TM) Client VM (build 1.4.2_13-b06, mixed mode)

Oct 30, 2009 5:40:50 PM com.sap.inst.jload.Jload main

INFO: Jload -sec EP1,jdbc/pool/EP1,
home/sapmnt/EP1/SYS/global/security/data/SecStore.properties,
home/sapmnt/EP1/SYS/global/security/data/SecStore.key -dataDir D:/setup/Java Component\JAVA_EXPORT\JDMP -job C:\PROGRA_1\SAPINS1\NW04S\SYSTEM\MSS\CENTRAL\AS\IMPORT.XML -log jload.log

Oct 30, 2009 5:40:51 PM com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

Oct 30, 2009 5:40:51 PM com.sap.inst.jload.Jload logStackTrace

SEVERE: java.sql.SQLException: [SAP_NWmss][SQLServer JDBC Driver]Unable to connect. Invalid URL.

at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.sap.nwmss.jdbc.base.BaseDriver.connect(Unknown Source)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)

at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)

at com.sap.inst.jload.Jload.main(Jload.java:580)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

ERROR 2009-10-30 17:40:51

CJS-30049 Execution of JLoad tool 'C:\j2sdk1.4.2_13\bin\java.exe -classpath C:\PROGRA_1\SAPINS1\NW04S\SYSTEM\MSS\CENTRAL\AS\install\sharedlib\launcher.jar -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/lib/iaik_jce.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/jload.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/antlr.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/exception.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/jddi.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/logging.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/offlineconfiguration.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/opensqlsta.jar;C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/install/sharedlib/tc_sec_secstorefs.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/base.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/util.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/sqlserver.jar;D:/usr/sap/EP1/SYS/exe/uc/NTI386/mssjdbc/spy.jar -sec EP1,jdbc/pool/EP1,
home/sapmnt/EP1/SYS/global/security/data/SecStore.properties,
home/sapmnt/EP1/SYS/global/security/data/SecStore.key -dataDir "D:/setup/Java Component\JAVA_EXPORT\JDMP" -job C:\PROGRA_1\SAPINS1\NW04S\SYSTEM\MSS\CENTRAL\AS\IMPORT.XML -log jload.log' aborts with return code 1.<br>SOLUTION: Check 'jload.log' and 'C:/PROGRA_1/SAPINS1/NW04S/SYSTEM/MSS/CENTRAL/AS/jload.java.log' for more information.

ERROR 2009-10-30 17:40:51

FCO-00011 The step importJavaDump with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_Jload|ind|ind|ind|ind|9|0|importJavaDump was executed with status ERROR .

[sunny_pahuja2]

Hi,

Have you checked listener is up and running ?

Thanks

Sunny