SA-12122

Summary

You are doing a fresh install. The install fails with the below error.

Error Messages

[java] Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-TableWithNoColumns PEGA_DATA_SIT.PR_DATA_IH_DIM_ACTION PegaDATA
[java] From: (unknown)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:663)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:500)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:384)
[java] at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:346)
[java] at com.pega.pegarules.data.internal.dictionary.ClassMapImpl.readExternalPropertyDefinitions(ClassMapImpl.java:2509)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.seedClassMapWithProperties(ImportImpl.java:1436)
[java] at com.pega.pegarules.deploy.internal.util.ImportImpl.bootstrapPegaRULES(ImportImpl.java:476)
[java] at com.pega.pegarules.deploy.internal.archive.ApplicationBundle.doImport(ApplicationBundle.java:1402)
[java] ... 12 more

Steps to Reproduce

You receive this error when executing the command line installation procedure.

Root Cause

There were synonyms defined for a number of PR_DATA_IH_* tables in a different schema in the same database instance including for the specific table referenced in the error message.

Resolution

The existing synonyms for the PR_DATA_IH_* tables in the other schema were dropped for the installation and the installation completed successfully.
The synonyms were then re-created in the other schema.