topic Re: OLEDB: snapshot too old: rollback segment too small in QlikView

OLEDB: snapshot too old: rollback segment too small

tobias_klett — Fri, 12 Sep 2014 16:57:09 GMT

Hi,

I keep getting the same error message. I am loading each month of the data with a where statement an do create a seperate QVD per month. Some of them are working ok while some month trow this error message:

Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-0155: snapshot too old: rollback segment number 11 with Name "_SYSSMU11_3849636359" too small

Tobias

Re: OLEDB: snapshot too old: rollback segment too small

Gysbert_Wassenaar — Fri, 12 Sep 2014 17:08:19 GMT

That is something you should show your local friendly Oracle Database Administrator. The error occurs on the database server, not in Qlikview. See this article for more information: www.dba-oracle.com/t_ora_01555_snapshot_old.htm

Re: OLEDB: snapshot too old: rollback segment too small

tobias_klett — Fri, 12 Sep 2014 17:17:44 GMT

Thanks Gysbert, I think this will help to solve the problem

Re: OLEDB: snapshot too old: rollback segment too small

Thu, 25 Sep 2014 07:33:04 GMT

HI!

Have you obtained any resolution to this yet?

Thanks,
K

Re: OLEDB: snapshot too old: rollback segment too small

tobias_klett — Thu, 25 Sep 2014 08:23:55 GMT

Hi,

no this was with the customer, whom I told about the link above. Rightnow they are not investigating any further because it does not occur with my Delta load... 😞

Re: OLEDB: snapshot too old: rollback segment too small

Thu, 25 Sep 2014 08:44:50 GMT

So, shall i also suggest our customer that we can perform one full extract load during off peak hours and post then incremental load? Would this resolve the issue?

Thanks,

Re: OLEDB: snapshot too old: rollback segment too small

tobias_klett — Thu, 25 Sep 2014 08:46:36 GMT

Hi, it might do it. I don't do any full loads any more since the past months are already stored in QVDs anyways. I only load the current month and do this at night time.

Re: OLEDB: snapshot too old: rollback segment too small

Thu, 25 Sep 2014 08:49:35 GMT

Cool...Shall try this way further.

Thanks a lot Tobias for such a quick response! Nice!

Thanks,