Flyberius
Newbie
Karma: +0/-0
Posts: 3
|
 |
« on: October 28, 2013, 06:05:03 PM » |
|
Hi All,
Got a slight issue. It seems that some records when getting inserted into our PBXDATA table on our PBX database get truncated.
Are there any Advanced PBX logs that I can use to further troubleshoot the issue. I imagine, once I know the cause, I can increase the varchar size for the offending column.
I have attached an image showing the message being produced.
Below are the logs I have found. 28/10/13 14:51:24 [192.168.2.240:5001] pbxlogger. Unable to write to database [[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.]
28/10/13 14:51:24 [192.168.2.240:5001] pbxlogger. SQL: INSERT INTO "PBXDATA" ("CALL_TIME", "DURATION", "DURATION_S", "DIRECTION", "CALL_TYPE", "FLAG1", "FLAG2", "FLAG3", "FLAG4", "FLAG5", "FLAG6", "FLAG7", "CALLER_PHONE", "DIALED_PHONE", "TRUNK", "CO", "ACC", "EXT", "RING", "COST", "DNIS", "AUTH", "AREA_CODE", "COUNTRY_CODE", "PBX_IDENTIFIER") VALUES (:P0, :P1, :P2, :P3, :P4, :P5, :P6, :P7, :P8, :P9, :P10, :P11, :P12, :P13, :P14, :P15, :P16, :P17, :P18, :P19, :P20, :P21, :P22, :P23, :P24)
From what I can see it seems to have an issue with all the columns.
|
