I'm trying to process an access cube and receive system resource exceeded. I
haven't a clue as to what resource I've exceeded. The process took about 55
minutes, then blew up. Where do I start? Thanks George

Hi George,

Doing a quick search this looks like an Access error. How big is the Access
database that you are processing? How many rows? How many dimension and
levels and members?

In the processing log where did it display the error? In the query phase or
aggregation phase?

It could be the query is too complex and the data too large for Access
database.
How much ram do you have?

David Botzenhart
Mariner Consulting


"George Morton" <gmorton1 (AT) optonline (DOT) net> wrote

Hi George,

This looks like an error from Access. When you look at the processing log
when does the error occur? Is it in the Query phase or in the Aggregation
phase? How large is the cube that is in Access, how many rows, how many
dimensions, levels and members? This will state how complex the query is if
you are going beyond what Access can handle. Have you tried to put the cube
in SQL Server?

David Botzenhart


"George Morton" <gmorton1 (AT) optonline (DOT) net> wrote

The data source is SQL server, not access. Access is used for the OLAP
application. There are about a million rows in the transactions table, the
query looks like this:

Partition 'Transactions' Execute : SELECT "Accounts"."SSN_TIN",
"Accounts"."ACCT_NUMBER", "Transactions"."INT_TYPE",
"Transactions"."PROCEEDS" FROM "Transactions", "Accounts" WHERE

("Transactions"."SSN_TIN"="Accounts"."SSN_TIN") AND

("Transactions"."ACCT_NUMBER"="Accounts"."ACCT_NUM BER")

This is the first "process" I've run against this cube, so I think there is
one dimension, a million rows, one level and one member (but I'm not sure
how to determine each). On the server side, there's a gig of ram, one the
workstation side there's 512 MB.

The blow-by-blow from the process dialog follows:

(1) Processing Partition 'Transactions' failed. No changes have been made to
the database.

Start time: 1:25:57 PM

Initializing Partition 'Transactions'

Partition 'Transactions' Execute : SELECT "Accounts"."SSN_TIN",
"Accounts"."ACCT_NUMBER", "Transactions"."INT_TYPE",
"Transactions"."PROCEEDS" FROM "Transactions", "Accounts" WHERE

("Transactions"."SSN_TIN"="Accounts"."SSN_TIN") AND

("Transactions"."ACCT_NUMBER"="Accounts"."ACCT_NUM BER")

Data source provider error: System resource exceeded.;3035;

Time:4/13/2005 2:02:48 PM

Rolling back transaction in Database 'DataWarehouse'

System resource exceeded.;3035; Time:4/13/2005 2:02:51 PM .....

Thank you for your assistance. George.

"David Botzenhart" <David.Botzenhart (AT) mariner (DOT) usa.com> wrote

Hi George,

Sorry its taken me a while to reply. Getting my taxes done.

This error is coming from the provider in SQL. You should see some errors in
your Application Event Log as well.

See if you can run the exact same query in Query Analyzer, if not then its a
pure SQL issue.

David

"George Morton" <gmorton1 (AT) optonline (DOT) net> wrote