This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Dear All
Envirnoment
Maximo 6.2
Bea 8.0
Windows Server 2003
today i just rebuild the maximo.ear file and deploy it and i am get into this error
Fatal Maximo failed to start
java.lang.exception at psdi.server.MXServer.needToRunUpdateDB
when i run update db its gives me the error
java.lang.Exception: Cannot run database script update.
DB version(MAXUPG) is not same as either Last release DB build or Current release DB build.
at psdi.tools.UpdateDB.startProcess(UpdateDB.java:1068)
at psdi.tools.UpdateDB.loadScriptInfo(UpdateDB.java:258)
at psdi.tools.UpdateDB.main(UpdateDB.java:1999)
configdb is also not running error is
RA-00942: table or view does not exist
Tue Jul 26 16:28:51 GMT+05:00 2011
ConfigDB completed with errors Tue Jul 26 16:28:51 GMT+05:00 2011
i just run the patch of maximo 6.2.1 after this but the problem remains same.
please help.
regards
Amir Shahzad
Amir,
Read this article below
https://www-304.ibm.com/support/docview.wss?uid=swg21315960
If you run \<maximohome>\applications\maximo\version.bat the DB Build value should match what is in the MaxVars table where VarName is MAXUPG. If it is not, update the MaxVars table to match what is listed by version.bat.
See sample from our environment below where our DB Build is 'V600-609".
D:\maximo\applications\maximo\version.bat
MAXIMO Application Server 6.2.2 Build 198 DB Build V600-609,
IBM Maximo for Utilities 6.3.2 Build 074 DB Build V600-162
SQL > SELECT VarValue FROM MaxVars WHERE VarName = 'MAXUPG' ;
V600-609
SQL >
Hope that helps.
Dinesh
--- In MAXIMO@yahoogroups.com, "Amir" <ashahzad.1978@...> wrote:
>
> Dear All
> Envirnoment
> Maximo 6.2
> Bea 8.0
> Windows Server 2003
>
> today i just rebuild the maximo.ear file and deploy it and i am get into this error
>
> Fatal Maximo failed to start
> java.lang.exception at psdi.server.MXServer.needToRunUpdateDB
>
> when i run update db its gives me the error
>
> java.lang.Exception: Cannot run database script update.
> DB version(MAXUPG) is not same as either Last release DB build or Current release DB build.
> at psdi.tools.UpdateDB.startProcess(UpdateDB.java:1068)
> at psdi.tools.UpdateDB.loadScriptInfo(UpdateDB.java:258)
> at psdi.tools.UpdateDB.main(UpdateDB.java:1999)
>
> configdb is also not running error is
> RA-00942: table or view does not exist
> Tue Jul 26 16:28:51 GMT+05:00 2011
> ConfigDB completed with errors Tue Jul 26 16:28:51 GMT+05:00 2011
>
> i just run the patch of maximo 6.2.1 after this but the problem remains same.
>
> please help.
>
> regards
> Amir Shahzad
>
Dear Danish,
i have updated the maxvars table according to your instructions
but problem remains same any other clue
your help is required
regards
amir shahzad
--- In MAXIMO@yahoogroups.com, "dinesh_t_shenoy" <dtshenoy@...> wrote:
>
> Amir,
>
> Read this article below
>
> https://www-304.ibm.com/support/docview.wss?uid=swg21315960
>
> If you run \<maximohome>\applications\maximo\version.bat the DB Build value should match what is in the MaxVars table where VarName is MAXUPG. If it is not, update the MaxVars table to match what is listed by version.bat.
>
> See sample from our environment below where our DB Build is 'V600-609".
>
> D:\maximo\applications\maximo\version.bat
>
> MAXIMO Application Server 6.2.2 Build 198 DB Build V600-609,
> IBM Maximo for Utilities 6.3.2 Build 074 DB Build V600-162
>
> SQL > SELECT VarValue FROM MaxVars WHERE VarName = 'MAXUPG' ;
>
> V600-609
>
> SQL >
>
> Hope that helps.
>
> Dinesh
>
> --- In MAXIMO@yahoogroups.com, "Amir" <ashahzad.1978@> wrote:
> >
> > Dear All
> > Envirnoment
> > Maximo 6.2
> > Bea 8.0
> > Windows Server 2003
> >
> > today i just rebuild the maximo.ear file and deploy it and i am get into this error
> >
> > Fatal Maximo failed to start
> > java.lang.exception at psdi.server.MXServer.needToRunUpdateDB
> >
> > when i run update db its gives me the error
> >
> > java.lang.Exception: Cannot run database script update.
> > DB version(MAXUPG) is not same as either Last release DB build or Current release DB build.
> > at psdi.tools.UpdateDB.startProcess(UpdateDB.java:1068)
> > at psdi.tools.UpdateDB.loadScriptInfo(UpdateDB.java:258)
> > at psdi.tools.UpdateDB.main(UpdateDB.java:1999)
> >
> > configdb is also not running error is
> > RA-00942: table or view does not exist
> > Tue Jul 26 16:28:51 GMT+05:00 2011
> > ConfigDB completed with errors Tue Jul 26 16:28:51 GMT+05:00 2011
> >
> > i just run the patch of maximo 6.2.1 after this but the problem remains same.
> >
> > please help.
> >
> > regards
> > Amir Shahzad
> >
>
After updating the maxvars and running updatedb and configdb what happened? What do the logs state?
Lon Stone
-----Original Message-----
From: "Amir" <ashahzad.1978@yahoo.com>
Sender: MAXIMO@yahoogroups.com
Date: Thu, 28 Jul 2011 18:15:25
To: <MAXIMO@yahoogroups.com>
Reply-To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Re: Maximo 6.2 Problem
Dear Danish,
i have updated the maxvars table according to your instructions
but problem remains same any other clue
your help is required
regards
amir shahzad
--- In MAXIMO@yahoogroups.com, "dinesh_t_shenoy" <dtshenoy@...> wrote:
>
> Amir,
>
> Read this article below
>
> https://www-304.ibm.com/support/docview.wss?uid=swg21315960
>
> If you run \<maximohome>\applications\maximo\version.bat the DB Build value should match what is in the MaxVars table where VarName is MAXUPG. If it is not, update the MaxVars table to match what is listed by version.bat.
>
> See sample from our environment below where our DB Build is 'V600-609".
>
> D:\maximo\applications\maximo\version.bat
>
> MAXIMO Application Server 6.2.2 Build 198 DB Build V600-609,
> IBM Maximo for Utilities 6.3.2 Build 074 DB Build V600-162
>
> SQL > SELECT VarValue FROM MaxVars WHERE VarName = 'MAXUPG' ;
>
> V600-609
>
> SQL >
>
> Hope that helps.
>
> Dinesh
>
> --- In MAXIMO@yahoogroups.com, "Amir" <ashahzad.1978@> wrote:
> >
> > Dear All
> > Envirnoment
> > Maximo 6.2
> > Bea 8.0
> > Windows Server 2003
> >
> > today i just rebuild the maximo.ear file and deploy it and i am get into this error
> >
> > Fatal Maximo failed to start
> > java.lang.exception at psdi.server.MXServer.needToRunUpdateDB
> >
> > when i run update db its gives me the error
> >
> > java.lang.Exception: Cannot run database script update.
> > DB version(MAXUPG) is not same as either Last release DB build or Current release DB build.
> > at psdi.tools.UpdateDB.startProcess(UpdateDB.java:1068)
> > at psdi.tools.UpdateDB.loadScriptInfo(UpdateDB.java:258)
> > at psdi.tools.UpdateDB.main(UpdateDB.java:1999)
> >
> > configdb is also not running error is
> > RA-00942: table or view does not exist
> > Tue Jul 26 16:28:51 GMT+05:00 2011
> > ConfigDB completed with errors Tue Jul 26 16:28:51 GMT+05:00 2011
> >
> > i just run the patch of maximo 6.2.1 after this but the problem remains same.
> >
> > please help.
> >
> > regards
> > Amir Shahzad
> >
>
Dear Lon Stone,
The whole situation is
my maximo db version is
D:\Maximo6\Maximo\applications\maximo>version
MAXIMO Application Server 6.2.00 Build 142 DB Build V600-502
My MAXUPG Value is
Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
SQL> SELECT VarValue FROM MaxVars WHERE VarName = 'MAXUPG' ;
VARVALUE
--------------------------------------------------------------------------------
V600-502
both values are same so i think there is no need to change varvalue, if changing required please guide me.
D:\Maximo6\Maximo\tools\maximo>updatedb
Updatedb process starts...
Connecting to: jdbc:oracle:thin:@pkueta02psge:1521:maximo
Log File: Updatedb20110729101246.log
Product MAXIMO updatedb process starts...
MAXUPG: V520-14, Current release DB build: V600-502, Last release DB build: V600
-76
Cannot run database script update.
DB version(MAXUPG) is not same as either Last release DB build or Current releas
e DB build.
Updatedb process ends: ERROR
Please check the log file.
D:\Maximo6\Maximo\tools\maximo>
i have changed varvalue to V600-76 but configdb still getting me same error.
thanks for your continous help.
regards
Amir Shahzad
--- In MAXIMO@yahoogroups.com, "Lon Stone" <lonnie_s_stone@...> wrote:
>
> After updating the maxvars and running updatedb and configdb what happened? What do the logs state?
> Lon Stone
>
> -----Original Message-----
> From: "Amir" <ashahzad.1978@...>
> Sender: MAXIMO@yahoogroups.com
> Date: Thu, 28 Jul 2011 18:15:25
> To: <MAXIMO@yahoogroups.com>
> Reply-To: MAXIMO@yahoogroups.com
> Subject: [MAXIMO List] Re: Maximo 6.2 Problem
>
> Dear Danish,
>
> i have updated the maxvars table according to your instructions
> but problem remains same any other clue
> your help is required
>
>
> regards
> amir shahzad
>
> --- In MAXIMO@yahoogroups.com, "dinesh_t_shenoy" <dtshenoy@> wrote:
> >
> > Amir,
> >
> > Read this article below
> >
> > https://www-304.ibm.com/support/docview.wss?uid=swg21315960
> >
> > If you run \<maximohome>\applications\maximo\version.bat the DB Build value should match what is in the MaxVars table where VarName is MAXUPG. If it is not, update the MaxVars table to match what is listed by version.bat.
> >
> > See sample from our environment below where our DB Build is 'V600-609".
> >
> > D:\maximo\applications\maximo\version.bat
> >
> > MAXIMO Application Server 6.2.2 Build 198 DB Build V600-609,
> > IBM Maximo for Utilities 6.3.2 Build 074 DB Build V600-162
> >
> > SQL > SELECT VarValue FROM MaxVars WHERE VarName = 'MAXUPG' ;
> >
> > V600-609
> >
> > SQL >
> >
> > Hope that helps.
> >
> > Dinesh
> >
> > --- In MAXIMO@yahoogroups.com, "Amir" <ashahzad.1978@> wrote:
> > >
> > > Dear All
> > > Envirnoment
> > > Maximo 6.2
> > > Bea 8.0
> > > Windows Server 2003
> > >
> > > today i just rebuild the maximo.ear file and deploy it and i am get into this error
> > >
> > > Fatal Maximo failed to start
> > > java.lang.exception at psdi.server.MXServer.needToRunUpdateDB
> > >
> > > when i run update db its gives me the error
> > >
> > > java.lang.Exception: Cannot run database script update.
> > > DB version(MAXUPG) is not same as either Last release DB build or Current release DB build.
> > > at psdi.tools.UpdateDB.startProcess(UpdateDB.java:1068)
> > > at psdi.tools.UpdateDB.loadScriptInfo(UpdateDB.java:258)
> > > at psdi.tools.UpdateDB.main(UpdateDB.java:1999)
> > >
> > > configdb is also not running error is
> > > RA-00942: table or view does not exist
> > > Tue Jul 26 16:28:51 GMT+05:00 2011
> > > ConfigDB completed with errors Tue Jul 26 16:28:51 GMT+05:00 2011
> > >
> > > i just run the patch of maximo 6.2.1 after this but the problem remains same.
> > >
> > > please help.
> > >
> > > regards
> > > Amir Shahzad
> > >
> >
>
>
>
>
>
>
>
Dear All,
any one who has encounter this problem before
--- In MAXIMO@yahoogroups.com, "Amir" <ashahzad.1978@...> wrote:
>
> Dear Lon Stone,
>
> The whole situation is
>
> my maximo db version is
>
> D:\Maximo6\Maximo\applications\maximo>version
> MAXIMO Application Server 6.2.00 Build 142 DB Build V600-502
>
> My MAXUPG Value is
>
> Connected to:
> Oracle9i Release 9.2.0.1.0 - Production
> JServer Release 9.2.0.1.0 - Production
>
> SQL> SELECT VarValue FROM MaxVars WHERE VarName = 'MAXUPG' ;
>
> VARVALUE
> --------------------------------------------------------------------------------
> V600-502
>
> both values are same so i think there is no need to change varvalue, if changing required please guide me.
>
> D:\Maximo6\Maximo\tools\maximo>updatedb
> Updatedb process starts...
> Connecting to: jdbc:oracle:thin:@pkueta02psge:1521:maximo
> Log File: Updatedb20110729101246.log
> Product MAXIMO updatedb process starts...
> MAXUPG: V520-14, Current release DB build: V600-502, Last release DB build: V600
> -76
> Cannot run database script update.
> DB version(MAXUPG) is not same as either Last release DB build or Current releas
> e DB build.
> Updatedb process ends: ERROR
> Please check the log file.
> D:\Maximo6\Maximo\tools\maximo>
> i have changed varvalue to V600-76 but configdb still getting me same error.
>
> thanks for your continous help.
>
>
> regards
> Amir Shahzad
>
>
> --- In MAXIMO@yahoogroups.com, "Lon Stone" <lonnie_s_stone@> wrote:
> >
> > After updating the maxvars and running updatedb and configdb what happened? What do the logs state?
> > Lon Stone
> >
> > -----Original Message-----
> > From: "Amir" <ashahzad.1978@>
> > Sender: MAXIMO@yahoogroups.com
> > Date: Thu, 28 Jul 2011 18:15:25
> > To: <MAXIMO@yahoogroups.com>
> > Reply-To: MAXIMO@yahoogroups.com
> > Subject: [MAXIMO List] Re: Maximo 6.2 Problem
> >
> > Dear Danish,
> >
> > i have updated the maxvars table according to your instructions
> > but problem remains same any other clue
> > your help is required
> >
> >
> > regards
> > amir shahzad
> >
> > --- In MAXIMO@yahoogroups.com, "dinesh_t_shenoy" <dtshenoy@> wrote:
> > >
> > > Amir,
> > >
> > > Read this article below
> > >
> > > https://www-304.ibm.com/support/docview.wss?uid=swg21315960
> > >
> > > If you run \<maximohome>\applications\maximo\version.bat the DB Build value should match what is in the MaxVars table where VarName is MAXUPG. If it is not, update the MaxVars table to match what is listed by version.bat.
> > >
> > > See sample from our environment below where our DB Build is 'V600-609".
> > >
> > > D:\maximo\applications\maximo\version.bat
> > >
> > > MAXIMO Application Server 6.2.2 Build 198 DB Build V600-609,
> > > IBM Maximo for Utilities 6.3.2 Build 074 DB Build V600-162
> > >
> > > SQL > SELECT VarValue FROM MaxVars WHERE VarName = 'MAXUPG' ;
> > >
> > > V600-609
> > >
> > > SQL >
> > >
> > > Hope that helps.
> > >
> > > Dinesh
> > >
> > > --- In MAXIMO@yahoogroups.com, "Amir" <ashahzad.1978@> wrote:
> > > >
> > > > Dear All
> > > > Envirnoment
> > > > Maximo 6.2
> > > > Bea 8.0
> > > > Windows Server 2003
> > > >
> > > > today i just rebuild the maximo.ear file and deploy it and i am get into this error
> > > >
> > > > Fatal Maximo failed to start
> > > > java.lang.exception at psdi.server.MXServer.needToRunUpdateDB
> > > >
> > > > when i run update db its gives me the error
> > > >
> > > > java.lang.Exception: Cannot run database script update.
> > > > DB version(MAXUPG) is not same as either Last release DB build or Current release DB build.
> > > > at psdi.tools.UpdateDB.startProcess(UpdateDB.java:1068)
> > > > at psdi.tools.UpdateDB.loadScriptInfo(UpdateDB.java:258)
> > > > at psdi.tools.UpdateDB.main(UpdateDB.java:1999)
> > > >
> > > > configdb is also not running error is
> > > > RA-00942: table or view does not exist
> > > > Tue Jul 26 16:28:51 GMT+05:00 2011
> > > > ConfigDB completed with errors Tue Jul 26 16:28:51 GMT+05:00 2011
> > > >
> > > > i just run the patch of maximo 6.2.1 after this but the problem remains same.
> > > >
> > > > please help.
> > > >
> > > > regards
> > > > Amir Shahzad
> > > >
> > >
> >
> >
> >
> >
> >
> >
> >
>