com.microsoft.sqlserver.jdbc.SQLServerException

Blueprint and App Design
, , , , , , , ,
1

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]//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 (:slight_smile:

Event.png
Event.png1591×789 61.3 KB

2

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.

3

@MahesanVasudevan

Thank you Vasudevan, we are working with our DBA team.

4

@chagamreddy

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)

5

@chagamreddy Issue has been resolved.