IJ30521: OUT OF THE BOX LABOUR UTILIZATION REPORT NOT WORKING AFTER UPGRADE TO 7.6.1.1

APAR status

• Closed as program error.

Error description

• After upgrading to 7.6.1.1, the report labor_util.rptdesign
  does not work both in Labor app and Report administration
  app.
  
  
  Steps to reproduce:
  
  Attempt to run the report from
  Labor or Report administration applications.
  
  
  Error seems to
  be happening on the fetch statements:
  
  [7/16/20 5:22:05:464
  EDT] 00018532 SystemOut O %%%%%%%% FRAMESET FRAGMENT SOAP URL =
  https://www.site.com/maximo/bridge/frameset?__InT$WhErE=1%3D1&__
  locale=en_US&__newrun=true&__report=1594891323990%2Fbirtreport%2
  Flabor_util.rptdesign&__islocale=startdate&__scheduleType=immedi
  ate&__where__ibm__key=DsLvASMUQ4rfDEXshzr6uGpktyIDON&__reportnam
  e=labor_util.rptdesign&__UsE$InT$WhErE=true&__requestid=15948913
  22801&__document=%2Fopt%2FIBM%2FWebSphere%2FAppServer%2Fprofiles
  %2FctgAppSrv%2Ftemp%2Fnode.sodexo-na-stage-pui-wdc04-3%2FMXServe
  r01%2FMAXIMO_UI%2Fmaximouiweb.war%2Freportruntime%2Freports%2F15
  94891323990%2F_output%2Flabor_util.rptdocument&__InT$DiSp$WhErE=
  
  
  
  The error reads:
  
  [9/10/20 12:48:37:492 EDT] 0000016b
  SystemOut O 10 Sep 2020 12:48:37:492 [ERROR] [MXServer01] []
  ReportRequestFilter, Errorcode:500Error Description:<?xml
  version="1.0" encoding="UTF-8"?><soapenv:Envelope
  xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
  xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://w
  ww.w3.org/2001/XMLSchema-instance"><soapenv:Body><soapenv:Fault>
  <faultcode>BirtRunReportActionHandler.__execute()&amp;lt;/faultc
  ode><faultstring>Multiple exceptions
  occurred.</faultstring><detail><ns1:hostname xmlns:ns1="http://x
  ml.apache.org/axis/">x00454.cds.mro.com</ns1:hostname><string>or
  g.eclipse.birt.report.engine.api.EngineException: There are
  errors evaluating script &quot;if
  (!maximoDataSet.fetch())
  
  	return
  (false);
  
  row[&quot;orgid&quot;] = maximoDataSet.getString(&quot
  ;orgid&quot;);
  row[&quot;laborcode&quot;] = maximoDataSet.getSt
  ring(&quot;laborcode&quot;);
  row[&quot;craft&quot;] = maximoData
  Set.getString(&quot;craft&quot;);
  row[&quot;paycode&quot;] = ma
  ximoDataSet.getString(&quot;paycode&quot;);
  row[&quot;regpremhr
  s&quot;] = maximoDataSet.getFloat(&quot;regpremhrs&quot;);
  row[
  &quot;groupfield&quot;] = row[&quot;laborcode&quot;] +
  &quot;|&quot; + row[&quot;craft&quot;] + &quot;|&quot; +
  row[&quot;paycode&quot;];
  row[&quot;subfield&quot;] =
  row[&quot;laborcode&quot;] + &quot;|&quot; +
  row[&quot;craft&quot;];
  
  // Execute secondary
  query
  
  labtransStrucDataSet = MXReportDataSetProvider.create(thi
  s.getDataSource().getName(),&quot;labtrans&quot;);
  labtransStruc
  DataSet.open();
  
  var where = params[&quot;where&quot;];
  if
  (params[&quot;laborcode&quot;].value)
  	where += &quot; and
  labor.laborcode = '&quot; + params[&quot;laborcode&quot;] +
  &quot;' &quot;;
  ................
  null.
  	at org.eclipse.birt.repo
  rt.engine.script.internal.DtEScriptExecutor.handleJS(DtEScriptEx
  ecutor.java:99)
  	at org.eclipse.birt.report.engine.script.intern
  al.DataSetScriptExecutor.handleJS(DataSetScriptExecutor.java:256
  )
  	at org.eclipse.birt.report.engine.script.internal.ScriptDataS
  etScriptExecutor.handleFetch(ScriptDataSetScriptExecutor.java:14
  3)
  	at org.eclipse.birt.data.engine.impl.ScriptDataSetRuntime.fe
  tch(ScriptDataSetRuntime.java:103)
  	at org.eclipse.birt.data.eng
  ine.impl.PreparedScriptDSQuery$ScriptDSQueryExecutor$CustomDataS
  et.fetch(PreparedScriptDSQuery.java:260)
  	at org.eclipse.birt.da
  ta.engine.executor.cache.OdiAdapter.fetch(OdiAdapter.java:226)
  
  at org.eclipse.birt.data.engine.executor.cache.RowResultSet.fetc
  h(RowResultSet.java:145)
  	at org.eclipse.birt.data.engine.execut
  or.cache.RowResultSet.doNext(RowResultSet.java:118)
  	at org.ecli
  pse.birt.data.engine.executor.cache.RowResultSet.next(RowResultS
  et.java:96)
  	at org.eclipse.birt.data.engine.executor.cache.Expa
  ndableRowResultSet.next(ExpandableRowResultSet.java:63)
  	at org.
  eclipse.birt.data.engine.executor.cache.SmartCacheHelper.populat
  eData(SmartCacheHelper.java:318)
  	at org.eclipse.birt.data.engin
  e.executor.cache.SmartCacheHelper.initInstance(SmartCacheHelper.
  java:285)
  	at org.eclipse.birt.data.engine.executor.cache.SmartC
  acheHelper.getResultSetCache(SmartCacheHelper.java:246)
  	at org.
  eclipse.birt.data.engine.executor.cache.SmartCache.&lt;init&gt;(
  SmartCache.java:74)
  .................
  
  
  Environment:
  
  Tivoli's
  process automation engine 7.6.1.1
  

Local fix

• n/a
  

Problem summary

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: | Release 7.6.1.3 of Base Services
  

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

  MAXIMO REPORTIN

• Fixed component ID

  TIVOREPTS

Applicable component levels