Hi,
I am facing an issue with a scheduled process that reads a CSV file using the DataImport script. This process is scheduled to run three times a day, but it fails when executed via the schedule, producing the following error:
2025-02-24 09:16:16 +00:00 - Error - \comau-test-oneidentity - VI.JobService.JobComponents.HandleObjectComponent - AFAA9544-9629-4980-93DB-A72A8353EEA5: Errors occurred Error saving Person: [810103] Error generating processes for event CCC_NotifyErrorRegardingCSVFile_PersonManagerByPersonnelNumber. [810222] Error running script 'Event_CCC_NotifyErrorRegardingCSVFile_PersonManagerByPersonnelNumber'. [810108] Error generation process step event CCC_NotifyErrorRegardingCSVFile_PersonManagerByPersonnelNumber. [810109] Error generating process CCC_UpdateIdentitiesManagerByPersonnelNumber. [810155] Error running prescript. [System.IO.DirectoryNotFoundException] Could not find a part of the path 'C:\Users\Public\Documents\csv\log.txt'. The event CCC_NotifyErrorRegardingCSVFile_PersonManagerByPersonnelNumber was triggered for 1 object(s) of type DialogTable.
Behavior When Running Manually from Object Browser:
- If the file exists → The process runs successfully, processes the file, and archives it as expected (implemented in VB.NET).
- If the file does not exist → The process fails with the following error:
[810103] Error generating processes for event CCC_NotifyErrorRegardingCSVFile_PersonManagerByPersonnelNumber. [810222] Error running script 'Event_CCC_NotifyErrorRegardingCSVFile_PersonManagerByPersonnelNumber'. [810108] Error generation process step event CCC_NotifyErrorRegardingCSVFile_PersonManagerByPersonnelNumber. [810109] Error generating process CCC_UpdateIdentitiesManagerByPersonnelNumber. [810110] Error generating process step Assert file exists. [810156] Error generating parameter FName. Object reference not set to an instance of an object.
Attempted Solution:
To prevent this failure, I tried modifying the parameter’s value template as follows:
Dim fictitious As String = "C:\Users\Public\Documents\csv\fictitious.csv" Dim file As String If String.IsNullOrEmpty(values("FilePathAndName").ToString) Then file = fictitious Else file = values("FilePathAndName").ToString End If Value = file
Questions:
- How can I prevent the process from failing when executed via the schedule?
- How can I ensure that the process handles the case where the CSV file is missing, instead of failing?
Info:
1. One Identity Manager version: 9.1
2. Process looks like: https://photos.app.goo.gl/X17qJtAprSu5AJzm8
3. Including the step that asserts if the file exists, doesn't make any difference, gives the same error.
Any insights or recommendations would be greatly appreciated!
Regards,
Abdalla