2014-05-16 12:43 PM
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?
2014-05-16 08:31 PM
What is your WFA version? The possible setting change depends on the WFA version.
For WFA2.1 and above, see my reply ( towards the end) in this post: https://communities.netapp.com/message/120404#120351
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.
2014-05-17 11:49 PM
How big is the data the custom script is trying to acquire?
The transaction timeout happens if the data is very very large.
You need to see why the custom script is taking so long time.
Where is the most time taken when the acquisition happens?
2014-05-19 11:34 AM
The file it is trying to pull in is 79000 lines long with three columns. (DFS Path, Target Path, and the state of that link (ONLINE/OFFLINE)
I'm not sure how I would check where the acquisition is being hung up at.
2014-05-27 06:00 AM
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.