URGENT: Locked process - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

URGENT: Locked process

Author

Topic

CanadaDBA

583 Posts

Posted - 2004-08-23 : 09:30:52

Urgent!!
Please Help ASAP:

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!

Canada DBA

CanadaDBA

583 Posts

Posted - 2004-08-23 : 09:37:20

More info:

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

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-23 : 12:15:39

The file is locked by something. If you can't figure out what has it locked, reboot. Then rerun the package.

Tara

CanadaDBA

583 Posts

Posted - 2004-08-23 : 12:46:04

Tarra,
It's production server and there are lots of users connected. I can not do a reboot at least up to end of the day (8:00pm). I need to get some approval, too.

In the error message "Can not open a log file of specified name", what it means? Which log file it is talking about?

Thanks,

quote:
Originally posted by tduggan

The file is locked by something. If you can't figure out what has it locked, reboot. Then rerun the package.

Tara

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-23 : 12:57:50

I suspect that it has to do with DTS package logging. Open the package up, go to Package menu option, then properties. Then go to logging tab.

Tara

CanadaDBA

583 Posts

Posted - 2004-08-23 : 13:35:52

I have seen this already. Here is the information in that log:


Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:The process cannot access the file because it is being used by another process.
 (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.
)
Step Error code: 80070020
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100

It is talking about a file. What file?

The DTS opens a text file and imports into a table. I can copy the text file into another folder, so it shouldn't be locked by anything. There should be something inside the SQL. I have read "the package log is in MSDB databse"; what's its name? How can I get more detailed information from the error message?

Thanks,

quote:
Originally posted by tduggan

I suspect that it has to do with DTS package logging. Open the package up, go to Package menu option, then properties. Then go to logging tab.

Tara

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-23 : 13:39:09

I think you missed my point. I think you are getting the error due to the DTS package log file being in use. The one that you are opening to view these errors, I think that's the file that is locked. Turn off logging and see if the package executes successfully.

Tara

CanadaDBA

583 Posts

Posted - 2004-08-23 : 14:22:42

Under the Logging tab, there is no check mark infront of the "Log package execution...". Also, there is no check under Advanced, infront of "Show lineage...".

There was a Error file under logging that I cleared it.

Still the error exists. How can I find the log in the MSDB? What's the name of the table?

quote:
Originally posted by tduggan

I think you missed my point. I think you are getting the error due to the DTS package log file being in use. The one that you are opening to view these errors, I think that's the file that is locked. Turn off logging and see if the package executes successfully.

Tara

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-23 : 14:27:49

I believe it's sysdtspackagelog.

Tara

CanadaDBA

583 Posts

Posted - 2004-08-23 : 15:08:23

There are two rows in sysDTSpackageLog. These logs are dated as:
2004-08-23 12:51:44.000
2003-10-28 07:33:17.000

I deleted the log using the delete option in the DTS package right click menu and the 2004 row was deleted. The Error still exists.

Do you think rebooting will solve the problem?

Thanks,

quote:
Originally posted by tduggan

I believe it's sysdtspackagelog.

Tara

Canada DBA

CanadaDBA

583 Posts

Posted - 2004-08-23 : 23:48:51

I rebooted 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.

Canada DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources