[Anthill-pro] Problems with Anthill db migration 3.3.6->3.4.7

[Uldis Karlovs-Karlovskis]

I was able to fix this by decrypting database user password. Somewhy it
wasn`t working :/

 

Also to fix data exporting I have changed table field VALUE definition to:

create table WORKFLOW_PROPERTY (

                            WORKFLOW_ID     NUMERIC NOT NULL,

                            NAME            VARCHAR2(256) NOT NULL,

                                    SEQ             NUMERIC NOT NULL,

                            DESCRIPTION     VARCHAR2(256),

                            VALUE
VARCHAR2(512),

                            LABEL
VARCHAR2(256),

                            USER_OVERRIDE   NUMERIC DEFAULT 0,

                            REQUIRED        NUMERIC DEFAULT 0,

                            PRIMARY KEY (WORKFLOW_ID, NAME)

                        );;

 

And afterthen upgrade failed with error message:

Caused by: com.urbancode.cm.db.updater.ApplyException: ORA-02291: integrity
constraint (ANTHILL.WDE_TO_JOB_FK) violated - parent key not found

: INSERT INTO WORKFLOW_DEFINITION_EDGES

            (WORKFLOW_DEFINITION_ID, FROM_JOB_CONFIG_ID, TO_JOB_CONFIG_ID)

          SELECT

            WDE.WORKFLOW_ID,

            WDE.FROM_JOB_CONFIG_ID,

            WDE.TO_JOB_CONFIG_ID

          FROM

            TEMP_WORKFLOW_DEFINITION_EDGES WDE

        at com.urbancode.cm.db.updater.SqlTask.apply(SqlTask.java:78)

        at com.urbancode.cm.db.updater.Change.apply(Change.java:68)

        at
com.urbancode.cm.db.updater.DbUpgradeTask.execute(DbUpgradeTask.java:107)

        ... 59 more

--- Nested Exception ---

 

As I understand there is some data inconsistency with workflows and jobs but
how to fix it?

 

Uldis Karlovs-Karlovskis, C. T. Co

 <mailto:uldis.karlovs-karlovskis at ctco.lv> uldis.karlovs-karlovskis at ctco.lv

 

-----Original Message-----
From: anthill-pro-bounces at lists.urbancode.com
[mailto:anthill-pro-bounces at lists.urbancode.com] On Behalf Of Uldis
Karlovs-Karlovskis
Sent: ceturtdiena, 2008. gada 10. janvārī 12:47
To: 'AnthillPro user and support list.'
Subject: [Anthill-pro] Problems with Anthill db migration 3.3.6->3.4.7

 

Hello!

I have problems when migrating Anthill to new version. My Oracle database is
on remote server. I`m sure that anthill application works fine with it but
installation is somewhy failing:

 

[root at anthill anthill3-install]# install-server.sh

Buildfile: install.with.groovy.xml

 

install-server:

    [unzip] Expanding:
/export/storage0/home/uldisk/anthill3-3.4.7Lin/anthill3-install/conf.zip
into /tmp/ahp3-install-19982.tmp

     [echo]

     [echo] Installing AnthillPro3 Server

     [echo] Enter the directory where AnthillPro3 server should be
installed. [Default: /opt/anthill3/server]

/opt/anthill3.4/server

     [echo] A previous version (3.3.6.b219) exists in the specified
directory. Do you want to upgrade the currently installed version? [Y,n]

Y

     [echo]

     [echo] Installing AnthillPro3 Server to: /opt/anthill3.4/server

     [echo] Please enter the home directory of the JRE/JDK used to run the
server. [Default: /export/storage0/opt/j2sdk1.4.2_15]

 

     [echo] JVM Version detected: 1.4.2_15

     [echo] JAVA_HOME: /export/storage0/opt/j2sdk1.4.2_15

     [echo] Enter the database schema name. (required if user has DBA role)

 

   [delete] Deleting directory /opt/anthill3.4/server/lib

    [mkdir] Created dir: /opt/anthill3.4/server/lib

    [mkdir] Created dir: /opt/anthill3.4/server/lib/ext

     [copy] Copying 277 files to /opt/anthill3.4/server/conf

     [copy] Copying 1 file to /opt/anthill3.4/server/conf/sql

     [copy] Copying 66 files to /opt/anthill3.4/server/lib

     [copy] Copying 1409 files to /opt/anthill3.4/server/opt

     [copy] Copying 660 files to /opt/anthill3.4/server/opt

   [delete] Deleting directory /opt/anthill3.4/server/opt/help

    [mkdir] Created dir: /opt/anthill3.4/server/opt/help

     [copy] Copying 1 file to /opt/anthill3.4/server/opt/help

    [unzip] Expanding:
/export/storage0/home/uldisk/anthill3-3.4.7Lin/anthill3-install/opt/help/ant
hill3-help-content.zip into /opt/anthill3.4/server/opt/help

     [copy] Copying 1 file to /opt/anthill3.4/server/bin

    [unzip] Expanding:
/opt/anthill3.4/server/opt/tomcat/webapps/ROOT/tools/remoting/anthill3-remot
ing.zip into /opt/anthill3.4/server/opt/tomcat/webapps/ROOT/tools/remoting

    [unzip] Expanding:
/opt/anthill3.4/server/opt/tomcat/webapps/ROOT/tools/scripting/anthill3-scri
pting.zip into
/opt/anthill3.4/server/opt/tomcat/webapps/ROOT/tools/scripting

Copying server files for Unix...

     [copy] Copying 1 file to /opt/anthill3.4/server/bin

     [copy] Copying 1 file to /opt/anthill3.4/server/bin

     [copy] Copying 1 file to /opt/anthill3.4/server/bin/init

     [echo] Found currently installed version: 3.3.6.b219

     [echo] DB Versioned upgrades

   [delete] Deleting directory /tmp/ahp3-install-19982.tmp

 

BUILD FAILED

: : java.sql.SQLException: ORA-01017: invalid username/password; logon
denied

 

 

Total time: 1 minute 36 seconds

 

Uldis Karlovs-Karlovskis, C. T. Co

 <mailto:uldis.karlovs-karlovskis at ctco.lv> uldis.karlovs-karlovskis at ctco.lv

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.urbancode.com/pipermail/anthill-pro/attachments/20080110/1520d8f2/attachment-0001.htm