Error in CSV-IN connector

2605
2
11-29-2013 01:12 PM
Highlighted
New Contributor
Hi All!

I built a SSIS ETL that reads data from one table of sql server 2005 and writes this data in a CSV file into a folder placed in Geoevent Server.

I also built a geoevent procesor that has a csv-in, a field mapper processor and a feature update.

The problem is that the geoevent processor is frequently generating the following error:

[ATTACH=CONFIG]29473[/ATTACH]

The SSIS ETL doesn't write directly in the geoevent folder. It writes the csv file in a local folder placed in SSIS Server and then copies the file to the destination folder in geoevent server.

How could i fix this? or
What other way i could build this integration?

Thanks for you advice.
0 Kudos
2 Replies
Highlighted
New Contributor
The error message is saying '... cannot access the file because it is being used by another process' which would indicate that something else is holding a lock onto the file and GeoEvent Processor cannot open it.  Can you please ensure that you do not have the file open in Excel or another program and retry and let us know if this corrects the situation?

Thanks,
Adam Mollenkopf
ArcGIS GeoEvent Processor for Server - Product Lead
0 Kudos
Highlighted
New Contributor
I ask apologize for delay this response.

Yeah Adam, i can ensure that there isn't other process is taking the csv file when GEP is trying to take it. The ETL writes the file in a folder and then the same ETL moves the file to the GEP Folder. That move takes milliseconds.

Meanwhile, i solved the problem making a batch file (that works in the same GEP server trought a scheduled task) that moves the CSV file from folder where ETL writes the file to the GEP Folder. Since then all files have been taked from GEP without problems.

Adam, my other question is: What is the rate of read the files of GEP?

Thanks a lot
César Guzmán
0 Kudos