Solved

Invalid Username and Password when accessing accounting system through Citrix.

Posted on 2009-06-29
5
741 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can I rollback insert statements after commit in oracle? 7 133
database upgrade 8 74
Include a logo in email body using Oracle utl_mail 11 30
pl/sql - query very slow 26 60
#Citrix #Internet Explorer #Enterprise Mode #IE 11 #IE 8
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

772 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