Forum Discussion
Copy Job source internal error
I was getting the exact same error since yesterday for any warehouse I wanted to use as the source for the Copy Job. I tried connecting to different warehouses with data in it but I got the same internal error.
Later I found that I needed to re-authenticate my warehouse connection that was being used to connect to the source. I went to the 'Manage Connections and Gateways screen', in the Conenctions tab located my connection for the warehouse, saw that it was offline, reauthenticated the connection from the 'settings' option of the connection, and then I was able to resolve the error.
Hope that helps!
I was getting the exact same error since yesterday for any warehouse I wanted to use as the source for the Copy Job. I tried connecting to different warehouses with data in it but I got the same internal error.
Later I found that I needed to re-authenticate my warehouse connection that was being used to connect to the source. I went to the 'Manage Connections and Gateways screen', in the Conenctions tab located my connection for the warehouse, saw that it was offline, reauthenticated the connection from the 'settings' option of the connection, and then I was able to resolve the error.
Hope that helps!
Yes, that was it. When I checked my connection it was showing as 'Offline' - why did it need reauthenticating is a topic for another discussion, could get interesting with pipelines suddenly failing with vague error messages!
Thanks
Jeff