July 9, 2009 at 12:13 am
Hi, People.
Every day on my company we execute series of jobs intended for an ETL and cube processing of our BI structure, recently according to my company policy the infrastructure dep. installed Windows Server SP4 on the server, since this SP has been installed some of the jobs fail, for example, one of the jobs that executed a DTS intended to process a cube, had this error output:
Executed as user: BODCLU16\SQLAdmin. ...art:
DTSStep_DTSOlapProcess.Task_1 DTSRun OnFinish: DTSStep_DTSOlapProcess.Task_1
DTSRun OnStart: DTSStep_DTSOlapProcess.Task_17
DTSRun OnError: DTSStep_DTSOlapProcess.Task_17, Error = -2147221504 (80040000)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700 Error Detail Records:
Error: -2147221504 (80040000); Provider Error: 0 (0)
Error string: Invalid OLEVERB structure
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 700
Error: -2147467259 (80004005); Provider Error: 0 (0)
Error string: The repository structure cannot be created on the target server:
The transaction has exceeded the allotted time.
or more information, see the section 'Service Pack Installation' in the Servic... Process Exit Code 1. The step failed.
I think it might be some dll replacement or something like that I'm running SQLServer 2000 after all, its old and for that reason its posible that it happened. I've found on the web that it could be a permission problem on a scripting directory.
I've already searched on the internet about, that problem I've found:.
http://techrepublic.com.com/5208-11184-0.html?forumID=57&threadID=191590&start=0
Does any of you have a clue or a KB link that could help me to solve this problem?
Thanks in advanced!.
July 10, 2009 at 5:11 am
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply