Problem(Abstract)
The value for database version (MAXUPG) is not the same as either Last release database build or Current release database build
Cause
The database version is higher than the application version
Diagnosing the problem
The following error appears in the systemout.log
[25/02/11 14:01:17:452 GMT] 00000023 SystemOut O 25 Feb 2011 14:01:17:451 [INFO] BMXAA6471I - Base Services 7.1.1.6 Build 20091208-1415 DB Build V7116-173,
TPAE 7.1.1.5 Build 20090911D2 DB Build V7115-01,
ServiceProvider 7.1.1.2 Build 20100408-1049 DB Build V7122-06,
Common PMP 7.1.1.5 Build 20090624D2 DB Build V7115-11 is starting.
[25/02/11 14:01:17:458 GMT] 00000023 SystemOut O 25 Feb 2011 14:01:17:458 [INFO] BMXAA6453I - The server is connecting to database version: V7116-173
[25/02/11 14:01:17:485 GMT] 00000023 SystemOut O 25 Feb 2011 14:01:17:484 [INFO] --------------------------******************--------------------------
[25/02/11 14:01:17:485 GMT] 00000023 SystemOut O 25 Feb 2011 14:01:17:485 [INFO] BMXAA6478I - Product: ServiceProvider The value for database version (MAXUPG) is not the same as either Last release database build or Current release database build
[25/02/11 14:01:17:485 GMT] 00000023 SystemOut O 25 Feb 2011 14:01:17:485 [INFO] --------------------------******************--------------------------
[25/02/11 14:01:17:509 GMT] 00000023 SystemOut O 25 Feb 2011 14:01:17:488 [FATAL]
java.lang.Exception
Resolving the problem
If you copy an environment from another environment the application version and the database must match.
Check the version of the application
1. IBM\SMP\maximo\applications\maximo\version.bat
Check the database version.
2.select * from maxvars where varname like '%DB%'
select * from maxvars where varname='MAXUPG'
For an example if the version shows the following
Base Services 7.1.1.6 Build 20091208-1415 DB Build V7116-173
ServiceProvider 7.1.1.0 Build 20090818-1403 DB Build V7120-08
The product version and base services DB Build version must match with # 2 results. You can't connect to an existing application different version of DB Build.