VAR issue

[aponterules]

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!!!!

[aponterules]

anyone?

[cavagnaro]

Have you tested the user permissions?

[aponterules]

thanks cavangaro

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

[cavagnaro]

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

[aponterules]

Yeeaaahhh!!!

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!!!

[cavagnaro]

Nice! Well done! Now save your notes