cannot run JSPM

[Former Member]

Hi,

I am trying to run JSPM, but it fails with error:

Cannot initialize application data. Could not detect database. Check if it is running. Could not execute DMT command dbinfo with arguments...

DMT.LOG:

Oct 25, 2013 4:35:57 PM [Info]: Bootstrapping configuration has been started.

Oct 25, 2013 4:35:57 PM [Info]: Bootstrapping common configuration has been completed.

Oct 25, 2013 4:35:57 PM [Info]: Bootstrapping configuration for UNX has been completed.

Oct 25, 2013 4:35:57 PM [Info]: Bootstrapping configuration for 700 has been completed.

Oct 25, 2013 4:35:57 PM [Info]: Bootstrapping configuration has been completed.

Oct 25, 2013 4:35:57 PM [Info]: Program name DMT, version 0.9, release 6.40.

Oct 25, 2013 4:35:57 PM [Info]: Software packages info:

Oct 25, 2013 4:35:57 PM [Info]: Package com.sap.sdt.dmt: version 1.0

Oct 25, 2013 4:35:57 PM [Info]: Current command is dbinfo.

Oct 25, 2013 4:35:57 PM [Info]: Description:

Oct 25, 2013 4:35:57 PM [Info]: Prints out information of the specified DB

Oct 25, 2013 4:35:57 PM [Info]: Parameter: variable-handler=/usr/sap/DS1/DVEBMGS90/j2ee/JSPM/config/DBINFO.XML

Oct 25, 2013 4:35:57 PM [Info]: Option: rootdir=/usr/sap/DS1/DVEBMGS90/j2ee/JSPM

Oct 25, 2013 4:35:57 PM [Info]: Option: descriptor=nodea2_DS1

Oct 25, 2013 4:35:57 PM [Info]: Option: logfile=/usr/sap/DS1/DVEBMGS90/j2ee/JSPM/log/log_2013_10_25_16_35_00/DMT_01.LOG

Oct 25, 2013 4:35:57 PM [Info]:

Oct 25, 2013 4:35:57 PM [Info]: Executing command dbinfo.

Oct 25, 2013 4:35:57 PM [Info]: Setting up the OpenSQL connection with secure store.

Oct 25, 2013 4:36:00 PM [Info]: Connection to SAPDS1DB has been established.

Oct 25, 2013 4:36:00 PM [Info]: Database product information:

Oct 25, 2013 4:36:00 PM [Info]: DB product name = DB2/AIX64

Oct 25, 2013 4:36:00 PM [Info]: Vendor version information: SQL0905A

Oct 25, 2013 4:36:00 PM [Info]: Database ID DB6 has been extracted from product name DB2/AIX64.

Oct 25, 2013 4:36:00 PM [Info]: Could not execute command dbinfo.

Oct 25, 2013 4:36:00 PM [Info]: Start time: 2013/10/25 16:35:57

Oct 25, 2013 4:36:00 PM [Info]: Stop time : 2013/10/25 16:36:00

Oct 25, 2013 4:36:00 PM [Info]: Duration  : 0:00:03.318

Oct 25, 2013 4:36:00 PM [Error]: Error during execution.

Oct 25, 2013 4:36:00 PM [Error]: java.lang.NumberFormatException: For input string: "A"

Oct 25, 2013 4:36:00 PM [Error]: Could not read database metadata from the JDBC connection.

Oct 25, 2013 4:36:00 PM [Error]: Execution has been terminated. More information can be found in the log file /usr/sap/DS1/DVEBMGS90/j2ee/JSPM/log/log_2013_10_25_16_35_00/DMT_01.LOG.

Oct 25, 2013 4:36:00 PM [Error]: Program has finished with error. 1

It looks like it is a problem with version parsing.

Please

[Former Member · Accepted solution]

Hi Andrzej,

Please check the following note. Also, based on your log: Could not read database metadata from the JDBC connection, please check JdbcCon.log file and /usr/sap/DS1/DVEBMGS90/j2ee/JSPM/log/log_2013_10_25_16_35_00/DMT_01.LOG.

Note 914818 - JSPM: Could not detect database

Thanks

Adil

[Former Member · Accepted solution]

Hi Adil,

Thanks for you answer. All the information that are in DMT_01.LOG are in my previous post. I cannot locate JdbcCon.log and unfortunately none of the points in the Note 914818 seem to be relevant.

Thanks

Andrew

[Former Member · Accepted solution]

Hi Andrez,

The JdbcCon.log file is usually found uder /home/sidadm.  Also, please make sure that you have the correct password saved in Config Tool, Secure Store.  If you do not have correct password of Administrator in the Secure Store, please enter the correct password, save the Config Tool, and bounce the server.

Thanks

Adil

[Sriram2009 · Accepted solution]

Hi Andrew

Could you check the SAP KBA  1763578  - Error: java.lang.NumberFormatException: For input string: "sapms<SID>"

Regards

Ram

[Former Member · Accepted solution]

Hi,

Please check the below note.

Note 1738191 - DB6: NumberFormatException in AS Java update/upgrade

What is your system release. Looks to be 640. So try to update JSPM first using SDM.

Program name DMT, version 0.9, release 6.40

Thanks

Rishi Abrol

[Former Member · Accepted solution]

Hi,

1738191 is the note I was looking for. JSPM was 7.02 SP12, I have upgraded to SP14 and the problem is solved now.

Thanks for help.

Andrzej

[anandkarthik_raja]

Hi,

Note 1738191- DB6: NumberFormatException in AS Java update/upgrade

Or else you can go for update of DB version.