CAST Management Studio - Launching CAST MS - Fatal Error - ERROR column inplace does not exist

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

ReleaseYes/No
8.3.x✅

Observed on RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Step by Step Scenario

Below is the step-by-step scenario leading to the problem:

  1. Upgrade from a version less than 8.3.30 to a higher version.
  2. 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 - 

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,

  1. Restore a backup of the bases before migration

  2. Run the below queries on the MNGT schema -

ALTER TABLE .CMS_CODE_REPO_BO ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_BOEXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_DBUDB ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_DBZOSEXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_FILE ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_FORMSEXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_MFEXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_ORACLEEXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_SAPEXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_SQLSERVEREXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_SYBASEEXTRACT ADD COLUMN InPlace INT ALTER TABLE .CMS_CODE_REPO_UIEXTRACT ADD COLUMN InPlace INT

3. Run the upgrade again.
4. Launch CAST-MS.
5. f you do not find the information you are looking for or a solution for your problem, in this page, contact [CAST Technical Support](https://help.castsoftware.com/hc/en-us/requests/new) with the below [relevant input](https://doc.castsoftware.com/display/TKBQG/CAST+Management+Studio+Component+CMS#CASTManagementStudioComponentCMS-RelevantInput) to help CAST Support team investigate your problem or procure the required information.

**Notes/comments**

Ticket # 34959

**Related Pages**