Title: RE: Loosing form relation in guides
**
James,
 
Unfortunately not at the time.  I think you're on the right track though with this being a database issue and not so much an AR issue.  Maybe we can setup a test machine with oracle 10gr2 and do some experimenting.
 
Darren


From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3
Sent: Thursday, July 20, 2006 6:44 AM
To: [email protected]
Subject: Re: Loosing form relation in guides

**

Darren:

Any possibility of upgrading the database to Oracle 10gr2?  You will have to use, at least, the 10gr2 clients.

James McKenzie

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LAU, DARREN (ASI)
Sent: Wednesday, July 19, 2006 4:01 PM
To: [email protected]
Subject: Re: Loosing form relation in guides

Current Production and Test Server

OS: Windows 2000 Server
DB: Oracle 9.2.0.7.0
AR: 5.1.2 Patch 1375

Future Production and Test Server

OS: Windows 2003 Server
DB: Oracle 9.2.0.7.0
AR: 7.0 Patch 1

Turned on all the logs for both 5 and 7 and did the restart.  No pertinent error messages.


-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W
Sent: Wednesday, July 19, 2006 11:03 AM
To: [email protected]
Subject: Re: Loosing form relation in guides

I was thinking it might be something in ARCONTAINER but you are right that the Primary form data looks like it is stored in CNTR_OWNR_OBJ.

With all of the logs turned on are there any error messages in them when you start the service?  What's your OS and DB (we use Solaris and Oracle and I've never seen this problem on any of our servers).

If you have a test box that you could reproduce this on you might start all of the logs, stop the service, clear the log files, start the service, then see if there are any errors in any of the logs.

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LAU, DARREN (ASI)
Sent: Wednesday, July 19, 2006 11:22 AM
To: [email protected]
Subject: Re: Loosing form relation in guides

Fred,

I'm not quite following you here.  Let's take an AL Guide for example.
Where in the definition of a AL Guide is there a specific reference to a server?  Our problem is that whenever the AR service is restarted we lose the form relations of our container objects.  Say if you open up an AL Guide in the Admin Tool, on the basic tab, under the form name section, the checkbox for the appropriate form gets magically unchecked.

But if I look at the underlying database table CNTR_OWNR_OBJ all the appropriate data is still there.  If we manually recheck the appropriate form through the admin tool the AL Guide will work again.  That is until the next time the AR service gets restarted and we start at square one again.

Darren

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W
Sent: Wednesday, July 19, 2006 7:55 AM
To: [email protected]
Subject: Re: Loosing form relation in guides

It almost sounds like your server does not know how to reference itself.
Are the guides referencing the server by a different alias than the server knows itself as?  If you reference a server by different names I would suggest that all of the names be listed in the ar.conf (ar.cfg on

Windows)

Server-Name: arserver
IP-Name: arserver.full.domain
IP-Name: alias1
IP-Name: alias1.full.domain

If someone is referencing the server by the IP only you might have to add that to the config file as well.

Fred

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Darren Lau
Sent: Tuesday, July 18, 2006 2:16 PM
To: [email protected]
Subject: Re: Loosing form relation in guides

I'm having this same exact problem on our 5.1.2 servers as well as our 7.0 test servers.  Everytime the AR service is restarted we lose all or most of the form relations in our container objects.  Has anyone else heard of this problem before and knows a solution or a fix?  Thanks.



Darren


On Tue, 10 Aug 2004 09:48:54 +0200, Jarl Groneng <[EMAIL PROTECTED]> wrote:

>Hi,
>
>Once a while my filter and active linke guides are loosing the form
relation. This happend everytime I restart the server, or when the server has been reloaded. In admin tool I can see the form the guide are related to, but when I open the guide I have to choose a form to related it to.

After saving the guide, it runs as planned.
>
>If the relation are lost when the server reloads, the guides still
runs.
But when the server are reaterted the guides needed to be re-related.
>
>Seems like there in any inconsitence in the arcontainer and related
tables, but have not been able to find it yet.
>
>??
>
>Regards,
>Jarl
>

________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___

Reply via email to