TNG Reporting issue

[azola_sofi]

Hi

It seems that TNG has developed an issue with the CSV file. We keep getting a CSV input error. This is what the logs show.

2013-01-28 13:51:25:495 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 13:51:25:495 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/3000-0000036f[10]UniqueID: 1359373846.883[10]DialStatus: ANSWER[10]
2013-01-28 14:02:12:066 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 14:02:12:066 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/3000-00000372[10]UniqueID: 1359374416.886[10]DialStatus: ANSWER[10]
2013-01-28 14:04:32:224 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 14:04:32:224 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/114-00000375[10]UniqueID: 1359374476.889[10]DialStatus: ANSWER[10]
2013-01-28 14:09:07:986 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 14:09:07:986 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/3000-00000377[10]UniqueID: 1359374783.891[10]DialStatus: ANSWER[10]
2013-01-28 14:10:04:986 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 14:10:04:986 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/114-0000037a[10]UniqueID: 1359374969.894[10]DialStatus: ANSWER[10]
2013-01-28 14:49:23:071 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 14:49:23:071 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/111-0000037c[10]UniqueID: 1359377332.896[10]DialStatus: ANSWER[10]
2013-01-28 14:56:45:497 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 14:56:45:497 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/3000-0000037e[10]UniqueID: 1359377767.898[10]DialStatus: ANSWER[10]
2013-01-28 14:56:47:828 [1.0.7.0] - AMI Exception:ParseCDRRecordToTNGFormat (tr- ["""0878022710"" <0878022710>","0878022710","111","from-did-direct","SIP/3000-0000037e","SIP/111-0000037f","Dial","SIP/111,"""",tr","2013-01-28 14:56:07","2013-01-28 14:56:40","2013-01-28 14:56:45","38","5","ANSWERED","DOCUMENTATION","","1359377767.898","audio:20130128-145635-1359377767.898.wav",1224[10]]): 'tr' is not a valid date and time
2013-01-28 14:59:13:778 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 14:59:13:778 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/3000-00000380[10]UniqueID: 1359377817.900[10]DialStatus: ANSWER[10]
2013-01-28 14:59:17:883 [1.0.7.0] - AMI Exception:ParseCDRRecordToTNGFormat (tr- ["""0878022710"" <0878022710>","0878022710","111","from-did-direct","SIP/3000-00000380","SIP/111-00000381","Dial","SIP/111,"""",tr","2013-01-28 14:56:57","2013-01-28 14:57:29","2013-01-28 14:59:13","136","104","ANSWERED","DOCUMENTATION","","1359377817.900","audio:20130128-145725-1359377817.900.wav",1227[10]]): 'tr' is not a valid date and time
2013-01-28 15:10:23:323 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 15:10:23:323 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/3000-00000382[10]UniqueID: 1359378589.902[10]DialStatus: CANCEL[10]
2013-01-28 15:10:28:151 [1.0.7.0] - AMI Exception:ParseCDRRecordToTNGFormat (tr- ["""0785151076"" <0785151076>","0785151076","111","from-did-direct","SIP/3000-00000382","SIP/111-00000383","Dial","SIP/111,"""",tr","2013-01-28 15:09:49","2013-01-28 15:09:49","2013-01-28 15:10:23","34","34"," time

[Belinda Frick]

I would also always suggest to upgrade to the latest version of TNG - refer to forum post: TNG for Asterisk version 1.0.7.7 upgrade

For the log entry

Code: Select all

2013-01-28 13:51:25:495 [1.0.7.0] - AMI Exception:ProcessAMIEvent: Access violation at address 0813F4D5, accessing address 000000A9
2013-01-28 13:51:25:495 [1.0.7.0] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: SIP/3000-0000036f[10]UniqueID: 1359373846.883[10]DialStatus: ANSWER[10]


Refer to forum post: AMI Exception:ProcessAMIEvent: Access violation Asterisk 1.8

For the log entry:

Code: Select all

2013-01-28 14:59:17:883 [1.0.7.0] - AMI Exception:ParseCDRRecordToTNGFormat (tr- ["""0878022710"" <0878022710>","0878022710","111","from-did-direct","SIP/3000-00000380","SIP/111-00000381","Dial","SIP/111,"""",tr","2013-01-28 14:56:57","2013-01-28 14:57:29","2013-01-28 14:59:13","136","104","ANSWERED","DOCUMENTATION","","1359377817.900","audio:20130128-145725-1359377817.900.wav",1227[10]]): 'tr' is not a valid date and time

See forum post - AMI Exception:ParseCDRRecordToTNGFormat ...not.. valid date

If your subscription is up to date you can also upgrade to TNGLive for Asterisk - refer to forum post:
TNG 4* update 2012

NOTE: The difference between the two version is the registration/subscription process. For more information regarding TNGLive for Asterisk see forum post:Does TNGLive work with Asterisk?

[Belinda Frick]

Did you manage to implement the above suggestions?

First I will suggest upgrading your version of TNG and then check the settings as per forum post links.