Getting the error "Export_1 - Connection is not available'" automating an export to SharePoint

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.

If you are not going to substitute the connection in export template, please uncheck “Use automation connection” box, or you have to specify the Oracle connection here. Please don’t use SharePoint connection.

The export/import to SharePoint List does not use SharePoint connection in connection manager, they are done using different technologies, and should not be mix used.

I have the “Use automation connection” unchecked.

I do use both the Oracle and the SharePoint connections in the query. Is this a problem since the export runs correctly when I do the export manually?

I thought you were exporting query from Oracle connection to SharePoint list. If you are using cross query with Oracle and SharePoint connections, this is totally fine.

Are you still get the “connection not available” error after unchecking the box?

Yes, I still get the error.

I have a problem ticket, SR Number:3340471.

Thanks for the help.

From: Kiki [mailto:bounce-Kiki@toadworld.com]

Sent: Wednesday, March 23, 2016 1:18 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Getting the error “Export_1 - Connection is not available’” automating an export to SharePoint

*** This is an EXTERNAL email. Please exercise caution. DO NOT open attachments or click links from unknown senders or unexpected email. - STS-Security***

RE: Getting the error “Export_1 - Connection is not available’” automating an export to SharePoint

Reply by Kiki

I thought you were exporting query from Oracle connection to SharePoint list. If you are using cross query with Oracle and SharePoint connections, this is totally fine.

Are you still get the “connection not available” error after unchecking the box?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.