>From our knowledgebase: Problem Remedy reports will not run if there is a semi-colon in the user password Solution The Remedy ODBC driver used to execute a Crystal Report from the Remedy application will consider a semi-colon to mark the end of the password, and only a partial password will be sent to either ARS or LDAP depending on where the authentication is going. Remove the semi-colon from the password to resolve this issue. Operational Application / Software/Remedy AR System User/Authentication Issues Application / Software/Remedy AR System User/Application Error Infrastructure - Servers/Remedy/Help Desk Application
Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Payne, George Sent: Friday, September 14, 2007 1:26 PM To: arslist@ARSLIST.ORG Subject: Re: Hey gang! ** Hey Ben, Good suggestion. Running a report directly from Crystal Report Designer does NOT cause problems. I'm prompted for the user's credentials in the ARSystem ODBC driver and it accepts them just fine. Does the ARSystem cache the user's password somewhere to use when running a Crystal Report? Gp George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED] _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore Sent: Friday, September 14, 2007 1:02 PM To: arslist@ARSLIST.ORG Subject: Re: Hey gang! ** If you have Crystal Report Designer, I'd bring up the report in crystal and run the report from there with the problematic user's credentials. See if the problem occurs there. Ben Cantatore Remedy Administrator Avon (914) 935-2946 "Payne, George" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 09/14/2007 01:36 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Hey gang! ** Ok...I'm a little buffaloed by this one, but I think I've nailed it down; at least a little bit: Server: 7.0.01 P02 on UNIX ITSM: 7.0 DB: Oracle 10g also on UNIX Users are usually authenticated with their Active Directory credentials when the AR System password is left blank. UserA is able to run Crystal Reports just fine and UserB gets an ARERROR 9014 using the same machine and the same client. The users have IDENTICAL security profiles within Remedy. What it comes down to is that UserB has a ";" in his password. The ";" passes authentication to the AR System just fine, but it causes an error running a Crystal Report. Is the password stored as a Global or Session Variable so that it can be supplied when needed by the Crystal Reports engine? I was able to reproduce this by entering a password directly into CTM:People with a ";" in the password. The user can login and do anything else they want to do in the system, EXCEPT run a Crystal Report. Is this a bug in Remedy or Crystal?? Thanks, Gp George Payne Corporate Applications Developer Electric Reliability Council of Texas (512) 248-3940 [EMAIL PROTECTED] __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
