User Guide › Design › Data Acquisition › Adapters › Adding Adapters › Add a Text File Adapter › General Step › Processing Tab

Processing Tab

In the Processing tab set the adapter's run and processing behavior.

1. In Run, select:
   • Once: To have the adapter run, read records and stop automatically when there is no new data to read. The file adapter reads all the files, waits a few seconds, tries to read new records (depends on the sleep time) and if there are no new records it stops. This is the most common setting for adapters. This setting is mainly used for running the adapters manually or schedule them to run with an external scheduling tool.
   • Always: To have the adapter run continuously. This is mainly used when the adapter is deployed as a service.

   Note: Until further notice, whenever you edit an adapter whose Run mode is "Always", you must stop and restart the "Oblicore - AdaptersListener" service.

   1. Open the Control Panel, Administrative Tools, Services.
   2. Stop and restart the "Oblicore - AdaptersListener" service.

      The service can now put into effect the adapter load configuration change.

2. Select the "Repeat until dry" check box to have the adapter wait (depends on the sleep time), and try to run the queries again (depends on the query’s sleep time) and if there are no new records stop. This check box is enabled if Once is selected.
3. In Runtime errors limit, type a positive integer value. This field determines the errors limit, like errors in the input events, before the adapter is blocked. When the number is 0 the adapter is never blocked. When not specified the default is 1, which means that the adapter is blocked after the first error.
4. In Pending events upper limit, type a value between 1 to 100000. This determines the upper limit of pending records that are kept in the pending file (also known as the rejected events file). When the adapter reaches this limit, it stops and changes to block status until these records are translated. When not specified the default value is 1000.
5. In Load translation table timeout, specify the translation table loading mode timeout in seconds. This field is enabled if Mode in the General tab is set to Online.
6. Select the Save illegal events check box to save the illegal events.
7. Select the Unlimited depth of regular expression search check box to ignore any limit on the regular expression process.
8. Select the Preliminary query check box to have the adapter check the queries when it connects to the database.
   • When this check box is cleared, the adapter checks the queries by executing them without any change. The adapter runs on the return records later and does not read them again.
   • When this check box is selected, the adapter replaces each "where" string in the select statement with "where 1=2 and" and only then executes the queries. Use this option to check all the queries before the adapter starts to run over the records and when this addition dramatically shortens the query time.

   Note: Some of the providers do not optimize the query process. Therefore, when the query is legal, the execution takes the same amount of time as it takes without the addition.

9. Click Save. The Adapter Wizard page General step is displayed.