APAR status
Closed as program error.
Error description
Problem description This is regarding the Incident application. Steps to Reproduce 1. Go to Incident application 2. Click on Advanced Search 3. Enter search string in a field that will prompt the "please wait" box and will also return no records (i.e display name field enter % imp123%) 4. Click Find 5. Pop up Box appears: Please wait ... 6. Search completes and message appears: BMXAA4186E - No records found that match the specified query 7. Click OK 6. Click on Cancel at bottom of query search space Expected Result Advanced search window closes and user is returned to application List tab. Actual Result Error returned : BMXAA4214E-An unknown error has occured Please contact your system administrator for assistance. User cannot return back to the application unless search criteria is supplied to query that returns results. This is also occurring in other applications, listed below: Assets, Change, Activities and Task, Service Requests Error in SystemOut log file - 22 Aug 2012 13:02:34:967 [ERROR] BMXAA6714E - Data for the next record in the mboset could not be retrieved for the SQL query: select * from incident where ((status = 'NEW' or status = 'QUEUED' or status = 'INPROG' or status = 'PENDING' or status = 'RESTORED') and historyflag = 0) order by ticketid for read only com.ibm.db2.jcc.am.SqlException: Processing was cancelled due to an interrupt.. SQLCODE=-952, SQLSTATE=57014, DRIVER=3.59.81 at com.ibm.db2.jcc.am.dd.a(dd.java:679) at com.ibm.db2.jcc.am.dd.a(dd.java:60) at com.ibm.db2.jcc.am.dd.a(dd.java:127) at com.ibm.db2.jcc.am.qm.b(qm.java:3900) at com.ibm.db2.jcc.am.qm.a(qm.java:3882) at com.ibm.db2.jcc.t4.cb.a(cb.java:793) at com.ibm.db2.jcc.t4.cb.m(cb.java:763) at com.ibm.db2.jcc.t4.cb.i(cb.java:246) at com.ibm.db2.jcc.t4.cb.c(cb.java:54) at com.ibm.db2.jcc.t4.q.c(q.java:44) at com.ibm.db2.jcc.t4.rb.j(rb.java:147) at com.ibm.db2.jcc.am.bn.ib(bn.java:2048) at com.ibm.db2.jcc.am.bn.a(bn.java:3000) at com.ibm.db2.jcc.am.bn.a(bn.java:659) at com.ibm.db2.jcc.am.bn.executeQuery(bn.java:643) at psdi.mbo.MboSet.getNextRecordData(MboSet.java:2916) at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2591) at psdi.mbo.MboSet.fetchMbos(MboSet.java:2557) at psdi.mbo.MboSet.getMbo(MboSet.java:1850) at psdi.webclient.system.beans.DataBean.getMbo(DataBean.java:3979) at psdi.webclient.system.beans.DataBean.filterrows(DataBean.java:56 68) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor Impl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at psdi.webclient.system.session.AsyncProcess.run(AsyncProcess.java :95) at java.lang.Thread.run(Thread.java:595)
Local fix
n/a
Problem summary
**************************************************************** * USERS AFFECTED: * * Maximo Users * **************************************************************** * PROBLEM DESCRIPTION: * * Advanced search results in unknown error and can not back * * out of the search window. * **************************************************************** * RECOMMENDATION: * * Upgrade to latest release * **************************************************************** This is regarding the Incident application. Steps to Reproduce 1. Go to Incident application 2. Click on Advanced Search 3. Enter search string in a field that will prompt the "please wait" box and will also return no records (i.e display name field enter %imp123%) 4. Click Find 5. Pop up Box appears: Please wait ... 6. Search completes and message appears: BMXAA4186E - No records found that match the specified query 7. Click OK 6. Click on Cancel at bottom of query search space Expected Result: Advanced search window closes and user is returned to application List tab. Actual Result: Error returned : BMXAA4214E-An unknown error has occured Please contact your system administrator for assistance. User cannot return back to the application unless search criteria is supplied to query that returns results. This is also occurring in other applications, listed below: Assets, Change, Activities and Task, Service Requests Error in SystemOut log file - 22 Aug 2012 13:02:34:967 ERROR BMXAA6714E - Data for the next record in the mboset could not be retrieved for the SQL query: select * from incident where ((status = 'NEW' or status = 'QUEUED' or status = 'INPROG' or status = 'PENDING' or status = 'RESTORED') and historyflag = 0) order by ticketid for read only com.ibm.db2.jcc.am.SqlException: Processing was cancelled due to an interrupt.. SQLCODE=-952, SQLSTATE=57014, DRIVER=3.59.81 at com.ibm.db2.jcc.am.dd.a(dd.java:679) at com.ibm.db2.jcc.am.dd.a(dd.java:60) at com.ibm.db2.jcc.am.dd.a(dd.java:127) at com.ibm.db2.jcc.am.qm.b(qm.java:3900) at com.ibm.db2.jcc.am.qm.a(qm.java:3882) at com.ibm.db2.jcc.t4.cb.a(cb.java:793) at com.ibm.db2.jcc.t4.cb.m(cb.java:763) at com.ibm.db2.jcc.t4.cb.i(cb.java:246) at com.ibm.db2.jcc.t4.cb.c(cb.java:54) at com.ibm.db2.jcc.t4.q.c(q.java:44) at com.ibm.db2.jcc.t4.rb.j(rb.java:147) at com.ibm.db2.jcc.am.bn.ib(bn.java:2048) at com.ibm.db2.jcc.am.bn.a(bn.java:3000) at com.ibm.db2.jcc.am.bn.a(bn.java:659) at com.ibm.db2.jcc.am.bn.executeQuery(bn.java:643) at psdi.mbo.MboSet.getNextRecordData(MboSet.java:2916) at psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2591) at psdi.mbo.MboSet.fetchMbos(MboSet.java:2557) at psdi.mbo.MboSet.getMbo(MboSet.java:1850) at psdi.webclient.system.beans.DataBean.getMbo(DataBean.java:3979) at psdi.webclient.system.beans.DataBean.filterrows(DataBean.java:56 68) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessor Impl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethod AccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at psdi.webclient.system.session.AsyncProcess.run(AsyncProcess.java :95) at java.lang.Thread.run(Thread.java:595)
Problem conclusion
Advanced search dialog can now be cancelled after no records are found. The fix for this APAR is contained in the following maintenance package: | release\fix pack | TPAE Fix Pack 7.5.0.5 or 7.1.1.13
Temporary fix
Comments
APAR Information
APAR number
IV36150
Reported component name
INCIDENTS
Reported component ID
5724R70IN
Reported release
711
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2013-02-01
Closed date
2013-06-04
Last modified date
2013-06-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
MAXIMO
Fix information
Fixed component name
SYSTEM CONFIG
Fixed component ID
5724R46S1
Applicable component levels
R711 PSY
UP
[{"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":"711","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
04 June 2013