-
Title
When running a Batch Process for "Update Cache Server Permissions"; the Batch update appears to stall and does not complete. -
Description
When running a Batch Cache Server Update it does not complete as expected and appears to stall. The output after running may appear similar to:
...Importing the data into a scratch table ...
Auto-Detect File type=CSV, Row Delimiter=CRLF, header columns=detected
First non-empty row seems to contain headers.
Sample_file.csv Successfully loaded for processing: 4 rows, 6 columns
... Processing scratch-table to work table...
Work table populated with 3 rowsAfter the above, the Batch Update does not progress as expected or provide further information. When processing a valid CSV the next expected lines would continue with:
... Adding the following Cache Server Permissions ...
This would be followed by lines noting the detail of the added Cache Server Permissions.
-
Cause
If some of the information in the Batch file is not correct, the Batch may not complete. This behavior can be seen if an incorrect User ID is used in the CSV as the Cache User account. The Detail provided by the Batch process may not clearly define what information is incorrect, and stops processing. -
Resolution
Verify that the information such as the Cache User name is accurate in the CSV file and test running it again.
Testing with a CSV that has only a single row may assist in narrowing down the issue and assist in troubleshooting.