APAR status
Closed as program error.
Error description
Error "There was an exception on the server. Check your report parameter values, or contact your system administrator, who can find additional details in the server log." appears when selecting a site from the lookup for the Location Hierarchy report. Log shows " [5/24/23, 6:30:39:422 GMT] 0000019d SystemOut O 24 May 2023 06:30:39:419 [ERROR] [MXServer] [] DataSet [paramsHelperDS] fetch failed: com.ibm.db2.jcc.am.SqlDataException: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, " STEPS TO REPRODUCE: Login to maximo Open Location application Click on action "Run Report" Run Report -->Location Hierarchy by System Select parameters for Site using lookup. Select a site with more than 7 characters in the name: , System: PRIMARY Submit RESULTS: There was an exception on the server. Check your report parameter values, or contact your system administrator, who can find additional details in the server log." EXPECTED RESULTS: report should run for the selected data PRODUCT VERSION: Manage 8.6.2
Local fix
no fix if site is >8 characters in length, or 8 characters if using the exact match - i.e. = in the parameter.
Problem summary
**************************************************************** * USERS AFFECTED: * * MAXIMO * **************************************************************** * PROBLEM DESCRIPTION: * * Location Hierarchy report throws exception in DB2 database * * when SITEID is selected using lookup and the SITEID value * * has maximum length, by default 8 characters. * **************************************************************** Use theReport Administration application to import loc_hierarchy.rptdesign manually.
Problem conclusion
The fix for this APAR is contained in the following maintenance package: release\fix pack for Release 8.x Product
Temporary fix
Comments
APAR Information
APAR number
IJ47388
Reported component name
MAXIMO REPORTIN
Reported component ID
TIVOREPTS
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-06-28
Closed date
2024-06-24
Last modified date
2024-06-24
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
25 June 2024