Troubleshooting Hyperion Enterprise Client Published with Citrix

Troubleshooting Hyperion Enterprise Client Published with Citrix
		Modified 31-JAN-2011     Type TROUBLESHOOTING

---

Applies to:

Hyperion Enterprise - Version: 5.0.1.0.00 to 6.5.1.0.00 - Release: 5.0 to 6.5
Information in this document applies to any platform.

Purpose

To aid in troubleshooting issues publishing Hyperion Enterprise with Citrix.

Last Review Date

May 21, 2010

Instructions for the Reader

Troubleshooting Details

Make sure that the application was installed using the “install mode” on the server.

1. Go to the server where application will be installed and published on Citrix.

2. Physically put the server into "Install Mode" by issuing the following from a 'cmd' window: 
 

DO NOT CLOSE this window; minimize it for now if you wish.

3. Install the application normally.

4. Back at the 'cmd' window, issue the following command: 
     

5. Close the command window.

6. Go to Citrix as normal and publish the application. 

Test with user-class and administrative accounts directly at the server.

This test will take the “published” aspect out of the equation and give insight as to whether this issue is related to the application being published with Citrix, or if it could be permissions or security policy related that could prevent the application from running correctly as a specific user.

Test directly on the server: 

1. Go directly to the Citrix server. 

2. Open the Citrix Metaframe Presentation Server Management Console. 

3. Click on Farm where the published application resides.

4. Find the Published application in question.

5. Right Click the published application - click Properties. 

6. Click on Application Location - look at Command Line to see where the actual executable is on the server. 

7. Close the Management Console. 

8. Go directly to the executable of the application in question to test locally on the Citrix server itself (not using the "published" application). 

9. Right click on the executable and click "run as". 

10. First test with the Administrator ID to test that the application itself is working properly. 
      This will show us if the issue is user specific or security related.

Check that “Memory Optimization” setting is turned off on the Hypent.exe file located in Hyperion Solutions\Hyperion Enterprise 

For Citrix Presentation server 4 and 4.5, the Memory Optimization exclusion list is located in the Presentation Server Console under the farm properties in the Memory Optimization section. 
It is best to configure the optimization to run daily at an off peak time. You can configure this in the Presentation Server Console under Farm properties > Memory Optimization. 

To exclude additional applications from memory optimization in Citrix XenApp: 

1. Depending on the version of XenApp you have installed, from the Start menu, select All Programs > Citrix > Management Consoles and choose Access Management Console or Delivery Services Console. 

2. In the left pane, select the farm on which you want to exclude additional applications from memory optimization. 

3. From the Action menu, select Modify farm properties > Modify all properties. 

4. In the Farm Properties dialog box, choose Farm-wide > Memory/CPU > Exclude Applications. The Exclude Applications page appears. This page lists the applications that memory optimization ignores.

5. Click Add. The Browse Files dialog box listing all servers in the farm appears. 

6. Navigate to the applications from each server that you would like memory optimization to ignore, clicking OK to add each executable to the Exclude Applications page. 

7. Click Apply to implement your changes and then OK to close the Farm Properties dialog box. 

If users do not see the Enterprise application at first log on:

For NEW users: (have not previously logged in via Citrix)

1. Create the database normally in a network directory accessible to the Citrix/Terminal server. 

2. Switch the Citrix/Terminal Server box to INSTALL mode – from cmd prompt 

3. While physically logged into Citrix/Terminal server, log into the Enterprise application, add the new database, open it and set all dimensions of the point of view. 

4. Log out of Enterprise. 

5. Switch Citrix/Terminal server back to EXECUTE mode – from cmd prompt 

6. As users log into Citrix/Terminal Server sessions the updated HYPENT.INI for Enterprise should copy to their individual home directories. 

For CURRENT users: (already have a HYPENT.INI in home directory)

 

1. From any user's Citrix/Terminal Server session, log into Enterprise, add the new database, open it, and set all dimensions of the point of view. 

2. Log out of Enterprise. This causes the HYPENT.INI (for Enterprise) file to be updated. 

3. Copy the updated HYPENT.INI file from the home directory of the user in step 1, to all other users' individual home directories. 

If Enterprise Retrieve is not working for some users.

It's possible that some users get the error “Cannot open HPAPP.DAT.” 

Setting up Hyperion Retrieve with user specific or multiple HPAPP.DAT files in a Citrix Environment.:

1.The admin must log in as the user and set up a user variable pointing to the path for the HPAPP.DAT to the user's home directory. The admin must set this up for each user and have the copy of the specific HPAPP.DAT in the users home directory. If a system environment variable has already been set up for the HPAPP.DAT, it would need to be removed since it will take precedence over a user variable that is set up. 

1. An HPAPP.DAT file with desired data application references needs to be created/copied for every user to his/her personal Metaframe home directory. 

2. Create a User Variable 

Go to -> Control Panel ->System ->Environment with the following attributes: 

Variable: HPAPP.DAT 

Value: drive\home directory path\HPAPP.DAT 

It may also be necessary to leave the default file location in Excel blank

 

Citrix Published Retrieve has different default file location

Citrix published version of Hyperion Enterprise Retrieve has a different Default file location then the one specified in the Tools / Options / General (TAB) / Default file location in Excel.

The use of Excel startup switch /p folder path\folder name when publishing the application will set the default file location to the specified folder in the startup switch. This switch will override the folder location shown in the Default file location in Excel.

An example of the issue:

Client's publishing Enterprise Retrieve with the following
"c:\Program Files\Microsoft Office\Office10\EXCEL.EXE" /p "c:\PROGRAM
FILES\Enterprise 651" "c:\PROGRAM FILES\Enterprise 651\RHXLL32.XLL"

You can remove this switch from the command line used to publish Retrieve in Citrix.

@ Note:
 This is a consolidated document made from the following articles which have now been removed:

References

NOTE:1128334.1 - Points to Consider when Installing Oracle's Hyperion Enterprise Release 6.5.1 on a Windows/Citrix 64-bit Platform
NOTE:580746.1 - Adding An Applications To Oracle's Hyperion Enterprise
NOTE:581499.1 - How To Set Up Hyperion Retrieve With User Specific Or Multiple HPAPP.DAT Files In A Citrix Environment.