Well the fun continues.... Joe: Checked all server references and there are no embedded references.
Jason: Looks to me like there might be a permission issue from the SQL Log. Frank: You might be right about the hot backup - I am having one done @ 0300hrs tonight - will try with this one. Guillaume & David: Excellent suggestion - I will definitely take this into consideration when it's "Showtime". Fred: Good suggestion - I see now from the SQL Logs - that there is an error that what I am seeing in the error log only occurs when the Remedy Service is restarted. See below some excerpts: <SQL > <TID: 0000005952> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int5952', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000005952> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float5952 <SQL > <TID: 0000004332> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int4332', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000004332> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float4332 <SQL > <TID: 0000005928> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int5928', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000005928> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float5928 <SQL > <TID: 0000004012> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int4012', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000004012> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float4012 <SQL > <TID: 0000003992> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int3992', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000003992> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float3992 <SQL > <TID: 0000005688> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int5688', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000005688> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float5688 <SQL > <TID: 0000005312> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int5312', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000005312> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float5312 <SQL > <TID: 0000005208> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */*** ERROR *** Cannot drop the table 'AR0int5208', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000005208> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9440 */DROP TABLE AR0float5208 <SQL > <TID: 0000004068> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9590 */*** ERROR *** Cannot drop the table 'AR0int4068', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000004068> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9590 */DROP TABLE AR0float4068 <SQL > <TID: 0000004372> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9590 */*** ERROR *** Cannot drop the table 'AR0int4372', because it does not exist or you do not have permission. (SQL Server 3701) <SQL > <TID: 0000004372> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9590 */DROP TABLE AR0float4372 <SQL > <TID: 0000002564> <RPC ID: 0000000000> <Queue: Preload > <Client-RPC: 000000 > <USER: > /* Thu Jul 15 2010 16:55:53.9750 */*** ERROR *** Cannot drop the table 'AR0int2564', because it does not exist or you do not have permission. (SQL Server 3701) ARERROR LOG EXAMPLES... ------------------------------------------------------------------------------- (c) Copyright 1991-2009 BMC Software, Inc. Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (propList format -- 20\1\6\3\3\41\2\450\500\23962\2000\4\6\1\5\6\2\7\40\2147483649\14\40\1\21\41\2\1687\1700\25199\3200\24\4\4\0x80\40\41\0\ \65\41\2\0\0\0\0\66\41\2\0\0\0\0\80\4\37\Information Généré Par Le Système\81\4\8\ (ARERR 556) Thu Jul 15 16:55:55 2010 User Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 User Password Change Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 User Password Management Configuration Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 Alert List Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 Report Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 ReportSelection Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 ReportType Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 ReportCreator Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:55 2010 AR System User Central File Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) ------------------------------------------------------------------------------- Thu Jul 15 16:55:55 2010 AR System User Preference Thu Jul 15 16:55:55 2010 390600 : Missing data in the SQL database (ARERR 556) Thu Jul 15 16:55:57 2010 390600 : Form does not exist on server (ARERR 303) Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) Thu Jul 15 16:55:57 2010 User Password Change:UpdatePassword`! Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) Thu Jul 15 16:55:57 2010 User Password Change:UpdatePassword`! Thu Jul 15 16:55:57 2010 390600 : Form does not exist on server (ARERR 303) Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) Thu Jul 15 16:55:57 2010 User Password Change:UpdatePasswordErrorHandler Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) Thu Jul 15 16:55:57 2010 User Password Change:UpdatePasswordErrorHandler Thu Jul 15 16:55:57 2010 390600 : Form does not exist on server (ARERR 303) Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) Thu Jul 15 16:55:57 2010 User Password Change:UpdatePasswordMessage Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) Thu Jul 15 16:55:57 2010 User Password Change:UpdatePasswordMessage Thu Jul 15 16:55:57 2010 390600 : Form does not exist on server (ARERR 303) Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) Thu Jul 15 16:55:57 2010 User Password Management:RestrictSubmit Thu Jul 15 16:55:57 2010 390600 : Error in definition for a filter (ARERR 343) ------------------------------------------------------------------------------- I am currently asking the DBA to make sure permissions on the Sandbox are the same as the permissions on Production. Thanks - All. Time for some sleep - then try again in the Morning. On Jul 15, 3:13 pm, Guillaume Rheault <[email protected]> wrote: > Hey Elry, > > One more thing that I forgot to mention to you, that is a new feature with > ARS 7.5, I believe. > As you may know, AR Server license keys are stored in the database, not in a > file as it used be before. > However, the new feature in ARS 7.5 is that you can enter ARS licenses for > servers for which the Host ID is not the one of the current server. > When the ARS server starts, it picks the license key that matches its host id. > > In our case, we entered the DEV and UA ARS serverlicense keys in production, > so when we do the database restore, we don't have to key in the ARS Server > license key. Very handy. > > Myself and other listers have accomplished this task, so it's doable. > > So don't give up, and make sure you document all the issues you run into for > your specific environment, create a checklist as I suggested, so the next > time it will be smoother. > > Guillaume > > ________________________________________ > From: Action Request System discussion list(ARSList) [[email protected]] on > behalf of Elry [[email protected]] > Sent: Thursday, July 15, 2010 2:12 PM > To: [email protected] > Subject: Re: SQL Database Replication > > Well... > > We were able to get the system up and running, but I noticed that > there are some odd things: > > 1) All structures and data appear to be available at the database > level. > 2) Server Information had no data. > 3) User form cannot be pulled up in the User Tool/ Dev Studio. > 4) Forms that are large (300 + fields) cannot be pulled up in the User > Tool/ Dev Studio. > 5) ARERR 556 Missing data in the SQL Database is "littered" throughout > the arerror.log for forms and workflow. > > This begs the question: Has anyone out there had any such experience > with 7.5???? > > On Jul 15, 12:20 pm, Elry <[email protected]> wrote: > > > > > Hi Guys... > > > Thanks for all the responses so far. > > > Guillame: I am checking the ar.cfg file right now and correcting a > > few discrepancies (i.e. the ARAdmin password in production is not the > > default). > > > LJ: I agree with Oracle last year - we were able to drop and attach > > database instances without a "hitch". > > > Right now - it looks like it is probably the differences with the > > ar.cfg that might be the issue. > > > On Jul 15, 12:03 pm, LJ LongWing <[email protected]> wrote: > > > > Elry, > > > This is how we manage our refreshes of Dev/Test, I can let you know that > > > for > > > our custom application, that function works just fine. > > > > -----Original Message----- > > > From: Action Request System discussion list(ARSList) > > > > [mailto:[email protected]] On Behalf Of Elry > > > Sent: Thursday, July 15, 2010 9:36 AM > > > To: [email protected] > > > Subject: Re: SQL Database Replication > > > > Thanks Terry... > > > > Just spoke to the DBA - what he actually did was: > > > > 1) Made a backup copy of Production. > > > 2) Restored the backup copy to the Sandbox. > > > > This appears to be quite different from replication - could this be > > > the source of the problem. > > > > On Jul 15, 11:30 am, Terry Bootsma <[email protected]> wrote: > > > > ** Elry: > > > > One thing to consider is that when you replicate from server A to server > > > B, the replicated database may not be in an "active" state. You may have > > > to take it out of this state to actually start Remedy and have it connect > > > to > > > it... have you tried this? > > > > Terry > > > > > On Jul 15, 2010,Elry<[email protected]> wrote: > > > > > Hi Guillaume... > > > > We just gave it a try this morning and got the following error: > > > > Incorrect format in the definition file (ARERR 402). This is when the > > > > ARS Service tries to start - this ouput occurs in the arrerror.log > > > > Looks like ARMonitor shuts it down with a ARERR 33 AND ARERR 32. > > > > Anyone familiar with this .... > > > > On Jul 15, 10:58 am, Guillaume Rheault <[email protected]> wrote: > > > > > Elry, > > > > > > I believe option A is the best, because you will get all the data from > > > production on your development and test environments. This is a huge plus. > > > > > There are a few things that you would need to change once the database > > > is overwritten, such as updating the ARS and ITSM licenses assigend to > > > users > > > (assuming your fixed and floating counts are different from production to > > > dev and UAT), and disabling the outgoing mailbox from your dev and UAT > > > environments, to make sure no email goes out accidentally. > > > > > > Keep in mind that BMC (well really the old Remedy) architected ARS > > > > > from > > > its inception do perform this very task, so it's definitely doable. There > > > were some bugs in older ARS versions where the server references were > > > hardcoded, but this is not the case with latest versions (i.e. 7.x and > > > 6.3, > > > I believe). > > > > > > You may find some sporadic server references in entries in > > > > > configuration > > > forms in ITSM, but BMC is working towards making sure there are no server > > > references in the next version. > > > > > It's only a matter of keeping for yourself a checklist of things to do > > > after the DB overwrite. > > > > > > I suggest creating a ticket with BMC support specifying your ITSM > > > version and patch, so BMC can tell you where, if any, server references > > > are > > > found in your ITSM version. > > > > > > I think you'll find this the best option once you get going. > > > > > > Guillaume > > > > > > ________________________________________ > > > > > From: Action Request System discussion list(ARSList) > > > [[email protected]] on behalf of Elry [[email protected]] > > > > > Sent: Thursday, July 15, 2010 8:46 AM > > > > > To:[email protected] > > > > > Subject: SQL Database Replication > > > > > > Hi Folks... > > > > > > I am going to ask this question again - because I have never seen a > > > > > definitive answer. > > > > > > Here is what we have: > > > > > > 1) Independent SQL Database Tier (2005). > > > > > 2) ARSystem Application Tier (7.5 Patch 2). > > > > > 3) Mid-tier (7.5 Patch 2). > > > > > > Environments: > > > > > > 1) Sandbox > > > > > 2) Development > > > > > 3) Staging > > > > > 4) Production > > > > > 5) Reporting/Archiving (to be deployed). > > > > > > What we need to do is the following: > > > > > > 1) Update the Staging and Development environments with data from > > > > > production > > > > > 2) Replicate the Production database to our new Reporting/Archiving > > > > > environment. > > > > > > Options being considered: > > > > > > A) Database Replication. > > > > > B) BMC Remedy Migrator. > > > > > C) DSO. > > > > > > We understand and know how to use options B) and C). We are looking > > > > > for feedback from anyone who is successfully using option A). > > > > > Specifically... > > > > > > 1) What type of replication. > > > > > 2) Are there configuration paramaters that are retained at the > > > > > database level that need to be changed. > > > > > 3) Are there any considerations for ar.cfg. > > > > > > I have never seen a white paper on database replication ( I understand > > > > > that this method is unsupported). > > > > > > Any feedback would be greatly appreciated. > > > > ___________________________________________________________________________ > > > ____ > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are" > > > > ___________________________________________________________________________ > > > ____ > > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are" > > > > ____________________________________________________________________________ > > > ___ > > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are" > > > > > _attend WWRUG10www.wwrug.comARSlist:"Where the Answers Are"_ > > > > ____________________________________________________________________________ > > > ___ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are" > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"- Hide quoted > > > text - > > > > - Show quoted text - > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > > attend wwrug10www.wwrug.comARSlist:"Where the Answers Are"- Hide quoted > > text - > > > - Show quoted text - > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
