[Anthill-pro] Problems with Anthill db migration 3.3.6->3.4.7
Ryan Smith
rws at urbancode.com
Thu Jan 10 09:59:33 CST 2008
Good find Uldis. We will add that checking to the upgrade so this doesn't break for people upgrading in the same situation.
Ryan
Uldis Karlovs-Karlovskis wrote:
> 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
>
> //uldis.karlovs-karlovskis at ctco.lv//
> <mailto: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
>
> //uldis.karlovs-karlovskis at ctco.lv//
> <mailto: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/anthill3-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-remoting.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-scripting.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
>
> //uldis.karlovs-karlovskis at ctco.lv//
> <mailto:uldis.karlovs-karlovskis at ctco.lv>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Anthill-pro mailing list
> Anthill-pro at lists.urbancode.com
> http://lists.urbancode.com/mailman/listinfo/anthill-pro
--
===========================================================
Ryan Smith. 2044 Euclid Ave., Suite 600
Lead Developer Cleveland, Ohio 44115
Urbancode, Inc.
email: rws at urbancode.com
web: www.urbancode.com phone: 216-858-9000
web: www.anthillpro.com fax: 216-858-9602
===========================================================
More information about the Anthill-pro
mailing list