Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Kavitha Ethirajalu (Kavitha Ethirajalu)
Ucare
Kavitha Ethirajalu
Ucare
US
Kavitha Ethirajalu Member since 2016 22 posts
Ucare
Posted: Jul 6, 2018
Last activity: Jul 9, 2018
Posted: 6 Jul 2018 12:27 EDT
Last activity: 9 Jul 2018 2:22 EDT
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)

Show More

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]


Show Less
To see attachments, please log in.
DevOps

Posted: 6 years ago
Posted: 9 Jul 2018 2:22 EDT
Venkata Chalapathi Janapati (janav)
PEGA
Principal Engineer, Technical Support - Runtime Engine and Search
Pegasystems Inc.
IN

Hi,

Please make sure the required permissions are provided.

Also, can you please let us know what is the value supplied for bypass.pega.schema in setupDatabase.properties file ?

Can you please share this file.

Thanking you.

--Venkat

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice