SAP_COLLECTOR_FOR_PERFMONITOR Job getting failed.

[Former Member]

Dear All,

In my system a job of perfom collector gets cancelled particularly at the 4 in morning and 7 in evening .Where as rest of the day it runs smoothly and successfully.I had already checked that there are no other jobs scheduled at that particular time.Due to this I also get a runtime error dump in the system i.e.

*Runtime Errors OBJECTS_OBJREF_NOT_ASSIGNED*

*Exception CX_SY_REF_IS_INITIAL*

*Date and Time 16.05.2008 04:21:06*

The log of the cancelled job is as follows:

-

---

Job started

Step 001 started (program RSCOLL00, variant , user ID BACKJOB_USER)

Clean_Plan:Cleanup of DB13 Plannings

Clean_Plan:started by RSDBPREV on server watsonapp

Clean_Plan:Cleaning up jobs of system WEP

Clean_Plan:finished

Database system not supported

:Exception CX_DBA_ADBC in program RSORA_SELECT_001line 0

: Kernel Error ID:

: SYSID: WEP

: SY-SUBRC: 0

: SQL statement: select nspacegen from SAPB35.rspspace

: Database: B35

:caused by

:Exception CX_SQL_EXCEPTION in class CL_SQL_CONNECTION

: Kernel Error ID:

: DB Error: No

: SQL Code: 0

: SQL Message:

: DB Object Exists: No

: Duplicated Key: No

: Internal Error: 10

: Invalid Cursor: No

: Unknown Connection: Yes

: Connection Closed: No

Exception CX_DBA_ADBC in program RSORA_SELECT_001 include line 0

ABAP/4 processor: OBJECTS_OBJREF_NOT_ASSIGNED

Job cancelled

-

---

Requesting you all suggest a solution for the same.Please consider this at very high as we have an audit in 2 days.Thus want to clear this issue at the earliest.

Thanks and Regards,

Amit

[Former Member]

Hello Amit,

This is caused by a program error in the GET_CONNECTION method of the CL_SQL_STATEMENT class.

For more Details visit Note 514908.

Regards

Vivek

[Former Member]

Dear Vivek,

thanks for the reply.But the note you had mentioned is not applicable to us.Request you to please suggest me the solution for the same.

Regards,

Amit

[Former Member]

Hi Amit

It seems that Error is occuring due to some wrong job scheduled in DB13 at around 4 AM and 7 PM respectively. Look into the error:

 Clean_Plan:Cleanup of DB13 Plannings
Clean_Plan:started by RSDBPREV on server watsonapp
Clean_Plan:Cleaning up jobs of system WEP
Clean_Plan:finished
Database system not supported

And to that scheduled job your database is not supported. Check what job is it, most probably it should be clean up log.

Hope this helps.

Regards

Rahul

[Former Member]

Hello,

check the note

Note 1042725 - DB02 Refresh terminates in short dump

[Former Member]

Did it solve the problem.

I have an similar issue where thi job fails daily at 4:00 and 19:00

Sumit

[Former Member]

HI,

Go to ST03 -->Collector and performance DB --->Performance database ---> Monitoring database and

double click on the Content in that Other Information column search for days h/2 , weeks h/2, months h/2 and double click on days h/2 , weeks h/2, months h/2 it will delete.

This will resolve your problem.

Regards,

Soorya.

[Former Member]

Hi. Are you read this Note 1125713 - DBACockpit: Error due to unavailable remote connection ?

[Former Member]

Dear Sergo,

I had applied that note in production but still the job failed and also the dump has occured again.As this note did not came as solution for the issue raised.The job runs every hour but the jobs gets failed on particular time.It is been observed that no other jobs are active during the run of the mentioned job.Please suggest me at the earliest as I have to clear this issue a t the earliest.

Thanks and Regards,

Amit

[Former Member]

Hello. Check in DB13 and in sm37 are somfing in 4 in morning and 7 in evening to (over job or backup for example) ? Also are in your system modes like Day-Mode Night-Mode ? If yes check the times for this. Regards.