DB13 Jobs - Are cancelled a second after they start to run.

[Former Member]

On the server the brtools run ok as ora<sid> and <sid>adm

Any advice on what to check?

[former_member204746 · Accepted solution]

there might be a mismatch between DB13 jobs and its SM37 counterpart.

I would delete all DBA* jobs in SM37, then delete contents of table SDBAP.

then, try running one job immediately. does that work? if not, supply logs again, yuo might have problem with OPS$ authentication.

one last thing, it might be time that you learn how to use that forum. I would read the following links:

http://www.sdn.sap.com/irj/sdn/crphelp

http://wiki.sdn.sap.com/wiki/display/SCNGUIDE/GuidetoSCN

[Former Member · Accepted solution]

<<one last thing, it might be time that you learn how to use that forum. I would read the following links>>

What am I doing wrong?

[Former Member · Accepted solution]

<< would delete all DBA* jobs in SM37, then delete contents of table SDBAP.>>

DELETE FROM "SAPXI3"."SDBAP";

COMMIT;

SELECT * FROM "SAPXI3"."SDBAP";

no rows selected

<<then, try running one job immediately. does that work?

if not, supply logs again, yuo might have problem with OPS$ authentication.>>

DB13:

No action log found

DBA:CLEANUPLOGS_____@115325/3000 Canceled 02/17/2010 11:53:27 02/17/2010 11:53:27 02/17/2010 11:53:29

Job log: No job logs available for this job

DB37:

DBA:CLEANUPLOGS_____@115325/3000 WFEE Canceled 02/17/2010 11:53:27 2 0

Step List Overview:

1 RSDBAJOB ABAP &0000000000078 WFEE EN

[former_member204746 · Accepted solution]

read SAP note 400241.

and.. what are you doing wrong?

read http://www.sdn.sap.com/irj/sdn/crphelp

[Former Member · Accepted solution]

1) SAP note 400241 did not help. I checked all that before I posted the question.

2) Now in DB13 'CleanLogs' worked once.

I ran UpdateStats' and that failed.

I ran 'CleanLogs' gain and that failed.

3) << and.. what are you doing wrong? read http://www.sdn.sap.com/irj/sdn/crphelp>>

I still do not know what you are talking about?

[Former Member · Accepted solution]

It appears that DB13 is working now.

I looked in sm21 and saw errors writing to /usr/sap/temse.

The UNIX team changed the ownership & permissions on /usr/sap/temse directory and now DB13 apperas to be working.

Thanks for everyone's help.

Edited by: Bill Fee on Feb 17, 2010 3:10 PM

[former_member204746 · Accepted solution]

you are still not assigning poInts, that's what is wrong. read the link I gave you and you will understand.

[Former Member · Accepted solution]

One final point...

After the permissions & ownership was changed on /usr/sap/temse the sub directory 030JOBLG was created and then the SM37 logs could be written.

This is why the DB13 jobs failed with no logs.

Edited by: Bill Fee on Feb 18, 2010 8:13 AM

[Former Member]

Sorry about assigning points?

I'll try to do it now.

[anindya_bose]

Hi Bill

Please check the detail of the job log. Or else you can check from Sm37. Go to SM37, check for all the jobs which start with DBA. i. e provide DBA* in the job name. Then check the job log.

Below note might help you. But until and unless you provide more details , its difficult to provide solution

Note: 446172- (SXPG_COMMAND_EXECUTE (program_start_error) in DB13)

Thanks and Regards

ANindya

[Former Member]

Oracle: 10.2.0.4.0

brtools: 7.10 (25)

OS: AIX 6.1

DB13:

DBA:CHECKDB_________@010000/3007 Canceled

No job logs available for this job

SM37:

DBA:CHECKDB_________@010000/3007 BTC_MSTNO Canceled

SM59:

SAPXPG_DBDEST_XIDDB01 exists and the test connection is okay

Program: /usr/sap/XID/SYS/exe/run/sapxpg

On Server xiddb01:

ls -l /usr/sap/XID/SYS/exe/run/sapxpg

-rwxrwxr-x 1 xidadm sapsys 6706247 Dec 09 12:58 /usr/sap/XID/SYS/exe/run/sapxpg

Is ther anything else I should look at?

[anindya_bose]

Hi

Can you please check the link below if it helps

Are you facing this from always or recently after some change like oracle upgrade?

Regards

Anindya

Edited by: Anindya Bose on Feb 17, 2010 10:45 PM

[Former Member]

I checked the thread before I posted my question. It did not help.

[Former Member]

This is an new isntall

[anindya_bose]

Hi

Have you gone through https://service.sap.com/sap/support/notes/651452 ?

[Former Member]

Yes, I looked at that note. It did not help.