OLE db error/General Script Error in Qlikview

[#1]

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

[marcus_sommer]

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