Hi to everyone!

I got error code -2147467259 (Unspecified error), source: OLE DB provider
for Analysis Services 8.0 in following line of code:

Set oMember = oCube.GetSchemaObject(adObjectTypeMember,
oMember2.UniqueName).

oCube is valid ADOMD.CubeDef object, oMember2 is valid ADOMD.Member.
Machine is Win XP Pro with Pivot Table Services 2k.

Any idea?

This code was executed in heavy-duty procedure (a lot of queries, writebacks
and metadata objects) so maybe it is lack of memory on client?

Grzegorz

Hi Grzegorz,

I would like you to provide more information so that I can narrow this
problem down.

1. Is any Service Pack applied on the Analysis Services?

2. I would like you to provide the detailed error message? If it is
possible, could you provide the error message screen shot?

3. From your description, if this code executed in light-duty procedure,
does any error occur?
Also, if this code was executed in heavy-duty procedure, does the error
occur every time when you implement your codes?

I am standing by for your response.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Hi Grzegorz,

According to my experience, this problem is quite complex. I would suggest
that you open an incident with Microsoft Product Support Services via
http://support.microsoft.com/default...EN-US;CNTACTMS, so that
we can have dedicated engineer to assist you.

I would like to collect further information in addition to Michael Shao's.
1. Does "-2147467259 (Unspecified error)" always occur when you execute the
following code?
Set oMember = oCube.GetSchemaObject(adObjectTypeMember,
oMember2.UniqueName)

2. I understand that you have a program to execute the code. Is the program
the same computer as Analysis Services computer?

3. Is it OLAP 7.0 or Analysis Services 2000? Is it SP4 for OLAP 7.0 and SP3
for Analysis Services 2000?

4. What is the MDAC version of client computer and server computer?

5. Please post the system and application event log on both computers.

6. You mention that the problem happens in heavy-duty procedure. If you
only execute that problematic code in the program, does the problem happen?
If so, could you post the detailed code and error message so that I can
perform further research. With the current information, I am afraid that I
am unable to help further.


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------

Hi!

1. Error message was in polish language: "Nieokre¶lony b³±d" (Unspecified
error). Source was Microsoft OLE DB Provider for Analysis Services.
2. Computer: Windows XP Pro with SP1 (Polish version), installed evaluation
version of SQL Server 2000 and Analysis Services 2000 (120-day trial),
installed MDAC 2.7 SP1 (English version), installed PTSFull from Analysis
Services 2000 (full version, probably SP3) - maybe this is reason of the
problem. This computer connects to OLAP Server (Analysis Services 2000 SP3),
code which generates error is operating with this connection (it doesn't use
local OLAP server).
3. GetSchemaObject method was executed thousands times before error was
raised. I think there are some memory leaks, because user of the computer
told as about shortage of memory (machine slowed down, he couldn't run any
applications). I often use GetSchemaObject (eg. for getting ADOMD.Member
object from cellset's axis position object in order to read other member
properties).

By now I haven't so much information. Computer with problem works in our
client place and I have some difficulties with getting all of needed
informations. But I think a whole installation is wrong.

I'll try to get more information (event logs, data about process from Task
Manager: memory usage, GDI, User resources).

Thank you for your attention.

Grzegorz Stolecki, Poland

PS. Sorry for my English.

Hi Grzegorz,

I understand that you need time in obtaining the information I requested in
previous post. Please do post all of them.

In addition, you may check with the following when the problem occurs:
1. Can you use Analysis Manager on the client and server to administer the
Analysis Services computer? Does it have any problem when you operate it?
2. Check with MDX Sample Application. Can you connect it to Analysis
Services computer from client and server? Any similar problem encoutered
with its functionality?


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------

We solved problem by reinstalling whole system. We installed Windows 2000
and client only components of MSAS2K. Bill and Michael: thank you for your
attention. If you are interested I have some additional informations (eg.
event logs) from old installation.

Grzegorz Stolecki