Occasionally a user will close a P6 application and the user’s session does not just go away. The easiest thing I’ve found is to check to see if there are hung sessions in the usession table (in Oracle – other database types may use a different name). This is the type of error you might see:
Look for hung sessions by running the following query, plugging the actual username into ‘Username’:
SELECT * FROM usession WHERE user_id = (
SELECT user_id FROM users WHERE user_name = 'Username');
If any are present, run this query:
DELETE FROM usession WHERE user_id = (
SELECT user_id FROM users WHERE user_name = 'Username');
COMMIT;
The user should again be able to log into P6 at this point.
Just a quick note here. If you are running ColdFusion and you know that your bindings are set up correctly, but web requests being sent to the default root of websites on your server other than the intended one, it it highly likely that the “Cache web server paths” option was mistakenly (or unwittingly) set, causing all manner of havoc in directing among multiple sites.
Turn it off, restart the ColdFusion Application Server service, and enjoy proper web routing once again!
After downloading a new version of Citrix Receiver and installing it, I discovered that the single sign-on (SSO) functionality that used to “just work”, had stopped working.
After hunting through the Local Group Policy Editor, the registry, and the folder in which Citrix was installed, I was able to put together the following instructions. Completing these steps fixed my problem, however, the fole locations may vary somewhat depending on how your Windows and Citrix installations are configured.
Note: The person executing these steps will need local admin rights on the PC.
Add the following site(s) to the Local Intranet zone in Internet Options. (These will be specific to your organization.)
http://yourcitrixwebportal.com
https://yourcitrixwebportal.com
In Internet Explorer, go to Tools –> Internet options. On the Security tab, click “Local intranet” in the “Select a zone…” area.
Click the Sites button, and on the next dialog box, click the Advanced button.
Add each site above by pasting or typing the URL into the “Add this website…” field and click the Add button for each one. The checkbox requiring HTTPS should be unchecked.
Click Close, OK.
Click the Advanced tab on the Internet Options box. Make sure the “Enable Integrated Windows Authentication” checkbox is checked. If not, check it. (You will also need to reboot the PC if this setting is changed after closing Internet Options.)
Click OK to close Internet Options.
Copy files from the Citrix Receiver client into the appropriate Windows folder to enable Citrix Group Policies.
Copy CitrixBase.admx and receiver.admx from “C:\Program Files (x86)\Citrix\ICA Client\Configuration” to “C:\Windows\PolicyDefinitions”
Copy CitrixBase.adml and receiver.adml from “C:\Program Files (x86)\Citrix\ICA Client\Configuration\en-US” to “C:\Windows\PolicyDefinitions\en-US”
Click Start –> Run –> type gpedit.msc in the search field and hit Enter to open the Local Group Policy Editor. Find the “User authentication” folder in the left pane under Local Computer Policy –> Computer Configuration –> Administrative Templates –> Citrix Components –> Citrix Receiver. Click “User authentication” to display its settings in the right pane. In the right pane, double click “Local user name and password”. Click the Enabled radio button, and make sure that the “Enable pass-through authentication” and “Allow pass-through authentication for all ICA connections” checkboxes are checked. Click OK to close the “Local user name and password” settings box. Close the Local Group Policy Editor.
Reboot the PC.
When opening the Citrix app you may see a box asking to Permit or Block access to local resources. Check the checkbox and select Permit.
