Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My qlik view file got failed and it's showing the message as "The Source Document was NOT reloaded successfully. DocumentPath"
and verified the log file and it contains the below error message
8/3/2017 1:52:58 AM: Error: SQL##f - SqlState: S1000, ErrorCode: 1555, ErrorMsg: [Oracle][ODBC][Ora]ORA-01555: snapshot too old: rollback segment number 92 with name "_SYSSMU92_2533553443$" too small
Thanks,
Mohan
Looks like, Rollback issue? Can we know the process you done to pull the data?
Hi Anil,
Thanks for your reply.
As i am new to Qlik view and the file already scheduled to run every day pm.
The file contrains below syntax to fetch the data .
tmp_extra_scrap;
SQL
SELECT * FROM <owner>.<view name>
Please let me know if you need any other information.
Thanks,
Mohan
As far as Qlikview don't require Owner Name. Can you select from Driver section and choose only Views and connect to view table. More information is here. Because, Currently i don't have SQL Server to test
Loading from SQL Database Views | Qlik Community
Hi Mohan
This is an oracle error and usually happens during long running queries from a transactinal databses.
Please contact your oracle db for advise on resolving the error.
Hi Sasi,
Thanks for your reply. I will check all the tables/view and the performance as well.
Thanks,
Mohan
Thanks Anil. I will check and let you know.