DIALER ORACLE EXTERNAL DATABASE

[dminof]

ERROR Db_TestTables callque : ORA-00911: invalid character

Please Your Help

 

Dr Diego

logs and config vg.zip

[SupportTeam]

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.

[dminof]

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

[SupportTeam]

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.

[dminof]

 

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)

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 '',

.......

 

*/

   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

[SupportTeam]

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.

[dminof]

but you must know what the problem is.

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

[SupportTeam]

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?

[dminof]

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

[SupportTeam]

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?

[dminof]

cri, cri,ci,cri

[SupportTeam]

Looks like above reply is a mistake? Can you please post your reply again?