VoiceGuide IVR Software Main Page
Jump to content

DIALER ORACLE EXTERNAL DATABASE

Recommended Posts

This system is using a 6 years old v7.4 of VoiceGuide.

If you are deploying a new system please use the current version of VoiceGuide.

When using Oracle for VoiceGuide's database engine it's recommended to create the tables and indexes manually in Oracle first (as per the commands in the Db_Create_Oracle.DataAccess.Client.sql file in VoiceGuide's \system\setup\ subdirectory.

Share this post


Link to post

Hello, yes, the client has a previous license and the table was created manually, so it says that the table already exists.

Share this post


Link to post

So apart from the warnings in log files are you encountering any issues?

It looks like you want this new system to use the Oracle database from existing/previous system, yes?

 

BTW, just as a general comment:

If the default SQLite engine is not sufficient to meet the needs of the system being deployed then the next recommended choices are MS SQL Server (the free Express edition is fine) or MySQL. Orcale has generally proven harder to deploy.

The SQLite engine is usually sufficient for systems up to 60 ports.

Share this post


Link to post

 

The client has ORACLE 11g, assumes that their VG system is good for any database.
What I want is for the client to load the table directly from their ORACLE, so they don't have to use Voiceguide DB.

Those errors do not allow loading records as every time you start the bookmark it tries to create the table.

 

 

181246.656   0       Db_Open conn.Open returned
181246.657           Db_TestTables start, conn.DataSource=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.129.180.8)(PORT=1522))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dbhvq.quito.hcjb.org))), Provider=Oracle.DataAccess.Client
181246.661           Db_TestTables callque ExecuteScalar SELECT COUNT(*) FROM callque call (default):huh:

181246.676   0       Db_CreateTables start. Database=[]
181246.676   0       sql create database command read from [C:\Program Files (x86)\VoiceGuide\system\setup\Db_Create_Oracle.DataAccess.Client.sql]
181246.676           dial  CreateTableStructureSqlCommand:

CREATE TABLE callque

ID NUMBER PRIMARY KEY,
PhoneNumber VARCHAR2(100) DEFAULT '',
PhoneNumberPrefix VARCHAR2(100) DEFAULT '',
ActivateTime DATE, 
AnswerTimeout NUMBER DEFAULT 40,
CampaignName VARCHAR2(100) DEFAULT '',

.......

 

*/
:mellow:
   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)
   at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
   at ..(DbConnection , String )
181246.700   0       Db_Open close connection after table create, and reopen
181246.708   0       Db_Open Reopen CreateConnection call
181246.708   0       Db_Open Reopen CreateConnection returned. 

 

 

 

Db_Create_Oracle.DataAccess.Client (1).sql

Share this post


Link to post

Please use the current version of VoiceGuide and post traces from current version if you still encounter any issues.

The version of VoiceGuide which was installed on this new system is 6 years old.

Share this post


Link to post

but you must know what the problem is.

I cannot install the new version since the client has licenses of 7.4

Share this post


Link to post

Looks like there is an error report at database check/create time during system initialization.

Has the client been running v7.4 for 6 years and only now wants to change to using Oracle for internal DB, or have they been using Oracle for internal DB all this time?

If they have been using Oracle for internal DB for last 6 years then looks like this error report at initialization did not stop them from using it beforehand.

Looks like this customer wants to load outgoing calls direct into the database's 'outdial' table. Yes? Have you tried loading the calls into the table to see if call details are then retrieved by VoiceGuide and the calls then made?

Share this post


Link to post

yes, calls are loaded directly into the table if calls are made.

Exactly before using internal VG db

But use of dialer user interface to load calls and reports is lost

Share this post


Link to post
Quote

yes, calls are loaded directly into the table if calls are made.

So calls are made OK if you load them directly into Oracle DB's 'outdial' table?

 

Quote

Exactly before using internal VG db

So has the client been using the default internal DB (SQLite) for 6 years and only now wants to change to using Oracle?

 

Quote

But use of dialer user interface to load calls and reports is lost

So when using v7.4 with Oracle the Call Reports are not saved? Is this the issue?

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×