Question & Answer
Question
STEPS:
1) Set SQL to DEBUG in Logging application
2) Open Postman and enter a GET URL to connect to an SQL Server environment
http://hostname:port/maxrest/oslc/os/mxperson?stableId&lean=1&oslc.select=personid&stablepaging=0&lastfetchts=904687&fetchmodedelta=1
3) Get a response:
{"member": [
{
"email_collectionref": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--/email",
"_rowstamp": "[0 0 0 0 0 21 -80 -127]",
"personid": "ABBY",
"sms_collectionref": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--/sms",
"href": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--",
"phone_collectionref": "http://hostname:port/maxrest/oslc/os/mxperson/_QUJCWQ--/phone"
},
4) In the Maximo log, rowstamp converts to BIGINT
select * from person where (cast(rowstamp as bigint)>904687)
Question:Why it is returning in bye array format instead of integer?
When you pass rowstamp to Maximo in the get request, the lastfetchts value is integer. Why Maximo needs rowstamp in integer format for request but returns byte array format in response?
[{"Type":"MASTER","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":"a8m50000000CbFGAA0","label":"Integration"}],"ARM Case Number":"TS009160210","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"},{"Product":{"code":"SSRHPA","label":"IBM Maximo Application Suite"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
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
Modified date:
17 September 2025
UID
ibm16584947