PureEngage On-Premises

 View Only

Sign Up

  • 1.  Interaction Server SQL scripts

    Posted 01-10-2018 18:20
    The 8.5 eServices Install Guide states there is a 1 SQL script to run for Interaction Server.  In truth, there are 13 scripts in the Oracle directory.  I can surmise the upgrade scripts aren't necessary for a fresh install, but I have no idea about the 'eldb_oracle.sql' vs 'eldb_oracle_nvc.sql' vs 'isdb_oracle.sql' vs 'isdb_oracle_nvc.sql'.  Is there current documentation available on these scripts and which are applicable for a fresh install?


  • 2.  RE: Interaction Server SQL scripts

    Posted 01-10-2018 18:55
    No Genesys documentation on this, but I think I answered the question myself by reading the sql scripts.  Looks like the 'nvc' variants of sql scripts set up nvar fields in the tables.  The other scripts set up var fields for the same tables.  Pick one or the other. 

    At this point, I'm guessing these 2 scripts are required for a fresh install on Oracle: eldb_oracle.sql,  isdb_oracle.sql


  • 3.  RE: Interaction Server SQL scripts

    Posted 01-11-2018 13:31
    ISDB script creates database schema needed by IXN as there the interactions handled by IXN are stored. ELDB is related to the event logger funcionality, which is optional. So, in general - you need to execute at least the ISDB script, the ELDB is fully optional and depends on your needs.