When HW on Windows I have similar problem. Also HW service crushing.

Starting:
2018-04-20 22:52:34 ODBC INIT SQLTCHAR: 2
2018-04-20 22:52:34 Connected to relational database

Use "Build RDB Data":
2018-04-20 22:48:02 SA/THREAD(22) CheckInternetEnabler failed
2018-04-20 22:48:19 SA Error building RDB Data

Use "Build All RDB Data"
2018-04-20 22:51:06 SA Failed executing prepared insert, rc: -1
2018-04-20 22:51:06 SA Failed executing prepared insert, vc: CUVc

2018-04-20 22:51:06 SA ODBC ERROR, SQLSTATE 22008 message '[Microsoft][ODBC SQL Server Driver]Datetime field overflow' NATIVE ERROR 0
2018-04-20 22:51:06 SA Disabling RDB interface due to previous errors
2018-04-20 22:51:06 SA Error building RDB Data
2018-04-20 22:52:05 SA Error clearing RDB Data
2018-04-20 22:52:09 SA Error clearing RDB Data
2018-04-20 22:52:16 SA Error clearing RDB Data
Crush

But anyway, some of registers make a HW server crush. IVVc,CUVc etc.

2018-04-20 23:23:55 SA Failed executing statement 2: -1
2018-04-20 23:23:55 SA create table IVVcMath (recid int not null, rowno int not nul
2018-04-20 23:23:55 SA l, STP SMALLINT,ARTCODE NVARCHAR(20),QUANT DECIMAL(31,7),PRI
2018-04-20 23:23:55 SA CE DECIMAL(31,7),rdbSUM DECIMAL(31,7),VREBATE DECIMAL(31,7),
2018-04-20 23:23:55 SA SALESACC NVARCHAR(10),OBJECTS NVARCHAR(60),ORDROW INTEGER,BA
2018-04-20 23:23:55 SA SEPRICE DECIMAL(31,7),ROWGP DECIMAL(31,7),FIFO DECIMAL(31,7)
2018-04-20 23:23:55 SA ,SPEC NVARCHAR(100),VATCODE NVARCHAR(10),RECEPY NVARCHAR(20)
2018-04-20 23:23:55 SA ,SERIALNR NVARCHAR(60),PRICEFACTOR DECIMAL(31,7),VARLIST NVA
2018-04-20 23:23:55 SA RCHAR(30),CUPNR INTEGER,FIFOROWVAL DECIMAL(31,7),COEFFICIENT
2018-04-20 23:23:55 SA DECIMAL(31,7),CUACCCODE NVARCHAR(20),EXCISENR NVARCHAR(20),
2018-04-20 23:23:55 SA PERIODCODE NVARCHAR(10),UNITCODE NVARCHAR(5),UNITFACTQUANT D

2018-04-20 23:23:55 SA ECIMAL(31,7),UNITFACTPRICE DECIMAL(31,7),UNITXVAL DECIMAL(31
2018-04-20 23:23:55 SA ,7),UNITYVAL DECIMAL(31,7),UNITZVAL DECIMAL(31,7),VECODE NVA
2018-04-20 23:23:55 SA RCHAR(20),CREDITCARD NVARCHAR(20),AUTHORIZATIONCODE NVARCHAR
2018-04-20 23:23:55 SA (10),POSCODE NVARCHAR(20),CURNCYCODE NVARCHAR(5),FRRATE DECI
2018-04-20 23:23:55 SA MAL(31,7),TORATEB1 DECIMAL(31,7),TORATEB2 DECIMAL(31,7),BASE
2018-04-20 23:23:55 SA RATE1 DECIMAL(31,7),BASERATE2 DECIMAL(31,7),PAYMODE NVARCHAR
2018-04-20 23:23:55 SA (2),GCNR INTEGER,CUSTORDNR NVARCHAR(60),REPAEXVAT DECIMAL(31
2018-04-20 23:23:55 SA ,7),BASEPRICEB2 DECIMAL(31,7),TAX2CODE NVARCHAR(5),TAX2PRC D
2018-04-20 23:23:55 SA ECIMAL(31,7),TAX2REB DECIMAL(31,7),TAX1REB DECIMAL(31,7),TAX
2018-04-20 23:23:55 SA 2ACC NVARCHAR(10),CREDITEDROW INTEGER,NOTUPDSTOCKFLAG SMALLI
2018-04-20 23:23:55 SA NT,CUSERVICEHISTNR INTEGER,CUSERVICEUNTILDATE DATETIME,SERVI

2018-04-20 23:23:55 SA CEDELDATE DATETIME,LOCATION NVARCHAR(10),rdbCOMMENT NVARCHAR
2018-04-20 23:23:55 SA (100),DISCAPPROVEDBY NVARCHAR(10),PERCEPTIONS SMALLINT,VOIDE
2018-04-20 23:23:55 SA DROWNR INTEGER,VOIDEDSIGN NVARCHAR(10),OVST SMALLINT,WITHHOL
2018-04-20 23:23:55 SA DINGS SMALLINT,WHTAX NVARCHAR(2),CCTRANSID NVARCHAR(50),TAXT
2018-04-20 23:23:55 SA EMPLATECODE NVARCHAR(60),RESUSAGE NVARCHAR(10),MBRCODE NVARC
2018-04-20 23:23:55 SA HAR(10),CHEQUENR INTEGER,CHECKNR NVARCHAR(20),POINTS DECIMAL
2018-04-20 23:23:55 SA (31,7),SALESASSISTANT NVARCHAR(10),CCTIMESTAMP NVARCHAR(20),
2018-04-20 23:23:55 SA MOTHERARTCODE NVARCHAR(20),RECIPEQUANT DECIMAL(31,7),ORDNR I
2018-04-20 23:23:55 SA NTEGER,IVNR INTEGER,RETROW INTEGER,QTROW INTEGER,SHNR INTEGE
2018-04-20 23:23:55 SA R,SHROW INTEGER,CUSTARTCODE NVARCHAR(20),SALESMEN NVARCHAR(6
2018-04-20 23:23:55 SA 0),CREDOFFICIALSERNR NVARCHAR(100),MOTHERNR NVARCHAR(60),AES

2018-04-20 23:23:55 SA TATUS SMALLINT,CUSTOMSNR NVARCHAR(30),COUNTRYOFORG NVARCHAR(
2018-04-20 23:23:55 SA 5),SECONDARYSERIALNR NVARCHAR(60),ALTERNATEDEVICEID NVARCHAR
2018-04-20 23:23:55 SA (30),MOTHERSECONDARYSERIALNR NVARCHAR(60),MOTHERALTERNATEDEV
2018-04-20 23:23:55 SA ICEID NVARCHAR(30),UNITCOMMENT NVARCHAR(200),RVRSVATCODE NVA
2018-04-20 23:23:55 SA RCHAR(10),CCRECEIPTNR NVARCHAR(50),FIFOCUR DECIMAL(31,7),FIF
2018-04-20 23:23:55 SA OROWVALCUR DECIMAL(31,7),CURNCYCODECUR NVARCHAR(5),IVFORRETN
2018-04-20 23:23:55 SA R INTEGER,RETFROMCOMP NVARCHAR(0),USEDBIRTHREBATE SMALLINT,p
2018-04-20 23:23:55 SA rimary key (recid,rowno))
2018-04-20 23:23:55 SA ODBC ERROR, SQLSTATE 42000 message '[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Length or precision specification 0 is invalid.' NATIVE ERROR 1001
2018-04-20 23:23:55 SA Disabling RDB interface due to previous errors
2018-04-20 23:23:55 SA Failed allocating statement
2018-04-20 23:23:58 Windows Service version
2018-04-20 23:23:58 Starting application...

Hello!

From what I understand the part that is still valid is "But anyway, some of registers make a HW server crush. IVVc,CUVc etc."?


Would it be possible for you to repot a bug as I would not be able to give you answer right away?

Best regards,


HansaWorld Latvija

It's problem for Windows Server. On Linux server all registers sync fine.

I have now got this working using the ODBC Driver 17 for SQL Server. I think there should be some updated guidance on how to set this up, from start to finish, as the current manual is a bit vague.