Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Fra on January 18, 2007, 11:49:05 AM

Title: ICON installation
Post by: Fra on January 18, 2007, 11:49:05 AM

I'm trying to install ICON 7.2.000.18; in the ICON (outdated  >:( ) deployment guide to execute the provided scripts to initialize the IDB in the following order:

1. gcc_<db_type>_schema.sql
2. gos_<db_type>_schema.sql
3. gcc_<db_type>_dict.sql
4. gcc_<db_type>_stp_api.sql
5. gcc_<db_type>_stp_sys.sql

but I got "Std 25018 Fatal error: database queue [DBWCALLPARTY]: schema version [] is obsolete" followed by an ICON crash.

I have found in the release notes that starting from 7.2.000.14 version a new set of scripts is provided:

gcc_<db>_dict_2.sql
gcc_<db>_schema_2.sql
gcc_<db>_stp_api_2.sql
gcc_<db>_disp.sql
gcc_<db>_version.sql

A deployment procedure is said to be included in the software installation package, but actually there is not.
Since they are mentioned as "extensions", I run both old and new set, but I'm still having the same error above. Should only the new set be run against the db? Does anybody have the updated deployment procedure?

Title: Re: ICON installation
Post by: LeszekM on January 18, 2007, 01:13:05 PM

The sequence of the scripts to run is described in the deployment procedure which can be found in the ICON installation package.

The sequence is:

gcc_<db>_schema.sql          Main core schema script   
gcc_<db>_dict.sql                Dictionary content   
gos_<db>_schema.sql          Outbound schema script   
gcc_<db>_stp_api.sql            Core stored procedures   
gcc_<db>_stp_sys.sql            System stored procedures   
gcc_<db>_dict_2.sql            Dictionary extension   
gcc_<db>_schema_2.sql        Schema extension   
gcc_<db>_stp_api_2.sql        Stored procedures extension   
gcc_<db>_disp.sql                Dispatcher interface upgrade   
gcc_<db>_version.sql            Schema version upgrade   


Regards,
Leszek

Title: Re: ICON installation
Post by: Fra on January 18, 2007, 01:41:36 PM

[quote author=LeszekM link=topic=2004.msg6776#msg6776 date=1169125985]
The sequence of the scripts to run is described in the deployment procedure which can be found in the ICON installation package.

The sequence is:

gcc_<db>_schema.sql          Main core schema script   
gcc_<db>_dict.sql                Dictionary content   
gos_<db>_schema.sql          Outbound schema script   
gcc_<db>_stp_api.sql            Core stored procedures   
gcc_<db>_stp_sys.sql            System stored procedures   
gcc_<db>_dict_2.sql            Dictionary extension   
gcc_<db>_schema_2.sql        Schema extension   
gcc_<db>_stp_api_2.sql        Stored procedures extension   
gcc_<db>_disp.sql                Dispatcher interface upgrade   
gcc_<db>_version.sql            Schema version upgrade   


Regards,
Leszek
[/quote]

Thanks a lot LeszekM,

now it works  :D I don't why I don't have any deployment procedure in my package  :-\