IJ30035: SQL SERVER REST API - ROWSTAMP CONVERSION ISSUE

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION:
  When converting the JSON rowstamp to the lastfetchts parameter,
  receive error: "BMXAA4210E - MSSQL Database error number 8114
  has occurred."
  
  STEPS TO REPRODUCE:
  1) Go to Postman
  Enter a get method:
  http://hostname:port/maxrest/oslc/os/mxperson?stableId&lean=1&pa
  geno=1&oslc.pageSize=5&oslc.select=personid&stablepaging=1&lastf
  etchts=2263&fetchmodedelta=1
  where lastfetchs value is the rowstamp
  The OSLC query contains a "Lastfetchts" value which is the
  rowstamp
  2) Click on the Send button
  It does not return any output
  3) Enters a large rowstamp
  http://hostname:port/maxrest/oslc/os/mxperson?stableId&lean=1&pa
  geno=1&oslc.pageSize=5&oslc.select=personid&stablepaging=1&lastf
  etchts=22631427128&fetchmodedelta=1
  
  ACTUAL BEHAVIOUR:   Error: "BMXAA4210E - Database error number
  8114 has occurred. Invalid SQL queries are logged in the log
  file. Check the SQL query to identify the error.",
  "statusCode": "400",
  "reasonCode": "BMXAA4210E",
  "extendedError": {
  "moreInfo": {
  "href":
  "http://hostname:port/maxrest/oslc/error/messages/BMXAA4210E"
  
  Except from log with SQL set to DEBUG
  [ERROR] select count(*) from person where (rowstamp>2248966109)
  com.microsoft.sqlserver.jdbc.SQLServerException: Error
  converting data type timestamp to numeric.
  
  EXPECTED BEHAVIOUR:  No error message
  Maximo log should show the query below:
  select count(*) from person where (cast(rowstamp as
  BIGINT)>2248966109)
  
  PRODUCT VERSION:
  IBM Maximo Asset Management version 7.6.0.8
  IBM Integration Framework 7.6.0.8
  

Local fix

Problem summary

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
    | release\fix pack | Interim Fix for Release 7.6.1.3 Product
  

Temporary fix

Comments

APAR Information

• 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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels