Skip to Content
0
Former Member
Jul 19, 2016 at 04:23 AM

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

57 Views

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!