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.

Managed to sort this.

I have sent you an email detailing another issue I have stumbled upon regarding exporting to SQL.

Hi all.  I have been testing PBX logger using the trial.  Got a nice SQL database set up and it all worked perfectly.  Occasionally the application would fail to start but this seemed no big deal as it worked the majority of the time I tried to start it.

Anyway, I have purchased the software and activated it and rebooted the PC that it sits on.  However now the application wont start at all.  It simply hangs upon opening.

Event viewer shows this:

*****
The program pbxlogger.exe version 3.0.6.621 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
 Process ID: a10
 Start Time: 01ceb05c90b57735
 Termination Time: 15
 Application Path: C:\Program Files (x86)\Advanced PBX Data Logger\pbxlogger.exe
 Report Id: ef5bddea-1c4f-11e3-ba1d-1803734e9917
*****

I upgraded the software to the latest version to see if this would help.  Alas no.

*****
The program pbxlogger.exe version 3.0.7.828 stopped interacting with Windows and was closed. To see if more information about the problem is available, check the problem history in the Action Center control panel.
 Process ID: af0
 Start Time: 01ceb05d0bec4141
 Termination Time: 13
 Application Path: C:\Program Files (x86)\Advanced PBX Data Logger\pbxlogger.exe
 Report Id: 90c07833-1c50-11e3-ba1d-1803734e9917
*****

Any thoughts on this.  I am praying to god this is a problem you have seen before.

PC details:

Windows 7 64bit
CPU: 3.3GHz quad core
RAM: 6GB