Didn't spend the time to investiage, reported it as a bug and made a quick/dirty fix to get the installer to complete properly. The only thing that fails to import when this happens are the fb forms/workflow.
Axton Grams On 9/6/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote:
** 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___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
