IV55986: LOADING DATA VIA INTEGRATION OBJECT (ISKEY) WRONGLY RECORDS EXCEPTION " A BLANK VALUE FOR ACTIONNAME., NULL"

APAR status

• Closed as program error.

Error description

• Loading data via integration object (iskey) wrongly records
  exception exception:
  [-1]com.tririga.ws.errors.InvalidArgumentException: A valid
  record id must be specified when using a blank value for
  actionName., null
  
  
  PMR Summary:
  
  Prob: Integration object failing to load records on isKey
  
  1. Loading records with isKey (InvalidArgumentException) : " A
  valid record id must be specified when using a blank value for
  ActionName,, null"
  
  2. How to reload a failed record or re-submit a failed record.
  
  
  Envir: TRI (A) 10.3.2 / 3.3.2, Oracle, Weblogic, OS AIX
  (IBM JDK)
  
  Client desc:
  
  A valid record id must be specified when using a blank value
  for actionName
  
  I am trying to load records using Integration Object with isKey
  set in data mapping.
  
  Number of records get imported but number of them return
  following error:
  
  [-1]com.tririga.ws.errors.InvalidArgumentException: A valid
  record id must be specified when using a blank value for
  actionName., null
  
  --
  
  Steps to Reproduce:
  
  1. Goto Home  > Portfolio > Geo/Location Hierarchy
  
  2. Click New World Region
  
  3. Create a record called "Is Key Data Load" save and activate
  
  --
  
  4. Goto Home > Tools > System Setup > Integration > Integration
  Object
  
  5. Click Add
  
  
  6. General tab set the following.
  
  Name:   Test Exception
  
  Schema:  File
  
  Direction:  Inbound
  
  
  7. File Section
  
  Delimiter Pipe |
  
  Manual (checked)
  
  File: Attach a file with values to load.
  
  Client provided a file csv format.
  
  Eg values:
  
  triNameTX|triFedGLCTX|triCountryCodeTX
  Kenya|KE|KE
  South Africa|ZA|ZA
  Bangladesh|BD|BD
  Bhutan|BT|BT
  Brunei|BN|BN
  Cambodia|KH|KH
  China|CN|CN
  India|IN|IN
  Indonesia|ID|ID
  Japan|JP|JP
  Kazakhstan|KZ|KZ
  North Korea|KP|KP
  South Korea|KR|KR
  Kyrgyzstan|KG|KG
  Laos|LA|LA
  Malaysia|MY|MY
  Maldives|MV|MV
  Mongolia|MN|MN
  Myanmar|MM|MM
  Nepal|NP|NP
  Philippines|PH|PH
  Singapore|SG|SG
  Sri Lanka|LK|LK
  Taiwan|TW|TW
  Tajikistan|TJ|TJ
  Thailand|TH|TH
  
  
  8. Click the Data Map tab and populate the fields.
  
  Select Modules: Geography
  BO: triCountry
  Forms: Country (triCountry)
  Default Action: Create Draft (triCreateDraft)
  
  
  9. Map screen Add the Fields
  
  triNameTX                   isKey (Checked)
  triCountryCodeTX
  triFeDGLCTX
  
  10. Save Map
  
  11. Save the Integration Object record.
  
  12. Click Execute.
  
  Wait for processing to complete.
  On the General tab check the Execution History.
  
  Check if any failures.
  For client they receive failures.
  
  Exception:
  
  [-1]com.tririga.ws.errors.InvalidArgumentException: A valid
  record id must be specified when using a blank value for
  actionName., null
  
  Server.log
  
  2014-02-19 13:26:45,322 INFO
  [com.tririga.custom.integration.Resubmit](WFA:14562638 -
  22603616 triResubmit:333178601 IE=333178601) [25109]
  integration completed.
  2014-02-19 13:32:26,061 INFO
  [com.tririga.custom.integration.Integration](WFA:14562638 -
  22603089 triExecute:333178609 IE=333178609) [25129] registering
  clientId: [14562638] for custom task.
  2014-02-19 13:32:48,884 ERROR
  [com.tririga.ws.TririgaWSImpl](Thread-773)
  com.tririga.ws.errors.InvalidArgumentException: A valid record
  id must be specified when using a blank value for actionName.
  com.tririga.ws.errors.InvalidArgumentException: A valid record
  id must be specified when using a blank value for actionName.
           at
  com.tririga.ws.WSProcessThread.processRecord(WSProcessThread.jav
  a:426)
           at
  com.tririga.ws.WSProcessThread.run(WSProcessThread.java:134)
  ----------------------------------------------------------------
  
  L2 reproduced the problem. (L3 Request: 124231)
  Attachments on L3 request.
  Development requested to add an APAR.
  

Local fix

• None other then to resubmit the records which failed.
  
  Client more concern as effects their load of records if fails.
  

Problem summary

• Resolved an Integration Object file data import issue, where
  the following error would occur if the file contained a mixture
  of new and existing data: "A valid record id must be specified
  when using a blank value for actionName". Due to this error,
  the new data in the file would not correctly import. This fix
  will be available in the 3.3.2.2 and 3.4.0.0 releases.
  

Problem conclusion

•  This fix will be available in the 3.3.2.2 and 3.4.0.0 releases.
  

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:

Modules/Macros

• 999
  

Fix information

• Fixed component name

  TRI APPLCATION

• Fixed component ID

  5725F26AB

Applicable component levels

• R332 PSY

     UP