Skip to Content
0

Schedule Instance failed with Database error

Dec 13, 2016 at 12:06 PM

367

avatar image

Hi All,

Schedule Failed Instance Error: : The following database error occurred: A database error has occured. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901)

My scheduled report has failed with above error.

We heard that , there could be a lot of reasons for the above mentioned error.

Database Name :Oracle

Kindly let me know ,how to address this issue.

Thanks

Ram

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mahboob Mohammed Dec 13, 2016 at 06:53 PM
0

Hi Ramanaidu,

Are you able to manually refresh the report?

Thanks,

Mahboob Mohammed

Show 3 Share
10 |10000 characters needed characters left characters exceeded

yes Mahboob,

We were able to refresh the report manually.

0

Hi Ramanaidu,

As you're able to refresh it manually, please try to save a copy of this report, schedule that copy and see what happens. Also, please check from CMC, if all the services are running fine.

Thanks,
Mahboob Mohammed

1

Sure Mahboob,

will do the same and let you know the update asap.

My query is ,once we confirm that required services are running and enabled ,If we schedule the report and still If we get the same error ,does it mean that issue is with oracle DB team ?

Suppose ,If the schedule instance get failed , do we need to contact oracle DB Team ? If not ,what's the next step.

Please let me know your inputs

0
Mahboob Mohammed Dec 19, 2016 at 03:15 PM
0

Hi Ramanaidu,

It can be anything related to database, not necessarily something that the DBA team needs to look into. Please run an integrity check on the universe to make sure the datatype of Object and the column in table are same, that might be one of the issues.

Thanks,

Mahboob Mohammed

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Mahboob,

Thanks for the inputs.

As we are able to refresh the report , suppose If there is any mismatch between object and column data type ,how does it effects the scheduling? ( data types are same)

Kindly let me know ,how does it effects the scheduling ?

0

Some of those mismatches may not effect report schedules, but some mismatches will effect the report schedules as to fail the schedule. Ex: If you've a Date datatype column, whose object is setup as String datatype, and then if you have a filter on the report on the Date object, the schedule will fail due to the mismatch.

Thanks,

Mahboob Mohammed

0