Symptoms: DTS with Analysis Services Task shuts machine
down if run as scheduled job.

Environment:
Workstation-class server running SQL Server 2000 and
Analysis Services both SP3.


If I run the DTS package interactively - no problem

If I run thru as a "job" it shutsdown the system and there
is no log anywhere that I can see.

Here's the catch!!

I am able to get this to work if tell it to Fail
Package on Log Error within the logging properities.

With this set - the job status is "failed", however the
DTS package executes successfully!!

Here is the error I get from the Job. I have not been
able to find any info on the error -2147220251

Executed as user: NAPLESW2K\SYSTEM. DTSRun: Loading...
DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSOlapProcess.Task_1 DTSRun OnFinish:
DTSStep_DTSOlapProcess.Task_1 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnProgress:
DTSStep_DTSDataPumpTask_1; 1 Rows have been transformed or
copied.; PercentComplete = 0; ProgressCount = 1 DTSRun
OnFinish: DTSStep_DTSDataPumpTask_1 Error: -
2147220251 (800404E5); Provider Error: 0 (0) Error
string: Error accessing Windows Event Log. Error
source: Microsoft Data Transformation Services (DTS)
Package Help file: sqldts80.hlp Help context:
700. Process Exit Code 1. The step failed.



Things I've tried:
increase event log file size

does youir sql agent run under a valid NT account ?
or the standard system account ? (not recommanded)

"Tom Dalsimer" <tom (AT) tdals (DOT) com> a écrit dans le message de
news:e8hpkNhjDHA.2364 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 2003-09-29

Hi and thanks for responding. It is running under the system account - and
always has run every night for a year this way.

The only thing that I can think of that has changed is that I added a new
shared dimension around the same time as this started.


"Jéjé" <willgart (AT) hotmail (DOT) com> wrote

I use the complete process.

I also found this note
http://support.microsoft.com/default...&Product=sql2k
which talks about the threading.

threading has been set to the "main thread" all along. Good thought though!

I have just isolated the problem to, what appears to be, the package
logging. I have been able to work around whatever the problem is by turning
off package logging to sql server.

not sure if this is related to the problem, but it seems to have fixed it
for now. maybe it has something to do with msdb.


"Jérôme Poudou" <jerome.poudou (AT) merkurium (DOT) com> wrote

Hi Tom,

If I understand this correctly is Analysis service crashing. If so could
you confirm that there is a version of dbghelp.dll into "c:\program
files\Microsoft Analysis Services\bin"? The version of Dbghelp.dll must be
6.1.3.0, or later when this file is placed into the bin directory will
sqldumper create a minidump of the crash into the Analysis Services\Data
directory. Could you post this dump so that I can have a look.

Regards,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

Not only is Analysis Services crashing, but the whole system is crashing.
Powered off completely.

the dbghelp.dll is not there; please advise.

Tom
""Bas Kersten [MSFT]"" <bask (AT) online (DOT) microsoft.com> wrote

Hi Tom,

I have send you an e-mail with one of the latest versions of dbhelp.dll
with installation instructions. I really would like to have a look into
this crashes stack, I have never seen that it crashes a complete system,
that should never happen.

Regards,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

I am getting a similiar error when building dimensions of
DB2 tables.
Error msg: SqlDumper.exe - Entry Point Not Found : The
procedure entry point MiniDumpWriteDump could not be
located in the dynamic link library dbghelp.dll.

This crashes the olap server.

This only seems to be happening for dimensions that have a
level where the field type is of DBDATE.

Any ideas

Thanks
Dharmesh Kalyan