I have a weird issue regarding MailRelay tests.
I am sending all test results for the installation to a SQL server.
For some reason the results from MailRelay tests are not being inserted into the SQL server database.
According to the error below there may be some field capacity being exceeded during insertion which wouild cause it to be truncated. Which one I dont know. Is this a bug? All other tests log to the SQL server just fine. Only the MailRelay tests are not getting in and causing the syslog to grow with every attempt.
I get the following error in the syslog file:
[10/24/2010 11:01:30 PM] Sys Primary log error. ODBC error code: 4294967295 ([Microsoft][SQL Server Native Client 10.0][SQL Server]String or binary data would be truncated
[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated) Logging initiated by "MailRelay: mailrelaytest@domain.com to mailrelaytest@domain.com" test.
Any suggestions?
Primary Log Error with MailRelay Tests
Well, we don't know either, we don't know what fields, variables and SQL query do you use.According to the error below there may be some field capacity being exceeded during insertion which wouild cause it to be truncated. Which one I dont know
However I do not think this is a big problem. How many field do you use? 7? 15? You may easily check all of them.
If you are using SQL query to store test name, comment, related url, path to private log files, I would check corresponding fields in the first place.
Regards
Alex
To follow up on this, I doubled the field sizes in the database and the problem went away.
The database table that was originally created was the default table schema in the options dialog under log settings. No modifications were done to the names or the field sizes.
This error was specific to the mail relay tests and nothing else.
I noticed the erro would occurr when the remote agent would be disconnected then upon reconnection the error would pop up in the syslog.
I suspect that there was some data ro invalid character maybe in the reply that was too large and exceeded the filed size generating the error.
The database table that was originally created was the default table schema in the options dialog under log settings. No modifications were done to the names or the field sizes.
This error was specific to the mail relay tests and nothing else.
I noticed the erro would occurr when the remote agent would be disconnected then upon reconnection the error would pop up in the syslog.
I suspect that there was some data ro invalid character maybe in the reply that was too large and exceeded the filed size generating the error.