DPA - Version 2024.2 Upgrade for Oracle tablespace freespace alert

5/16/2024 7:26 PM

2/19/2025 5:19 AM

The tablespace freespace status will be seen as broken after upgrading DPA to 2024.2. This alert is supported for Oracle, Db2 database.

Currently, it is working only for Db2 Database.

Database Performance Analyzer

Below is the sample of error iwc.log file:
 

WARN   (2024-04-23T16:41:09,573-0500) [https-jsse-nio-8124-exec-8] {name=ZIMACORE_ZIMACOREDB} AbstractAlertTask:337 - Error executing alert 
[Tablespace Freespace] for database [ZIMACORE_ZIMACOREDB]
org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [select DISTINCT DB_NAME igniteex FROM 
TABLE(MON_GET_MEMORY_POOL(NULL,NULL,-2)) WHERE DB_NAME IS NOT null]; nested exception is java.sql.SQLSyntaxErrorException: 
ORA-00904: "MON_GET_MEMORY_POOL": invalid identifier
	at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:93) ~[spring-jdbc-sw-5.3.29.jar:?]
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-sw-5.3.29.jar:?]
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79) ~[spring-jdbc-sw-5.3.29.jar:?]
	at com.confio.idc.util.Db2Utils.getActiveDatabases(SourceFile:374) ~[pi.jar:?]
	at com.confio.iwc.alerts.definitions.TablespaceFreeSpaceAlert.runAlert(SourceFile:46) ~[pi.jar:?]
	at com.confio.iwc.alerts.tasks.AbstractAlertTask.execute(SourceFile:314) [pi.jar:?]
	at com.confio.iwc.alerts.tasks.AbstractAlertTask.executeAsTest(SourceFile:258) [pi.jar:?]
	at com.confio.iwc.alerts.AlertManager.testAlert(SourceFile:113) [pi.jar:?]
	at com.confio.iwc.web.controller.alerts.AlertController.handleTestAlert(SourceFile:655) [pi.jar:?]
	at com.confio.iwc.web.controller.alerts.AlertController.handleRequest(SourceFile:498) [pi.jar:?]
	at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:51) [spring-webmvc-5.3.29.jar:5.3.29]
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1072) [spring-webmvc-5.3.29.jar:5.3.29]
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:965) [spring-webmvc-5.3.29.jar:5.3.29]
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) [spring-webmvc-5.3.29.jar:5.3.29]
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) [spring-webmvc-5.3.29.jar:5.3.29]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:555) [servlet-api.jar:4.0.FR]
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) [spring-webmvc-5.3.29.jar:5.3.29]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) [servlet-api.jar:4.0.FR]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) [catalina.jar:9.0.85]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.85]
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) [tomcat-websocket.jar:9.0.85]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.85]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.85]
	at com.confio.iwc.web.filter.LoginFilter.doFilter(SourceFile:301) [pi.jar:?]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) [catalina.jar:9.0.85]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) [catalina.jar:9.0.85]

 

For workaround of this issue , customer can create a custom alert with type 'Custom SQL Alert - Multiple Numeric Return' and add below query as Alert parameter with Oracle database instance.
 

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

select tablespace_name, 100-used_percent from dba_tablespace_usage_metrics