Question

4
Replies
629
Views
NagarajP0101 Member since 2017 54 posts
ING Belgium SA NV
Posted: April 18, 2018
Last activity: April 24, 2018
Closed

Database Error : Database-TableWithNoColumns

Hi,

We migrated oracle version from 11g to 12c and we found issue with one of our ST nodes.

In our regression testing, we found the below exception when we test one of our rest services.

Exception : com.pega.pegarules.pub.PRRuntimeError: Database Error : Database-TableWithNoColumns<synonym name> Database

We are using websphere application server and when we connect back to oracle 11 in WAS console back , its working fine.

we found some posts on this synonym issue

1.https://pdn.pega.com/support-articles/table-mapping-error-database-error-database-tablewithnocolumns

2.https://pdn.pega.com/support-articles/table-mapping-error-database-error-database-tablewithnocolumns

3.https://pdn.pega.com/support-articles/full-install-fails-database-tablewithnocolumn

Solution for most of these synonyms are to delete invalid synonyms, recreate synonyms and add prvileges.

we checked the synonym which is valid and we tried re-creating too. it doesn't solve the issue.

It has privileges(CREATE SESSION,CREATE ANY TABLE WITH ADMIN OPTION,ALTER ANY TABLE,INSERT ANY TABLE WITH ADMIN OPTION,SELECT ANY TABLE,UPDATE ANY TABLE,DELETE ANY TABLE,CREATE ANY INDEX,CREATE ANY PROCEDURE,EXECUTE ANY PROCEDURE,CREATE ANY VIEW,CREATE ANY TYPE,CREATE ANY TRIGGER,ALTER ANY TRIGGER,GRANT ANY OBJECT PRIVILEGE,DROP ANY PROCEDURE,DROP ANY TRIGGER,DROP ANY TABLE,DROP ANY VIEW,DROP ANY INDEX,ANALYZE ANY,ANALYZE ANY DICTIONARY , CREATE ANY MATERIALIZED VIEW WITH ADMIN OPTION , CREATE ANY SYNONYM WITH ADMIN OPTION

Kindly advise what we are missing here

DevOps Data Integration
Moderation Team has archived post
Share this page LinkedIn