Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Server execution failed

Author  Topic 

cmdurian
Starting Member

4 Posts

Posted - 2008-10-09 : 16:01:54
I received this error today when attempting to create a new application in Hyperion Financial Managment. It was followed by "could not connect to any server in the specified cluster." There were no errors previously and I have changed none of the settings. Does anyone know what could be causing this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-09 : 16:04:32
Are you using SQL Server?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

cmdurian
Starting Member

4 Posts

Posted - 2008-10-09 : 16:08:14
Yes. 2000.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-09 : 16:13:57
Could you post the entire text of the error? I have a feeling that this is a Hyperion error rather than a SQL error.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

cmdurian
Starting Member

4 Posts

Posted - 2008-10-09 : 16:50:37
Here is the error:

Error Reference Number: {C64ECD08-178E-41F3-85A0-17A2D9C48EB7}
Num: 0x80080005;Type: 1;DTime: 10/9/2008 4:46:51 PM;Svr: FINIT33;File: CHsxClient.cpp;Line: 1073;Ver: 4.0.2.0.967;
Num: 0x80041142;Type: 1;DTime: 10/9/2008 4:46:51 PM;Svr: FINIT33;File: CHsxClient.cpp;Line: 746;Ver: 4.0.2.0.967;
Num: 0x80041142;Type: 0;DTime: 10/9/2008 4:46:51 PM;Svr: FINIT33;File: CHsxClient.cpp;Line: 2764;Ver: 4.0.2.0.967

Is there a way for me to test whether this is a Hyperion problem or a SQL problem?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-09 : 17:40:57
Yes you can run SQL Profiler with the Exception event added to the trace and perhaps the RPC:Completed event. Once you've started the trace, make the error happen from the application. Then stop the trace and scroll to see if the exception is in there. If it isn't, then the error isn't happening inside SQL Server but rather from the application code.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

cmdurian
Starting Member

4 Posts

Posted - 2008-10-14 : 09:30:38
It turned out to be an HFM issue. Thank you so much for your help.
Go to Top of Page
   

- Advertisement -