SQL state [42000]; error code [942]; ORA-00942: table or view does not exist ; nested exception is j
Hi Everyone,
While running reports through the Web Front-end application(a reporting application) my client gets the following errors. A similar error is generated when he runs any of his standard queries....can anyone please advise . I have looked into the DB and the table or user with that name does not exist, is it because certain permissions (like Create Table etc..) are missing for the user who is running this query...thanks!
While running reports through the Web Front-end application(a reporting application) my client gets the following errors. A similar error is generated when he runs any of his standard queries....can anyone please advise . I have looked into the DB and the table or user with that name does not exist, is it because certain permissions (like Create Table etc..) are missing for the user who is running this query...thanks!
Configuration error has been found by preparing of query form with Query Id = RANDOM_TO_SERVER_REPORT.
See details: org.springframework.jdbc.UncategorizedSQLException: ORA-00942: table or view does not exist ; uncategorized SQLException for SQL [select distinct app_acro FROM abcddmin.tbl_abc_defg_base ORDER BY upper(app_acro)]; SQL state [42000]; error code [942]; ORA-00942: table or view does not exist ; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
0