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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-03 : 08:46:22
|
| Jon Davies writes "I am trying to build a cube in Analysis Services from a 2.5 Gb fact table. The fact table is a SAS Dataset and I am using ODBC to access it. After one hour of processing Analysis Services gives up and returns the following error:Step error source: <name of cube/fact table>Step error description: Record=1Step error code: 80040076If I run the process from a smaller version of the fact table the process works fine. It appears that Analysis Services passes a query to SAS via ODBC and simply gives up when SAS has not returned a result after an hour. Is there a way of increasing the amount of time analysis services waits for a result?I am running SQL Server 2000 (SP 2) on Win NT Server Enterprise Edition (SP Unknown)" |
|
|
|
|
|
Cube process fails after one hour