Question

4
Replies
315
Views
DPSSingh Member since 2009 53 posts
JPMC
Posted: May 2, 2016
Last activity: May 3, 2016
Closed
Solved

Error while getting the list of checkedout rules: code: -1 SQLState: -1 Message: Database-TableWithNoColumns

Hi All - I have upgraded my system from 7.1.5 to 7.1.9 on weblogic + oracle 11G and I am getting below error when we try to save an operator id from developer portal by logging in as Administrator@pega.com user id.

Errors:

•Error while getting the list of checkedout rules: code: -1 SQLState: -1 Message: Database-TableWithNoColumns

In logs I see below trace:

[fault (self-tuning)'] [  STANDARD] [                    ] [       GEMS:01.01.01] (  internal.access.DatabaseImpl) ERROR myserver|XXX.XXX.XX.XX user - There was a problem with the database when getting a list:

com.pega.pegarules.pub.database.NonexistentTableException: Database-TableWithNoColumns RMS_PEGA_RULES.pwbv4_rule_locking PegaRULES

From: (H8C2EA1BC40D4B1214E89FF79026660A4: )

at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:663)

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)

I checked below thread and it points to synonym related issue https://pdn.pega.com/forums/integration/nonexistenttableexception. I checked the view pwbv4_rule_locking and I do see public synonym and no private synonyms.

I have upgrade my other 3 lower environment and I didn't face this issue in any of my Dev/Dev2/QA environment , this issue only happening in UAT environment which we are upgrading. Can someone please let me know what the issue could be?

<Moderator removed PI>

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn