Analysis Manager Error

I've been getting the following error message whenever I
try to connect to my remote server to work on some cubes.
"Cannot open connection to Analysis server 'WRPBI'
Error in data [possible data corruption]"
How can I fix it? I've reinstalled Analysis Manager but
it didn't help.
Thanks
Hi sacred,
You should apply SP3 for Analysis Services to the Analysis Services server.
If you are unable to upgrade the Analysis Services server to SP3, you can
also restore connectivity to the Analysis Server by replacing the
MSOLAP80.DLL,
MSOLAP80.RLL, MSMDGD80.DLL and MSMDCB80.DLL files on the client machine
with a
version equal to or less than the build number of your MSMDSRV.EXE
<><><><><><><><><><><><><><><><><><><><><><><><>
| Content-Class: urn:content-classes:message
| From: "sacred" <sacred21@.airpost.net>
| Sender: "sacred" <sacred21@.airpost.net>
| Subject: Analysis Manager Error
| Date: Wed, 29 Dec 2004 18:07:15 -0800
| Lines: 12
| Message-ID: <05dc01c4ee14$4852d080$a401280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcTuFEhSQNjxLD0AQgyujxk4ZUZu2w==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.clients
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clients:29328
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.clients
|
| I've been getting the following error message whenever I
| try to connect to my remote server to work on some cubes.
|
| "Cannot open connection to Analysis server 'WRPBI'
| Error in data [possible data corruption]"
|
| How can I fix it? I've reinstalled Analysis Manager but
| it didn't help.
|
| Thanks
|
|
|
<><><><><><><><><><><><><><><><><><><><><><><><>
Yasemin Gunduz
Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.

An Full-Text Catalog Item Count of 0?

Hi,
I've enabled a full-text index on a table having 77 thousand records on a
varchar(50) column. And yet when I when I populate the catalog:
exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
I get an item count,
SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
of 0.
This column has data 95% of the time. What am I missing?
Thank you.
--
Mark Holahan
Check the event log and the gatherer logs for messages:
It is likely you are running into one of the errors in these kb articles
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
news:Ogx2wObHFHA.2860@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've enabled a full-text index on a table having 77 thousand records on a
> varchar(50) column. And yet when I when I populate the catalog:
> exec sp_fulltext_catalog 'OrdersCatalog', 'start_full'
> I get an item count,
> SELECT fulltextcatalogproperty('OrdersCatalog', 'ItemCount'),
> of 0.
> This column has data 95% of the time. What am I missing?
> Thank you.
> --
> --
> Mark Holahan
>
|||Bull's eye! Thanks.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ek2TowbHFHA.3880@.TK2MSFTNGP10.phx.gbl...
> Check the event log and the gatherer logs for messages:
> It is likely you are running into one of the errors in these kb articles
> http://support.microsoft.com/default...b;en-us;295034
> http://support.microsoft.com/default...b;en-us;317746
> http://support.microsoft.com/default...b;en-us;295772
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mark Holahan" <mark.holahan@.unifiedllc.com> wrote in message
> news:Ogx2wObHFHA.2860@.TK2MSFTNGP12.phx.gbl...
>
|||Hi Hilary,
I have had a similar problem with the Full-text Catalog Item Count of 0,
after I enable some Full-text Indexing from 4 tables. I can view the
table names on the Full-text Catalog, but when double-clicked the
Catalog, the propereties page showed an Item Count of 0.
Because we are developing a back-end database for a SharePoint Services
server, based on the information from the SharePoint Administration
guide, we needed to use Domain Account, instead of the local System
account, after we saw the Item Count of 0 for our first try.
The big question is after we set up the domain account, the Item Count
was still zero.
Is something wrong with the Full-text Search configuration, or on the
SharePoint Service server?
Thanks,
Jeffrey
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||Is MSSearch running under the local system account? It must be for this to
work.
Are there any error or warning messages in the application log from MSSearch
or MSSCi?
You might want to consult these kb article for more information on resolving
the typical problems you get this MSSearch and SQL Server.
http://support.microsoft.com/default...b;en-us;295034
http://support.microsoft.com/default...b;en-us;317746
http://support.microsoft.com/default...b;en-us;295772
"Jeffrey Wang" <cjeffwang@.gmail.com> wrote in message
news:ug43i2TIFHA.2924@.TK2MSFTNGP15.phx.gbl...
> Hi Hilary,
> I have had a similar problem with the Full-text Catalog Item Count of 0,
> after I enable some Full-text Indexing from 4 tables. I can view the
> table names on the Full-text Catalog, but when double-clicked the
> Catalog, the propereties page showed an Item Count of 0.
> Because we are developing a back-end database for a SharePoint Services
> server, based on the information from the SharePoint Administration
> guide, we needed to use Domain Account, instead of the local System
> account, after we saw the Item Count of 0 for our first try.
> The big question is after we set up the domain account, the Item Count
> was still zero.
> Is something wrong with the Full-text Search configuration, or on the
> SharePoint Service server?
> Thanks,
> Jeffrey
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!

Alternatives to SQL FTS.

I've been using FTS for 5 years now on 1.5million rows of data. Certain
things have alway annoyed me about it however:
1. I never managed to succesfully move/copy ft catalogs.
2. Noise words/symbols/single characters e.g. c#, c#, "I am not".
3. Search speed and ranking/relevance quality.
3. Population performance.
I know by constantly staying on top of the excellent advice in this forum I
can probably overcome these issues, but frankly I'm not sure I want to take
this route. Not at least before I've explored the alternatives. So my
question is what alternative products would anyone recommend taking a look at
? The ft queries would be made from a C#/.Net/ASP/NET app, and I don't mind
if the text records are stored in a database or maybe an XML file.
I haven't looked at Yukon yet - so that may well be a valid answer.
Any takers ?
I would have a look at Yukon for the following reasons
1) you can now a) detatch and reattach full text catalogs with the database
files
b) your full text catalogs can be backed up with
your back and restored. This is the default behavior
c) you can replicate full text indexes as long as
your subscriber database is full text enabled
2) by default c and j are indexed if they are preceeded by a ++ or a #. SQL
2005 (Yukon) can be made to be noise insensitive - ie your queries will not
break with a noise word
3) Search preformance is greatly improved. The ranking algorithm yeilds
different results but is much the same.
4) radical improvements in indexing performance.
There are other options out there - like SQL Turbo
(http://www.imceda.com/SQLTurbo_Description.htm) and omnidex
(http://www.disc.com/).
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"slartyb" <slartyb@.discussions.microsoft.com> wrote in message
news:6532CD01-5506-4B51-AF94-7E2D6C65740E@.microsoft.com...
> I've been using FTS for 5 years now on 1.5million rows of data. Certain
> things have alway annoyed me about it however:
> 1. I never managed to succesfully move/copy ft catalogs.
> 2. Noise words/symbols/single characters e.g. c#, c#, "I am not".
> 3. Search speed and ranking/relevance quality.
> 3. Population performance.
> I know by constantly staying on top of the excellent advice in this forum
I
> can probably overcome these issues, but frankly I'm not sure I want to
take
> this route. Not at least before I've explored the alternatives. So my
> question is what alternative products would anyone recommend taking a look
at
> ? The ft queries would be made from a C#/.Net/ASP/NET app, and I don't
mind
> if the text records are stored in a database or maybe an XML file.
> I haven't looked at Yukon yet - so that may well be a valid answer.
> Any takers ?
>

Alternative to Microsoft Enterprise Manager?

I can't use Enterprise Manager - I've got a cable connection and Comcast
blocks port 1061 which EM uses.
Anyone know a browser-based alternative to EM (preferably written in ASP)?
Thanks!
-Bill.
You could try the SQL Server Web Data Administrator. It's
available at:
http://www.microsoft.com/downloads/d...displaylang=en
Other alternatives are listed in this article:
http://www.aspfaq.com/show.asp?id=2442
-Sue
On Tue, 15 Mar 2005 15:18:33 -0500, "Victor"
<blank@.blank.com> wrote:

>I can't use Enterprise Manager - I've got a cable connection and Comcast
>blocks port 1061 which EM uses.
>Anyone know a browser-based alternative to EM (preferably written in ASP)?
>Thanks!
>-Bill.
>