|
Title: Truncated Data Error Post by: Flyberius 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. Title: Re: Truncated Data Error Post by: Arthur Grasin on October 29, 2013, 08:06:16 AM Please, contact me at support _at_ aggsoft.com. I need your raw log file and your current configuration to test it.
|