Maximo List Archive - MX75 w/SPATIAL Installing DEMO DATA (maxinst) on SQL

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.

MX75 w/SPATIAL Installing DEMO DATA (maxinst) on SQL

From: Kevin Frazier (2011-11-18 11:43)

I am having an issue installing Demo Data on a Maximo 7.5 instance running Spatial 7.5 and was wondering if anyone else has run into this issue before. Any insight you can provide would be greatly appreciated. Thanks in advance.
OS: Win2K8 Server Std R2
DB: MSSQL 2K8 Std
WAS 7.1
Here's the output from the cmd window:
(C:\>maxinst.bat -sPRIMARY -tPRIMARY)
Database update in progress, please wait..........
Current version :V7110-0
Updating To :V7120-35
Checking for IS Content.........
Checking for IS Content.........
Checking for IS Content.........
Checking for IS Content.........
Checking for IS Content.........
Checking for IS Content.........
Checking for IS Content.........
Error running file: V7120_12
Script Update complete: Error
Updatedb process ends: ERROR
Please check the log file.
java.lang.Exception: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK ERRORS I
N UPDATE LOG FILE -Updatedb20111117220745.log
Cannot insert duplicate key row in object 'dbo.crontaskparam' with unique index
'crontaskparam_ndx'.
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)
Here's the error message from the UpdateDB log file:
-- Script: Successful
-- Calling the class : psdi.spatial.en.V7120_12 Thu Nov 17 21:12:03 EST 2011
-- -------------------------------------------------------------------
delete from crontaskparam where crontaskname='PlusSCreateFeatureLinkCronTask' and instancename='PlusSCreateFeatureInstance'
go
insert into crontaskparam( crontaskname, instancename, parameter, value, crontaskparamid) select 'PlusSCreateFeatureLinkCronTask', 'PlusSCreateFeatureInstance', 'GISOBJECTS', '', maxreserved +1 from maxsequence where tbname = 'CRONTASKPARAM' and name = 'CRONTASKPARAMID'
go
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate key row in object 'dbo.crontaskparam' with unique index 'crontaskparam_ndx'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1449)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658)
at psdi.script.AutoUpgradeTemplate.executeSql(Unknown Source)
at psdi.script.industrysolution.AutoUpgradeTemplateIS.executeSql(AutoUpgradeTemplateIS.java:1188)
at psdi.script.AutoUpgradeTemplate.executeSql(Unknown Source)
at psdi.script.industrysolution.AutoUpgradeTemplateIS.executeSql(AutoUpgradeTemplateIS.java:1183)
at psdi.spatial.en.V7120_12.init(V7120_12.java:88)
at psdi.script.AutoUpgradeTemplate.<init>(Unknown Source)
at psdi.script.industrysolution.AutoUpgradeTemplateIS.<init>(AutoUpgradeTemplateIS.java:115)
at psdi.spatial.en.V7120_12.<init>(V7120_12.java:47)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
at java.lang.reflect.Constructor.newInstance(Constructor.java:516)
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)
-- BEGINUPDATEDBERROR
-- Product: IBM Maximo Spatial Asset Management
-- Error running file: V7120_12
-- UPDATEDBFILE:V7120_12.class
-- Script: Error
java.lang.Exception: Cannot insert duplicate key row in object 'dbo.crontaskparam' with unique index 'crontaskparam_ndx'.
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)
java.lang.Exception: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK ERRORS IN UPDATE LOG FILE -Updatedb20111117211025.log
Cannot insert duplicate key row in object 'dbo.crontaskparam' with unique index 'crontaskparam_ndx'.
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)
[cid:image001.png@01CCA5E3.E93B2B30]
Kevin Frazier
Infrastructure Engineer

From: Matt Holland (2011-11-18 11:51)

It looks like the index violation is happening on CRONTASKPARAMID. Since
this is SQL Server it is looking at the MAXSEQUENCE table to establish the
next unique ID. I would try comparing the maximum CRONTASKPARAMID from the
CRONTASKPARAM table against the MAXRESERVED value in the MAXSEQUENCE table.
If MAXRESERVED is lower than the maximum CRONTASKPARAMID in the database
you will need to raise this value...
Something similar to the following should work...
update maxsequence set maxreserved = (select max(crontaskparamid) + 1 from
crontaskparam) where tbname = 'CRONTASKPARAM' and name = 'CRONTASKPARAMID'
On Fri, Nov 18, 2011 at 11:43 AM, Kevin Frazier <
kfrazier@cohesivesolutions.com> wrote:
> **
>
>
> I am having an issue installing Demo Data on a Maximo 7.5 instance running
> Spatial 7.5 and was wondering if anyone else has run into this issue
> before. Any insight you can provide would be greatly appreciated. Thanks in
> advance.
>
> OS: Win2K8 Server Std R2
> DB: MSSQL 2K8 Std
> WAS 7.1
>
> Here's the output from the cmd window:
> (C:\>maxinst.bat -sPRIMARY -tPRIMARY)
>
> Database update in progress, please wait..........
> Current version :V7110-0
> Updating To :V7120-35
> Checking for IS Content.........
> Checking for IS Content.........
> Checking for IS Content.........
> Checking for IS Content.........
> Checking for IS Content.........
> Checking for IS Content.........
> Checking for IS Content.........
> Error running file: V7120_12
> Script Update complete: Error
> Updatedb process ends: ERROR
> Please check the log file.
> java.lang.Exception: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK
> ERRORS I
> N UPDATE LOG FILE -Updatedb20111117220745.log
> Cannot insert duplicate key row in object 'dbo.crontaskparam' with unique
> index
> 'crontaskparam_ndx'.
> 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)
>
> Here's the error message from the UpdateDB log file:
>
> -- Script: Successful
> -- Calling the class : psdi.spatial.en.V7120_12 Thu Nov 17 21:12:03 EST
> 2011
> -- ----------------------------------------------------------
> delete from crontaskparam where
> crontaskname='PlusSCreateFeatureLinkCronTask' and
> instancename='PlusSCreateFeatureInstance'
> go
> insert into crontaskparam( crontaskname, instancename, parameter, value,
> crontaskparamid) select 'PlusSCreateFeatureLinkCronTask',
> 'PlusSCreateFeatureInstance', 'GISOBJECTS', '', maxreserved +1 from
> maxsequence where tbname = 'CRONTASKPARAM' and name = 'CRONTASKPARAMID'
> go
> com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert duplicate
> key row in object 'dbo.crontaskparam' with unique index 'crontaskparam_ndx'.
> at
> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
> at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
> at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1449)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)
> at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
> at
> com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:658)
> at psdi.script.AutoUpgradeTemplate.executeSql(Unknown Source)
> at
> psdi.script.industrysolution.AutoUpgradeTemplateIS.executeSql(AutoUpgradeTemplateIS.java:1188)
> at psdi.script.AutoUpgradeTemplate.executeSql(Unknown Source)
> at
> psdi.script.industrysolution.AutoUpgradeTemplateIS.executeSql(AutoUpgradeTemplateIS.java:1183)
> at psdi.spatial.en.V7120_12.init(V7120_12.java:88)
> at psdi.script.AutoUpgradeTemplate.<init>(Unknown Source)
> at
> psdi.script.industrysolution.AutoUpgradeTemplateIS.<init>(AutoUpgradeTemplateIS.java:115)
> at psdi.spatial.en.V7120_12.<init>(V7120_12.java:47)
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:44)
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
> at java.lang.reflect.Constructor.newInstance(Constructor.java:516)
> 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)
> -- BEGINUPDATEDBERROR
> -- Product: IBM Maximo Spatial Asset Management
> -- Error running file: V7120_12
> -- UPDATEDBFILE:V7120_12.class
> -- Script: Error
> java.lang.Exception: Cannot insert duplicate key row in object
> 'dbo.crontaskparam' with unique index 'crontaskparam_ndx'.
> 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)
>
> java.lang.Exception: DATABASE Script UPDATE COMPLETED WITH ERROR. CHECK
> ERRORS IN UPDATE LOG FILE -Updatedb20111117211025.log
> Cannot insert duplicate key row in object 'dbo.crontaskparam' with unique
> index 'crontaskparam_ndx'.
> 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)
>
> [cid:image001.png@01CCA5E3.E93B2B30]
> Kevin Frazier
> Infrastructure Engineer
>
>
>
>
>
--
Thanks,
Matt Holland