IJ21622: REMOVE ROWSTAMP FROM THE PUB CHANNEL JSON

APAR status

• Closed as program error.

Error description

• Abstract
  ========
  Remove rowstamp from the pub channel
  json
  
  Problem
  =========
  When performing an update action
  against the PR the Publish channel generate the JSON Message
  and send it to the endpoint the Message proceeded successfully
  on the test server and delivered to DEV server.
  
  But the
  message contains the _rowstamp property with value coming from
  the TEST server !, so the message doesn't process and gives
  error:
  
  "BMXAA8229W - Record xxxxxx has been updated by another
  user. Your changes have not been saved. Refresh the record and
  try again."
  
  If you delete the _rowstamp property from the
  message, you can Consume the message.
  
  Steps to
  reproduce
  ====================
  1. Go To Integration --> Object
  Structure--> Create a new record "MODIFYPR"
  Consumed By:
  INTEGRATION
  Source Object = PR
  
  2. Exclude all persistent field
  except "description" , "PR1" , "PRNUM", "SITEID" --> OK and
  Save Changes
  
  3. Create a new Publish Channel =
  MODIFYPR-CHN
  Associate Object Structure = MODIFYPR
  Check the
  box against "Publish JSON"
  Enable Event listener.
  
  4. Create a
  new End Points = OUTBOUND-DE
  Handler = HTTP
  HEADERS =
  Content-Type:application/json,x-method-
  override:Patch,properties:prnum,description,siteid
  HTTPMETHOD =
  POST
  URL = https://xxxx-xxxx.xxxxx.xxxx/meaweb/esqueue/Inbound-s
  ys/MODIFYPR-R-ES
  USERNAME = xxxxxx
  PASSWORD = XXXXXXXXXX
  
  5.
  Create a new External Systems "OUTBOUBT-SYS"
  End Point =
  OUTBOUND-DE
  Outbound Sequential Queue =
  jms/maximo/int/queues/sqout
  Inbound Sequential Queue =
  jms/maximo/int/queues/sqin
  Inbound Continous Queue =
  jms/maximo/int/queues/cqin
  Enabled = CHECKED
  
  6. Click on
  Publish Channels Tab --> Click Select Channel --> Select
  "MODIFYPR-CHN"
  End Point = OUTBOUND-DE
  Enabled = CHECKED
  
  7.
  Go to PR --> select an existing PR = 1010
  Change the
  description and SAVE
  
  8. Go to Message Reprocessing --> Filter
  for OUTBOUBT-SYS
  
  Results
  ========
  Error data
  {
  "_id":
  "1010-BEDFORD",
  "_rowstamp": "243650",
  "description": "TEST
  with Maximo",
  "href": "http:\/\/xxxx.xxxx.xx.xxxxxx.xxx.xxxx:xx\
  /maximo\/oslc\/os\/modifypr\/_MTAxMC9CRURGT1JE",
  "prnum":
  "1010",
  "siteid": "BEDFORD"
  }
  
  So the message doesn't process
  and gives the error:
  "BMXAA8229W - Record xxxxx has been
  updated by another user. Your changes have not been saved.
  Refresh the record and try again."
  
  Expected
  Results
  ================
  No row stamp should be
  displayed.
  
  Environment
  ==============
  TPAE 7.6.1.0
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * REMOVE ROWSTAMP FROM THE PUB CHANNEL JSON                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

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