on 09-11-2007 8:21 AM
Hi Gurus,
Currently I m facing the problem in the shceduled system background job.A job "SAP_COLLECTOR_FOR_PERFMONITOR" is been scheduled and is running successfully on hourly basis .The job gets cancelled on particular time i.e. at 04:00:06 and 19:00:07 .Whereas on other time it finishes successfully.The logs of the jobs(in which error is there) are as follows:
-
08.09.2007 04:00:06 Job started
08.09.2007 04:00:07 Step 001 started (program RSCOLL00, variant , user ID DDIC)
08.09.2007 04:00:10 Clean_Plan:Cleanup of DB13 Plannings
08.09.2007 04:00:10 Clean_Plan:started by RSDBPREV on server watsonid
08.09.2007 04:00:10 Clean_Plan:Cleaning up jobs of system WED
08.09.2007 04:00:10 Clean_Plan:finished
08.09.2007 04:00:10 Database system not supported
08.09.2007 04:01:20 :Exception CX_DBA_ADBC in program RSORA_SELECT_001line 0
08.09.2007 04:01:20 : Kernel Error ID:
08.09.2007 04:01:20 : SYSID: WED
08.09.2007 04:01:20 : SY-SUBRC: 0
08.09.2007 04:01:20 : SQL statement: select nspacegen from SAPB35.rspspace
08.09.2007 04:01:20 : Database: B35
08.09.2007 04:01:20 :caused by
08.09.2007 04:01:20 :Exception CX_SQL_EXCEPTION in class CL_SQL_CONNECTION
08.09.2007 04:01:20 : Kernel Error ID:
08.09.2007 04:01:20 : DB Error: No
08.09.2007 04:01:20 : SQL Code: 0
08.09.2007 04:01:20 : SQL Message:
08.09.2007 04:01:20 : DB Object Exists: No
08.09.2007 04:01:20 : Duplicated Key: No
08.09.2007 04:01:20 : Internal Error: 10
08.09.2007 04:01:20 : Invalid Cursor: No
08.09.2007 04:01:20 : Unknown Connection: Yes
08.09.2007 04:01:20 : Connection Closed: No
08.09.2007 04:01:20 Exception CX_DBA_ADBC in program RSORA_SELECT_001 include line 0
08.09.2007 04:01:20 ABAP/4 processor: OBJECTS_OBJREF_NOT_ASSIGNED
08.09.2007 04:01:20 Job cancelled
-
I m unable to get why the job gets cancelled at particular time. i.e. what is that which makes the job cancel.Kindly let me know how to approach to the issue.
Eagerly waiting for the positive response.
Thanks in advance.
Regards,
Amit
Hi Amit,
Apart from versions ,Could you provide the excerpts of the database log like alert log.
Regards
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Please check in DB13 if any activites have been scheduled to run at the times :
04:00:06 and 19:00:07.
May be a conflict is arising out of that.
regards.
Ruchit.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Amit,
Do you get problem when using tcode ST04 ?
What SAP version you are using.
You problem could be cause by some of the job that only run at particular time.
Your can see from ST03N - Collector - Performance Monitor Collector - Execution Times.
Regards,
Fendi Suyanto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit,
Are you facing the same problem while DB02 refresh?
If so then apply note 1042725.
Hope this is useful
Regards
Umesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Umesh,
Thanks for your reply.Would also like to thank Juan for the reply , i had tried with db02 im not getting dump with that.We are curently using oracle 10 and kernel is also upto date.The thing which is confusing me is this job is running on other time on same day, only time which i had mentioned its not running.Below attached is the log of the successfull run.
-
08.09.2007 01:00:07 Job started
08.09.2007 01:00:07 Step 001 started (program RSCOLL00, variant , user ID DDIC)
08.09.2007 01:00:10 Database system not supported
08.09.2007 01:00:10 Database system not supported
08.09.2007 01:00:13 Job finished
-
Eagerly waiting for the reply.
Thanks in advance.
Regards,
Amit
Hi Amit,
I can see "Database system not supported" just before the first dump... what DB are you using? is your kernel up to date?
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.