Why are we getting "Error A0: DataCollect helper process failed to complete successfully" while running built-in data collect returned?

« Go Back

Information

Title	Why are we getting "Error A0: DataCollect helper process failed to complete successfully" while running built-in data collect returned?

Summary	Error while running built-in data collect.Code. Error A0: DataCollect helper process failed to complete successfully

URL Name	Why-are-we-getting-Error-A0-DataCollect-helper-process-failed-to-complete-successfully-while-running-built-in-data-collect-returned

Resolution

Remove UMID (level 0) association to a group on Step 5 of Database Setup except for Worklist and respective staging tables.

Products	Allocation

Module	Data Collect

Version	8.1

Error Message Code

"Error A0: DataCollect helper process failed to complete successfully
ORA-00957: duplicate column name"

Cause

This error may occur if any column that contains a UMID (level 0) is associated with a group on Step 5 of Database Setup.

Additional Information

UMID must be mapped in Step 9 only
The configuration error may not apply to data collects in earlier versions, but will likely trip up data collect in 8.1 because of changes to that process that are less tolerant of the poor configuration
The built-in data collect requires that the UMID be populated from groups on your staging table during the data collect. Only use groups in your UMID that exist as columns on your staging tables. In other words, build your UMID using WorkList columns (groups associated with WorkList table columns on Step 5) that also exist as staging tables columns (groups associated with Staging table columns on Step 5)

Publication Status	Published