Centric CRM 4.1 (Stable and Released)

Core Team

PUBLIC PROFILE

Back to topics

File Submissions

centric-CRM-4.0.2 to 4.1 installdb for pgsql

You need to be logged in to post messages

centric-CRM-4.0.2 to 4.1 installdb for pgsql

11/8/2006 9:30 AM EST (edited)

By vj venkatakumar

hai all,
have centriccrm-4.0.2 installed and some data also inserted , how can i upgrade my centric to 4.1. (unstable) what pgsql scripts that i need to execute.

can any body help me

regards
vjvenkatakumar

1. 11/8/2006 10:48 AM EST

By Tom Manos

Hi,

I think there is a readme file that comes with the code that explains exactly how to do an upgrade.

-Tom

2. 11/10/2006 8:31 AM EST

By vj venkatakumar

Hai all.

I have centric-4.0.2 Stable version installed in my LINUX machine and some data is stored. Now i want to upgrade my centric to centric-4.1(UnStable).

Database : pgsql.

I followed the following steps.

1> Set all required paths.
2> Executed ant deploy command.
3> Executed ant upgradedb command. While this command is executing it is asked for a file name with extension to be executed for upgrade the exixting data base, and the database name(centric4.0.2) to be upgrade.I gave the file name as 2006-06-14-script01-mr.sql located at centricSrc4.1/src/sql/postgresql/upgrade the result is given Build success. After that i had try to execute ant register.ws command to imlement webservices it is also given Build success.

When i started the server and tried to acess centric it is giving the following Error it is asked for post installations but no database upgrading steps not found. I had completed post installation steps and try to login to centric crm.

It is given followin Error.

Access: ERROR: column a.allow_webdav_access does not exist

In logs i found Following Errors

FileUtils-> Source file not found: /opt/jakarta-tomcat-5.5.9/webapps/centric/WEB-INF/setup/application.xml
FileUtils-> Source file not found: /opt/jakarta-tomcat-5.5.9/webapps/centric/WEB-INF/setup/system.xml
FileUtils-> Source directory does not exist: /opt/jakarta-tomcat-5.5.9/webapps/centric/WEB-INF/setup
FileUtils-> Source directory does not exist: /opt/jakarta-tomcat-5.5.9/webapps/centric/WEB-INF/setup
ApplicationPrefs-> Starting CRON
Login-> Default error: ERROR: column a.allow_webdav_access does not exist
LabelHandler-> SystemStatus is null
LabelHandler-> SystemStatus is null

Is there any thing i went wrong in instalaltion. Any body please tell me how can i use my existed centric4.0.2 database in centric-4.1 .

I also attached my log files.

Files

logs.tar.gz

3. 11/10/2006 8:34 AM EST

By Matt Rajkowski

Concursive Corporation
Product Design

For postgres, the command to upgrade from 4.0.2 to 4.1 is:

% ant upgradedb -Darg1=upgrade_v40-41.txt

This text file describes each and every script that will be executed. If you've already executed one in the list by itself, then the script needs to be commented out in this text file.

4. 11/11/2006 2:23 AM EST (edited)

By vj venkatakumar

Thank you for your reply, But could't find file upgrade_v40-41.txt in centricSrc-4.1 .

regards
vjvenkatakumar

4 results found