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"
