APAR status
Closed as fixed if next.
Error description
ERROR DESCRIPTION: report fails for a user who does not have All Sites access with error - "The multi-part identifier "inventory.siteid" could not be bound." PROBLEM: Maximo adds the site restrictions to the WHERE clause in the form of validation against INVENTORY.SITEID but this table is not included in the 2 sql statements that are using the where (matrectransidDataSet and matusetransidDataSet) PERFORMANCE ISSUE: n/a STEPS TO REPRODUCE: Log into maximo as a user who does not have any groups with "All sites" privileges but has access to Inventory application run the report kit.rptdesign for any date range CURRENT ERRONEOUS RESULT: "The multi-part identifier "inventory.siteid" could not be bound." EXPECTED RESULT: should run for any user ADDITIONAL INFO: n/a ENVIRONMENT (SYSTEM INFO): n/a
Local fix
modify the rptdesign to include the table in the 2 sql statements and import modified report
Problem summary
**************************************************************** * USERS AFFECTED: * * Inventory Report users for Kit Report * **************************************************************** * PROBLEM DESCRIPTION: * * Queries on the report that used the Maximo where clause did * * not properly join the Inventory object * **************************************************************** * RECOMMENDATION: * * Import the latest report design to fix * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IJ03409
Reported component name
BIRT INTEG-REPO
Reported component ID
5724R46B1
Reported release
760
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-01-18
Closed date
2018-03-05
Last modified date
2018-03-05
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.6","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
10 April 2023