• No : 30595
  • Open Date : 2019/08/23 17:07
  • Print
NEW

[DataSpider Servista] An error occurs in [Table write] and [Table add write] processing of Dr.Sum adapter.

The following error occurs in [Table write (insert)] and [Add table write] processing of Dr.Sum adapter. Please tell me the cause and the workaround.
 
jp.co.dw_sapporo.drsum_ea.DWException: Error code (<10 or more single-byte alphanumeric characters>)
 
Category : 

Answer

■Probable cause
 
This is the error that the time required for [Write Table], [Update SQL Execute], and [Add Table Write] transactions of Dr.Sum EA adapter is longer than the process timeout setting value of Dr.Sum EA Server. The duration of a transaction is from the start of process to the commit.
 
If you do not use the transaction icon, it will be committed for each icon. Therefore, the required time of the transaction is the time from the start to the end of each icon of [write to table], [execute update SQL] and [write to table add].
 
If you are using a transaction icon, it is committed at the end of the transaction ([commit]). Therefore, the time required for the transaction is from the start of the processing of the [Write in Table], [Update SQL Execution], and [Add Table] icon to the end of the transaction ([commit]).
 
■Workaround
 
In order to avoid the error above, please set the process timeout value of Dr.Sum EA Server to write longer than the duration of transaction.