Skip to Content
avatar image
Former Member

Scheduled job failed

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Sep 11, 2007 at 08:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2007 at 08:31 AM

    Hi Amit,

    Are you facing the same problem while DB02 refresh?

    If so then apply note 1042725.

    Hope this is useful

    Regards

    Umesh

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 11, 2007 at 09:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2007 at 09:58 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Sep 11, 2007 at 11:04 AM

    Hi Amit,

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

    Regards

    Umesh

    Add comment
    10|10000 characters needed characters exceeded