ICON installation

Genesys Cloud Routing
1

I’m trying to install ICON 7.2.000.18; in the ICON (outdated >:frowning: ) 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_dict_2.sql
gccschema_2.sql
gccstp_api_2.sql
gccdisp.sql
gcc_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?

2

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_schema.sql Main core schema script
gccdict.sql Dictionary content
gosschema.sql Outbound schema script
gccstp_api.sql Core stored procedures
gccstp_sys.sql System stored procedures
gccdict_2.sql Dictionary extension
gccschema_2.sql Schema extension
gccstp_api_2.sql Stored procedures extension
gccdisp.sql Dispatcher interface upgrade
gcc_version.sql Schema version upgrade

Regards,
Leszek

3

Thanks a lot LeszekM,

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

2 Likes