Question

1
Replies
22
Views
KavithaEthirajalu Member since 2016 22 posts
Ucare
Posted: July 6, 2018
Last activity: July 9, 2018
Closed

7.3.1 PEGA update failed with SQL exception Cannot drop the trigger 'trpr4_base

Hello,

We are running PEGA update from 7.1.7 to 7.3.1 and on running , it failed wiht below exception.My update was successful and ran good in Dev, qa and train.But in stage env alone it failed.

a] 2018-07-05 21:45:48,067 ( SQLLoaderInternal) INFO - File: mssql00010.sql

[java] 2018-07-05 21:45:48,072 ( SQLLoaderInternal) INFO - DROP TRIGGER RULES.TRPR4_BASE

[java] 2018-07-05 21:45:48,081 ( SQLLoaderInternal) INFO - Failed to execute SQL in file mssql00010.sql

[java]

[java] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the trigger 'trpr4_base', because it does not exist or you do not have permission.

[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)

[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)

[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)

[java] at com.pega.pegarules.install.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:151)

[java] at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:110)

[java] at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:98)

[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)

[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)

[java] 2018-07-05 21:45:48,102 ( SQLLoaderInternal) WARNING - Statement: drop trigger Rules.trpr4_base

[java] 2018-07-05 21:45:48,104 ( SQLLoaderInternal) WARNING -

[java] ********************************************************************************

[java]

[java] Encountered a SQL Exception, clean schema before running again.

[java]

[java] 2018-07-05 21:45:48,067 ( SQLLoaderInternal) INFO - File: mssql00010.sql

[java] 2018-07-05 21:45:48,072 ( SQLLoaderInternal) INFO - DROP TRIGGER RULES.TRPR4_BASE

[java] 2018-07-05 21:45:48,081 ( SQLLoaderInternal) INFO - Failed to execute SQL in file mssql00010.sql

[java]

[java] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot drop the trigger 'trpr4_base', because it does not exist or you do not have permission.

[java] at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1635)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:865)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:762)

[java] at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276)

[java] at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:184)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:159)

[java] at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:735)

[java] at com.pega.pegarules.install.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:151)

[java] at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:110)

[java] at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:98)

[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)

[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)

[java] 2018-07-05 21:45:48,102 ( SQLLoaderInternal) WARNING - Statement: drop trigger Rules.trpr4_base

[java] 2018-07-05 21:45:48,104 ( SQLLoaderInternal) WARNING -

[java] ********************************************************************************

[java]

[java] Encountered a SQL Exception, clean schema before running again.

[java]

DevOps
Moderation Team has archived post
Share this page LinkedIn