The problem is that the database still contains references to the old server. The only way I know to get rid of the pointers to the old server, is through an export/import process.
I have seen this before. We ended up using the import/export tool in remedy to move the data. This can be time consuming. I have not seen this happen often and have not figured out what data is retaining the old server info, but this method fix it for us. It removed what ever server references were in the tables. Todd -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin Sent: Wednesday, June 27, 2007 2:31 PM To: [email protected] Subject: Re: Mid-Tier Crystal Reports get data from wrong server We copied the database, then installed ARS onto the db. Dwayne ---- Original message ---- >Date: Wed, 27 Jun 2007 14:14:51 -0400 >From: Todd <[EMAIL PROTECTED]> >Subject: Re: Mid-Tier Crystal Reports get data from wrong server >To: [email protected] > >How did you move the forms over to the new server? > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin >Sent: Wednesday, June 27, 2007 1:57 PM >To: [email protected] >Subject: Re: Mid-Tier Crystal Reports get data from wrong server > > >Hi Todd, > >Thanks for your suggestion. > >In "General Settings" I see Preference Server(s), HomePage Server, Crystal >Report Location, and Reporting Working Directory, all set correctly. I've >combed the config tool for any reference to the old server, and even deleted >the old server from the se >rver list. > >Dwayne > >---- Original message ---- >>Date: Wed, 27 Jun 2007 13:48:02 -0400 >>From: Todd <[EMAIL PROTECTED]> >>Subject: Re: Mid-Tier Crystal Reports get data from wrong server >>To: [email protected] >> >>You will have to change the path in the mid-tier config tool. I do not have >>the tool in fornt of me to verify the exact location in the tool, but I >>beleive it is under the "General Settings" option. >> >>-----Original Message----- >>From: Action Request System discussion list(ARSList) >>[mailto:[EMAIL PROTECTED] Behalf Of Dwayne Martin >>Sent: Wednesday, June 27, 2007 1:33 PM >>To: [email protected] >>Subject: Mid-Tier Crystal Reports get data from wrong server >> >> >>Hello Everyone, >> >>We have moved our AR System to a new server. In the User tool, Crystal >>Reports display the correct data. In Mid-Tier they are pulling data from >>the old server, or trying to. >> >>We have a control panel with a single record. Mid-Tier displays the record >>from the old server. If we shut down the old server it says, "ARERR [9200] >>User has no access permission to bluejay [the old server]." >> >>I updated the "AR Server" setting in the "AR System ODBC Data Source" on >the >>web server machine and rebooted it, but no luck. I can't find anyplace >else >>that would cause Mid-Tier to look for the old server. >> >>I've tried both checking and un-checking the report's "verify On First >>Refresh" setting. >> >>I've also cleared the cache on both Mid-Tier and my browser. It is an IE >>browser, and I have "Check for newer versions. . ." set to "Every visit to >>the page." >> >>What am I missing? >> >>(ARS 7.01 p3, Linux ARS Server, Mid Tier 6.3 on IIS 5 web server on Win 2K >>machine) >> >>Dwayne Martin >>Computing Support >>James Madison University >> >>__________________________________________________________________________ _ >_ >>___ >>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" > >Dwayne Martin >Computing Support >James Madison University > >___________________________________________________________________________ _ >___ >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" Dwayne Martin Computing Support James Madison University ____________________________________________________________________________ ___ 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"
