Re: Crystal Report Error
Mikhail: That may be at least part of the issue. The ODBC settings on the client must include the name of a server to connect to (AR Server) and a login that has at least "Read" permissions to the data being retrieved (i.e., a User form Login Name that can read the forms in the reports). I have a special user account set up in the User form just for ODBC access to Crystal Reports. It has a Restricted Read license and belongs to a Remedy Group that can read most forms. HTH, Michael W. Luttmann Senior Database Administrator [EMAIL PROTECTED] 719-554-2462 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mikhail Sent: Friday, March 16, 2007 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: Crystal Report Error Hi Susan and Michael, Thank you for your inputs. The crystal report resides in a network location. And yes, it is associated with an active link. We've already done the method you suggested, yet we still get the same error. After I reloaded everything, I didn't check the ODBC configuration because I don't know what goes in there. I just checked it now. This is what I have in my ODBC configuration: I went to Control Panel > Administrative Tools > Data Sources (ODBC) Under the User DSN tab, i chose "AR System ODBC Data Source" and clicked "Configure.." All that is setup is the "Data Source Name" which is set to "AR System ODBC Data Source". The rest of the fields are blank. On Mar 16, 12:14 pm, "Luttmann, Michael W Ctr 21 SCS/SCBBN" <[EMAIL PROTECTED]> wrote: > Sounds like a problem with the ODBC configuration on the client. I'd > start checking there. > > Michael W. Luttmann > Senior Database Administrator > [EMAIL PROTECTED] > > > > -Original Message- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Mikhail > Sent: Friday, March 16, 2007 9:45 AM > To: [EMAIL PROTECTED] > Subject: Re: Crystal Report Error > > I'm working with Derek on this problem. We tried recreating this > problem on someone else's computer, and it worked just fine. Now with > that given, along with the error stating "An error occurred while > generating the Crystal report - Logon failed. (ARERR 1904).", tells me > that the problem must be in the client-side, probably some iffy dll's > or something. I tried uninstalling EVERYTHING on my computer that is > related to Remedy (user, admin, migrator, alert), then reinstalled > everything again (v7.0.01 patch 001), but I still get that error. > Any thoughts? > > Thank you, > Mikhail > > On Mar 5, 1:23 pm, Derek Fernandes <[EMAIL PROTECTED]> wrote: > > Hi listers, > > > We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk > 4.03. > > We have a couple of Crystal Reports that were working on ARS 6.3. Now, > > when we push the button to print the report we get the following > error: > > > An error occurred while generating the Crystal report: 0x80047e48 - > > Logon failed. (ARERR1904) > > > I have installed the latest version of the User Tool and checked the > > active link that generates the report, and made sure on the Report > > Information tab: > > Report Type = Crystal > > Location = Embedded > > Name = \\reportname.rpt > > Destination = Printer > > > Any help would be greatly appreciated. > > > Derek > > > -- > > Derek Fernandes > > Programmer Analyst > > U of C Information Technologies > > ES 1010, University of Calgary > > Calgary, Alberta T2N 1N4 > > 403.210.9879 > > > ___- > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where > the Answers Are" > > > ___ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where > the Answers Are" > > ___- > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are"- Hide quoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Crystal Report Error
Sounds like a problem with the ODBC configuration on the client. I'd start checking there. Michael W. Luttmann Senior Database Administrator [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mikhail Sent: Friday, March 16, 2007 9:45 AM To: arslist@ARSLIST.ORG Subject: Re: Crystal Report Error I'm working with Derek on this problem. We tried recreating this problem on someone else's computer, and it worked just fine. Now with that given, along with the error stating "An error occurred while generating the Crystal report - Logon failed. (ARERR 1904).", tells me that the problem must be in the client-side, probably some iffy dll's or something. I tried uninstalling EVERYTHING on my computer that is related to Remedy (user, admin, migrator, alert), then reinstalled everything again (v7.0.01 patch 001), but I still get that error. Any thoughts? Thank you, Mikhail On Mar 5, 1:23 pm, Derek Fernandes <[EMAIL PROTECTED]> wrote: > Hi listers, > > We just moved to ARS 7.0.1 patch 1 but we are still using HelpDesk 4.03. > We have a couple of Crystal Reports that were working on ARS 6.3. Now, > when we push the button to print the report we get the following error: > > An error occurred while generating the Crystal report: 0x80047e48 - > Logon failed. (ARERR1904) > > I have installed the latest version of the User Tool and checked the > active link that generates the report, and made sure on the Report > Information tab: > Report Type = Crystal > Location = Embedded > Name = \\reportname.rpt > Destination = Printer > > Any help would be greatly appreciated. > > Derek > > -- > Derek Fernandes > Programmer Analyst > U of C Information Technologies > ES 1010, University of Calgary > Calgary, Alberta T2N 1N4 > 403.210.9879 > > ___- > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Email Notifications not working
I would check with your Exchange administrator(s) and make sure that the
Exchange Server is configured to ACCEPT incoming connections via SMTP.
It is disabled by default, I believe.
Michael W. Luttmann
Senior Database Administrator
[EMAIL PROTECTED]
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Remedy Developer
Sent: Saturday, January 20, 2007 10:41 AM
To: arslist@ARSLIST.ORG
Subject: Re: Email Notifications not working
**
Hey Carey,
Thanks for the info. I would surely look into the same.
Rgds,
Frank
On 1/20/07, Carey Matthew Black <[EMAIL PROTECTED]> wrote:
Frank,
Hum... based on the limited info you provided I am not sure
where the
break down is. But here is some information that might help you
figure
it out based on the rest of the data you see in the logs.
( I am only talking about outbound email here. )
What the Email Engine does is login to the ARS sever (using the
application password) and get the Email Config info. Assuming
that
works then it should be able to also read data from the AR
System
Email Messages form. It will use the Email Config info to "do
the
right thing" with messages that are waiting to be sent. ('Send
Message' = "Yes")
If the Email Engine is getting this far and failing to connect
to the
SMTP server then I think you will only see errors in the email
engine
logs. (But you might also see AR System Email Error Log form
entries
too.)
ON the other hand
If the Email Engine is unable to talk to the ARS server (via the
application password) then it will not even be able to read the
Email
Config form or the "AR System Email Messages" form.
So if that Authentication error is specific to the SMTP server,
then
you likely need to fix the data in the MailBox Config form. (or
maybe
your NT Account has been locked/disabled/password changed?)
If the Authentication error is specific to the Email Engine
login to
ARS, then you need to updates is "application password" in it's
config
file. (See the docs for details.)
HTH.
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Love, then teach
Solution = People + Process + Tools
Fast, Accurate, Cheap Pick two.
On 1/20/07, Remedy Developer < [EMAIL PROTECTED]
> wrote:
> **
> Hi Fred,
> My emaild.sh_log contains "Authentication
failure-Severe". What I would
> like to know first of all is that do we have to specify User
name and
> password in Email Config form for Solaris.
>
> Rgds.,
> Frank
>
> On 1/18/07, Grooms, Frederick W <[EMAIL PROTECTED]>
wrote:
> > **
> >
> > What does your emaild.sh_log have in it? (Usually located
in engine install dir>/Logs )
> >
> > Fred
> >
> >
> From: Action Request System discussion list(ARSList)
> [mailto:arslist@ARSLIST.ORG ] On Behalf Of Remedy Developer
> > Sent: Thursday, January 18, 2007 11:04 AM
> > To: arslist@ARSLIST.ORG
> > Subject: Email Notifications not working
> >
> > Hi All,
> > My environment is as follows:
> > ARS 6.3 server patch 18 installed on Sun Solaris 5.9 with
Oracle 9i
> database and Email Engine 6.3. My exchange server is Microsoft
Exchange and
> for outgoing the protocol is SMTP relay with outgoing port as
25. I do not
> have SSL enabled.
> > I am providing the username and password of the user that I
am trying to
> send the email to in Email configuration form and I have the
same user
> configured in my User form with the same Email Address.
> >
> > My Email configuration form is configured correctly and when
I try sending
> email from Email Messages form, it says "Yes" instead of
"Sent". I do not
> have any clue as to why the notification is not going. Kindly
help.
> >
> > Rgds.,
> > Frank
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
ARSlist:"Where the Answers Are"
__20060125___This posting was submitted with HTML in
it___
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
Re: ARS Admin Tool 7.02 (Error writing registry values) ARERR 2815
We have gotten around this. If your network makes you use a non-admin account (an account without local admin rights) for regular work, like ours, then launch the Admin Tool using "Run as..." and select an account with local admin rights. You only need to do this once, and then you can work normally after that. Still not sure which registry entries need to be written, but at least it doesn't yell at us any more. Michael W. Luttmann Senior Database Administrator [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Tuesday, November 28, 2006 8:20 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Admin Tool 7.02 (Error writing registry values) ARERR 2815 ** I have not found a fix, Did not put in a ticket.. I figured it was just me.. it seems not to hurt anything.. But I believe it is a SDC configuration that prevents it from writing to the registry. I have not had any issues, except it does come up everytime. I am not planning on logging a ticket, as I just don't have the time.. if the admintool did not work.. I would. On 11/28/06, Luttmann, Michael W Ctr 21 SCS/SCBBN <[EMAIL PROTECTED]> wrote: ** I searched the archives looking for a thread that addresses the subject problem. I found one that was originally posted in August by Patrick Zandi. I also have a DoD system and after upgrade to the 7.0 Admin Tool we (my co-worker and I) are both getting ARERR 2815 when logging in to the Admin Tool. Was there ever a resolution on this? There was no follow-up or resolution that I could fi nd in the archive. Michael W. Luttmann Senior Database Administrator [EMAIL PROTECTED] __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
ARS Admin Tool 7.02 (Error writing registry values) ARERR 2815
I searched the archives looking for a thread that addresses the subject problem. I found one that was originally posted in August by Patrick Zandi. I also have a DoD system and after upgrade to the 7.0 Admin Tool we (my co-worker and I) are both getting ARERR 2815 when logging in to the Admin Tool. Was there ever a resolution on this? There was no follow-up or resolution that I could find in the archive. Michael W. Luttmann Senior Database Administrator [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Active Directory Administration from Remedy
We do fairly extensive personnel management by pushing and pulling info to and from Active Directory using the LDAP vendor forms. We even do account creation and disabling that way now, through our (customized) personnel management form. We have set up our ARDBC LDAP form to use a domain account with admin privileges in AD, then I created filters that modify the vendor form data as values are changed in Remedy. The implicit SAVE action from the filter writes the data to AD. I've only had one issue with it, when I tried to modify two values in one filter and it caused the LDAP thread to lock up. While debugging, I split the action into two separate filters (to see which value was causing the problem), and it all cleared up. I'll be happy to provide more detail if you have specific questions. Mike Luttmann Senior Database Engineer [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, November 13, 2006 7:30 AM To: arslist@ARSLIST.ORG Subject: Re: Active Directory Administration from Remedy Chris, I have not yet set out on this path, but I see it in my future too. >From the little work I have done playing with the idea I think one option might be to turn to a command line interface. (Especially if your ARS server runs on a Windows Server.) AD appears to have some command line tools that might make this type of thing fairly easy to to. I would think that if you have to build a Web Service front end to AD that you would have much more initial work to do and likely more ongoing work than using Microsoft supplied command line interfaces. I did stumble into this info and found it quite eye opening on this topic to. ( http://www.intel.com/it/pdf/active-directory.pdf ) Please let us (or at least me) know what you end up doing. :) I am sure there are others out there that would like to let ARS manage their AD universe(s) too. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 11/10/06, Chris Abell <[EMAIL PROTECTED]> wrote: > Hi all > > I've been tasked with creating a Remedy front end that will be used to > administer accounts and security groups in Active Directory. > > We're using a few different LDAP vendor forms for part of this project but > this won't meet all of our data requirements, so WebServices appear to be > the most logical next step. > > What I'd like to know is: > > Has anyone else attempted this kind of project? If so, how did you go > about it (in terms of products/protocols)? > > What kind of things should I be looking out for? (interpreting/updating > the userAccountControl attribute being an example of something that won't > be entirely straighforward) > > Thanks > > Chris ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Remedy ARS connectivity to Magic (UNCLASSIFIED)
** We played around with this for a while, and we were able to connect to the Magic system via SQL tables and procedures, since both our systems were on MS-SQL. With the proper SQL-level login connections, the data we needed from the Magic system was pushed to a custom table on our SQL server, then we were able to view and apply workflow to this table with a View form. HTH, Mike Luttmann Senior Database Engineer [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank, Gordon M Mr NISO/Lockheed Martin Sent: Wednesday, October 18, 2006 6:35 AM To: arslist@ARSLIST.ORG Subject: Remedy ARS connectivity to Magic (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Hello all, I have never worked with Magic and was wondering if someone has interfaced Remedy ARS with Magic. Is this feasible? Does it make sense? What would be the gains of this type of configuration? Just looking for some experienced info on Magic Thanks up front, Gordon Frank US Army/Lockheed Martin Classification: UNCLASSIFIED Caveats: NONE __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Remedy Disaster Recovery Solutions
** I’ve received several requests for this already… and I will forward my procedures to all who asked. That said, our solution is very similar to some of the previous posts: - Use log shipping if possible. (We don’t have SQL Enterprise, but I have configured off-site backups using the SQL Agent and a custom Backup device.) - Use (or get) Hot Backup licenses from BMC. It just requires that you fill out an agreement form that you will not abuse them. - Know how to set up MS SQL Maintenance Plans to do full backups and transaction logs (ours run every 30 min.) - Know how to use MS SQL restore processes, including the restoring of transaction logs. - Database replication is the fastest way to maintain a backup, but may prevent you from using the target server for development. (We have limited hardware resources.) - Coordinate with your Sys Admins to have tape backups made from your database backup directory. That way, you’ll be able to go back as far as you want to. The only thing about my written procedure is that it’s… written. The Air Force requires contractors like me to have such procedures updated and posted. Mike Luttmann Senior Database Engineer [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Luttmann, Michael W Ctr 21 SCS/SCBBN Sent: Tuesday, September 26, 2006 10:09 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy Disaster Recovery Solutions I just went through this process on Friday, when the RAID controller on my production server failed catastrophically (is there any other way?). If you need a comprehensive document, let me know and I’ll send you what I have (Bonus: it was just tested and updated with lessons learned!) Possible drawback: we are on Windows 2003 Server and MS SQL Database. Cheers, Mike Luttmann Senior Database Engineer [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marino, Melanie A Sent: Friday, September 22, 2006 9:47 AM To: arslist@ARSLIST.ORG Subject: Remedy Disaster Recovery Solutions Can anyone share with me what their company is using for Remedy Disaster Recovery? We are looking to replicate our Remedy production environment to another site in real-time and switch back and forth between the servers as needed. We are trying to determine the best solution. We are running on a Solaris machine and an Oracle DB. Your help would be greatly appreciated. Thanks, Melanie Marino Project Manager KPMG LLP [EMAIL PROTECTED] * The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. * __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___
Re: Remedy Disaster Recovery Solutions
** I just went through this process on Friday, when the RAID controller on my production server failed catastrophically (is there any other way?). If you need a comprehensive document, let me know and I’ll send you what I have (Bonus: it was just tested and updated with lessons learned!) Possible drawback: we are on Windows 2003 Server and MS SQL Database. Cheers, Mike Luttmann Senior Database Engineer [EMAIL PROTECTED] 719-554-2462 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Marino, Melanie A Sent: Friday, September 22, 2006 9:47 AM To: arslist@ARSLIST.ORG Subject: Remedy Disaster Recovery Solutions Can anyone share with me what their company is using for Remedy Disaster Recovery? We are looking to replicate our Remedy production environment to another site in real-time and switch back and forth between the servers as needed. We are trying to determine the best solution. We are running on a Solaris machine and an Oracle DB. Your help would be greatly appreciated. Thanks, Melanie Marino Project Manager KPMG LLP [EMAIL PROTECTED] * The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. * __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: How to reach the ARSlist Archives
** BTW, I’ve noticed that if you try to go to the simple URL, http://www.arslist.org, it redirects to an invalid page (similar to the URL below, but the “s” is left off from “/archives/”). Someone may want to look into that. Mike Luttmann [EMAIL PROTECTED] From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Tuesday, May 09, 2006 3:15 PM To: arslist@ARSLIST.ORG Subject: How to reach the ARSlist Archives ** Currently the following url will get you to the archives. A great place to search for issues you may be having and to find previously provided solutions. http://listserv.rbugs.com/archives/arslist.html Susan __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
