I have a custom datasource script that goes out and discovers all of our DFS Namespaces, and all of their Targets. The first part that just gathers the namespaces and puts into a CSV goes and updates fine. The second table that I have which pulls all the DFS Links inside the namespaces takes about an hour and half to complete. That part is fine and is expected as well. The part that fails is when the csv file gets uploaded into the database it is running into an issue where it is taking too long to upload. Below is the error I get.
Acquisition timed out as it took longer than 15 minutes to load acquired data into the cache database - ARJUNA016063: The transaction is not active!
Anyone have any suggestions. Is there any settings that I can modify to to increase this timeout?
Note: The default config setting provided by NetApp is optimal for the most common use cases. Modifying the JBoss config may have unwanted issues and not all of them have been known or verified by NetApp.
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
That does not seem like a very large dataset. I would attempt a manual import using mysql work bench and see how long that takes. I would look for a data formatting issue in the input file or a bad charter in the file. If you are retrieving the via powershell you may want to consider using the mysql insert process documented in other scripts on the wfa site.