Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: KG on July 19, 2017, 04:32:00 AM

Title: WFM DB scripts for Oracle DB
Post by: KG on July 19, 2017, 04:32:00 AM

Hi All,

We have just downloaded and ran exe file of Database Utility for WFM.

Once DBU is installed, we can see Scripts in DBU folder for Oracle.

But in the script we are finding the sql commands to insert into the existing DB but for creating new DB, no data is found like DB  schema and Create DB sql commands etc.

Please guide how or where to download the scripts for creating the DB for Oracle in WFM.


Thanks in Advance.

Regards,
KB

Title: Re: WFM DB scripts for Oracle DB
Post by: Kubig on July 19, 2017, 07:12:54 AM

BRU tool will do the database schema based on your configuration (of course, the DB user has to be created before running BRU).

Title: Re: WFM DB scripts for Oracle DB
Post by: KG on July 19, 2017, 07:25:35 AM

Thanks Kubig!

And Im posting the same reply here.

We have downloaded the DBU and installed.

DBA is asking for the scripts for the new DB.

But we are finding only INSERT commands in the Scripts for Oracle.

where do we find the scripts for creating the schema?

Title: Re: WFM DB scripts for Oracle DB
Post by: Kubig on July 19, 2017, 07:36:03 AM

The scripts should be located under install folder of BRU, folder "scripts".

Title: Re: WFM DB scripts for Oracle DB
Post by: KG on July 19, 2017, 09:03:18 AM

Hi, Im finding the Scripts in DBU folder.

But under Backups, finding only [b]BRUtil.wfm file[/b]

[b]C:\Program Files (x86)\GCTI\WFM85\Database Utility\Scripts

C:\Program Files (x86)\GCTI\WFM85\Database Utility\Backups
[/b]

In script folder, there are multiple .sql files including for Oracle.

In that sql file, Im not finding the commands to create the DB schema for a new Database.

Title: Re: WFM DB scripts for Oracle DB
Post by: Kubig on July 19, 2017, 09:10:18 AM

As I said, the schema itself has to be created by your DBA, it will not be created by the app automatically.

Title: Re: WFM DB scripts for Oracle DB
Post by: KG on July 19, 2017, 09:15:55 AM

But the DBA is asking for the Scripts.

And if we give the Scripts that is present in Intallation Package under DBU, it contains insert commands and create table commands.

But not the commands for creating the schema.

Title: Re: WFM DB scripts for Oracle DB
Post by: Kubig on July 19, 2017, 10:19:44 AM

There is no scripts to create schema at all. Just tell your DBA to create standard DB schema with appropriate user (required permissions you can find in documentation) and then use the provided scripts.

Title: Re: WFM DB scripts for Oracle DB
Post by: KG on July 19, 2017, 10:45:47 AM

Thank You Kubig.
:)