OLE db error/General Script Error in Qlikview

Wed, 26 Mar 2014 14:01:05 GMT

Hi Guys,

I am a performing an incremental load on an oracle table from qlikview using a OLEDB connector.

I am facing the below error,after it fetches a huge amount of records

Error: OLEDB read failed

26-03-2014 5:25:55 PM: General Script Error

26-03-2014 5:25:55 PM: Execution Failed

26-03-2014 5:25:55 PM: Execution finished.

I am aware that this problem might be because at that particular point,some other resource was trying to access this table.My script contains a select statement,due to which a lock is not acquired on the table for this period of reload.

I am aware that this error is actually because of a lock.

How does one solve with this issue,or someone pls give me a workaround.

This issue has taken a hell lot of my time,and Im not finding a definite solution.

Best,

Rochelle

Re: OLE db error/General Script Error in Qlikview

marcus_sommer — Wed, 26 Mar 2014 14:58:00 GMT

I would try to split the load in smaller slices perhaps on a year- or product-level and store these as qvd. Afterwards make an incremental load - see here how it worked:

Incremental Load

CRUDhelper framework - Incremental loads with ease

- Marcus

topic OLE db error/General Script Error in Qlikview in QlikView

OLE db error/General Script Error in Qlikview

Re: OLE db error/General Script Error in Qlikview