October 25, 2002 at 8:25 am
Good morning all,
Every night we transfer tables from our Progress production database to a SQL Server7 reporting database with a DTS package. This has been a very reliable process. The last two nights howerver, I have seen this error
"Error: -2147467259 (80004005); Provider Error: 3023(BCF) Error String: Backup,CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after current backup, CHECKALLOC, or file manipulation operation is completed.
The error occurs in the middle of a datapump and occured in different tables each night. A backup of the SQL database does occur after the DTS package and I was able to load the tables successfuly the next morning. I can't find much about this error in KB or BOL. Any thoughts?
Once again thanks for any help.
October 25, 2002 at 1:02 pm
It looks there are some kind of jobs running at same time period DTS job was running. Try to move them either early ot later to see whether problem is still coming.
October 31, 2002 at 7:16 am
Allen,
Sorry about the delay. Well you are correct of course. I had not noticed that the time for this DTS package had grown to the point it was bumping into a SQL backup of the same database. Thanks for your help.
Jonathan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply