JR62216: GETTING THE OUTPUT TABLE OF A DATA RULE OR RULE SET USING REST API WITH MICROSERVICES ON.

APAR status

• Closed as program error.

Error description

• On an UG install, if the jdbc datasource for iadb is configured
  with "localhost" in the WebSphere Console, the API call - https:
  //hostname:9446/ibm/iis/ia/api/executableRule/outputTable?projec
  tName=<Project_Name>&ruleName=<RuleName>&executionID=0 , fails
  with the below error :
  
  Something went wrong. More details
  follow... Cannot call IA micro-service GET workspaces/ec1481df.6
  4b1b87d.kahmvbpv4.44m3lbe.5urhav.h8m7dlreflhdrr604di0h/dataRules
  /ec1481df.a5023b17.kaa6mi0r3.uheeubt.6nl810.uqk98anqa011bc85t959
  d/executions/ec1481df.f92d8a7c.kahn1g3or.pb6o5um.nemdc5.a8mjt9ah
  3vsojk1aea4pk/outputData with params {nbOfRecords=-1,
  startIndex=0}: Remote error
  com.ibm.iis.ia.services.exceptions.IAException occurred:
  CDICO0105E: Invalid port: Disconnect non transient connection
  error: [jcc][t4][2043][11550][4.23.42] Exception Connect error:
  Error opening socket to server localhost/127.0.0.1 on port
  50,000 with message: Connection refused (Connection refused).
  ERRORCODE=-4499, SQLSTATE=08001
  
  Now after changing the
  HostName from "localhost" to point to the physical host name,
  the above call fails with the below error :
  
  Failed with error
  -- CDIIA0001E: APIServiceProvider.java:194 An error occurred
  while accessing the service XMETAHelper.query()
  

Local fix

Problem summary

• Getting the output table of a data rule or rule set using REST
  API fails on an install with IA Microservices
  

Problem conclusion

• Fixed in 11.7.1 FP1
  

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

  WIS INFORM ANAL

• Fixed component ID

  5724Q36IA

Applicable component levels

• RB71 PSY

     UP