The following error is raised when processing file chr0002.97. It
seems to be related to the value in the [asaiuui] field. However, if
the INSERT statement is copied from the error log file and manually
run against the database using the SQL Server Management Studio, the
record gets inserted successfully. There are other records with UUI
data that also insert sucessfully. Can anyone provide any assistance
or direction on troubleshooting? I have uploaded the chr0002.97
file.
Thanks in advance for any assistance.
Tue Dec 02 14:13:42 -0500 2008 (35940) Error processing ECHI file -
DBI::DatabaseError: Execute
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL
Server
Unclosed quotation mark after the character string '5180'.
HRESULT error code:0x80020009
Exception occurred.: INSERT INTO [echi_records] ([segment],
[vdn9], [events0], [asaiuui], [cwcdigits], [cwcs0], [queuetime],
[events1], [split1], [malicious], [origholdtime], [cwcs1], [firstvdn],
[holdabn], [events2], [split2], [dispsklevel], [cwcs2],
[lastobserver], [audiodifficulty], [events3], [split3],
[observingcall], [cwcs3], [uuilen], [events4], [cwcs4], [segstart],
[eqloc], [events5], [conference], [talktime], [duration], [disptime],
[onholdtime], [acdnum], [agentreleased], [events6], [dispivector],
[collectdigits], [firstivector], [origreason], [calldisp],
[callingII], [ansreason], [dispsplit], [events7], [obslocid],
[daqueued], [events8], [consulttime], [ucid], [trunkgroup],
[dialednumber], [dispvdn], [vdn2], [vdn3], [segstop], [assist],
[origlocid], [callid], [vdn4], [transferred], [tklocid], [vdn5],
[ringtime], [callingparty], [acwtime], [answerlocid], [vdn6], [holds],
[disppriority], [vdn7], [origlogid], [anslogid], [netintime], [vdn8])
VALUES(2, '', 0, '5180 |UNO|12|
6508649903|1849008|00001024021227184479|
5180|1849895|', '', '', 0, 0, -1, 'N', 0, '', '1849895', 'N', 0, -1,
0, '', '', 'N', 0, -1, 'N', '', 4, 0, '', '20081120 07:35:22', '', 0,
'N', 0, 64, 12, 0, 1, 'N', 0, 897, '1', 895, 0, 4, '', 0, -1, 0, 0,
'N', 0, 0, '00001024511227184522', 0, '1849895', '1849897', '1849896',
'1849897', '20081120 07:36:26', 'N', 0, 4992903, '', 'N', 0, '', 0,
'1839956', 0, 0, '', 0, 0, '', '', '', 0, '')
Tue Dec 02 14:13:42 -0500 2008 (35940) ECHI-Converter service stopped