It looks like each of the filters has a bad action and that is causing the count of actions to be off. When you imported did you mark the "Replace Options on the Destination Server" option?
You have 7 bad action value, 7 Incorrect format in the definition file, and 7 numactions errors. I think each of the 7 filters has a bad action and that causes the numaction error. If necessary you might have to do the following ( *** LAST RESORT *** ) 1. Find the FilterID for each of the 7 filters. 2. In each of the FILTER_% tables delete the records for those FilterID(s) 3. Re-Import the 7 filters Hope this helps some. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Wednesday, January 31, 2007 11:08 AM To: [email protected] Subject: Re: ARS 7.0 Install as non-root user Hi Axton, Some time ago you offered to help me if I ran into problems doing a non-root install in ARS 7.01. I hope that offer is still good. Here is what happened. The install went OK, after a few snags. But when we restart the system we get all sorts of messages about improperly defined objects. Some of these are about filters. In each case the filter is not in the filter list in the Admin tool for the new database. But when I try to import the missing filter from the old database I get "This violates a unique index." The filter IS in the "filter" table. I am working with Remedy support. They sent me a script for updating the number of actions in the "filter" record. The problem is that the "filter" record for each filter has the same number of actions in the new database as in the old. So I don't think that the "numactions" is the problem. There is one message about the number of actions, but it doesn't say what the filter is. This is even more worrisome. There are quite a few messages where they don't even say what the object is. I am attaching a screen print of the start-up messages. If you have time to look at them I would be glad for your suggestions. If not, I realize that we are all busy people. Like I say, I am working with Support, but I would still be glad for your opinion. Best Wishes, Dwayne Martin PS: We are installing on RedHat Linux, Oracle 10 db ---- Original message ---- >Date: Thu, 7 Dec 2006 14:50:28 -0500 >From: Axton <[EMAIL PROTECTED]> >Subject: Re: ARS 7.0 Install as non-root user >To: [email protected] > > ** > Installing as non-root works well on solaris for the > 7.0.01 release. Here are the steps I used: > > Step 1: Upload Installation Media > Step 2: Identify and remove server side direct sql > workflow (there is a known bug in the upgrade > process if there is direct sql server side workflow; > not sure if related to unicode upgrade or not) > Step 3: Stop Remedy > Step 4: set the necessary environment variables > LC_ALL > LANG > Oracle Env Vars for 10g > unset ARNONROOTINSTALL; ARNONROOTINSTALL=TRUE; > export ARNONROOTINSTALL > unset AROS; AROS=SOLARIS; export AROS > # Precautions to work around SW00253401 - certain > custom background images cause arserverd to core > dump - solaris specific solution > LD_PRELOAD=libumem.so; export LD_PRELOAD > unset UMEM_DEBUG > unset UMEM_LOGGING > Step 5: Create a backup of the filesystem > Step 6: Upgrade ARServer - run ar_install using your > non-root account > > The key here is the env var ARNONROOTINSTALL. > > Axton Grams > > On 12/7/06, Dwayne Martin <[EMAIL PROTECTED]> wrote: > > I am planning to install ARS 7.0.01 as non-root on > a Red-Hat > Linux server (Oracle 10 db). I came upon the > exchange shown > below, which suggests installing as root, then > changing the > object ownerships afterwards. > > The only disadvantage I see is that I would need > to get root > permissions, which I don't normally have. > > Has anyone succeed in installing ARS 7 as non-root > on a Unix > or Linux platform? > > Does anyone have any additional advice to offer? > > Dwayne Martin > James Madison University > > ******* previous exchange ************* > > Date: Tue, 25 Jul 2006 11:47:14 -0400 > Reply-To: [email protected] > Sender: "Action Request System discussion > list(ARSList)" > <[email protected] > > From: Kevin Shaffer > <[EMAIL PROTECTED]> > Subject: ARS 7.0 Install as non-root user > Content-Type: text/plain; charset="iso-8859-1" > > We are unable to get 7.0 to install successfully > as a non-root > user, however it works fine installing as a root > user. Has > anyone successfully installed ARS 7.0, ITSM 7.0 > and CMDB as > root user and then converted it after the install > to run as > non-root. > Any gotchas or recommendations. Is there a list > of all files > that need updated? I have pulled the KB's off the > web site, > but they all are outdated. I am more interested > in experience > doing this with 7.x. > TIA > Kevin > ************** > From: Dave Zifchock <[EMAIL PROTECTED]> > Subject: Re: ARS 7.0 Install as non-root user > > Kevin, > Every install I have made has been as the root > user and > converted over to a > non-root user. On HPUX, I would just chown the > <remedy > install dir> and > the /etc/arsystem and /etc/arinstall directories > and it ran > without any > flaws. Just make sure you shut down all of your > current ARS > processes and > then change the permissions. > ******************* > Subject: Re: ARS 7.0 Install as non-root user > In-Reply-To: > < > [EMAIL PROTECTED]> > Content-Type: text/plain; charset=ISO-8859-1; > format=flowed > Content-Disposition: inline > > See my other thread, entitled "ARS 7.0 p001 > Install Issues" > > This was done as non-root > > What problem are you having > > Axton Grams > > ************* > From: Axton Grams <[EMAIL PROTECTED]> > Subject: ARS 7.0 p001 Install Issues > Content-Type: text/plain; charset=ISO-8859-1 > > Has anyone successfully installed ARServer 7.0 > p001 with all > languages > in the following environment: > > - Solaris 9 > - Oracle 10g client > - Remote Oracle 9.2 db (unicode) > - non-root install > - new install > > The installer crashes at the beginning of the > import of the FB > forms, > stating dbVersion is an invalid operator. > > Other relevant install settings: > - all languages > - new install > - area plugin > - no portmapper > - webservices plugin > - all other plugins/daemons not installed (arsnmp, > ardbc) > - Solaris LANG en_US.UTF-8 > - Oracle NLS_LANG american > > One thing I noticed is a whole bunch of arx import > errors for the > localized messages form, simply because of the > number of > records exceeds > 2000. > > Thanks, > Axton Grams > From: Axton < [EMAIL PROTECTED]> > Subject: Re: ARS 7.0 p001 Install Issues > In-Reply-To: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset=ISO-8859-1; > format=flowed > Content-Disposition: inline > > Here is the exact error. I reproduced it. > > Installing Flash Objects: Mon Jul 24 21:05:36 EDT > 2006 > > ./ar_install: test: unknown operator dbVersion > > Looking at the install script, it looks like the > installer > dies at this point: > > In the stage 6 of the install script: > > 12299 # Import required and selected > plugins > 12300 ImportPlugins > >>> 12301 ImportFlash > > Now in the importFlash function: > > 3279 > ############################################################## > 3280 # ImportFlash - Upgrade and import > FlashObject Forms > 3281 # > 3282 > ############################################################## > 3283 ImportFlash() > 3284 { > 3285 lecho "Installing Flash Objects: `date` > " > 3286 lecho > 3287 SAMPLE_FORMS="$INSTALL_DIR/samples/en" > 3288 $CD $SAMPLE_FORMS > 3289 > >>> 3290 if [ ${DB_UPGRADE} -eq 1 -a > ${ARS_VER} -lt 21 > ]; then > 3291 LoadSchemaWithRIK FlashForms > "${IMPORT_MODE}" > "${UPGRD_USER}" "${UPGRD_PASS}" > 3292 if [ $? -ne 0 ]; then > 3293 lecho "FlashForms failed to > import." > 3294 lecho "Problems encountered > while > importing the > form FlashForms.def" > 3295 lecho "Please refer to the log > in > $INSTALL_DIR/Logs/ for further details." > 3296 else > 3297 note "FlashForms successfully > installed." > 3298 fi > 3299 fi > > From the output, I can tell that the first line of > this > function ran. > > In the ArEnvHistory file, these are the values of > the vars > used in the > if statement: > > DB_UPGRADE=0 > ARS_VER=select dbVersion from control > > Obviously the if statement can't handle the sql > statement. > > Here is the diff to fix this (sloppy hack, for new > installs only): > > [EMAIL PROTECTED]:/var/log/remedy/media/ars70p1/ars70p001/arsystem> > diff > -u ar_install.bak ar_install > --- ar_install.bak Mon Jul 24 10:41:19 2006 > +++ ar_install Mon Jul 24 21:36:28 2006 > @@ -11780,6 +11785,7 @@ > ############################################ > # Stage 6 : Set up sample forms and Demo > ############################################ > +ARS_VER=0; export ARS_VER > STAGE=6 > LogOnly "Stage 6: `date`" > if [ $FRESH_INSTALL -eq 1 ]; then > > Axton Grams > > Dwayne Martin > Computing Support > James Madison University > > __20060125_______________________This posting was > submitted with HTML in it___ 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"
