SQL Server Performance

Error in locked process

Discussion in 'SQL Server DTS-Related Questions' started by CanadaDBA, Aug 23, 2004.

  1. CanadaDBA New Member

    My DTS package in production failed and gave me the following error:

    The process can not access the file because it is being used by another process.
    Can not open a log file of specified name. The process can not access the file because it is being used by another process.

    I killed some process but still the problem exists. What shoudl I do? Please help!
    Here are returned messages:


    Error string: The process cannot access the file because it is being used by another process.

    Error source: Microsoft Data Transformation Services (DTS) Package
    Help file: sqldts80.hlp
    Help context: 1100

    Error Detail Records:

    Error: -2147024864 (80070020); Provider Error: 0 (0)
    Error string: The process cannot access the file because it is being used by another process.

    Error source: Microsoft Data Transformation Services (DTS) Package
    Help file: sqldts80.hlp
    Help context: 1100


    Error: -2147024864 (80070020); Provider Error: 0 (0)
    Error string: Cannot open a log file of specified name. The process cannot access the file because it is being used by another process.

    Error source: Microsoft Data Transformation Services (DTS) Package
    Help file: sqldts80.hlp
    Help context: 4700

    DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147024864 (80070020)
    Error string: The process cannot access the file because it is being used by another process.

    Error source: Microsoft Data Transformation Services (DTS) Package
    Help file: sqldts80.hlp
    Help context: 1100

    Error Detail Records:

    Error: -2147024864 (80070020); Provider Error: 0 (0)
    Error string: The process cannot access the file because it is being used by another process.

    Error source: Microsoft Data Transformation Services (DTS) Package
    Help file: sqldts80.hlp
    Help context: 1100


    Error: -2147024864 (80070020); Provider Error: 0 (0)
    Error string: Cannot open a log file of specified name. The process cannot access the file because it is being used by another process.

    Error source: Microsoft Data Transformation Services (DTS) Package
    Help file: sqldts80.hlp
    Help context: 4700


    CanadaDBA
  2. CanadaDBA New Member

    Here is info from Package logs: <br /><pre><br />Step Error Source: Microsoft Data Transformation Services (DTS) Package<br />Step Error Description:The process cannot access the file because it is being used by another process.<br /> (Microsoft Data Transformation Services (DTS) Package (80070020): Cannot open a log file of specified name. The process cannot access the file because it is being used by another process.<br />)<br />Step Error code: 80070020<br />Step Error Help File<img src='/community/emoticons/emotion-7.gif' alt=':s' />qldts80.hlp<br />Step Error Help Context ID:1100<br /></pre><br /><br />CanadaDBA
  3. Argyle New Member

    As it says another process is accessing your file. If you don't know what process it is (an ftp process, a file editor, another batch job that use the file etc) download filemon from www.sysinternals.com and check.
  4. Luis Martin Moderator

    Have you running others scheduled jobs?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

  5. CanadaDBA New Member

    Thank you for introducing the website.
    I had to reboot the server while no one was working with it. After that, The DTS package worked. Before reboot, I tried to run the DTS again but again got the error. I am wonder why this happened while I couldn't see any running/sleeping processes.


    quote:Originally posted by Argyle

    As it says another process is accessing your file. If you don't know what process it is (an ftp process, a file editor, another batch job that use the file etc) download filemon from www.sysinternals.com and check.

    CanadaDBA
  6. Argyle New Member

    It doesn't have to be related to a process in sql server, it can be any process on the server itself. The error is from the operating system and not from sql server.
  7. pvstipel New Member

    Hi,

    What was the outcome of this topic? Could you solve the error?
    I'm experiencing the same at this moment.

    Regards,
  8. satya Moderator

    Do you have any anti-virus package installed on the server or corresponding server that is used by DTS.

    May track the process using PROFILER.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page