Background jobs failing

[nanda_kumar21]

Hi,

We have solman 7.0 with EHP1/Oracle on HP-UX.

In SM37 i see the following background jobs failing.

SM:MOVE TO ARCHIVE QUEUE

SM:REMOVE INCONSISTENCIES

SM:SESSIONS RESET

for the job SM:Move to Archive Queue the ST22 error analysis reads

 A RAISE statement in the program "CL_DSMOP_SOLUTION=============CP" raised the
  exception
 condition "COULD_NOT_OPEN_DATA_MODEL".
 Since the exception was not intercepted by a superior
 program, processing was terminated.
 Short description of exception condition:
 For detailed documentation of the exception condition, use
 Transaction SE37 (Function Library). You can take the called
 function module from the display of active calls.

for the job SM:Remove Inconsistencies the job log reads:

Job started
Step 001 started (program RDMD_REMOVE_INCON, variant , user ID SOLMAN_BTC)
rdmd_delete_deleted_marked
No authorization.
Job cancelled after system exception ERROR_MESSAGE

for the job SM:SESSIONS RESET, the job log reads:

Job started
Step 001 started (program RDSMOP_SESSSION_RESET, variant &0000000000075, user ID NKUMAR)
Sessions in solution SAP Solution Manager Reference already have the correct status
Sessions in solution SAP CUTOMER RELATIONSHIP MANAGEMENT SOLUTION already have the correct status
Sessions in solution SAP BUSINESS INTELLIGENCE SOLUTION already have the correct status
Sessions in solution SAP PROCESS INTEGRATION SOLUTION already have the correct status
Sessions in solution SAP ECC SOLUTION already have the correct status
Sessions in solution SAP Solution already have the correct status
Sessions in solution Quality_Solution already have the correct status
Sessions in solution Development_Solution need to be reset
No sessions found for resetting in solution Development_Solution
Sessions in solution SAP Solution Manager Reference already have the correct status
Sessions in solution SAP CUTOMER RELATIONSHIP MANAGEMENT SOLUTION already have the correct status
Sessions in solution SAP BUSINESS INTELLIGENCE SOLUTION already have the correct status
Sessions in solution SAP PROCESS INTEGRATION SOLUTION already have the correct status
Sessions in solution SAP ECC SOLUTION already have the correct status
Sessions in solution SAP Solution already have the correct status
Sessions in solution Quality_Solution already have the correct status
Sessions in solution Development_Solution need to be reset
Session 0100000000116 of type CP_BPM is initial
Session 0100000000117 of type EWA_CUST is initial
Session 0100000000114 of type SELF_CBP is initial
Session 0100000000115 of type SELF_CON is initial
Session 0100000000129 of type SOL_CSA is initial
No sessions found for resetting in solution Development_Solution
Opening and closing session started. Session SM0100000000124
Internal session terminated with a runtime error (see ST22)
Job cancelled

Pls help to solve this issue

thanks

Nanda

[peter_baumgartner]

Hi,

were you able to solve this issue? I have the same dumps after updating my Dev system to SPS25!

It can't be an issue with the permissions, because I granted SOLMAN_BTC the profiles SAP_ALL and SAP_NEW and updated the Role SAP_SOLMAN_BTC according to your note. Nothing helped.

I don't know why, but I'm also unable to open any "Solution" because I have no wrights?! I Tx "solution_manager" I see no solutions and under Settings - connect to sap I get the error "No authorization to open the data model" with the longtext "You need the authorization object D_MD_DATA, which is, e.g. in profiles D_MD_DAT_SHW and D_MD_DAT_EDI"

--> So i made a new Role with the D_MD_DATA and gave this permission to solman_btc and my user - nothing helped.

Any ideas?

[Paul_Babier]

Hello,

Please open a new thead. Read rules of engagement - one question per message and don't tack a question on to someone else's question. Create your own question. This allows solved questions to be used as solutions in future. This lets you credit people for helping you.

Regards,

Paul

[Paul_Babier]

Hi Nanda,

One of the errors is clearly due to lack of authorization.

Please refer to the security manual for your release level and ensure the apporiate security objects have been assigned to user SOLMAN_BTC.

This should help.

Regards,

Paul

[nanda_kumar21]

Hi,

The user SOLMAN_BTC was not manually created, it was created during one of the initial steps in SOLMAN_SETUP.

According to the securtiy guide,

SOLMAN_BTC

Role SAP_SM_BATCH is automatically assigned, and contains all necessary authorization for batch

processing.

I checked in SU01 and solman_btc has that role assigned.

According to Snote 1314587, i shud import the new authorisation for the user SOLMAN_BTC only if all the jobs scheduled by that user fails, in my case,only 2 jobs fail, and rest complete successfully.

So i am worried that importing the authorisations will overwrite the preious authorisation and data and wat if it affects other background as well.

Pls tell me how to proceed.

thanks

Nanda

[Former Member]

Hello Nanda,

You will need to adjust the authorizations as per the note. You might want to create a new role and make the changes so that the old authorizations are not lost.

About the second job failure, you probably have a ABAP Dump. IF you double click on the line :

Internal session terminated with a runtime error (see ST22)

It will take you the dump. Solve this dump and the job should complete.

Regards

Amit