Cool. I'll give this a try next time I need to refresh my non-production database.
Thanks, Shawn Pierson Remedy Developer | Energy Transfer 1300 Main St. Houston, TX 77002 | 713.989.7226 IT Service Desk: 1.855.658.2468 If you would like to report an issue with Remedy, please click here to enter an Incident. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Carl Wilson Sent: Wednesday, October 23, 2013 9:53 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR -149 in Developer Studio Hi, You can take a look into this (free tool): http://www.missingpiecessoftware.com/products/remedy-restore-tool Check if there are references that your SQL script is missing that may be causing the issue. Kind Regards, Carl Wilson http://www.missingpiecessoftware.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: 23 October 2013 15:29 To: arslist@ARSLIST.ORG Subject: Re: ARERR -149 in Developer Studio We're using LDAP authentication, and the thing that makes it confusing is that with the same user I can log in to the Mid Tier just fine, and I would have thought that the Mid Tier wouldn't work if the user_cache was corrupt. It seems to be specific to Developer Studio. Also, the way we resolve it is by removing the connection to that server, logging in to the others, then re-add it. That makes me think it's something specifically on the Developer Studio side where it's pulling some value and storing it somewhere, but I can't find anything like that in the files stored in the workspace. Thanks, Shawn Pierson Remedy Developer | Energy Transfer -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Wednesday, October 23, 2013 9:00 AM To: arslist@ARSLIST.ORG Subject: Re: ARERR -149 in Developer Studio 149 "A user name must be supplied in the control record." It sounds like the encrypted password in the database is being messed up. It could also be the User_Cache on the database Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pierson, Shawn Sent: Wednesday, October 23, 2013 8:30 AM To: arslist@ARSLIST.ORG Subject: ARERR -149 in Developer Studio ** Good morning, Does anyone know what causes ARERR -149 to appear in dev studio 7.6.4 when you log in? We seem to get it whenever we refresh our QA server's database with a copy of production. However, I run some SQL to change all the hard-coded server references so it should fix things. Thanks, Shawn Pierson Remedy Developer | Energy Transfer ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "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"