IJ40847: ERR_INVALID_RESPONSE ERROR DOWNLOADING RECORDS FROM TABLE WINDOW CONTROL

APAR status

• Closed as program error.

Error description

• PROBLEM:
  Downloading records from table window control in applications
  like the Work Order in children table of the Work Order
  Tracking, Plans tab, will make a new tab open and the following
  error is displayed in the browser:
  
  It looks like the webpage at http://hostname:9080/maximo/ui/165
  2106875617?_tbldnld=plans_children_table&uisessionid=4might be h
  new web address.
  
  ERR_INVALID_RESPONSE
  
  Here is a sample of what you see in the logs:
  
  SRVE0068E: An exception was thrown by one of the service methods
  of the servlet [webclient] in application [MAXIMO]. Exception
  created : [java.lang.IllegalArgumentException: Invalid sheet
  name 'List of Work Order 2018305648''. Sheet names must not
  begin or end with (').
  at org.apache.poi.ss.util.WorkbookUtil.validateSheetName(Workbo
  okUtil.java:159)
  at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFW
  orkbook.java:849)
  at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFW
  orkbook.java:122)
  at com.ibm.tivoli.maximo.export.excel.ExcelExportWriter.beginDo
  cument(ExcelExportWriter.java:83)
  at psdi.webclient.system.controller.TableDownload.init(TableDow
  nload.java:116)
  at psdi.webclient.system.controller.TableDownload.generatexlsx(
  TableDownload.java:200)
  at psdi.webclient.system.controller.RequestManager.manageReques
  t(RequestManager.java:208)
  at psdi.webclient.servlet.WebClientServlet.handleRequest(WebCli
  entServlet.java:141)
  at psdi.webclient.servlet.WebClientServlet.doGet(WebClientServl
  et.java:93)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  
  There seems to be an issue on how the excel spreadsheet name is
  being built, that's why it is not displayed on the screen, and
  apparently the root cause is that the user may have shortened
  the table title, which is used to set the work sheet name.
  
  
  By default, it is: Tasks for Work Order [wonum]
  The user's table title appears to be like this:  Work Order
  [wonum]
  
  The other key to this issue is that the wonum ends with a single
  quote. There is code in TableDownload.java that truncates the
  work sheet name after 30 characters. With the default table
  title, it becomes:
  List of Tasks for Work Order [the first character only of the
  wonum] (ex. List of Tasks for Work Order 1)
  ... but because the user's table title could have been
  shortened, the work sheet name does not get truncated
  List of Work Order 2018305648'
  
  
  STEPS TO REPRODUCE:
  1. Open Maximo as maxadmin
  2. Go to Application Designer and change Work Order Tracking app
  to ensure the plans_children_table label is shortened. Ensure
  that you have shortened the table title for Children workorder
  section in Plans tab, which is used to set the work sheet name.
  
  
  By default, it is: Tasks for Work Order [wonum]
  Set it to something like this:  Work Order [wonum]
  
  3. Save changes
  4. Go to Work Order Tracking app and select any record with
  children work orders associated
  5. Click on the download link for the table window showing the
  children work orders
  6. You will get:
  
  ERR_INVALID_RESPONSE error downloading records from table window
  control
  
  ...and in the logs you will see:
  SRVE0068E: An exception was thrown by one of the service methods
  of the servlet [webclient] in application [MAXIMO]. Exception
  created : [java.lang.IllegalArgumentException: Invalid sheet
  name 'List of Work Order 2018305648''. Sheet names must not
  begin or end with (').
  
  CURRENT ERRONEOUS RESULT:
  Getting error trying to click on the download link for the table
  window shoing the children work orders
  
  EXPECTED RESULT:
  We should not get any error trying to click on the download link
  for the table window shoing the children work orders
  
  ENVIRONMENT VERSION:
  IBM WebSphere Application Server 9.0.5.11
  Tivoli's process automation engine 7.6.1.2-IFIX20220330-1115
  Build 20200715-0100 DB Build V7612-284 HFDB Build HF7612-80
  IBM Maximo Asset Management Work Centers 7.6.0.4 Build
  20200715-0100 DB Build V7604-119 HFDB Build HF7680-10
  TRM RulesManager SE 5.8.0.4 Build 3711 DB Build V5832-01
  IBM Tpae Integration Framework 7.6.1.2 Build 20200615-2330 DB
  Build V7612-11
  IBM Maximo Asset Management 7.6.1.2 Build 20200715-0100 DB Build
  V7611-01
  IoT Connection Utility 7.6.0.3 Build 20200701-1409 DB Build
  V7603-32
  

Local fix

• Change the table title back to the default as a workaround
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Downloading records from table window control in             *
  * applications                                                 *
  * like the Work Order the following error is displayed in      *
  * logs                                                         *
  * Invalid sheet name 'List of Work Order 2018305648''. Sheet   *
  * names must not                                               *
  * begin or end with (').                                       *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR will be contained in a future release.
  

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

  SYSTEM CONFIG

• Fixed component ID

  5724R46S1

Applicable component levels