Question

Database Table Test Connection failure - NonexistentTable exception

We are trying to run a stored procedure in the backend. The Database connectivity is working fine, but while trying test connectivity for Database table, an error message (Non Existent table)is shown as attached. Upon analysis, it was identified that the Database table is missing in the backend.

We are trying for possibilities of running the query without creating a new DB table. So please let me know if the stored procedure could be run with the same schema without creating a new database table mapping.

Appreciate the help.

Comments

Keep up to date on this post and subscribe to comments

Pega
November 29, 2019 - 7:24am

Try saving Data-Admin-DB-table instance of table brms_emp_hierarchy

Pega
November 29, 2019 - 10:44am

Hi,

Did you verify in database whether table really exists or not.If the table itself is not present in schema then this is expected error.

Thanks,
Abhinav