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
- This issue can have more than one cause.
- If you want to use SharePoint for data population, your Sharepoint access token must use SharePoint user credentials. Authentication with the AgilePoint System Account is not supported for data population.
Data Services Windows Service Stopped
Cause
The Data Services Windows service is stopped.
Resolution
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
- 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.
- Do what is necessary to resolve the errors.
Error in Data Services
Cause
An error occurred in the Data Services software component.
Resolution
- On the AgilePoint Server machine, check the Event Viewer logs for any errors related to Data Services.
- Do what is necessary to resolve the errors.