BizTalk Server Tools - HAT Error - Automation server can't create object -

Author

HAT Error - Automation server can't create object -

skumar

2005-12-15, 5:58 pm

I have a Active/Active SQL cluster with Analysis services installed on both.
The BiztalkAnalsisDb , cubes has been processed and the BAM and all related
components have been installed on the Biztalk Application Host. When I try to
open the Service Metrics or Message Metrics from HAT I get the following
error Dialog

"Error Initializing Pivot Table Control
Automation server can't create object
You might have selected the wrong cube or the cube has not yet being
processed"

I have installed the same on my desktop and it is working fine. From my
desktop I can even view the analysis services from the cluster when I change
the preference on the HAT to point to the cluster.
We need this to work ASAP because of Time line issues.

Thanks

Sujith

--
sujith

WenJun Zhang[msft]

2005-12-16, 2:48 am

Hi Sujith,

Since same operation works on your desktop, looks like the cube data is
fine. My suggestion is you should use filemon & regmoon to to get a trace
when the error happens.

Here are the steps:

http://www.sysinternals.com/ntw2k/source/filemon.shtml

1) Launch filemon,stop capture and click filter on its toolbar.
Remove * and input: BTSHatApp.exe as the included string.

2) Change font if necessary(need restart filemon).

3) Start capture.

4) Reproduce the error

5) Stop capture and check the trace.

There may be FILE NOT FOUND or ACCESS DENIED errors indicating why the
error occurs. The steps of using regmon is similar.

If the problem has been very time-critical based on your product timeline,
a more effective way to get assistance is contacting our product support
service to open an incident. Each MSDN subscriber has 2 free incident
accounts. You can retrieve the phone number from the link below.

http://support.microsoft.com/defaul...US;PHONENUMBERS

Best regards,

WenJun Zhang
Microsoft Online Partner Support

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