Forum - SQL shadowing stopped

SQL shadowing stopped

Aldevinas Katkus

2017-07-28

We have a client with SQL shadowing and their shadowing has stopped recently. How can it happen that SQL server received wrong date?

2017-07-28 06:51:35 SYSTEM Atsijungti 192.168.0.187: the client closed the connection (2)
2017-07-28 06:53:37 GALIN Failed executing prepared insert, rc: -1
2017-07-28 06:53:37 GALIN Failed executing prepared insert, vc: VIVc
2017-07-28 06:53:37 GALIN ODBC ERROR, SQLSTATE 22008 message '[Microsoft][ODBC SQL Server Driver]Datetime field overflow' NATIVE ERROR 0
2017-07-28 06:53:39 GALIN Disabling RDB interface due to previous errors
2017-07-28 06:53:39 GALIN Error building RDB Data

Diana Klobukowska

2017-07-28

Hi,

In order for us to investigate this further, we would need to see that bug was repeatable. If not and you would like HW or one of our partners to investigate further please contact your local office where we can discuss options. Log files, user actions in the system at the time and registers would need to be examined.

Kind Regards
HansaWorld Team

Aldevinas Katkus

2017-07-31

Created byDiana Klobukowska12:10 28 July 2017

Hi, In order for us to investigate this further, we would need to see that bug was repeatable. If not and you would like HW or one of our partners to investigate further please contact your local office where we can discuss options. Log files, user act

I have tried this https://stackoverflow.com/questions/3318695/how-to-implement-logging-and-error-reporting-in-sql-stored-procedures/45410654#45410654 to catch the wrong date on the purchase invoice, however it did not help. Maybe I can enable some more detailed logging to catch the wrong invoice?

Aldevinas Katkus

2017-07-31

I have found an invoice with date 2091-12-07 date which caused ODBC mirroring to crash

Sanjay Parbhoo

2017-09-18

Created byAldevinas Katkus15:25 31 July 2017

I have found an invoice with date 2091-12-07 date which caused ODBC mirroring to crash

I have had a similar issue with Timesheets and Sales Orders. Took very long to find the offending records.

Sanjay Parbhoo

2017-10-26

Does anyone know of a way to find these records quickly?

Aldevinas Katkus

2017-10-26

Created bySanjay Parbhoo14:13 26 Oct 2017

Does anyone know of a way to find these records quickly?

use SQL profiler either the the one which comes with SQL server or this one (if I am right) http://expressprofiler.codeplex.com/

Back to the list

New Message
Open Questions My Questions