Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!

Invalid table name error in database cleanup workflow

Avatar

Level 2

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

1 Reply

Avatar

Level 2

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