Upon further testing I haven’t actually resolved this. Somehow the account of the consultant that left is tied to it because the jobs only run when he has a User record. I guess I’ll just open a ticket with BMC support to see if I can get it resolved that way because I can’t find any reference to that account anywhere in the jobs themselves or the database connections.
Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mitcham, Ross Sent: Monday, April 27, 2015 10:17 AM To: [email protected] Subject: Re: Spoon Troubleshooting ** What is the transformation you are running, is this AI transformation via ITSM/UDM? Or directly from Atrium Integrator? ________________________________ Ross Mitcham Lead Product Developer Direct +1 905.707.3534 50 Minthorn Bvld. Suite 200 Markham, ON L3T 7X8 Canada [BMC Communities]<https://communities.bmc.com/> [Twitter]<https://twitter.com/bmcsoftware> [Facebook]<https://www.facebook.com/bmcsoftware> [YouTube]<http://www.youtube.com/user/BMCSoftwareBMCtv> [LinkedIn]<http://www.linkedin.com/company/bmc-software> [Communities]<https://plus.google.com/+bmcsoftware/> [BMC Software|Bring IT to Life]<http://www.bmc.com/> From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Pierson, Shawn Sent: Monday, April 27, 2015 10:16 AM To: [email protected]<mailto:[email protected]> Subject: Re: Spoon Troubleshooting ** Thanks. Changing that seems to make no difference on my production box, but I was able to get a different error when the value was invalid on my test box, which makes me think that this is trying to pass an invalid AR User account somewhere. Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Monday, April 27, 2015 9:07 AM To: [email protected]<mailto:[email protected]> Subject: Re: Spoon Troubleshooting ** Shawn, If I'm not mistaken, the AI utilizes the password stored in UDM:RAppPassword for running jobs...this should be the "Application Service Password" if I'm not mistaken....set this properly and verify if it starts working. On Mon, Apr 27, 2015 at 7:58 AM, Pierson, Shawn <[email protected]<mailto:[email protected]>> wrote: ** Good morning, I’m not the most knowledgeable when it comes to Atrium Integrator, and I’m not really able to find much specific information about it in BMC’s documentation. Basically, I have a job that fails with errors such as the following: 2015/04/27 08:39:11 - ARDatabase - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : Authentication failed 2015/04/27 08:39:11 - ARDatabase - ERROR (version 4.1.0, build 1 from 2012-11-06 13.20.53) : ERROR (623): Authentication failed; This makes me think it’s unable to connect to Remedy, and in my job I have a CMDBOutput step that I connect to the server. When I go into that step and look at the Database Connection, it appears to have the right servername and port, and the User Name is “Remedy Application Service”. I have no idea if the password for that is correct in UDM:RAppPassword but nobody has changed it in the past week so I assume it’s correct. Also, if I click on the “Test” button on the Database Connection screen it works, but it seems to work even if I change the User Name to random text. I don’t think that either Test or Explore work correctly because they seem to always work. Also, if I try manually running the job on the Execute a transformation screen I hardcode the AR_PASS, AR_SERVER, AR_TCP_PORT, and AR_USER to values that I know work and still see the error. Do you all have any ideas of where else I could troubleshoot these problems? The log files are not very helpful, especially since it can’t write to the UDM:TransformationLog file since the job can’t connect to the server. One other thing is that it ran successfully last Monday. Since then, we’ve disabled the account of the consultant that set up the AI jobs for us. I can’t find his credentials hardcoded anywhere though. Thanks, Shawn Pierson Remedy Developer | Energy Transfer Private and confidential as detailed here<http://www.energytransfer.com/mail_disclaimer.aspx>. If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here<http://www.energytransfer.com/mail_disclaimer.aspx>. If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
