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.
| Author |
Topic |
|
banksy
Starting Member
2 Posts |
 Posted - 2004-02-01 : 20:46:42
|
| I am at a loss here. I have been diagnosing this issue for about a month now, but have not come close to resolving it. A client has an Analysis Database which can be processed one of two ways.1. We have set up a DTS package to do a FULL PROCESS each evening. This can take up to 8-9 hours to process the full database. When processing is launched from a scheduled job executing this DTS pacakge, the job fails with ERROR 1 below. It can process for anywhere from 1 hour to 8 hours before it gets this error. 2. If I do a full process of the same database from within Analysis Manager, the analysis database processed without any problems. This takes as long as the scheduled job would take if it were to be successful.Notes: SQL 2000 is on SP 3 as well as Analysis Services. OS is Win2000 Server with SP2. The server has dual PIII 1.00 Ghz processors.----------------------------------------------------------------------Executed as user: SERVER1\SYSTEM. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: RISLogicCS_PA_Process DTSRun OnError: RISLogicCS_PA_Process, Error = -2147221411 (8004005D) Error string: Error source: Ref Physician Demographics Help file: Help context: 1000440 Error Detail Records: Error: 0 (0); Provider Error: 0 (0) Error string: Error source: Ref Physician Demographics Help file: Help context: 1000440 DTSRun OnFinish: RISLogicCS_PA_Process DTSRun: Package execution complete. Process Exit Code 1. The step failed.-----------------------Terry BanksSr. Tech Support AnalystMerge eFilm |
|
|
mikepre
Starting Member
5 Posts |
Posted - 2004-03-05 : 13:46:57
|
| I'm not quite sure about your problem. Try migrating Olap repository to SQL Server 2000. I have had similar experiences when someone had opened the Analysis Manager, which opens Access Database with the Olap repository in exclusive mode.Best Regards,Michael PrendergastDataMart S.A.Chile |
 |
|
|
|
|
|
Analysis Processing Fails