Hi Team
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)
Kindly advise.
Regards,
Shyam