Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: efrainclg95 on March 01, 2022, 05:59:41 PM

Title: config database schema update
Post by: efrainclg95 on March 01, 2022, 05:59:41 PM
Good afternoon dear expert friends, I hope you are well first of all, I wanted to ask you for your help on a delicate point:

It so happens that we are updating the configserver from version 8.1.0 to 8.5.1, for this reason we find ourselves in the scenario of executing an update on the database schemas: config.

We already installed the new confserv, in 8.5, even objects can be created without problem, access to PULSE and GAX is ok.

To update the said schema, how should I proceed? What is the best procedure? I tried to use CCW but due to an error in the OS it does not work, I only have to do it through the database and this is my doubt, perhaps I should re-execute the script: CfgLocale_mssql (script generated after installation) in the config? or what script should I build to update, could you give me an example please.

Thanks a lot
Title: Re: config database schema update
Post by: Kubig on March 01, 2022, 06:54:29 PM
Have you followed this [url=https://docs.genesys.com/Documentation/FR/latest/FRMG/MGUpgradeDBSchema]https://docs.genesys.com/Documentation/FR/latest/FRMG/MGUpgradeDBSchema[/url]?
Title: Re: config database schema update
Post by: efrainclg95 on March 04, 2022, 05:52:23 PM
Hello Kubig

Thanks for the contribution, well what I did was the following, (as a contribution for other people):

Download the database maintenance package from the Genesys portal.
Run the installation of the new version of confserv, backup mode installation.
Once installed I went to the database and executed in my case the following script: upg_cfg_810_to_811_mssql, and shut down the old confserv and start the new one.
The new confserv started without problems, the log recognized all objects and processes.
Finally disable the old confserv service.

I hope it can be of some use, as a recommendation to make a backup copy of the config database.

Thanks