IJ45640: 7.6.1.2 UPDATEDB FAILING AT DB SCRIPT V7612_211 WHILE UPGRADING TO 7.6.1.3

APAR status

• Closed as program error.

Error description

• Updatedb failing at DB script V7612_211, below error can se
  seen:
  
  
  alter table a_maxuser alter column esigpass varbinary (50) null
  ;
  
  // Failed.
  
  create table zxa_maxuser (
  	databaseuserid varchar (18),
  	defsite varchar (8),
  	defstoreroom varchar (25),
  	failedlogins integer,
  	forceexpiration smallint,
  	loginid varchar (50),
  	maxuserid bigint,
  	memo varchar (256),
  	password varbinary (128),
  	personid varchar (30),
  	pwexpiration datetime,
  	pwhintanswer varbinary (2000),
  	pwhintquestion varchar (25),
  	querywithsite smallint,
  	screenreader smallint,
  	status varchar (12),
  	storeroomsite varchar (8),
  	sysuser smallint,
  	type varchar (30),
  	userid varchar (30),
  	eauditusername varchar (30),
  	eaudittimestamp datetime,
  	eaudittype varchar (1),
  	eaudittransid varchar (40),
  	esigtransid varchar (40),
  	inactivesites smallint,
  	defaultrepfacsiteid varchar (8),
  	defaultrepfac varchar (25),
  	isconsultant smallint,
  	sidenav integer,
  	ibmid varchar (100),
  	licmetrictype varchar (20),
  	integuser smallint,
  	esigpass varbinary (50),
  	rowstamp timestamp
  ) on 'PRIMARY'
  ;
  
  // Success.
  
  insert into zxa_maxuser (databaseuserid, defsite, defstoreroom,
  failedlogins, forceexpiration, loginid, maxuserid, memo,
  password, personid, pwexpiration, pwhintanswer, pwhintquestion,
  querywithsite, screenreader, status, storeroomsite, sysuser,
  type, userid, eauditusername, eaudittimestamp, eaudittype,
  eaudittransid, esigtransid, inactivesites, defaultrepfacsiteid,
  defaultrepfac, isconsultant, sidenav, ibmid, licmetrictype,
  integuser, esigpass) select databaseuserid, defsite,
  defstoreroom, failedlogins, forceexpiration, loginid, maxuserid,
  memo, password, personid, pwexpiration, pwhintanswer,
  pwhintquestion, querywithsite, screenreader, status,
  storeroomsite, sysuser, type, userid, eauditusername,
  eaudittimestamp, eaudittype, eaudittransid, esigtransid,
  inactivesites, defaultrepfacsiteid, defaultrepfac, isconsultant,
  sidenav, ibmid, licmetrictype, integuser, esigpass from
  a_maxuser
  ;
  
  // Failed.
  
  ERROR: BMXAA7025E -- Script failed while running.;
  Implicit conversion from data type varchar to varbinary is not
  allowed. Use the CONVERT function to run this query.
  	at psdi.dbmanage.ScriptRun(ScriptRun.java: 272)
  	at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  514)
  	at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  361)
  	at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  313)
  	at psdi.tools.RunScripts(RunScripts.java: 160)
  	at psdi.tools.UpdateDB(UpdateDB.java: 3008)
  	at psdi.tools.UpdateDB(UpdateDB.java: 2925)
  	at psdi.tools.UpdateDB(UpdateDB.java: 2333)
  	at psdi.tools.UpdateDB(UpdateDB.java: 5883)
  	at psdi.tools.UpdateDB(UpdateDB.java: 320)
  	at psdi.tools.UpdateDB(UpdateDB.java: 3443)
  Caused by: Implicit conversion from data type varchar to
  varbinary is not allowed. Use the CONVERT function to run this
  query.
  	at psdi.dbmanage.connection.DatabaseConnection(DatabaseConnect
  ion.java:623)
  	at psdi.dbmanage.connection.DatabaseConnection(DatabaseConnect
  ion.java:567)
  	at psdi.dbmanage.statement.TempTableModel(TempTableModel.java:
  430)
  	at psdi.dbmanage.statement.TempTableModel(TempTableModel.java:
  470)
  	at psdi.dbmanage.connection.DatabaseConnection(DatabaseConnect
  ion.java:1483)
  	at psdi.dbmanage.statement.MaximoMboModel(MaximoMboModel.java:
  605)
  	at psdi.dbmanage.statement.MaximoMboModel(MaximoMboModel.java:
  416)
  	at psdi.dbmanage.statement.AddAttributesStatement(AddAttribute
  sStatement.java:88)
  	at psdi.dbmanage.statement.MaximoMboModel(MaximoMboModel.java:
  694)
  	at psdi.dbmanage.statement.MaximoMboModel(MaximoMboModel.java:
  416)
  	at psdi.dbmanage.statement.AddAttributesStatement(AddAttribute
  sStatement.java:88)
  	at psdi.dbmanage.statement.Script(Script.java: 332)
  	at psdi.dbmanage.statement.Script(Script.java: 313)
  	at psdi.dbmanage.ScriptRun(ScriptRun.java: 266)
  	at psdi.tools.ScriptExecutionInfo(ScriptExecutionInfo.java:
  514)
  	... 9 more
  
  
  Reported on Version:
  Maximo 7.6.1.2
  

Local fix

• Disable ESIGENABLED and eauditenabled, then run updatedb. Later
  enable them back again.
  
  update sigoption set ESIGENABLED =0 WHERE app = 'USER' and
  ESIGENABLED =1;
  update maxobject set where eauditenabled=0 objectname ='MAXUSER'
  and eauditenabled=1;
  update maxobjectcfg set where eauditenabled=0 objectname
  ='MAXUSER' and eauditenabled=1;
  update maxattribute set where eauditenabled=0 objectname
  ='MAXUSER' and eauditenabled=1;
  update maxattributecfg set where eauditenabled=0 objectname
  ='MAXUSER' and eauditenabled=1;
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users upgrading from a version less than 7.6.1.2      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * UPDATEDB FAILING AT DB SCRIPT V7612_211 WHILE UPGRADING TO   *
  * 7.6.1.3                                                      *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR will be contained in a future release.
  

Temporary fix

Comments

APAR Information

• 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 SYSTEMS

• Fixed component ID

  5724R46AV

Applicable component levels