5 Replies Latest reply: May 15, 2014 10:10 AM by Olly Bond RSS

    MDP 10.5  OLE DB internal error

    Maurice _

      I have set up a new process, checked and rechecked that every path conforms to UNC, have recycled  the pump but the OLE DB internal error is not going away. I have deleted and recreated the entire process but the error is still there.

       

      Here is the error message:

       

      OLE DB internal error: 'W:\raemdeon\pickup\AccesData Bases\FilefromEMDEON' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides

       

      Any thoughts are greatly appreciated.

       

      Thank you,

       

      Maurice

        • MDP 10.5  OLE DB internal error
          mdyoung _

          Hi, Maurice.

           

          I'm assuming that the file from Emdeon (yes... we use them too) is your input file and that the W:\ is a mapped drive to a network resource. Either that or your server has a LOT of local drives on it. What I'd try first is to use the UNC pathway that W:\ is mapped to because I've ran into problems before when using mapped drives. Also, make sure that the credentials the DataPump service is running under has the proper rights to the network resouce. Open the Services MMC under Adminstrative Tools and check what the service "Monarch DataPump 10" is using.

           

          Although you can specify different credentials for Windows to use when mapping a drive rather than what the server or pc is signed into Windows with, DataPump is going to use whatever credentials its service is running on. If you used the default setup when you, or whoever, installed DataPump, more than likely DataPump is using the local system account, which may or may not have access to your resource. If this is the case and you decide to change what credentials DataPump runs under, make certain that the credentials you use doesn't break other processes' rights to their resouces.

           

          Hope this leads you in the right direction.

           

          Thanks,

           

          Micheal