Axton:
This is baaaadddd code here:
>>ARS_VER=select dbVersion from control
This should be a number not a select statement for SQL.
I'm wondering why it did not work.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Axton
Sent: Wednesday, September 06, 2006 1:23 PM
To: [email protected]
Subject: Re: ARS 7 install issues with Oracle 10gR2 on Solaris 9
Also, if the installer exits at this point, then it didn't complete successfully.
#################################################
Installing Flash Objects: Mon Jul 24 21:05:36 EDT 2006
./ar_install: test: unknown operator dbVersion #################################################
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.
Below is a 'sloppy' hack to get new installs (only) to complete successfully.
[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
__20060125_______________________This posting was submitted with HTML in it___
