2 Replies Latest reply: Oct 17, 2017 8:10 AM by Erik Venema RSS

    Unspecified error

    Alfred Simbun

      Hi fellow users.

       

      Anyone has this same problem before:

       

      Connector reply error: ErrorSource: Microsoft OLE DB Provider for Oracle, ErrorMsg: Unspecified error


      I tried to re-run the SQL script using Toad that is connected to the server and database. It worked fine over there.


      Hearing from any expert soon.


      Thanks.



        • Re: Unspecified error
          Michalina Kuczynska

          Hi there,

           

          Anything more specific maybe in the load script  logs? This could be caused by many reasons. I will probably also start from executing this as a different user set with permission to this DB and also making sure the table owner is defined within your script.

          • Re: Unspecified error
            Erik Venema

            I've encountered this error. I found a quick workaround by disconnecting and reconnecting after each table load.

            This makes it appear as if it's got something to do with connection time-outs.

             

            Have you found a better solution to this issue?