Scheduled job failed

[Former Member]

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

[Former Member]

Hi Amit,

Apart from versions ,Could you provide the excerpts of the database log like alert log.

Regards

Umesh

[Former Member]

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.

[Former Member]

Dear Ruchit,

I m not getting error when doing the st04 and also not scheduled any jobs on that particular time.

Waiting for the response.

Thanks in advance.

Regards,

Amit

[Former Member]

Hello Amit,

What is your SAP release and Database release/version.

Also your support package level.

regards.

Ruchit.

[Former Member]

Dear Ruchit,

The info you want are as follows:

db 10.2

sap : ECC6 with support pack level 102

DBSL version 700.08

DBSL Patch Level 073

Hope its useful .

Thanks in advance.

Regards,

Amit

[Former Member]

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

[Former Member]

Hi Amit,

Are you facing the same problem while DB02 refresh?

If so then apply note 1042725.

Hope this is useful

Regards

Umesh

[Former Member]

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

[JPReyes]

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