Hi all,
We are currently experiencing an issue with the 64-bit version of AS. I
can't offer too many more details other than in the AS Process Log it
everything appears to be ok... and then nothing. As an example one of our
most recent log files looked like this at the bottom:

----------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------------
15/08/04 19:55:45 24093 Initiating transaction in Database 'RAPTORE_200405'
15/08/04 19:55:46 24093 Processing Partition 'flex_acru_all_108_h08'
Start time: 19:55:46
15/08/04 19:55:52 24093 Initializing Partition
'flex_acru_all_108_h08'
15/08/04 19:56:01 24093 Partition 'flex_acru_all_108_h08' Execute :
SELECT "RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."BILLED_TIM E_ID",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."CUST_I D",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."CHANNEL_ID ",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."FIN_TIME_I D",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."GL_ACCT_ID ",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."ORG_UNIT_I D",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."PHYSICAL_I D",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."REVN_GENRT G_ID",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."CUST_SPORT F_ID",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."SOURCE_ID" ,
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."CUST_ANZSI C_ID",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."CUST_LOCAT ION_ID",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."CUST_SEGME NT_ID",
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F"."QTY" FROM
"RAPTORE"."VO_FLEX_ACRU_ALL_108_H08_F", "RAPTORE"."VO_FIN_TIME_D",
"RAPTORE"."VO_SOURCE_D" WHERE
("RAPTORE"."VO_FIN_TIME_D"."FIN_TIME_MBR_KEY_MTH"= ?) AND
("RAPTORE"."VO_FIN_TIME_D"."TIME_ID"="RAPTORE"."VO _FLEX_ACRU_ALL_108_H08_F".
"FIN_TIME_ID") AND ("RAPTORE"."VO_FIN_TIME_D"."FIN_TIME_MBR_KEY_QTR"= ?) AND
("RAPTORE"."VO_FIN_TIME_D"."FIN_TIME_MBR_KEY_YR"=? ) AND
("RAPTORE"."VO_SOURCE_D"."SOURCE_MBR_KEY_LVL02"=?) AND
("RAPTORE"."VO_SOURCE_D"."SOURCE_ID"="RAPTORE"."VO _FLEX_ACRU_ALL_108_H08_F".
"SOURCE_ID") AND ("RAPTORE"."VO_SOURCE_D"."SOURCE_MBR_KEY_LVL01"=?)
15/08/04 19:56:11 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 1). Rows processed: 80500
15/08/04 19:56:17 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 2). Rows processed: 65000
15/08/04 19:58:05 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 3). Rows processed: 1390000
15/08/04 19:59:50 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 4). Rows processed: 1356500
15/08/04 20:29:03 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 5). Rows processed: 21436000
15/08/04 20:29:04 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 6). Rows processed: 14000
15/08/04 20:29:06 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 7). Rows processed: 55500
15/08/04 20:30:43 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 8). Rows processed: 1892500
15/08/04 20:33:17 24093 Writing data of Partition
'flex_acru_all_108_h08' (segment 9). Rows processed: 2936000
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------------------

And that's it.... it just stops.... when I retrieved this log file it had
been sitting like this for approximately 13 hours. When I restart the OLAP
service and re issue the process command (from DTS) away it goes.

Any help would be greatly appreciated.

Regards
Josh Lawrence

Further to the above details we have now noticed that AS seems to be
stealing almost the entire memory on the machine.

After issuing the command to process five partitions in parallel away the
server goes and very quickly chews up the 16 gig of memory on the machine.

Seems this may be the issue which is causing AS to just stop. Only question
is, what could be cuasing AS to use so much memory?

Anyone have any ideas?

Thanks for any assistance

Josh

"Josh Lawrence" <someone (AT) microsoft (DOT) com> wrote

Josh,

You seem to be experiencing the same issue as what I'm seeing on 64-bit
AS. Processing just hangs. What is the current processing buffer size
for AS set to?

Were you able to dig up any information on this issue? I've currently
got a ticket open with MS for this issue.

-Justin

Josh Lawrence wrote:

Josh,

You seem to be experiencing the same issue as what I'm seeing on 64-bit
AS. Processing just hangs. What is the current processing buffer size
for AS set to?

Were you able to dig up any information on this issue? I've currently
got a ticket open with MS for this issue.

-Justin

Josh Lawrence wrote:

What is the SQL statement which is being issued? Frequently, if you don't
run the optimize schema tool from the cube editor, the complexity is so high
that processing appears to hang. The SQL statement should be in the
system-wide processing log file (see the SSAS Operations Guide for how to
configure it --
http://www.microsoft.com/technet/pro.../anservog.mspx)

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Justin" <justin (AT) email (DOT) com> wrote