RE: Problem processing partition
From: Peter Yang [MSFT] (petery_at_online.microsoft.com)
Date: 02/23/05
- Next message: Denise via SQLMonster.com: "Re: Basic ParallelPeriod question"
- Previous message: Burhan: "format error"
- In reply to: %u: "RE: Problem processing partition"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Feb 2005 06:29:25 GMT
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.
--------------------
| From: %u <nospam@nospam.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@news.free.fr>
<eZHaWINGFHA.3112@TK2MSFTNGXA02.phx.gbl>
| Date: 22 Feb 2005 15:01:00 GMT
| Lines: 76
| Message-ID: <421b492c$0$11963$626a14ce@news.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@proxad.net
| Path:
TK2MSFTNGXA02.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.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
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:57679
| X-Tomcat-NG: microsoft.public.sqlserver.olap
|
| == Quote from Peter Yang [MSFT] (petery@online.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@nospam.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@news.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@proxad.net
| > | Path:
| >
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.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
| > |
|
|
- Next message: Denise via SQLMonster.com: "Re: Basic ParallelPeriod question"
- Previous message: Burhan: "format error"
- In reply to: %u: "RE: Problem processing partition"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
