IBM Asset & Facilities Management Your destination for peer and expert insights to help unlock the power of data with AI and Asset & Facilities Management to advance your digital reinvention. Join / Log in
Hi,We have recently upgraded to 126.96.36.199 along with iFix 005. Post upgrade when we are trying to access "Manage Inspection Forms" we are getting below error:BMXAA9105E - Invalid OSLC order by identifier name specified. Make sure the identifier is included in the resource definition.In the background below query is getting fired and failed:
https://<ABCD>/maximo/oslc/os/mxapiinspform?savedQuery=INSPECTIONALL&lean=1&collectioncount=1&oslc.select=*%2Cinspectionformstatus%7Bhref%7D%2Cinspectionresult%7Bhref%7D%2Cinspquestion%7Bhref%7D%2Cpersonchange.displayname%2Cpersoncreate.displayname%2Cinspformscript%7B*%7D&oslc.pageSize=30&searchAttributes=name%2Cinspformnum&addlocalizedrep=1&oslc.orderBy=%2Bname&internalvalues=1&addid=1&querylocalized=1&internalvalues=1If you see highlighted part of above query is causing issues. If we replace "name" by "description" it works fine. So there is some setting somewhere which is not allowing "name" field to be used. Any pointers?
NAME should be a valid attribute on INSPECTIONFORM. Can you go into Database Configuration and verify that on the INSPECTIONFORM object you see NAME and that its search type is set to WILDCARD/EXACT? It's possible if this was set to NONE that the REST API would prevent sorting on it.
Hi Steven,Thanks for the inputs. I was able to resolve the issue. The problem was NAME attribute was somehow excluded from the MXAPIINSPFORM object structure. I have included it and now it is working fine.