Solved

Invalid Username and Password when accessing accounting system through Citrix.

Posted on 2009-06-29
5
740 Views
Last Modified: 2012-05-07
I am having a problem with particular users accessing our upgraded accounting system through Citrix.
Things that have changed since it was working correctly:
The only change on the Citrix Server was that I upgraded the Oracle ODBC DB Provider because I had upgraded the Oracle Database from 9i to 10g.
In addition to that change on the Citrix server, I have upgraded my database from Oracle 9i to 10g.  I have also put it on a brand new server which has been newly added to our domain.
The accounting application executables reside on the Citrix server and have not changed with this upgrade.  The database resides on the new db server.
The only difference from the user standpoint is that they have to type in a different database name to connect in the accounting system login.
The dilemma:
Every evening (at some point), these users access is eliminated.  
We cannot figure out what is making it quit working, and when.  There is nothing in the logs of the db server or the citrix server to give us a clue.  Nor can we figure out what is making it start working again when we log in.
The same log on script runs for ANY user connecting through citrix.
The fix, at this point, is for me to log into citrix (the same way these users do) and into the accounting system (the same as the users) and these users can then get in immediately.   Two steps are imperative to make this work again.  Someone other than those users has to log into Citrix AND anyone (even these users) can log into the accounting system.  Logging into citrix, alone, does not make it work.  It takes both steps.
I do not need to stay in the accounting system or logged into citrix for these users to continue working, all day.  They can log out; they can log in; they can shut down and reboot and go in and out of citrix and it just works fine  until the next morning.  This is not specific to this office either.  These same users have the same issue if they try to access citrix in the evening from home!  I also have the same issue with them if I try to log in as them.
Pretty bizarre&  Please help!
0
Comment
Question by:LATA2008
  • 2
5 Comments
 
LVL 6

Expert Comment

by:Jacob78
ID: 24740482
That is very odd. Does this accouting system run on a single citrix server, or multiple citrix servers?
0
 

Author Comment

by:LATA2008
ID: 24740623
The accounting system executables sits on the citrix server and also the database server.  The people who are local run the executables from the database server.  The people who use citrix run the executables from the citrix server.  They all connect to the same database on the same database server.  So, we have an oracle database on a server and we have Costpoint executables on that server and also on the Citrix server (just a copy of the same executables).  
0
 

Author Comment

by:LATA2008
ID: 24755669
I added Domain users to the local Administrators on the Citrix box nad now they don't have the login issue.

I cannot figure out WHY I have to do that and I want to get them out of there.

Patricia
0
 

Accepted Solution

by:
ee_auto earned 0 total points
ID: 24958740
Question PAQ'd, 500 points refunded, and stored in the solution database.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
sql query 9 38
Bash Script to Analyze Oracle Schemas 11 84
'G_F01' is not a procedure or is undefined 3 12
PL/SQL Display based on value 4 20
Citrix XenDesktop, gold image, VMware, vSphere.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now