Sign in to Community
Sign in to view all badges
Expand my Community achievements bar.
We are getting below error just after cleaning proposition through database cleanup workflow. Its showing invalid table name. Earlier It was running fine.
I have checked in the logs too but din't get anything, which table it is pointing. Its showing blank after delete from.
2018-08-24 10:45:18.217+02 00003DA9 00003DA9 1 verbose log Executing query 'DELETE FROM NmsPropositionRcp WHERE tsLastModified < to_timestamp_tz('20160903104518
.218','YYYYMMDDHH24MISS.FF3') AND ROWNUM<=20000'...
2018-08-24 10:45:18.223+02 00003DA9 00003DA9 1 verbose log Executing query 'DELETE FROM WHERE tsLastModified < to_timestamp_tz('20160903104518.223','YYYYMMDDHH
24MISS.FF3') AND ROWNUM<=20000'...
2018-08-24 10:45:18.224+02 00003DA9 00003DA9 1 error log ORA-210000 Oracle error: ORA-00903: invalid table name (iRc=-2006)
2018-08-24 10:45:18.225+02 00003DA9 00003DA9 1 error log WDB-200002 SQL statement 'DELETE FROM WHERE tsLastModified < to_timestamp_tz('20160903104518.223','Y
YYYMMDDHH24MISS.FF3') AND ROWNUM<=20000' could not be executed (error in position 13: 'WHERE'). (iRc=-2006)
I see you have already lodge a request with us for this issue and one of our support consultants is already looking into your request internally.
We will share further updates over the same ticket.