Question
ING Belgium SA NV
BE
Last activity: 24 Apr 2018 11:23 EDT
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.
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
JPMorgan Chase & Company
US
Hi,
Had you verified the synonyms by running the below query, on the error table ?
'select owner, object_name, status, object_type from dba_objects where object_name like <TableName> and object_type = 'SYNONYM'
ING Belgium SA NV
BE
Thanks for your reply.
I ran the query on error table and I could see the result.
Its fetching result in both oracle 11g and 12c table and synonyms are valid
ING Belgium SA NV
BE
I observed one more point also,
when i refresh the synonym class for which this issue is being thrown, i could see 'rule no longer exist'
When i observed the same in system->database-> ModifySchema->select tables ->Select columns ->
I could see "Table with no columns"
In log, i could see
java.sql.SQLSyntaxErrorException: ORA-00904: "PXOBJCLASS": invalid identifier
Please advise on this
ING Belgium SA NV
BE
Hi,
When we connect the external database with JDBC url, we are not getting this issue. The above mentioned issue occurs when we connect JDBC connection pool