Question
Estes Express Lines inc
US
Last activity: 24 Apr 2023 5:46 EDT
com.microsoft.sqlserver.jdbc.SQLServerException
Root exception
Class: com.microsoft.sqlserver.jdbc.SQLServerException Message: VIEW DATABASE STATE permission denied in database 'Databasename'.
Root exception
Class: com.microsoft.sqlserver.jdbc.SQLServerException Message: VIEW DATABASE STATE permission denied in database 'Databasename'.
at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1662) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:615) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3488) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:262) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:237) at com.microsoft.sqlserver//com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:515) at [email protected]-redhat-00001//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442) at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:532) at com.pega.pegarules.data.internal.access.Lister.listsWithResultPackager(Lister.java:421) at (:)
***Edited by Moderator Marije to add Support Case Details; update capability tags***
Accepted Solution
Updated: 24 Apr 2023 5:46 EDT
Estes Express Lines inc
US
We have raised an SR # INC-267294.
Please find the Pega Vendor comments:
sp_spaceused procedure is not running even when run directly from the DB client.
As discussed, please fix the permission issue from DB so that sp_spaceused procedure is executed properly without errors.
Or
The permissions to the sp_spaceused must be provided for the user given the jdbc/PegaRules to solve this issue or disable the agent completely. Please try to provide the permissions to the proper user and try.
Regards,
Chagamreddy BKreddy(Bala)
Pegasystems Inc.
GB
Hello @chagamreddy,
From the alert image that you have posted, it is clear that the alert is thrown for PegaAESRemote application, which is responsible for collecting DB metrices (apart form a lot of other things) and sent to PDC for making it available in DB dashboards in PDC. The exception points to the fact that the DB user for Pega application doesn't have the authorization to view the DB state. You may work with your DBA to have the right user grants configured and the issue should resolve itself.
Estes Express Lines inc
US
Thank you Vasudevan, we are working with our DBA team.
Accepted Solution
Updated: 24 Apr 2023 5:46 EDT
Estes Express Lines inc
US
We have raised an SR # INC-267294.
Please find the Pega Vendor comments:
sp_spaceused procedure is not running even when run directly from the DB client.
As discussed, please fix the permission issue from DB so that sp_spaceused procedure is executed properly without errors.
Or
The permissions to the sp_spaceused must be provided for the user given the jdbc/PegaRules to solve this issue or disable the agent completely. Please try to provide the permissions to the proper user and try.
Regards,
Chagamreddy BKreddy(Bala)
Estes Express Lines inc
US
@chagamreddy Issue has been resolved.