• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 30591
  • Open Date : 2019/08/23 17:05
  • Print
NEW

[DataSpider Servista] "Done" button can not be pressed after setting DB trigger

I can not press the "Finish" button after setting up the DB trigger. Please tell me the probable cause.
 
Category : 

Answer

If an XML type script input variable is not created in the script, set by DB trigger, the "Done" button may not be pressed.
 
When a user uses DB trigger, it is necessary to follow the procedure below.
 
  1. Add status column
It is necessary to add a status column to the monitored table. The DB trigger monitors the value of the status column of the monitoring target table and passes the data of the record, which the status has been changed, to the subsequent processing.
  1. Create XML type script input variable
Scripts set with DB triggers require a script input variables of type XML. The updated data is passed from the DB trigger to this script input variable.
 
If you can not press the "Done" button, please make sure that the script executed by the DB trigger has created an XML type script input variable.
 
Supplementary
 
You can also refer to "About Pre-setting" in the product help for pre-setting of DB trigger. Please check the details from the "Reference Information" link.
 
 
Reference information
  • DB trigger