Description
When opening up a connection profile to CAST- MS, the following error is encountered "ERROR: column "inplace" does not exist"
Please see the screenshot below:
Observed in CAST AIP
Release | Yes/No |
---|---|
8.3.x |
Observed on RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Step by Step Scenario
Below is the step-by-step scenario leading to the problem:
- Upgrade from a version less than 8.3.30 to a higher version.
- Open CAST-MS
Impact of the Problem
The impact of the problem on the analysis or the dashboard is:
Unable to start CAST-MS to do any analysis
Action Plan
The issue occurs after upgrading a schema from a version of AIP < 8.3.30 to a higher version.
The management base is not migrated in this case but local and central are up to date.
The Error Stack -
Error Stack
ERR: 2022-03-23 02:52:09: ERROR: column "inplace" does not exist Position: 91 com.castsoftware.java.ExternalException:ERROR: column "inplace" does not exist Position: 91 com.castsoftware.connection.JdbcConnection.throwException(JdbcConnection.java:1789) com.castsoftware.connection.JdbcConnection._executeQuery(JdbcConnection.java:1039) com.castsoftware.connection.JdbcConnection.executeQuery(JdbcConnection.java:971) com.castsoftware.mda.dbrefactor.FullEntityLoader.load(FullEntityLoader.java:352) com.castsoftware.mda.dbrefactor.Persistence.load(Persistence.java:330) com.castsoftware.mda.db.DatabaseLoader.run(DatabaseLoader.java:54) com.castsoftware.mda.access.DocumentHelper.loadDocument(DocumentHelper.java:512) com.castsoftware.mda.access.DocumentHelper.load(DocumentHelper.java:417) com.castsoftware.pmc.actions.InstallAutoDiscover.execute(InstallAutoDiscover.java:137) com.castsoftware.mda.impl.MemoryAction.topExecute(MemoryAction.java:265) com.castsoftware.mda.transactions.SectionAction.runInternal(SectionAction.java:44) com.castsoftware.mda.transactions.Section.runInTransaction(Section.java:192) com.castsoftware.mda.transactions.Section.run(Section.java:137) com.castsoftware.mda.transactions.Section.runHeadless(Section.java:308) com.castsoftware.mda.run.ConfigurationManager.runVerb(ConfigurationManager.java:566) com.castsoftware.mda.run.ConfiguredApplication.onTreatment(ConfiguredApplication.java:393) com.castsoftware.pmc.run.PMCConfiguredApplication.onTreatment(PMCConfiguredApplication.java:530) com.castsoftware.pmc.run.CLIPMCConfiguredApplication.onTreatment(CLIPMCConfiguredApplication.java:185) com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:244) com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:234) com.castsoftware.util.logger.Logging.execute(Logging.java:527) com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415) com.castsoftware.mda.run.ConfiguredApplication.run(ConfiguredApplication.java:233) com.castsoftware.pmc.run.CLIPMCConfiguredApplication.executeInLogContext(CLIPMCConfiguredApplication.java:107) com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:73) com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:68) com.castsoftware.util.logger.Logging.execute(Logging.java:527) com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415) com.castsoftware.pmc.run.CLIPMCConfiguredApplication.execute(CLIPMCConfiguredApplication.java:67) com.castsoftware.pmc.CLI.main(CLI.java:34) Connection Error: select Object_ID,Internal_Timestamp,Object_Name,Application_ID,RootPath,Deploy,IsMigrated,InPlace from <MNGT>.CMS_CODE_REPO_File com.castsoftware.java.InternalException:Connection Error: select Object_ID,Internal_Timestamp,Object_Name,Application_ID,RootPath,Deploy,IsMigrated,InPlace from <MNGT>.CMS_CODE_REPO_File org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323) org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473) org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393) org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:236) com.castsoftware.connection.JdbcConnection._executeQuery(JdbcConnection.java:1021) com.castsoftware.connection.JdbcConnection.executeQuery(JdbcConnection.java:971) com.castsoftware.mda.dbrefactor.FullEntityLoader.load(FullEntityLoader.java:352) com.castsoftware.mda.dbrefactor.Persistence.load(Persistence.java:330) com.castsoftware.mda.db.DatabaseLoader.run(DatabaseLoader.java:54) com.castsoftware.mda.access.DocumentHelper.loadDocument(DocumentHelper.java:512) com.castsoftware.mda.access.DocumentHelper.load(DocumentHelper.java:417) com.castsoftware.pmc.actions.InstallAutoDiscover.execute(InstallAutoDiscover.java:137) com.castsoftware.mda.impl.MemoryAction.topExecute(MemoryAction.java:265) com.castsoftware.mda.transactions.SectionAction.runInternal(SectionAction.java:44) com.castsoftware.mda.transactions.Section.runInTransaction(Section.java:192) com.castsoftware.mda.transactions.Section.run(Section.java:137) com.castsoftware.mda.transactions.Section.runHeadless(Section.java:308) com.castsoftware.mda.run.ConfigurationManager.runVerb(ConfigurationManager.java:566) com.castsoftware.mda.run.ConfiguredApplication.onTreatment(ConfiguredApplication.java:393) com.castsoftware.pmc.run.PMCConfiguredApplication.onTreatment(PMCConfiguredApplication.java:530) com.castsoftware.pmc.run.CLIPMCConfiguredApplication.onTreatment(CLIPMCConfiguredApplication.java:185) com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:244) com.castsoftware.mda.run.ConfiguredApplication$2.call(ConfiguredApplication.java:234) com.castsoftware.util.logger.Logging.execute(Logging.java:527) com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415) com.castsoftware.mda.run.ConfiguredApplication.run(ConfiguredApplication.java:233) com.castsoftware.pmc.run.CLIPMCConfiguredApplication.executeInLogContext(CLIPMCConfiguredApplication.java:107) com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:73) com.castsoftware.pmc.run.CLIPMCConfiguredApplication$1.call(CLIPMCConfiguredApplication.java:68) com.castsoftware.util.logger.Logging.execute(Logging.java:527) com.castsoftware.util.logger.Logging.runInNewContext(Logging.java:415) com.castsoftware.pmc.run.CLIPMCConfiguredApplication.execute(CLIPMCConfiguredApplication.java:67) com.castsoftware.pmc.CLI.main(CLI.java:34) INF: 2022-03-23 02:52:09: Return value: 1000
The issue occurs because the column that was added in AIP 8.3.30 was not created during the migration to 8.3.36.
As a workaround,
- Restore a backup of the bases before migration
Run the below queries on the MNGT schema -
WorkAround QueryALTER TABLE <mngt>.CMS_CODE_REPO_BO ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_BOEXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_DBUDB ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_DBZOSEXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_FILE ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_FORMSEXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_MFEXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_ORACLEEXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_SAPEXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_SQLSERVEREXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_SYBASEEXTRACT ADD COLUMN InPlace INT ALTER TABLE <mngt>.CMS_CODE_REPO_UIEXTRACT ADD COLUMN InPlace INT
- Run the upgrade again.
- Launch CAST-MS.
- f you do not find the information you are looking for or a solution for your problem, in this page, contact CAST Technical Support with the below relevant input to help CAST Support team investigate your problem or procure the required information.
Notes/comments
Ticket # 34959
Related Pages