Solved

RSDBAJOB failing Message no. 00564

Posted on 2008-10-13
9
6,852 Views
Last Modified: 2010-10-05
Hi,

I have a job running as a systems user which keeps failing. At first there were two instances of the job running at the same time. I deleted the one and afterwards it still failed.

The message in the Job Detail log is Action in SDBAP unknown

I found the following note pertaining to this Note 368023. I have rescheduled the job for tomorrow morning.

I have also found another comment related to this issue on one of the other sites. Where the person mentioned to browse the SDBAP table to see if there is entries related to this job available in the table. I assume this was related to the scheduling of the job. Has any of you done this?

Johan
0
Comment
Question by:profjohan11
  • 5
  • 2
9 Comments
 

Expert Comment

by:studdert
ID: 22730625
Hi Johan, I've hit a similar error mesg with a regularly scheduled job on my system. Some points/questions:

   -note 368023 appears to apply only to R/3 4.6, so unless you're running that (and are below the quoted patch level) this won't apply. It doesn't apply for me, we're running ECC 6.0.

   -what is the job that you're running? I'm running a checkdb job but the important point is the program that this is executing, what is this? Are you scheduling the job using 'db13' or 'sm36'?

   -you say you're running it as a "system" category user, does this user have SAP_ALL permissions?

   -I had a look using se11 + se16 at table SDBAP but this is only used AFAIK if you schedule your job with 'db13'. In any case all it shows is what you can see by going into the job within 'db13' anyway.

   Might be able to help further if you can answer the above. Still looking into my own issue here, have a couple of leads. I'll post again if I resolve it. Cheers, John.
0
 
LVL 2

Author Comment

by:profjohan11
ID: 22738552
Hi,


I am currently running 620 on my system.

SAPKB62055
SAPKH47025

So the note is not applicable to me. And yes the system user has all the necessary authentication.

And I have rescheduled it more than once.  Using different variations and users.  The job running on my system is a DBSTAT job.

Will still dig aroung on my side.

Johan


0
 
LVL 2

Author Comment

by:profjohan11
ID: 22738634
Hi,

I found this note 212868  which suggest the following actions.

Once again not valid for 620 but may assist you.

Call Transaction SE16 and delete all entries which have the value 'RCHCK' in the field BTYPE.
From the background job overview (Transaction SM37) delete the scheduled job. As a selection criteria, enter the job name 'DBA:STATC_CHECK*' and the user name

Johan
0
 
LVL 2

Author Comment

by:profjohan11
ID: 22771581
Hi,

Studdert I managed to find this note have a look at this.

752572

It is jobs that have replaced older runstats jobs I am testing it in my development environment tonight.

Regards,

JOhan
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 6

Expert Comment

by:Twisteddk
ID: 22784730
Likely your jobstatus has "unknown" because it has not been able to write a status to the joblog file. Check all job tables for incorrect or in processing jobs that might match your job. If this is a DBA job, also check failed and scheduled jobs in SM37 aswell as jobs listed in DB13.
Additionally ensure that all dialloge and backgound processes are running in your system SM50/SM51. Also review tracefiles ST11 at around the time of the job execution, aswell as system log SM21 and error messages ST22.
If the job is a default SAP job try creating a message on the service system http://service.sap.com/message
0
 
LVL 2

Accepted Solution

by:
profjohan11 earned 0 total points
ID: 23074737
Hi guys,

I have found the solution. In my case the problem was that I had to patch the update tool to the newest level. This is a tool that is located with the binaries in the /usr/sap/SID/SYS/exe/run directory. Filename dmdb6srp it was on patch level 23 and is now on patch level 26. Hope this may help you guys.

I still have a problem with the jobs being duplicated but need to implement a note to correct that which I can only do in the new year.

Regards,

Johan
0
 

Expert Comment

by:studdert
ID: 23075685
Thanks for the tips Johan, apologies for not posting back I actually forgot about this question posting as I found out that I could just de-schedule this job, it wasn't necessary (I setup separate checkdb runs later without any issue), and without it repeatedly annoying me I completely forgot! Well done on finding the solution, appreciate you posting it here -- in the event that I run into a similar issue some other time it could be very useful.
0
 
LVL 2

Author Comment

by:profjohan11
ID: 23137016
Patching the update tool solved the problem
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
As an accountant it is essential that I am able to provide accurate and timely information to management and staff.  One of the challenges that I have faced is the need to report on a time period, whether it be a month, quarter, or year, and wanting…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now