IBM Support

RS03345: EXCEL REPORT CREATED AFTER RUNNING A TEST SUITE THAT USES A CUSTOM DATA PROVIDER CANNOT BE OPENED.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In ODM 8.10 it is not possible to open the Excel report that is
    generated after running a test suite that uses a custom data
    provider cannot be opened. Microsoft Excel gives an error and
    the only way to open the report is by renaming the file from
    .xlsx to .xsl.
    
    Steps to reproduce:
    1. Follow steps on this link word to word:
    https://www.ibm.com/support/knowledgecenter/en/SSQP76_8.10.x/com
    .ibm.odm.dcenter.samples/topics/smp_dc_bc_simu.html
    2. In the "Running custom tests and simulations" section
    complete "Creating a custom test provider" and "Defining and
    running a test suite that uses a custom data provider" sections
    only. At step 3 of the "Defining and running a test suite that
    uses a custom data provider" section select the "Create excel
    file with report output values" checkbox.
    3. Try to open the report that gets created. You won't be able
    to & MS Excel will complain.
    

Local fix

  • Create a file TesDataProvider.xml with content:
    
    <!-- --- START FILE --- -->
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <!DOCTYPE properties SYSTEM
    "http://java.sun.com/dtd/properties.dtd">
    <properties>
    <comment></comment>
    <entry key="version">jrules-8.10.0</entry>
    <entry key="format.name">TestDataProvider</entry>
    <entry key="testable.execution.details"></entry>
    <entry
    key="number.of.digits.right.to.the.decimal.point.for.comparisons
    ">2</entry>
    <entry key="format.properties">office.version</entry>
    <entry key="format.property.office.version">2007</entry>
    </properties>
    <!-- ---- END FILE --- -->
    
    Copy the file in
    decisioncenter.war/WEB-INF/classes/scenarioSuiteFormats
    
    You need to reload scenario file or recreate a test suite to
    update the format. Existing report will remain with the
    incorrect format.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Decision Center users running test suites in the Business    *
    * Console.                                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Wrong format when generating the report.                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The code was fixed.
    

Temporary fix

  • Create a file TesDataProvider.xml with content:
    
    <!-- --- START FILE --- -->
    <?xml version="1.0" encoding="ISO-8859-1"?>
    <!DOCTYPE properties SYSTEM
    "http://java.sun.com/dtd/properties.dtd">
    <properties>
    <comment></comment>
    <entry key="version">jrules-8.10.0</entry>
    <entry key="format.name">TestDataProvider</entry>
    <entry key="testable.execution.details"></entry>
    <entry
    key="number.of.digits.right.to.the.decimal.point.for.comparisons
    ">2</entry>
    <entry key="format.properties">office.version</entry>
    <entry key="format.property.office.version">2007</entry>
    </properties>
    <!-- ---- END FILE --- -->
    
    Copy the file in
    decisioncenter.war/WEB-INF/classes/scenarioSuiteFormats
    
    Reload scenario file or recreate a test suite to update the
    format.
    

Comments

APAR Information

  • APAR number

    RS03345

  • Reported component name

    WS DECISION CTR

  • Reported component ID

    5725B6900

  • Reported release

    8A0

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-03-20

  • Closed date

    2019-04-01

  • Last modified date

    2019-04-01

  • 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

    WS DECISION CTR

  • Fixed component ID

    5725B6900

Applicable component levels

  • R8A0 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8A0","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
03 November 2021