APAR status
Closed as program error.
Error description
Transportation 7.1.1 install receive java.lang.NumberFormatException: For input string: "" in the updatedb log. Environment reproduced - base 7.1.1.6, TR 7.1 Last line in updatedb log before error - create or replace view wmassignment as select workorder.wonum, workorder.parent, workorder.status, workorder.statusdate, workorder.worktype, workorder.description, workorder.assetnum, workorder.location, workorder.jpnum, workorder.faildate, workorder.changeby, workorder.changedate, workorder.estdur, workorder.estlabhrs, workorder.estmatcost, workorder.estlabcost, workorder.esttoolcost, workorder.pmnum, workorder.actlabhrs, workorder.actmatcost, workorder.actlabcost, workorder.acttoolcost, workorder.haschildren, workorder.outlabcost, workorder.outmatcost, workorder.outtoolcost, workorder.historyflag, workorder.contract, workorder.wopriority, workorder.targcompdate, workorder.targstartdate, workorder.reportedby, workorder.reportdate, workorder.phone, workorder.problemcode, workorder.calendar, workorder.downtime, workorder.actstart, workorder.actfinish, workorder.schedstart, workorder.schedfinish, workorder.remdur, workorder.crewid, workorder.supervisor, workorder.wolablnk, workorder.respondby, workorder.assetlocpriority, workorder.calcpriority, workorder.chargestore, workorder.failurecode, workorder.glaccount, workorder.estservcost, workorder.actservcost, workorder.disabled, workorder.estatapprlabhrs, workorder.estatapprlabcost, workorder.estatapprmatcost, workorder.estatapprtoolcost, workorder.estatapprservcost, workorder.wosequence, workorder.hasfollowupwork, workorder.sourcesysid, workorder.ownersysid, workorder.pmduedate, workorder.pmextdate, workorder.pmnextduedate, workorder.worklocation, workorder.externalrefid, workorder.sendersysid, workorder.fincntrlid, workorder.generatedforpo, workorder.genforpolineid, workorder.orgid, workorder.siteid, CASE WHEN (workorder.istask = 1) THEN workorder.taskid ELSE null END as taskid, workorder.inspector, workorder.measurementvalue, workorder.measuredate, workorder.observation, workorder.pointnum, workorder.istask, workorder.woclass, workorder.onbehalfof, workorder.vendor as wovendor, workorder.origrecordclass, workorder.origrecordid, workorder.justifypriority, workorder.risk, workorder.environment, workorder.backoutplan, workorder.woacceptscharges, workorder.owner, workorder.classstructureid, workorder.parentchgsstatus, workorder.ownergroup, workorder.commoditygroup, workorder.commodity, workorder.workorderid, workorder.whomischangefor, workorder.reasonforchange, workorder.verification, workorder.persongroup, workorder.lead, workorder.hasld, workorder.interruptible, workorder.wogroup, workorder.langcode, workorder.rowstamp, assignment.wplaborid, assignment.craft, assignment.laborhrs, assignment.scheduledate, assignment.laborcode, assignment.startdate, assignment.finishdate, assignment.assignmentid, assignment.skilllevel, assignment.vendor, assignment.contractnum, assignment.rowstamp as rowstamp1, assignment.status as assignstatus,workorder.plustaccomp,workorder.plustcomp,workorder .plustfailure,workorder.plustpos,workorder.plustreason,workorder .plustwarrpresent,workorder.plusttelecode,workorder.plusttransac tionid, assignment.plustaccomp as plustaccompasgn,assignment.plustcomp as plustcompasgn,assignment.plustfailure as plustfailureasgn,assignment.plustinterptreason,assignment.plustp os as plustposasgn,assignment.plustqualmet as plustqualmet,assignment.plustreason as plustreasonasgn, workorder.plustconsistid FROM assignment RIGHT OUTER JOIN workorder on assignment.wonum = workorder.wonum and assignment.siteid = workorder.siteid ; running Calling the class : psdi.transportation.en.V7120_07 full error trace: java.lang.NumberFormatException: For input string: "" at java.lang.NumberFormatException.forInputString(NumberFormatExcep tion.java:63) at java.lang.Integer.parseInt(Integer.java:502) at java.lang.Integer.parseInt(Integer.java:531) at psdi.transportation.en.V7120_07.addMenus(Unknown Source) at psdi.transportation.en.V7120_07.process(Unknown Source) at psdi.script.AutoUpgradeTemplate.<init>(Unknown Source) at psdi.script.industrysolution.AutoUpgradeTemplateIS.<init>(Unknow n Source) at psdi.transportation.en.V7120_07.<init>(Unknown Source) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeCons tructorAccessorImpl.java:67) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Delega tingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:521) at psdi.tools.UpdateDB.runScriptClass(Unknown Source) at psdi.tools.UpdateDB.runScripts(Unknown Source) at psdi.tools.UpdateDB.startProcess(Unknown Source) at psdi.tools.UpdateDB.startProcess(Unknown Source) at psdi.tools.UpdateDB.loadScriptInfo(Unknown Source) at psdi.tools.UpdateDB.main(Unknown Source)
Local fix
no workaround
Problem summary
**************************************************************** * USERS AFFECTED: All users which upgrade to cobra or recent * * release * **************************************************************** * PROBLEM DESCRIPTION: Transportation 7.1.1 install receive * * java.lang.NumberFormatException: For * * input string: "" in the updatedb log. * * * * Environment reproduced - base 7.1.1.6, * * TR 7.1 * * * * * * * * * * * * Last line in updatedb log before error * * - create or replace view wmassignment * * as * * * * select workorder.wonum, * * workorder.parent, workorder.status, * * * * workorder.statusdate, * * workorder.worktype, * * workorder.description, * * * * workorder.assetnum, workorder.location, * * workorder.jpnum, * * * * workorder.faildate, workorder.changeby, * * workorder.changedate, * * * * workorder.estdur, workorder.estlabhrs, * * workorder.estmatcost, * * * * workorder.estlabcost, * * workorder.esttoolcost, workorder.pmnum, * * * * workorder.actlabhrs, * * workorder.actmatcost, * * workorder.actlabcost, * * * * workorder.acttoolcost, * * workorder.haschildren, * * * * workorder.outlabcost, * * workorder.outmatcost, * * * * workorder.outtoolcost, * * workorder.historyflag, * * * * workorder.contract, * * workorder.wopriority, * * * * workorder.targcompdate, * * workorder.targstartdate, * * * * workorder.reportedby, * * workorder.reportdate, workorder.phone, * * * * workorder.problemcode, * * workorder.calendar, workorder.downtime, * * * * workorder.actstart, * * workorder.actfinish, * * workorder.schedstart, * * * * workorder.schedfinish, * * workorder.remdur, workorder.crewid, * * * * workorder.supervisor, * * workorder.wolablnk, * * workorder.respondby, * * * * workorder.assetlocpriority, * * workorder.calcpriority, * * * * workorder.chargestore, * * workorder.failurecode, * * * * workorder.glaccount, * * workorder.estservcost, * * * * workorder.actservcost, * * workorder.disabled, * * * * workorder.estatapprlabhrs, * * workorder.estatapprlabcost, * * * * workorder.estatapprmatcost, * * workorder.estatapprtoolcost, * * * * workorder.estatapprservcost, * * workorder.wosequence, * * * * workorder.hasfollowupwork, * * workorder.sourcesysid, * * * * workorder.ownersysid, * * workorder.pmduedate, * * workorder.pmextdate, * * * * workorder.pmnextduedate, * * workorder.worklocation, * * * * workorder.externalrefid, * * workorder.sendersysid, * * * * workorder.fincntrlid, * * workorder.generatedforpo, * * * * workorder.genforpolineid, * * workorder.orgid, workorder.siteid, * * * * CASE WHEN (workorder.istask = 1) THEN * * workorder.taskid ELSE * * * * null END as taskid, * * workorder.inspector, * * * * workorder.measurementvalue, * * workorder.measuredate, * * * * workorder.observation, * * workorder.pointnum, workorder.istask, * * * * workorder.woclass, * * workorder.onbehalfof, workorder.vendor * * as * * * * wovendor, workorder.origrecordclass, * * workorder.origrecordid, * * * * workorder.justifypriority, * * workorder.risk, * * * * workorder.environment, * * workorder.backoutplan, * * * * workorder.woacceptscharges, * * workorder.owner, * * * * workorder.classstructureid, * * workorder.parentchgsstatus, * * * * workorder.ownergroup, * * workorder.commoditygroup, * * * * workorder.commodity, * * workorder.workorderid, * * * * workorder.whomischangefor, * * workorder.reasonforchange, * * * * workorder.verification, * * workorder.persongroup, workorder.lead, * * * * workorder.hasld, * * workorder.interruptible, * * workorder.wogroup, * * * * workorder.langcode, workorder.rowstamp, * * assignment.wplaborid, * * * * assignment.craft, assignment.laborhrs, * * assignment.scheduledate, * * * * assignment.laborcode, * * assignment.startdate, * * * * assignment.finishdate, * * assignment.assignmentid, * * * * assignment.skilllevel, * * assignment.vendor, * * * * assignment.contractnum, * * assignment.rowstamp as rowstamp1, * * * * assignment.status as * * assignstatus,workorder.plustaccomp,work * * order. plustcomp,workorder * * * * .plustfailure,workorder.plustpos,workor * * der.plustreason,workorder * * * * .plustwarrpresent,workorder.plustteleco * * de,workorder.plusttransac * * * * tionid, assignment.plustaccomp as * * plustaccompasgn,assignment. plustcomp * * as plustcompasgn,assignment. * * plustfailure as * * * * plustfailureasgn,assignment.plustinterp * * treason,assignment.plustp * * * * os as * * plustposasgn,assignment.plustqualmet as * * * * plustqualmet,assignment.plustreason as * * plustreasonasgn, * * * * workorder.plustconsistid FROM * * assignment RIGHT OUTER JOIN * * * * workorder on assignment.wonum = * * workorder.wonum and * * * * assignment.siteid = workorder.siteid * * * * ; * * * * * * * * * * * * running Calling the class : * * psdi.transportation.en.V7120_07 full * * error trace: * * * * java.lang.NumberFormatException: For * * input string: "" * * * * at * * java.lang.NumberFormatException.forInpu * * tString(NumberFormatException.java:63) * * * * at * * java.lang.Integer.parseInt(Integer.java * * :502) * * * * at * * java.lang.Integer.parseInt(Integer.java * * :531) * * * * at * * psdi.transportation.en.V7120_07.addMenu * * s(Unknown Source) * * * * at * * psdi.transportation.en.V7120_07.process * * (Unknown Source) * * * * at * * psdi.script.AutoUpgradeTemplate.<init>( * * Unknown Source) * * * * at * * psdi.script.industrysolution.AutoUpgrad * * eTemplateIS.<init>(Unknown Source) * * * * at * * psdi.transportation.en.V7120_07.<init>( * * Unknown Source) * * * * at * * sun.reflect.NativeConstructorAccessorIm * * pl.newInstance0(NativeMethod) * * * * at * * sun.reflect.NativeConstructorAccessorIm * * pl.newInstance(NativeConstructorAccesso * * rImpl.java:67) * * * * at * * sun.reflect.DelegatingConstructorAccess * * orImpl.newInstance(DelegatingConstructo * * rAccessorImpl.java:45) * * * * at * * java.lang.reflect.Constructor.newInstan * * ce(Constructor.java:521) * * * * at * * psdi.tools.UpdateDB.runScriptClass(Unkn * * own Source) * * * * at * * psdi.tools.UpdateDB.runScripts(Unknown * * Source) * * * * at * * psdi.tools.UpdateDB.startProcess(Unknow * * n Source) * * * * at * * psdi.tools.UpdateDB.startProcess(Unknow * * n Source) * * * * at * * psdi.tools.UpdateDB.loadScriptInfo(Unkn * * own Source) * * * * at psdi.tools.UpdateDB.main(Unknown * * Source) * * * * * * * * * * * * LOCAL FIX:no workaround * * * **************************************************************** * RECOMMENDATION: * * * * * * * **************************************************************** JAVA.LANG.NUMBERFORMATEXCEPTION: FOR INPUT STRING: "" IN UPDATEDB FROM TR 7.1.1 INSTALL
Problem conclusion
Change the way to add an application on maxmenu. Instead to have one app as focal point, all possible app will be considered
Temporary fix
Comments
APAR Information
APAR number
IZ81317
Reported component name
MAXIMO INSTALL
Reported component ID
5724R46IT
Reported release
710
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-08-03
Closed date
2010-09-10
Last modified date
2010-09-10
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
MAXIMO INSTALL
Fixed component ID
5724R46IT
Applicable component levels
R710 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCHPMC","label":"Maximo Install Tool"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"710","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
06 September 2022