++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++
HI, We have DB replication enabled on SQL2005 and it has to be turned off before making any changes to forms in Remedy. Moving a field may result in the Remedy trying to rebuild the SQL view representing the form, which in case of Remedy constitutes dropping the view and re-creating it. Dropping objects that are being replicated is not possible if they are being replicated and that is most likely the reason for errors you are getting. You can always turn the SQL logging off or check error logs to see what error exactly you are getting. Regards Jiri Pospisil IT Services LCH.Clearnet From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: 16 October 2008 19:21 To: [email protected] Subject: Re: Replication ** Brandi, We have been using SQL replication for several years. While I am not a DBA here is what I can remember: * Tables created by Remedy in ARSYSTEM really does not declare C1 as a primary key (at least in SQL 2000). * I believe this is done manually by the DBA. * When a table is being replicated you cannot Alter the ARSystem table without dropping replication first. Moving a field does not constitute an Alter of the table. * Joe is correct in that ARADMIN must be the dbo of the replicated db. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, October 16, 2008 12:31 PM To: [email protected] Subject: Re: Replication Brandi, I have replicated databases on MS-SQL, Oracle and other databases successfully and not have Remedy throw up on the users.. What method of replication did the dba use? Does the ARAdmin user that owns the ARSystem database have the same rights and privileges as the ARAdmin user on the original database? Typically on MS-SQL the ARAdmin user should be the dbo of the ARSystem database. Joe ----- Original Message ---- From: Brandi Barbour <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, October 16, 2008 1:11:25 PM Subject: Replication ** All, We have windows 2003 with sql 2005, ARS 7.1.0, ITSM 7.0.3. Our database engineer set up SQL replication for our production sql server to our backup sql server. The problem is that when he does the SQL replication set up the remedy system does not agree with it. We get errors when someone modifies a request and it pushes a value to a char field with an attached menu with the pattern = $MENU$. It says that the value we are sending does not meet $MENU$. We also get errors if we go to the admin tool and try to move a field.. Errors concerning the sql view does not exist. It seems that somehow the views are being changed. I know someone on the list had said that the replication adds columns to the views so the system is not recognizing the views correctly. I have seen some questions on arslist but did not know if anyone had a solution as of yet. Has anyone successfully set up SQL replication successfully? Thanks, Brandi __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify [EMAIL PROTECTED] The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com ************************************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
