Troubleshooting
Problem
You may face the following error in PM Master when you try to add a new record, and a condition is previously associated to WOSTATUS domain values:
BMXAA4210E - Database error number 207 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.
For some reason Master PM is validating against a condition on a domain associated to WOSTATUS and throwing this error.
Symptom
Steps to replicate this scenario :
Step 1. In Conditional Expression Manager app, Create a condition as this where clause, and Reevaluate = true.
STATUS NOT IN ('WAPPR','WSCH')
STATUS NOT IN ('WAPPR','WSCH')
Step 2. Associate the condition to the WOSTATUS Domain.
Open the Domains application and filter for WOSTATUS
Associate Condition to Status values like COMP for example. (Some of the domain status values associated are COMP, INPRG, CLOSE)
Associate and Save.
Open the Domains application and filter for WOSTATUS
Associate Condition to Status values like COMP for example. (Some of the domain status values associated are COMP, INPRG, CLOSE)
Associate and Save.
Step 3:
Open Master PM app and select New Master PM button and get the following error:
Open Master PM app and select New Master PM button and get the following error:
BMXAA4210E - Database error number 207 has occurred. Invalid SQL queries are logged in the log file. Check the SQL query to identify the error.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"ARM Category":[{"code":"a8m50000000CbP6AAK","label":"System Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6.0;7.6.1"}]
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 Asset Management
Component:
System Administration
Software version:
7.6.0, 7.6.1
Document number:
6373704
Modified date:
30 November 2020
UID
ibm16373704
Manage My Notification Subscriptions