SQL DBI Error [message #232340] |
Fri, 20 April 2007 03:53 |
ehegagoka
Messages: 493 Registered: July 2005
|
Senior Member |
|
|
Hi,
We have a perl script that runs every 30 minutes, but now we are getting this error
DBI execute FAIL -> ORA-01555: snapshot too old: rollback segment number 14 with name "RBS13" too small (DBD ERROR: error possibly near <*> indicator at char 149 in 'select distinct s.synergy_file, s.date_in_queue, s.lot, s.device, s.location, s.testertype, s.txflocs, s.que_reason, m.total_qty, m.datalog_qty from <*>synergy_queue s, metadata m where s.synergy_file = m.filepath and s.location = 'AMT_FM' and (s.que_reason = 'FT:GOOD' or s.que_reason = 'FT:EXTERNAL' or s.que_reason = 'FT:LOTDEV' or s.que_reason = 'FT:NOGZPFILE' or s.que_reason = 'FT:XMLFAIL1' or s.que_reason = 'FT:XMLFAIL2' or s.que_reason = 'FT:XMLFAIL3') and s.date_in_queue between (SYSDATE-5) and SYSDATE and m.category is not null and m.flot is not null and m.total_qty > 100 order by s.date_in_queue ASC, s.TESTERTYPE DESC')
But when I run that SQL on pl/sql developer it says no rows returned. What could be causing the rollback error Sir/Mam?
Regards,
Rhani
|
|
|
|
Re: SQL DBI Error [message #232524 is a reply to message #232366] |
Fri, 20 April 2007 19:22 |
ehegagoka
Messages: 493 Registered: July 2005
|
Senior Member |
|
|
Hi,
it's not new to me also, im just wondering why it did not occur when i used it in plsql developer, can you explain why?
thanks for "break the lines.." ill add it in my "must not forget to do".
Regards,
Rhani
|
|
|
|
|