Skip to main content
Skip table of contents

DigaTransfer: Error 22001 by writing to table DISPATCH_TASKS

After installing a new DigaSystem database and creating administration tables (version 3) we received an error message in DigaTransfer Broker:
Last Error (Clear): [11.08.2009 19:39:25] InternalCreateTask: System.Exception: ERROR [22001] [Microsoft][ODBC SQL Server Driver][SQL Server]Zeichenfolgen- oder Binärdaten würden abgeschnitten. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Die Anweisung wurde beendet. SQL=INSERT INTO DISPATCH_TASKS(REFNR,TASK_GUID,USERNAME,WORK_NAME,WORK_IP,TITLE,REFNRMAIN_S,SERVER_TABLE_S,REFNRMAIN_D,SERVER_TABLE_D,STATUS,ERROR,CREATEDATE,CREATETIME,TERMINATEDATE,TERMINATETIME,FLAGS,DATA,WORKERNAME,TARGETID) ...
This problem was caused by an old version of the Admin.exe tool. This old version created the field 'FLAGS' of the table 'DISPATCH_TASKS' in nvarchar(254) format.

In such case you need to change the database using ntext 16 for the column 'FLAGS'.
We recommend using the release version of Admin.exe and DigaSQL.dll before creating new databases. Of course the correct SQLAdmin section must be installed, too. 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.