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

Thu Jan 10 09:36:40 CST 2008

There were not deleted workflow configuration which hadn't project or
workflow records related to it. After cleaning all FK data it succeeded.
Strange how could this happen.

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ī 15:05
To: 'AnthillPro user and support list.'
Cc: 'Kirill Stecenko'
Subject: RE: [Anthill-pro] Problems with Anthill db migration 3.3.6->3.4.7

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/593da587/attachment-0001.htm