AnsweredAssumed Answered

Issue going from 12.0.6 -> v13

Question asked by dtietze on Feb 14, 2012
Latest reply on Feb 14, 2012 by dtietze
Hi.

Parallel to going through support, I thought I'd post here, as maybe someone else had a similar issue.

We're trying to upgrade a customer site from 12.0.6 to v13.
We have CA Hotfix 17 installed on the 12.0.6.

After runnning quite some time, install.sh fails with this exception:

--- Nested Exception ---
/home/niku/clarityv13/install-packages/12.1.1/upgrade-repack.12.1.1.1208/install.xml:606: exec returned: 1
at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.java:591)
at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java:617)

Line 606 in referenced XML file install.xml :
-------------------------------------------
<if property="language" isEmpty="true">
<exec executable="${install.dir}/bin/nikuadmin${script.suffix}" failonerror="true">
<arg line="db install -console"/>
</exec>
</if>


Attempt to call command manually, to get more information:
-------------------------------------------
./nikuadmin db install -console


Output:
-------------------------------------------

./nikuadmin db install -consolecd
Installing database schema...
==========================================
DBTools Log - Tue Feb 14 10:35:59 CET 2012
==========================================
Command: install database schema from driver file
To URL: jdbc:clarity:oracle://Q4DEE1SY898.ffm.t-systems.com:1521;SID=DEVC4TS;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
As user: niku
For vendor: oracle
Loading DBDriver file: /apps/DEV_4TS/Clarity/C4TSDEV/clarity/database/schema/driver.xml
Loading DBDriver file: /apps/DEV_4TS/Clarity/C4TSDEV/clarity/database/schema/driver.xml
Current database version is database_12.1.1_20110429
DBDriver for database_12.1.1_20110429
Resume installation of DBDriver ...
Note: Foreign Keys have been disabled
java.lang.IllegalArgumentException: 'timestamp(6)' is not a valid DataType
at com.niku.dbtools.xmlobjects.types.DataType.valueOf(DataType.java:261)
at com.niku.dbtools.OracleExtractor.createColumn(OracleExtractor.java:624)
at com.niku.dbtools.OracleExtractor.getColumns(OracleExtractor.java:772)
Note: Triggers have been disabled
at com.niku.dbtools.AbstractExtractor.getTable(AbstractExtractor.java:447)
Process - table: CMN_AUDITS_TSV.xml
at com.niku.dbtools.DriverApp.compareSchemaObject(DriverApp.java:1539)
at com.niku.dbtools.DriverApp.access$400(DriverApp.java:54)
at com.niku.dbtools.DriverApp$EntryIterator.next(DriverApp.java:1713)
at com.niku.dbtools.DriverApp.installSchemaDriver(DriverApp.java:425)
at com.niku.dbtools.Utilities.run(Utilities.java:1300)
at com.niku.dbtools.Utilities.main(Utilities.java:632)
Note: Foreign Keys and Triggers have been enabled
DBDriver failed to install!



Has anyone seen (and solved :-) ) similar problems? The " 'timestamp(6)' is not a valid DataType" error message does not make sense to me -- it should be valid according to Oracle's data type docs.

Appreciate any pointers,

Daniel

Outcomes