(OO) Support Tip: OO_CP_FILES_ROLLBACK table was created and then dropped

0 Likes

OO_CP_FILES_ROLLBACK table was created and then dropped. This causes an error related to the table truncating.

In wrapper.log,
INFO  | jvm 1   | xxxx/06/17 11:52:13 | INFO 17/06/xx 11:52: liquibase: META-INF/database/root.changes.xml: META-INF/database/central-oo1085.changes.xml::create OO_CP_FILES_ROLLBACK::central: ChangeSet META-INF/database/central-oo1085.changes.xml::create OO_CP_FILES_ROLLBACK::central ran successfully in 16ms
......
INFO  | jvm 1   | xxxx/06/17 11:52:13 | INFO 17/06/xx 11:52: liquibase: META-INF/database/root.changes.xml: META-INF/database/central-oo201805.changes.xml::drop table OO_CP_FILES_ROLLBACK::central: ChangeSet META-INF/database/central-oo201805.changes.xml::drop table OO_CP_FILES_ROLLBACK::central ran successfully in 0ms

in server.log,
xxxx-06-30 12:16:54,643 [https-jsse-nio-8443-exec-1] (DeploymentController.java:417) ERROR - StatementCallback; uncategorized SQLException for SQL [truncate table OO_CP_FILES_ROLLBACK]; SQL state [S0007]; error code [1088]; Cannot find the object "OO_CP_FILES_ROLLBACK" because it does not exist or you do not have permissions.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Cannot find the object "OO_CP_FILES_ROLLBACK" because it does not exist or you do not have permissions.

Since the table OO_CP_FILES_ROLLBACK was dropped on 6/17, so on 6/30 when trying to truncate it, the error came up.

To fix the issue create the table from the query below and provide the "db_name" accordingly :

Query :

CREATE TABLE db_name.dbo.OO_CP_FILES_ROLLBACK (
ID bigint NOT NULL,
CONTENT_PACK_ZIP image NULL
)

The liquibase changeset mentioned will not remove the table OO_CP_FILES_ROLLBACK from the database during installation process. But it will remove only during rollback part.

Labels:

Support Tip
Comment List
Anonymous
Related Discussions
Recommended