- Release notes
- Before you begin
- Managing access
- Getting started
- Integrations
- Working with process apps
- Working with dashboards and charts
- Working with process graphs
- Working with Discover process models and Import BPMN models
- Showing or hiding the menu
- Context information
- Export
- Filters
- Sending automation ideas to UiPath® Automation Hub
- Tags
- Due dates
- Compare
- Conformance checking
- Process simulation
- Root cause analysis
- Simulating automation potential
- Starting a Task Mining project from Process Mining
- Triggering an automation from a process app
- Viewing Process data
- Creating apps
- Loading data
- Transforming data
- Structure of transformations
- Tips for writing SQL
- Exporting and importing transformations
- Viewing the data run logs
- Merging event logs
- Configuring Tags
- Configuring Due dates
- Configuring fields for Automation potential
- Activity Configuration: Defining activity order
- Making the transformations available in dashboards
- Data models
- Adding and editing processes
- Customizing process apps
- Publishing process apps
- App templates
- Notifications
- Additional resources
Process Mining
Possible cause
There is an issue with CData Sync connecting to SQL Server.
Solution
-
Open SQL Server Configuration Manager.
-
Check the TCP Port number.
-
Check if TCP/IP is set to Enabled for the Port. The following illustrations shows an example.
You may encounter errors while loading data using CData Sync. For example, when some of the tables have loaded successfully, but for the remaining tables an error message occurs indicating that the database or disk is full.
Possible cause
When CData loads data from your source system to Azure Blob, CData Sync temporarily stores the .csv for the task on the local disk on the server where CData is installed. This error might show up when there is is an issue with the local disk.Possible solution
Starting with CData Sync v25, a setting is available to configure the temporary location where data is stored.
Follow these steps to configure this:
-
Go to the Advanced job settings.
- In the Additional Options field, add the following setting:
TempDirectory=D:\cdata_tmp.Important: You can use any drive or path, but make sure the folder is not located on the same disk where CData Sync is installed, and that the folder already exists.
When executing a task or job in CData with the source system set to SQL Server, you might encounter a timeout when running a query that produces a large volume of data.
Possible solution
- In the Source connection, go to the Advanced tab and locate the Miscellaneous section. Change the value for Timeout.
- This value is specified in seconds, you can increase this to 1800 (30 minutes).
- In the Job settings, go to the Advanced tab to edit the Replicate Options. Update the value for Command timeout.
- This value is specified in seconds, you can increase this to 1800 (30 minutes).
Note: Although the setting is described as controlling the timeout for destination connections, it also enforces a timeout on the source connection.
- This value is specified in seconds, you can increase this to 1800 (30 minutes).
