Troubleshooting
Problem
The /maximo/api/members/thisserver/pingdb MMI call returns a database connection error when Microsoft SQL Server database is used with IBM Maximo Manage application in IBM Maximo Application Suite. The error message displayed is as follows:
05 Jul 2023 07:54:34:518 [ERROR] [MXServer] [CID-MXOSLC-233823] ping db connection error -- The statement did not return a result set.
Symptom
The /pingDB MMI call shows empty braces with no data, that is, '{}'.
On checking Maximo Manage logs, the following stack trace can be seen:
05 Jul 2023 07:54:34:518 [INFO] [MXServer] [CID-MXOSLC-233823] Correlation started, correlation data added: ResponseResourceSize:2
On checking Maximo Manage logs, the following stack trace can be seen:
05 Jul 2023 07:54:34:518 [INFO] [MXServer] [CID-MXOSLC-233823] Correlation started, correlation data added: ResponseResourceSize:2
05 Jul 2023 07:54:34:518 [INFO] [MXServer] [CID-MXOSLC-233823] Correlation started, correlation data added: ResponseResourceSize:2 SendResponseTime:0
05 Jul 2023 07:54:34:519 [INFO] [MXServer] [CID-MXOSLC-233823] Correlation started, correlation data added: ResponseResourceSize:2 RequestURI:/maximo/api/members/thisserver/pingdb SendResponseTime:0
05 Jul 2023 07:54:34:519 [INFO] [MXServer] [CID-MXOSLC-233823] Correlation started, correlation data added: ResponseResourceSize:2 RequestURI:/maximo/api/members/thisserver/pingdb SendResponseTime:0 RequestParams:lean=1&ccm=1
05 Jul 2023 07:54:34:519 [INFO] [MXServer] [CID-MXOSLC-233823] Correlation started, correlation data added: ResponseResourceSize:2 RequestURI:/maximo/api/members/thisserver/pingdb SendResponseTime:0 ClientIP:10.128.3.164 RequestParams:lean=1&ccm=1
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"ARM Category":[{"code":"a8m3p000000hAeaAAE","label":"Maximo Application Suite-\u003EMAS Applications-\u003EManage"}],"ARM Case Number":"TS013531279","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Maximo Application Suite
Component:
Maximo Application Suite->MAS Applications->Manage
Software version:
All Versions
Document number:
7025113
Modified date:
11 August 2023
UID
ibm17025113
Manage My Notification Subscriptions