on 07-19-2016 5:23 AM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.