dbTalk Databases Forums  

Problem processing partition

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap Problem processing partition

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problem processing partition in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
%u
 
Posts: n/a

Default Problem processing partition - 02-22-2005 , 02:25 AM





Hello,

I have a wired
problem.
I have a cube
enabled in writing.
It works good , then
I archived it in a
..cab
and restore it in
another computer.
The restoration
works fine but when
I process the cube
it process only the
data of the table
who store the
writing data.
Then I do not see
the data of the
master partition.

Could someone help
me please ?

Thanks

Reply With Quote
  #2  
Old   
Peter Yang [MSFT]
 
Posts: n/a

Default RE: Problem processing partition - 02-22-2005 , 05:31 AM





Hello,

I agree with you it is a weird issue. Can you reproduce the issue or did it
only occur once? If you make the cube write-disabling, does the issue also
occur? If you re-processing the cube, does it many any change?

I was not able to reproduce the issue on my side currently. It seems that
we may need more clues to troubleshoot the problem.

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


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




--------------------
Quote:
From: %u <nospam (AT) nospam (DOT) com
Newsgroups: microsoft.public.sqlserver.olap
Subject: Problem processing partition
Organization: XXX News Server
X-User-Real-E-Mail:
User-Agent: PHP News Reader v2.5.9 (CDSHEEN)
Mime-Version: 1.0
Content-Type: text/plain; charset="big5"
Content-Transfer-Encoding: 8bit
X-HTTP-Posting-Host: 192.168.2.18
Date: 22 Feb 2005 08:25:51 GMT
Lines: 26
Message-ID: <421aec8f$0$24429$626a14ce (AT) news (DOT) free.fr
NNTP-Posting-Date: 22 Feb 2005 09:25:51 MET
NNTP-Posting-Host: 82.235.108.67
X-Trace: 1109060751 news12-e.free.fr 24429 82.235.108.67:40229
X-Complaints-To: abuse (AT) proxad (DOT) net
Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!newsfeed.icl.net!proxad.net!infeed-2.proxad.net!
news12-e.free.fr!not-for-mail
Quote:
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:57665
X-Tomcat-NG: microsoft.public.sqlserver.olap

Hello,

I have a wired
problem.
I have a cube
enabled in writing.
It works good , then
I archived it in a
.cab
and restore it in
another computer.
The restoration
works fine but when
I process the cube
it process only the
data of the table
who store the
writing data.
Then I do not see
the data of the
master partition.

Could someone help
me please ?

Thanks


Reply With Quote
  #3  
Old   
%u
 
Posts: n/a

Default RE: Problem processing partition - 02-22-2005 , 09:01 AM


== Quote from Peter Yang [MSFT] (petery (AT) online (DOT) microsoft.com)'s article
Quote:
Hello,
I agree with you it is a weird issue. Can you reproduce the issue or did it
only occur once?
Yes I can reproduce it, I reproduced it serveral times before posting
If you make the cube write-disabling, does the issue also
occur?
I tried this. I even deleted all data of the fact table who comes
from the writing process. And when I reprocess the cube it reads
only data from the writetable but no from the fact table.
It is realy strange.
Quote:
If you re-processing the cube, does it many any change?
no
I was not able to reproduce the issue on my side currently. It seems that
we may need more clues to troubleshoot the problem.
maybe the .cab ?
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: %u <nospam (AT) nospam (DOT) com
| Newsgroups: microsoft.public.sqlserver.olap
| Subject: Problem processing partition
| Organization: XXX News Server
| X-User-Real-E-Mail:
| User-Agent: PHP News Reader v2.5.9 (CDSHEEN)
| Mime-Version: 1.0
| Content-Type: text/plain; charset="big5"
| Content-Transfer-Encoding: 8bit
| X-HTTP-Posting-Host: 192.168.2.18
| Date: 22 Feb 2005 08:25:51 GMT
| Lines: 26
| Message-ID: <421aec8f$0$24429$626a14ce (AT) news (DOT) free.fr
| NNTP-Posting-Date: 22 Feb 2005 09:25:51 MET
| NNTP-Posting-Host: 82.235.108.67
| X-Trace: 1109060751 news12-e.free.fr 24429 82.235.108.67:40229
| X-Complaints-To: abuse (AT) proxad (DOT) net
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.
sul.t-online.de!t-online.de!newsfeed.icl.net!proxad.net!infeed-2.proxad.net!
news12-e.free.fr!not-for-mail
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:57665
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| Hello,
|
| I have a wired
| problem.
| I have a cube
| enabled in writing.
| It works good , then
| I archived it in a
| .cab
| and restore it in
| another computer.
| The restoration
| works fine but when
| I process the cube
| it process only the
| data of the table
| who store the
| writing data.
| Then I do not see
| the data of the
| master partition.
|
| Could someone help
| me please ?
|
| Thanks
|


Reply With Quote
  #4  
Old   
Peter Yang [MSFT]
 
Posts: n/a

Default RE: Problem processing partition - 02-23-2005 , 12:29 AM


Hello,

I am not sure if you tried to write-disable the original cube, re-archive
the original database, and restore the database again to test. Does the
issue also occur at this time? Does the issue only occur with one specific
database? Did you try it with sample database Foodmart?

Does the original partition exists in the restored cube? If so, if you
right click the partition->Process all partitions, is the original
partition processed?

I do not think it is a cab related issue though it can cause problems.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

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




--------------------
Quote:
From: %u <nospam (AT) nospam (DOT) com
Newsgroups: microsoft.public.sqlserver.olap
Subject: RE: Problem processing partition
Organization: XXX News Server
X-User-Real-E-Mail:
User-Agent: PHP News Reader v2.5.9 (CDSHEEN)
Mime-Version: 1.0
Content-Type: text/plain; charset="big5"
Content-Transfer-Encoding: 8bit
X-HTTP-Posting-Host: 192.168.2.18
References: <421aec8f$0$24429$626a14ce (AT) news (DOT) free.fr
eZHaWINGFHA.3112 (AT) TK2MSFTNGXA02 (DOT) phx.gbl
Date: 22 Feb 2005 15:01:00 GMT
Lines: 76
Message-ID: <421b492c$0$11963$626a14ce (AT) news (DOT) free.fr
NNTP-Posting-Date: 22 Feb 2005 16:01:00 MET
NNTP-Posting-Host: 82.235.108.67
X-Trace: 1109084460 news12-e.free.fr 11963 82.235.108.67:40516
X-Complaints-To: abuse (AT) proxad (DOT) net
Path:
TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFT NGXA03.phx.gbl!TK2MSFTNGP0
8.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!npeer.de.kpn-eurorings.net!
proxad.net!infeed-2.proxad.net!news12-e.free.fr!not-for-mail
Quote:
Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:57679
X-Tomcat-NG: microsoft.public.sqlserver.olap

== Quote from Peter Yang [MSFT] (petery (AT) online (DOT) microsoft.com)'s article
Hello,
I agree with you it is a weird issue. Can you reproduce the issue or
did it
only occur once?
Yes I can reproduce it, I reproduced it serveral times before posting
If you make the cube write-disabling, does the issue also
occur?
I tried this. I even deleted all data of the fact table who comes
from the writing process. And when I reprocess the cube it reads
only data from the writetable but no from the fact table.
It is realy strange.
If you re-processing the cube, does it many any change?
no
I was not able to reproduce the issue on my side currently. It seems
that
we may need more clues to troubleshoot the problem.
maybe the .cab ?
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
| From: %u <nospam (AT) nospam (DOT) com
| Newsgroups: microsoft.public.sqlserver.olap
| Subject: Problem processing partition
| Organization: XXX News Server
| X-User-Real-E-Mail:
| User-Agent: PHP News Reader v2.5.9 (CDSHEEN)
| Mime-Version: 1.0
| Content-Type: text/plain; charset="big5"
| Content-Transfer-Encoding: 8bit
| X-HTTP-Posting-Host: 192.168.2.18
| Date: 22 Feb 2005 08:25:51 GMT
| Lines: 26
| Message-ID: <421aec8f$0$24429$626a14ce (AT) news (DOT) free.fr
| NNTP-Posting-Date: 22 Feb 2005 09:25:51 MET
| NNTP-Posting-Host: 82.235.108.67
| X-Trace: 1109060751 news12-e.free.fr 24429 82.235.108.67:40229
| X-Complaints-To: abuse (AT) proxad (DOT) net
| Path:

TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSF TNGP08.phx.gbl!newsfeed00.

sul.t-online.de!t-online.de!newsfeed.icl.net!proxad.net!infeed-2.proxad.net!
news12-e.free.fr!not-for-mail
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:57665
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| Hello,
|
| I have a wired
| problem.
| I have a cube
| enabled in writing.
| It works good , then
| I archived it in a
| .cab
| and restore it in
| another computer.
| The restoration
| works fine but when
| I process the cube
| it process only the
| data of the table
| who store the
| writing data.
| Then I do not see
| the data of the
| master partition.
|
| Could someone help
| me please ?
|
| Thanks
|


Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top