I have an exception report where I read keys from a Sharepoint list, then export the current exceptions that have not already been listed on SharePoint. The export template works perfectly when I open the template and run it. However, when I attempt to automate using the same template, I get the error “Export_1 - Connection is not available”.
The query first determines the exceptions from an Oracle DB. Then reads the keys from the SharePoint list. The new exceptions are the result of the query.
The export is to the same SharePoint list the keys were read from.
I am using SharePoint 2010 and TDP 3.8. This doesn’t seem to be a very complex application, but, I haven’t yet gotten it to work.