cancel
Showing results for 
Search instead for 
Did you mean: 

Sap dataservice: Job error: 'Cannot retrieve <AL_CACHE>

Former Member
0 Kudos

hi guys,

now I am working on SAP Dataservice for ETL.

I have a Batch Job with a workflow to ETL data from SAP IQ to Oracle DB. It works well when I run it manual. I have set a schedule for this batch job with Data Service option, Multiple times a day, duration = 120 mins and interval = 15 mins. When the schedule job executed I always got error like below:

'Cannot retrieve <AL_CACHE> <c1b8a71ac1a8d20dec468980990b4db6> from the repository. Additional database information: <The number of columns <2> returned by SELECT query <select PARENT_OBJID, DF_LANGKEY from AL_CACHE where DF_GUID = 'a91917ee-3275-4e30-87b9-eb7741a3b6fc' AND CHECKSUM='c1b8a71ac1a8d20dec468980990b4db6' AND SEQNUM=-1> does not match the expected number of columns <6>. Notify Customer Support.>.'



Have you ever got the same error?

Please help me to fix this error.

Thank you!

Accepted Solutions (1)

Accepted Solutions (1)

former_member198401
Active Contributor
0 Kudos

Can you try removing 120 from Duration and check. If your job is scheduled to run in an interval of 15 minutes then duration need not be entered


Regards

Arun Sasi

Former Member
0 Kudos

Thanks for your reply, Arun Sasi

I keep duration 120 mins but I increase interval to 30 mins then my schedule run successfully. I don't know why although schedule job takes around 1 hour.

Answers (0)