Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: aponterules on May 14, 2010, 01:27:42 AM

Title: VAR issue
Post by: aponterules on May 14, 2010, 01:27:42 AM

Hi

I have issue with VAR,
Does any one knows why I have all the aplications under "Check VAR status" in green but "Critical Processing Errors- No calls Successfully processed in last cycle. Chek log"?

All the calls for var are being stored GVP\CN\ApplicationReporter\data\archives as .tmp files

Where is supposed to be the var client logs? at GVP server? VAR server?


I found the following in events_consolidator.log


-*-*-*-*-*-*-*-*-*-*-*-*- S T A R T I N G    C Y C L E -*-*-*-*-*-*-*-*-*-*-*-*
2010-05-12 17:22:00 : INFO : Proceeding to load event files
2010-05-12 17:22:00 : INFO : Files Read : 0, Processed : 0, Exceptions : 0, Errors : 0, Events Loaded : 0
2010-05-12 17:22:00 : INFO : Proceeding to Process Calls
2010-05-12 17:22:00 : ERROR : 1204 : Error executing SQL  " sp_executesql @stmt=N'INSERT INTO sub_call_flows    (app_id, subcf_id, subcf_name )    VALUES ( @APP_ID , @SCF_ID , @SCF_NAME ) ', @params=N' @APP_ID VARCHAR(33), @SCF_ID VARCHAR(33), @SCF_NAME VARCHAR(33)' , @APP_ID='Infonavit', @SCF_ID='Transfer_FondoAhorro', @SCF_NAME='Transfer_FondoAhorro' "  Error : 515 : The statement has been terminated.
2010-05-12 17:22:00 : ERROR : 1250 : DoSQL: Execute failed
2010-05-12 17:22:01 : ERROR : 20501 : Cannot insert IVR Action info for Transfer_FondoAhorro
2010-05-12 17:22:01 : ERROR : 1204 : Error executing SQL  " sp_executesql @stmt=N'INSERT INTO sub_call_flows    (app_id, subcf_id, subcf_name )    VALUES ( @APP_ID , @SCF_ID , @SCF_NAME ) ', @params=N' @APP_ID VARCHAR(33), @SCF_ID VARCHAR(33), @SCF_NAME VARCHAR(33)' , @APP_ID='Infonavit', @SCF_ID='Transfer_FondoAhorro', @SCF_NAME='Transfer_FondoAhorro' "  Error : 515 : The statement has been terminated.

IS this an SQL error?

The scheduled task of app reporter running every 3 minutes is working fine.....please help!!!!

Title: Re: VAR issue
Post by: aponterules on May 14, 2010, 02:44:49 PM

anyone?

Title: Re: VAR issue
Post by: cavagnaro on May 14, 2010, 02:55:29 PM

Have you tested the user permissions?

Title: Re: VAR issue
Post by: aponterules on May 14, 2010, 03:39:53 PM

thanks cavangaro

you the scheduled task? it has the administrator password
or the Internet Guest user, also has all the permissions

Title: Re: VAR issue
Post by: cavagnaro on May 14, 2010, 07:59:26 PM

VAR is configured with a SQL user, check that one.

Title: Re: VAR issue
Post by: aponterules on May 14, 2010, 10:12:56 PM

Yeeaaahhh!!! ;D

Thanks cavangaro for your help!!!

I saved the AppReporter database (for historic purposes) and executed again the sql scrip for this database, because of the message of the log,
And now it´s working fine!!!!

I assumed that it was a problem with the database because of the log of event reporter.

Great!!!

Title: Re: VAR issue
Post by: cavagnaro on May 15, 2010, 06:18:32 PM

:) Nice! Well done! Now save your notes ;)