Invalid table name error in database cleanup workflow

shyamc89450995

24-08-2018

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

Accepted Solutions (0)

Answers (1)

Answers (1)

anshuls47147052

Employee

28-08-2018

Hi Shyam

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.

Regards

Anshul Sharma