Support Article
Unable to Open Work Objects
SA-5789
Summary
We have recently upgraded our system from 6.2 Sp2 to 7.1.6. I am unable to open workobjects on the user portal due to the below error that table do not have columns. Test Connectivty for the calss instance is also throwing the same error.
We have configured the Datasource on Application server, declared the data source in prconfig.xml and created the Database instance choosing "use configuration preferences" option.
But the same is working fine when the Database instance is defined by giving the JDBC URL there. deos pega behaves differently during database calls based on the preferences selected in database definition?
There is no issue with the dabase connectivtiy, because other functionaly is working as expected. Able to retrieve the work list items etc...
Error Messages
Error in Obj-Open-By-Handle
com.pega.pegarules.pub.database.NonexistentTableException: Database-TableWithNoColumns schema.TABLE1
From: (H92AB8CEA2B3CA919F726B3AA895DB7A1:10.68.24.188)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:664)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:500)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)
at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.lookupSQL(ClassMapImpl.java:5180)
at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.getSQL(ClassMapImpl.java:1214)
at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.getSQL(ClassMapImpl.java:561)
at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4596)
at com.pega.pegarules.pub.runtime.AbstractActivity.objOpenByHandle(AbstractActivity.java:121)
at com.pegarules.generated.activity.ra_action_open_0a2239eaf761f9e40ef2e965891f057c.step7_circum0(ra_action_open_0a2239eaf761f9e40ef2e965891f057c.java:1092)
at com.pegarules.generated.activity.ra_action_open_0a2239eaf761f9e40ef2e965891f057c.perform(ra_action_open_0a2239eaf761f9e40ef2e965891f057c.java:174)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
at com.pegarules.generated.activity.ra_action_douiaction_cb321072ef69483913544df13aa40663.step22_circum0(ra_action_douiaction_cb321072ef69483913544df13aa40663.java:2242)
at com.pegarules.generated.activity.ra_action_douiaction_cb321072ef69483913544df13aa40663.perform(ra_action_douiaction_cb321072ef69483913544df13aa40663.java:421)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3275)
Steps to Reproduce
NA
Root Cause
Need to set includeSynonym=true in order to obtain synonym metadata
Resolution
add includeSynonym=true as additinoal jdbc property.
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.