JSPM error - Could not detect database.

[Former Member]

Hi Gurus,

After installing my EP on a standalone system (AIX with DB2)

I try to run JSPM to deploy patches but encountered the following errors:

Trouble Ticket Log

.

.

The execution ended in error.

Cannot initialize application data.

Could not detect database. Check if it is running.

Could not save database descriptor <hostname>_<SID> to /usr/sap/<SID>/JC00/j2ee/JSPM/param/<hostname>_<SID>.xml. See previous messages.

File /usr/sap/<SID>/JC00/j2ee/JSPM/param/<hostname>_<SID>.xml not found.

.

.

JSPM log throws this:.

.

.

###Bootstrapping has ended.##

###Initializing JSPM data model...##

###Detected profile directory .#1#/usr/sap/<SID>/SYS/profile#

###Detecting the parameters of the database...##

.

.

I've deployed the latest JSPM via SDM and followed sap note 914818. But it didn't solve the problem. It's actually different problem as my JSPM didn't even reached DMT stage.

Anyone have any idea on this?(AIX with DB2) Points will be awarded!!

Best Regards,

Jansen

[former_member185954 · Accepted solution]

Hello Jansen,

Can you please check if the directory /usr/sap/<SID>/JC00/j2ee/JSPM/param/ exists and if the permissions are correct.

The /usr/sap/<SID>/JC00/j2ee/JSPM/param/ directory should be accessible to <sid>adm:sapsys, try giving full permissions and then reduce the permission as per your company policies.

Also check the following link:

http://help.sap.com/saphelp_nw70/helpdata/EN/cd/157842698edc54e10000000a155106/frameset.htm

And the following SAP Note: 891983, which is the central note for JSPM.

Regards,

Siddhesh

Edited by: Siddhesh Ghag on Apr 24, 2008 12:41 PM

[Former Member · Accepted solution]

Hi Siddhesh,

Thanks for your prompt reply but unfortunately I already given full permissions for the folder and files and it's still giving the errors.

SAP Note: 891983 didn't specifically mention my problems..too

[former_member185954 · Accepted solution]

Hello Jansen,

Can you post the following logs:

DMT.LOG, DMT.OUT and DMT*.ERR in current JSPM log directory.

Regards,

Siddhesh

[Former Member]

Just curious... might be not relevant, but worth to check

could you check your adm and db2 users in OS level ?

login using the ID and use ulimit -a command..

if the 1st 4 row its not unlimited, try to set it to unlimited.

Sof file descriptior , etc set to -1 and size set to 2097151

[Former Member]

Hi all,

I took the bitter pill....reinstalled the DB and EP and now it works...funny.

Anyway thanks for all the suggestion.

[Former Member]

I haven't worked on DB2 but I faced similar issues before.

This is mainly if you are running out of diskspace in the log

Like in Oracle (saparch / oraarch)do you have any in DB2, check that. Clear or move the logs. Check if the DB is down.

Also try start SDM (StartServer.sh) under /usr/sap/<SID>/<instance>/SDM/program

[Former Member]

Hi Siddhesh,

As mentioned before, based on the log the error occurs even before DMT start so I do not have any DMT. files in the JSPM log directory.

Hi Shaji,

I tried to run StartServer.sh in SDM but it prompted that SDM is already up. As for the DB logs I'll check if the archives are full but I doubt so as none of my db file systems are full.

Edited by: Jansen Low on Apr 25, 2008 4:13 AM