Running Analysis 2000 sp3a & SQL Server 2000 sp3a developer versions on local
machine.

When entering the cube wizard thorough the Analysis Manager application and
straight after the first stage of selecting a fact table the Analysis Manager
application will crash to desktop with no error message reported in any
sql/analysis server log files, no error message from the Application and no
information with the event log. The error also happens when using the cube
editor to add a dimension to an empty cube.

I am able to browse/process/edit any cube so long as I do not use the method
above.

The error happens in any database and with any cube.

I have tried the following with no change in the problem. They are in no
particular order as I have tried the all many different times.

1. Reinstalled Analysis Services
2. Reinstalled service pack 3a for SQL and AS.
3. Tried both Access and SQL repositorys.
4. Tried hotfix olapqfe808.exe
5. Monitored the bug using sysinternals tools - REGMON, FILEMON and
PROCESSMON with no apparent or easy to understand error message or problem
dll.
6. Searched Microsoft Support with no comparable knowledge base article
7. Searched Newsgroups.
8. Reset all Analysis Services defaults
9. Changed location of data and temp directories.
10. Deleted all AS objects and restored archived versions.

I am hoping there is a hotfix to deal with this problem.

The only mildy similar problem reported on MS support is this which
describes the analysis manager disappering.

http://support.microsoft.com/default...b;en-us;311873

To progress my work I have been using the DSO/XML scripter tool and manually
writing the XML to create cubes/dimensions - as you can imagine this is
tiresome and does not really address the problem.

Thanks for your help

What kind of hardware are you running on?
TabletPC?
--
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.

"sqlman" <sqlman (AT) community (DOT) nospam> wrote

thanks for quick response Dave.

Yes TabletPC, Themes turned off, SP1 all autoupdates except SP2. It has
worked perfectly for months.



"Dave Wickert [MSFT]" wrote:

Yes, but there is a known bug with the cube editor and the TabletPC that you
are running into. If memory serves me right, it had to do with some legacy
VB code which was needed by the cube editor for it's UI, but the TabletPC
didn't port. Hopefully there is someone from PSS listening on this thread
who could comment. You might try coming into the box via a route where the
tablet functions are disabled, e.g. by term serving into yourself, using
Virtual PC, etc. I know that isn't the answer you were hoping for . . .
sorry.
--
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.

"sqlman" <sqlman (AT) community (DOT) nospam> wrote

Amazing really how bad the AS Manager is, having used the Yukon interface
its so hard to go back.

Shortly after reading your post I processed a prety large cube and acctually
got an AV - the culprit was tabtip.exe. I have sent the bug report through
the online reporting tool

After tabtip had AV'd I tried the cube wizard and all is working ! I am not
even using tablet features when I am working with SQL/AS on the tablet so its
no problem anymore although it obviously should be looked at. Shall I post
the error report here as well?

Thanks for your help



"Dave Wickert [MSFT]" wrote:

Hi,

As Dave had said, it is an known issue for us. Research reveals that this
is a known issue Visual Studio 98 RAD with any application that uses a
WinEvent hook and uses omctl32.ocx.

The problem is in the ComCtl32.ocx which is no longer supported. If the
mscomctl.ocx (Windows Common Controls 6.0) are used then the problem does
not occur.

I hope the hotfix in following document will contribute you more in this
issue, asking a hotfix from PSS will be a free case.

FIX: Access Violation in Comctl32.ocx on Windows 2000 or Later
http://support.microsoft.com/?id=827217

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Mingqing,

Thank you for your post and the included link. Unless I am missing
something, the link to the hotfix in article 827217 does not include any
download. It recommends we call MSFT. Do we need to, or is there another
place from which we can download the hotfix?

Thanks,

JDG.

""Mingqing Cheng [MSFT]"" wrote:

Hi JDG,

Thanks for your post.

I wanted to let you know that hotfixes are generally available for specific
issues in the Product. Please keep in mind that they are not fully
regression tested and should be applied only to systems experiencing the
specific problem. For this reason, the first step would be to verify if you
are indeed running into the problem addressed in a specific hotfix. The
individual sending of hotfixes must be tracked by Microsoft for reasons
such as: you may run into problems after installing the fix, when future
updates to the hotfix occur we want to be able to notify you. For these
reasons and others, many hotfixes are only available to customers if they
call into the appropriate Microsoft Support phone line, and receive direct
help and advice from a Microsoft support professional. We are not equipped
to send out and track hotfixes here in the Newsgroups forum.

If you prefer, you could contact Microsoft Product Support Services
directly to obtain the fix. For a complete list of Microsoft Product
Support Services phone numbers and information about support costs, visit
the following Microsoft Web site:

http://support.microsoft.com/default...EN-US;CNTACTMS

NOTE: In special cases, charges that are ordinarily incurred for support
calls may be canceled if a Microsoft Support Professional determines that a
specific update will resolve your problem. The typical support costs will
apply to additional support questions and issues that do not qualify for
the specific update in question.

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Hi JDG,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. Have you
contacted PSS opening a free case asking hotfix? Does that hotfix make
sense? If not, I would love to continuing troubleshooting this issue with
you until it is resolved.

If there is anything I could do to help you, please feel free to let me
know. We appreciate your patience and look forward to hearing from you!



Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!