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.
------------------------------
Suhas Joshi
------------------------------
Original Message:
Sent: Wed April 26, 2023 08:41 AM
From: Steven Shull
Subject: Issue accessing Manage Inspection Forms and Saving
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.
------------------------------
Steven Shull
Original Message:
Sent: Tue April 25, 2023 08:15 AM
From: Suhas Joshi
Subject: Issue accessing Manage Inspection Forms and Saving
Hi,
We have recently upgraded to 7.6.1.3 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=1
If 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?
------------------------------
Suhas Joshi
------------------------------