select * from CNTNR_OWNR_OBJ where OWNEROBJID not in (select SCHEMAID from ARSCHEMA)
select * from CNTNR_OWNR_OBJ where
CONTAINERID not in (select CONTAINERID from
ARCONTAINER)
select * from ARCTR_GROUP_IDS where
CONTAINERID not in (select CONTAINERID from
ARCONTAINER)
select * from ARCTR_SUBADMIN where
CONTAINERID not in (select CONTAINERID from
ARCONTAINER)
select distinct CONTAINERID from
ARREFERENCE where CONTAINERID not in (select CONTAINERID from
ARCONTAINER)
select * from ARREF_GROUP_IDS where
CONTAINERID not in (select CONTAINERID from
ARCONTAINER)
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 9:28 AM
To: [email protected]
Subject: Re: Loosing form relation in guides
Darren:
I
will state that you should seriously look at getting away from Oracle 9i with
the upgrade and EOL issues. If the machine is 'strong' enough to run 10g,
then you should look at moving towards it in the near future.
James McKenzie
________________________________
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of
LAU, DARREN (ASI)
Sent: Thursday, July 20, 2006 9:24
AM
To: [email protected]
Subject: 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___
__20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
