CMS Snapshot Analysis - Compute Snapshot - Fatal Error - Relation

Purpose (problem description)

This page provides an explanation and solution about the following Fatal Error message that may appear in the CAST MS log file.

ERROR: relation "work_objectsharingprevious" does not exist
Where: PL/pgSQL function apmaep_result_ecshared_tran(integer,integer,integer,integer) line 52 at SQL statement
org.postgresql.util.PSQLException:ERROR: relation "work_objectsharingprevious" does not exist
Where: PL/pgSQL function apmaep_result_ecshared_tran(integer,integer,integer,integer) line 52 at SQL statement
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2578)
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2313)
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331)
org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159)
org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77)
org.postgresql.jdbc.PgPreparedStatement.execute(PgPreparedStatement.java:148)
com.castsoftware.connection.JdbcConnection._executeProcedure(JdbcConnection.java:1256)
com.castsoftware.connection.JdbcConnection.executeProcedure(JdbcConnection.java:1222)
com.castsoftware.dssengine.Engine.callMetricProcedureOnCentralSite(Engine.java:1793)
com.castsoftware.dssengine.Engine.recalculateFunctionPointsResultsOnCentralSite(Engine.java:1778)
com.castsoftware.dssengine.Engine.recalculateFunctionPointsResultsOnCentralSite(Engine.java:1737)
com.castsoftware.dssengine.Engine.recalculateSnapshotOnCentralSite(Engine.java:1707)
com.castsoftware.dssengine.Engine.recalculateNextSnapshotOnCentralSite(Engine.java:1850)
com.castsoftware.dssengine.LocalSite.consolidateSnapshot(LocalSite.java:2645)
com.castsoftware.dssengine.LocalSite.importAndConsolidate(LocalSite.java:2066)
com.castsoftware.dssengine.Engine.computeSnapshot(Engine.java:582)
com.castsoftware.pmc.dashboard.dssengine.RunDSSEngine.documentExecute(RunDSSEngine.java:183)
com.castsoftware.mda.impl.MemoryTask.execute(MemoryTask.java:86)
com.castsoftware.java.treatment.Task.run(Task.java:380)
com.castsoftware.java.treatment.Task.runChildren(Task.java:590)
com.castsoftware.pmc.actions.snapshot.SnapshotGenerator.documentExecute(SnapshotGenerator.java:115)
com.castsoftware.mda.impl.MemoryTask.execute(MemoryTask.java:86)
com.castsoftware.java.treatment.Task.run(Task.java:380)
com.castsoftware.java.treatment.Task.runChildren(Task.java:590)
com.castsoftware.mda.impl.MemoryAction.execute(MemoryAction.java:272)
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: 2020-06-16 16:54:15: Return value: 1000

Observed in CAST AIP

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x

Observed on RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS3
CSS2

Step by Step scenario

Take a snapshot

Action Plan

Perform the below actions

Get the relation name from the Error shown in CMS log file
If the relation name is work_objectsharingprevious:
1. If you are taking a snapshot via AIP Console, and if there is no snapshot listed in the list of performed snapshots:
  1. Get the list of snapshots, from the cb:
    select * from dss_snapshots;
  2. If you see that there is a snapshot with an old date than the one you are trying to generate with an id equal to -1, it means that the snapshot was interrupted previously and it should be purged. This functionality does not exists in AIP Console currently, you will need to use CMS to remove the failed snapshot. Then you can generate the snapshot again.
2. Else if you are trying to consolidate the first snapshot then this is a known bug found in 8.3.24 and will be fixed in 8.3.26. As a WA add the following in the beginning of the stored procedure ADG_CENTRAL_STARTUP_INIT located on CB:
```
 perform droptemporarytable('WORK_ChangedArtifactSharing') ;
 perform droptemporarytable('WORK_ObjectSharingCurrent') ;
 perform droptemporarytable('WORK_ObjectSharingPrevious');
```
If you do not find the information you are looking for or solution for your problem, in this page, contact CAST Technical Support with the below Relevant Input in order to reproduce the compute snapshot issue.

Notes/comments

Ticket # 23883

Related Pages