Why Does Data Population Not Show Any Records in the Database Table?

Symptoms

When you configure data population in a process model, no records show in the target database table.

Good to Know

Error in WF_DATA_SERVICE_TEMPDB Table

Cause

An error occurred when moving records from the WF_DATA_SERVICE_TEMPDB table to the target database table.

The AgilePoint Data Services Windows service monitors records coming into the WF_DATA_SERVICE_TEMPDB table. The records then move to the target to be completed. If Data Services finds any error while processing the WF_DATA_SERVICE_TEMPDB record, it moves the records into the WF_DATA_SERVICE_ERRORDB table.

For more information, refer to Configure the Data Services Windows Service.

Resolution

  1. Check if there are records in WF_DATA_SERVICE_ERRORDB table. If errors exist, the column ERROR_DESC shows the details of the error message.
  2. Do what is necessary to resolve the errors.

Error in Data Services

Cause

An error occurred in the Data Services software component.

Resolution

  1. On the AgilePoint Server machine, check the Event Viewer logs for any errors related to Data Services.
  2. Do what is necessary to resolve the errors.