OLEDB read failed

[#1]

Hello Everybody,

I am loading the below piece of the code but I am getting error message as

7 fields found: WORK_QUEUE_ID, WQ_EMPLID, WQ_EXTERNAL_EMAIL, STATUS_DESC, WQ_DESCRIPTION, WQ_CREATED_DATE, WQ_CREATED_DATE, Error: OLEDB read failed.

General Script Error

But while running the same script in Toad the query runs fine. I am able to get alll the field values.

Could anyone please help me solving the issue.

SCRIPT:

Work_queue:
load WORK_QUEUE_ID,
WQ_EMPLID,
WQ_EXTERNAL_EMAIL,
STATUS_DESC,
WQ_DESCRIPTION,
WQ_CREATED_DATE,
WQ_CREATED_DATE;

SQL select W.WORK_QUEUE_ID as WORK_QUEUE_ID ,
W.EMPLID as WQ_EMPLID,
U.EXTERNAL_EMAIL as WQ_EXTERNAL_EMAIL ,
decode (W.STATUS, 'Q', 'Queued',
'C', 'Complete',
'A', 'Archived',
'P', 'In Progress',
'E', 'Error',
'Other') STATUS_DESC,
E.DESCRIPTION as WQ_DESCRIPTION,
W.CREATED_DATE as WQ_CREATED_DATE,
W.MODIFIED_DATE as WQ_MODIFIED_DATE
from edrdata.work_queue w, edrdata.user_master u, EDRDATA.EVENT_TYPE e
where W.MODIFIED_DATE > sysdate-90
and W.EVENT_CODE = E.EVENT_CODE
and U.EMPLID = W.EMPLID;

store Work_queue into $(vQvdPath)Work_queue.qvd (qvd);

Thanks In Advance

Sonali

[francoiscave]

Hi Sonali,

Can you try without the calculated field STATUS_DESC or do it in the Load Statement (with an ApplyMap it wil be better ;-)) .

Come back for the evolution.

Thanks,

François

[francoiscave]

Hi Sonali,

Do you have always some issue ?

If yes, how can we help you ?

If you are satisfied, can you mark a response as correct or helpful to close this thread.

It will easier to follow the open thread.

Thanks,

François