Thanks for your reply. Looks like ar.cfg is pointing to the remote db. Could
this be as simple as changing it back to the original db server? How will that
affect the data that's already on the db remote server. Would it be possible to
limp them into one?
> Date: Sun, 11 Jul 2010 19:41:44 -0700
> From: [email protected]
> Subject: Re: ARS split db problem
> To: [email protected]
>
> Look for the following:
> 1. In ar.conf file see if the db entry is changed or pointing to
> correct db .
> 2. In oracle there is a tnsname.ora file to store the db sid, check
> the similar sqlserver component for the correctness of the entries if
> any.
> 3. Are you using any load balancer/failovers/hotbackup etc.., in that
> case check with your network guyz if any changes have been made to
> hostnames/ip addresses etc...
> 4. Involve dba to check if the connection to main db is established
> during the remedy startup or not.
>
> On Jul 11, 4:22 pm, AR Admin <[email protected]> wrote:
> > Hello,
> >
> > We've got a strange database problem. Just wondering if anyone had
> > something similar or knows how to fix it. We have ARS 6.3 running on MS SQL
> > 2000 db on one server and somehow the main db attaches to another remote
> > SQL server. Seems like all new transactions are saved to the remote server
> > because that db is getting larger and the original stays the same. This
> > split causes a lot of problems with new forms and external sql queries.
> > Users are not able to submit to new forms without at least a floating
> > license. New fields created on old forms are not found when running SQL
> > queries. I'm guessing because field definitions are saved on the remote db
> > server. I don't know if the db was split intentionally at the time of
> > install, or what, but we were trying to lump it all into one db. Is this
> > something anyone dealt with before?
> >
> > Thanks
> >
> > _________________________________________________________________
> > Hotmail is redefining busy with tools for the New Busy. Get more from your
> > inbox.http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTA...
> > _______________________________________________________________________________
> > 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"
_________________________________________________________________
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with
Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
