Invalid table name error in database cleanup workflow

Avatar

Avatar
Validate 1
Level 2
shyamc89450995
Level 2

Likes

4 likes

Total Posts

19 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
shyamc89450995
Level 2

Likes

4 likes

Total Posts

19 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
shyamc89450995
Level 2

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)

Avatar

Avatar
Give Back
Employee
anshshar
Employee

Likes

2 likes

Total Posts

10 posts

Correct reply

2 solutions
Top badges earned
Give Back
Boost 1
Affirm 1
View profile

Avatar
Give Back
Employee
anshshar
Employee

Likes

2 likes

Total Posts

10 posts

Correct reply

2 solutions
Top badges earned
Give Back
Boost 1
Affirm 1
View profile
anshshar
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