It looks like it is all items added by 7.1.0. I wonder if the 7.5.0 patch 4 HP installer is missing things. Can you upgrade to 7.1.0 and then to 7.5?
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 11:05 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue Hi Fred, Here is the output from the log file... */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT COUNT(*) FROM user_cache WHERE userName = 'Action Request Installer Account' */OK */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT Feature, NumberField, LicenseQualifier, ExpireDate, LicenseKey FROM license_cache */*** ERROR *** ORA-00942: table or view does not exist */ORA-00942: table or view does not exist */SELECT MAX(serverId) FROM server_cache */OK */SELECT dbUpdate FROM control */OK */COMMIT WORK */SELECT groupId,groupName,groupType,groupCategory FROM group_cache ORDER BY 1 ASC */OK */SELECT groupType,MAX(timestamp) FROM group_cache GROUP BY groupType */OK */select count (*) from arschema */OK */SELECT name,schemaId,schemaType,coreVersion,timestamp,numFields,defaultVui,numVuis,nextFieldId,upgrdVersion,version,smObjProp,safeGuard,nextId,objProp,viewName, shViewName FROM arschema ORDER BY 2 ASC */*** ERROR *** ORA-00904: "SHVIEWNAME": invalid identifier */ORA-00904: "SHVIEWNAME": invalid identifier */SQL Trace Log -- OFF It seems that the some steps of the installation did not successfully complete... Mike -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Monday, July 19, 2010 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: ARS 7.0.1 to 7.5.0 Upgrade Issue If you don't already have logging turned on, edit your ar.conf file to enable logging on the arsql.log. This way you can see exactly which statements are failing. Debug-mode: 1 (page 333 of the Configuration Guide pdf) SQL-Log-File: Full_Path_to_log_File Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kendhammer, Mike Sent: Monday, July 19, 2010 9:48 AM To: arslist@ARSLIST.ORG Subject: ARS 7.0.1 to 7.5.0 Upgrade Issue Hello, Last week, I began trying to upgrade our 7.0.1 test environment to 7.5.0 patch 4. After finally getting through the installer, I am getting the following error when trying to do the arsystem start command. 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : Error reading license cache table. (ARERR 468) LoadLicenseCache() 390600 : This version of the Action Request System(R) is ready for use or evaluation without purchasing or activating an authorization key. For unlimited capabilities, contact your sales representative. (ARNOTE 27) 390600 : Failure during SQL operation to the database (ARERR 552) ORA-00904: "SHVIEWNAME": invalid identifier 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) (ARNOTE 0) Unable to receive indication that server is up. We are on HP-UX 11.31 and Oracle 11.2.0.1. I have tried running the installer twice, the second time after performing an uninstall. I have a ticket into BMC Support but the response has been a bit slow. They did mention that it seems some database objects weren't created, one being a LICENSE_CACHE table but I haven't got much further than that. Any suggestions on what I can try doing to resolve this? Thanks! Mike Mike Kendhammer Support Systems Enterprse Services Ingersoll Rand 3600 Pammel Creek Rd, La Crosse WI 54601 Office: +1 608.787.3078 Email: mkendham...@trane.com<mailto:mkendham...@trane.com> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" The information contained in this message is privileged and intended only for the recipients named. If the reader is not a representative of the intended recipient, any review, dissemination or copying of this message or the information it contains is prohibited. If you have received this message in error, please immediately notify the sender, and delete the original message and attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
