IBM Support

Troubleshooting database connection error on Microsoft SQL server for pingDB MMI call

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
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.

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