APAR status
Closed as program error.
Error description
Problem Description Error when the LBSLOCATION data is synchronized between Anywhere applications and Maximo (Desktop) STEPS TO REPRODUCE: 1) Go to "System Properties" application and filter for "mxe.int.webappurl" property Modify the default value to include a port number e.g. http://localhost:9080/meaweb Save and perform a "live refresh" 2) Filter for "mxe.int.globaldir" property Define the location of web service related file folder e.g. c:\IBM\SMP\maximo\mea-global 3) Filter for "mxe.int.containerdeploy" property Set the value to 1 Save and restart Maximo application server for the change to take effect 4) Go to "Database Configuration" application Bring up LBSLOCATION object Go to Relationships tab Click "New Row" button to add a new relationship relationship: WCPERSON Where Clause: personid =:key2 Child Object: PERSON Click "New Row" button to add another relationship relationship: WCLABORCRAFTRATE Where Clause: orgid =:key1 and laborcode=:key2 and defaultcraft = 1 Child Object: LABORCRAFTRATE Click "New Row" button to add another relationship relationship: WCASSIGNMENT Where Clause: wonum = :wonum and laborcode = :key2 and siteid = :key1 and changedate = (select max(a.changedate) from assignment a where a.wonum = assignment.wonum and a.siteid = assignment.siteid and a.laborcode = assignment.laborcode ) Child Object: ASSIGNMENT 5) Go to "Object Structures" application and create a new "Object Structure" called WCLBSLOCATION Set "Consumed By" as "Integration" Click "New Row" button Add the folllowing objects respectively: PERSON , LABORCRAFTRATE , ASSIGNMENT Object Parent Relationship Name LBSLOCATION LBSLOCATION PERSON LBSLOCATION WCPERSON LABORCRAFTRATE LBSLOCATION WCLABORCRAFTRATE ASSIGNMENT LBSLOCATION WCASSIGNMENT 6) Go to "Web Service Library" application Click "Create Web Service" action Select "Create Web Service from Object Structure" sub-option Select "WCLBSLOCATION" created from step 5 above Click "Create" button Select "WCLBSLOCATION" Web Service Select "Deploy to Application Server Web Service Container" action and select "Generate Deployment File Entries" to Deploy "WCLBSLOCATION" web service System message pops up: BMXAA7749I - A file was generated for deploying the WCLBSLOCATION Web service. 7) Click "Generate Schema, WSDL and View XML" button Go to the URL below http://localhost:9080/meaweb/wsdl/WCLBSLOCATION.wsdl 8) Go to SOAPUI and create a new project Enter a project name e.g. WCLBSLOCATION Enter the URL for the initial WSDL: http://localhost:9080/meaweb/wsdl/WCLBSLOCATION.wsdl Click OK 9) Enter the query below: <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:max="http://www.ibm.com/maximo"> <soapenv:Header/> <soapenv:Body> <max:QueryWCLBSLOCATION > <max:WCLBSLOCATIONQuery> <max:WHERE>concat(lastupdate, key2) in (select concat(max(lastupdate), key2) from lbslocation group by key2)</max:WHERE> </max:WCLBSLOCATIONQuery> </max:QueryWCLBSLOCATION> </soapenv:Body> </soapenv:Envelope> 10) Click the green arrow to run the query RESULTS: Maximo log shows error below: psdi.util.MXApplicationException: BMXAA4176E - Attribute WOCLASS does not exist. Gather the logs from the <HOME> directory and determine the process or app referencing the invalid attribute. EXPECTED RESULTS: No error message in Maximo log REPORTED IN VERSION Maximo Asset Management 7.6.0.9 IBM Maximo Anywhere 7.6.2.1
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * maximo spatial * **************************************************************** * PROBLEM DESCRIPTION: * * Error when the LBSLOCATION data is synchronized between * * Anywhere applications and Maximo (Desktop) * **************************************************************** * RECOMMENDATION: * ****************************************************************
Problem conclusion
Fix has been made to fix....The fix for this APAR is contained in the following maintenance package: | release\fix pack\interim fix for Release 7.6.1.1 of Base Services(Scheduler 7673)
Temporary fix
Comments
APAR Information
APAR number
IJ13300
Reported component name
ANYWHERE APPS
Reported component ID
5725M39MA
Reported release
762
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-02-05
Closed date
2019-03-08
Last modified date
2019-03-08
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
ANYWHERE APPS
Fixed component ID
5725M39MA
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSPJLC","label":"Maximo Anywhere"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"762","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
08 March 2019