Re: ARServer 7.0.1 Upgrade Installer
Axton, Thanks for the info. I'll keep this in mind if we upgrade our SUN servers instead of going to Windows. Before folks ask, we are looking at moving to Windows for many of the same reasons that James's is looking at moving to SUN. We have had more issues with down time since we went into a SUN Cluster than when we ever had on a stand alone SUN box. Issues have been disk related, human error, corruption of files for another database that crashed the storage array, etc. Throw on top of it a very controlling UNIX admin that uses SOX and Audits as justification for complete control. It took me a little over 6 months to document a fairly simple 6.3 installation and create a installation package for them to execute. It's time to move back to stand alone servers. Dave >Date:Fri, 13 Oct 2006 14:07:43 -0400 >From:Axton <[EMAIL PROTECTED]> >Subject: Re: ARServer 7.0.1 Upgrade Installer > >I tracked the issue down to the data in the filter_sql table. When >arupora is running, it logs to a file name /var/tmp/arsql.log. By >viewing this file I could see what the last select was and concluded >that the data returned by that select statement was causing the >segfault. I removed all the data from filter_sql (15 records) and the >installer completed successfully. > >Hope this helps someone. > >Axton Grams Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
I tracked the issue down to the data in the filter_sql table. When arupora is running, it logs to a file name /var/tmp/arsql.log. By viewing this file I could see what the last select was and concluded that the data returned by that select statement was causing the segfault. I removed all the data from filter_sql (15 records) and the installer completed successfully. Hope this helps someone. Axton Grams On 10/13/06, Axton <[EMAIL PROTECTED]> wrote: One would think there would have been some type of announcement. I have received confirmation from BMC that this is the maintenance release that is supposed to address the unicode upgrade issues. The problem is that the arupora utility dies due to a segmentation fault and core dumps. I'm working with BMC to resolve this issue, but it's rather slow going at this point. I'm hoping someone else in the community has or will attempt the following and share their experience: Upgrade from ARS 6.0.1 to ARS 7.0.1 App Server: SunOS 5.9 Database: Remote Oracle 9i Oracle Client on App Server: 10.2.0.whatever Db Charset: UTF-8 I am using the following for the LANG and NLS_LANG on the app server: LANG=en_US.UTF-8 NLS_LANG=american_america.AL32UTF8 ar_install calls a binary name arupora that is included with the install files. This program connects to the oracle db directly and gathers/updates a bunch of data. This program generates a segfault before it completes. The script exits with the following text: Running DB upgrade. This may take several minutes Running DB upgrade. /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 21 /* Fri Oct 13 10:03:35 2006 */ Upgrade old field-lengths codeset=0 'windows-1252' errorCode=0 An error was encountered during the upgrade of the ORACLE database ./ar_install: test: argument expected The core file is generated in the target installation directory. While running truss, I see the following output just before it core dumps: time() = 1160672159 lseek(3, 64878, SEEK_SET) = 64878 write(3, " / * T h u O c t".., 123) = 123 write(6, "\0ED\0\006\0\0\0\0\003 ^".., 237) = 237 read(6, "019B\0\006\0\0\0\0\01019".., 2064) = 411 time() = 1160672159 lseek(3, 65001, SEEK_SET) = 65001 write(3, " / * T h u O c t".., 37) = 37 write(6, "\015\0\006\0\0\0\0\00305".., 21) = 21 read(6, "\0E0\0\006\0\0\0\0\00601".., 2064) = 224 Incurred fault #6, FLTBOUNDS %pc = 0xFE1872FC siginfo: SIGSEGV SEGV_MAPERR addr=0x Received signal #11, SIGSEGV [default] siginfo: SIGSEGV SEGV_MAPERR addr=0x If I attach a debugger to the arupora utility and execute it, I get the following: dbx arupora dbxenv suppress_startup_message 6.2 Reading arupora Reading ld.so.1 Reading libclntsh.so.10.1 Reading libnsl.so.1 Reading libsocket.so.1 Reading libgen.so.1 Reading libdl.so.1 Reading libaio.so.1 Reading librt.so.1 Reading libkstat.so.1 Reading libm.so.1 Reading libthread.so.1 Reading libw.so.1 Reading libc.so.1 Reading libicuucbmc.so.32 Reading libicui18nbmc.so.32 Reading libicudatabmc.so.32 Reading libiostream.so.1 Reading libCstd.so.1 Reading libCrun.so.1 Reading libnnz10.so Reading libsched.so.1 Reading libmp.so.2 Reading libmd5.so.1 Reading libpthread.so.1 Reading libc_psr.so.1 Reading libCstd_isa.so.1 detected a multithreaded program (/opt/SUNWspro/bin/../WS6U2/bin/sparcv9/dbx) run "-c /prod/sys/remedyb/conf/ar.conf -d" Running: arupora -c /prod/sys/remedyb/conf/ar.conf -d (process id 26336) SQL tracing initiated to file /usr/tmp/arsql.log signal SEGV (no mapping at the fault address) in lmsaicmt at 0xfef9fcec 0xfef9fcec: lmsaicmt+0x007c:lduh[%i5 + 0x24], %o3 The arupora program is generating a file in /var/tmp that is named aaa. This file looks to contain a bunch of updates, stored in xml format, e.g.: 9\1\282054 ... Axton Grams On 10/13/06, Shellman, David <[EMAIL PROTECTED]> wrote: > Axton, > > If it's an upgrade and not a patch then this is the one that we were > also waiting for. We had gotten an email on the 5th that noted the > release was going to be "within the next week." I thought that there > would have been more of a formal announcement from BMC/Remedy. At least > a note on the What's Hot on the Support web site given the Tech Alert: > Upgrade to ARS 7.0 Unicode is not yet possible note on the site. > > Thanks, > Dave > > >Date:Thu, 12 Oct 2006 09:56:26 -0400 > >From:Axton <[EMAIL PROTECTED]> > >
Re: ARServer 7.0.1 Upgrade Installer
One would think there would have been some type of announcement. I have received confirmation from BMC that this is the maintenance release that is supposed to address the unicode upgrade issues. The problem is that the arupora utility dies due to a segmentation fault and core dumps. I'm working with BMC to resolve this issue, but it's rather slow going at this point. I'm hoping someone else in the community has or will attempt the following and share their experience: Upgrade from ARS 6.0.1 to ARS 7.0.1 App Server: SunOS 5.9 Database: Remote Oracle 9i Oracle Client on App Server: 10.2.0.whatever Db Charset: UTF-8 I am using the following for the LANG and NLS_LANG on the app server: LANG=en_US.UTF-8 NLS_LANG=american_america.AL32UTF8 ar_install calls a binary name arupora that is included with the install files. This program connects to the oracle db directly and gathers/updates a bunch of data. This program generates a segfault before it completes. The script exits with the following text: Running DB upgrade. This may take several minutes Running DB upgrade. /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 1 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ End of Stage 2 of 2 /* Fri Oct 13 10:03:35 2006 */ Start of Stage 1 of 21 /* Fri Oct 13 10:03:35 2006 */ Upgrade old field-lengths codeset=0 'windows-1252' errorCode=0 An error was encountered during the upgrade of the ORACLE database ./ar_install: test: argument expected The core file is generated in the target installation directory. While running truss, I see the following output just before it core dumps: time() = 1160672159 lseek(3, 64878, SEEK_SET) = 64878 write(3, " / * T h u O c t".., 123) = 123 write(6, "\0ED\0\006\0\0\0\0\003 ^".., 237) = 237 read(6, "019B\0\006\0\0\0\0\01019".., 2064) = 411 time() = 1160672159 lseek(3, 65001, SEEK_SET) = 65001 write(3, " / * T h u O c t".., 37) = 37 write(6, "\015\0\006\0\0\0\0\00305".., 21) = 21 read(6, "\0E0\0\006\0\0\0\0\00601".., 2064) = 224 Incurred fault #6, FLTBOUNDS %pc = 0xFE1872FC siginfo: SIGSEGV SEGV_MAPERR addr=0x Received signal #11, SIGSEGV [default] siginfo: SIGSEGV SEGV_MAPERR addr=0x If I attach a debugger to the arupora utility and execute it, I get the following: dbx arupora dbxenv suppress_startup_message 6.2 Reading arupora Reading ld.so.1 Reading libclntsh.so.10.1 Reading libnsl.so.1 Reading libsocket.so.1 Reading libgen.so.1 Reading libdl.so.1 Reading libaio.so.1 Reading librt.so.1 Reading libkstat.so.1 Reading libm.so.1 Reading libthread.so.1 Reading libw.so.1 Reading libc.so.1 Reading libicuucbmc.so.32 Reading libicui18nbmc.so.32 Reading libicudatabmc.so.32 Reading libiostream.so.1 Reading libCstd.so.1 Reading libCrun.so.1 Reading libnnz10.so Reading libsched.so.1 Reading libmp.so.2 Reading libmd5.so.1 Reading libpthread.so.1 Reading libc_psr.so.1 Reading libCstd_isa.so.1 detected a multithreaded program (/opt/SUNWspro/bin/../WS6U2/bin/sparcv9/dbx) run "-c /prod/sys/remedyb/conf/ar.conf -d" Running: arupora -c /prod/sys/remedyb/conf/ar.conf -d (process id 26336) SQL tracing initiated to file /usr/tmp/arsql.log signal SEGV (no mapping at the fault address) in lmsaicmt at 0xfef9fcec 0xfef9fcec: lmsaicmt+0x007c:lduh[%i5 + 0x24], %o3 The arupora program is generating a file in /var/tmp that is named aaa. This file looks to contain a bunch of updates, stored in xml format, e.g.: 9\1\282054 ... Axton Grams On 10/13/06, Shellman, David <[EMAIL PROTECTED]> wrote: Axton, If it's an upgrade and not a patch then this is the one that we were also waiting for. We had gotten an email on the 5th that noted the release was going to be "within the next week." I thought that there would have been more of a formal announcement from BMC/Remedy. At least a note on the What's Hot on the Support web site given the Tech Alert: Upgrade to ARS 7.0 Unicode is not yet possible note on the site. Thanks, Dave >Date:Thu, 12 Oct 2006 09:56:26 -0400 >From:Axton <[EMAIL PROTECTED]> >Subject: Re: ARServer 7.0.1 Upgrade Installer > >7.0.1 was released at the beginning of the month. This was not a >patch, but an upgrade. I was assuming this was the release that >support/engineering keeps referencing every time I've spoken with them >in the last few months. > >Axton Grams Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisb
Re: ARServer 7.0.1 Upgrade Installer
Axton, If it's an upgrade and not a patch then this is the one that we were also waiting for. We had gotten an email on the 5th that noted the release was going to be "within the next week." I thought that there would have been more of a formal announcement from BMC/Remedy. At least a note on the What's Hot on the Support web site given the Tech Alert: Upgrade to ARS 7.0 Unicode is not yet possible note on the site. Thanks, Dave >Date:Thu, 12 Oct 2006 09:56:26 -0400 >From:Axton <[EMAIL PROTECTED]> >Subject: Re: ARServer 7.0.1 Upgrade Installer > >7.0.1 was released at the beginning of the month. This was not a >patch, but an upgrade. I was assuming this was the release that >support/engineering keeps referencing every time I've spoken with them >in the last few months. > >Axton Grams Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
Hi, AR 7.0.01 installer has this upgrade utility inbuilt. So if you are using a prior version of AR Server with Unicode Database, AR 7.0.01 installer will handle the upgrade seamlessly now. Please refer to release notes for AR 7.0.01 for more explanation. Thanks Anand Ahire, Product Manager, Service Management Business Unit BMC Software, Sunnyvale, CA ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
7.0.1 was released at the beginning of the month. This was not a patch, but an upgrade. I was assuming this was the release that support/engineering keeps referencing every time I've spoken with them in the last few months. Axton Grams On 10/12/06, Shellman, David <[EMAIL PROTECTED]> wrote: James and Axton, As noted there is an issue with the 7.0 and 7.00.01 upgrade scripts concerning Unicode. Biggest issue seems to be an issue with the presentation layer and how the data was stored if views were localized. My understanding is that the upgrade script will be included with the next release (7.0.1 or 7.1 not sure of the official numbering scheme). AT BUW, we were told that the release date for this version was to be the middle of October. I haven't heard that of any slip in the release date so we should hear something at any time. Dave >Date:Wed, 11 Oct 2006 13:49:14 -0700 >From:"McKenzie, James J C-E LCMC HQISEC/L3" <[EMAIL PROTECTED]> >Subject: Re: ARServer 7.0.1 Upgrade Installer > >Axton: > >I don't know. I don't work with Unicode databases, yet. > >I too would like to know about this functionality. > >James McKenzie Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
James and Axton, As noted there is an issue with the 7.0 and 7.00.01 upgrade scripts concerning Unicode. Biggest issue seems to be an issue with the presentation layer and how the data was stored if views were localized. My understanding is that the upgrade script will be included with the next release (7.0.1 or 7.1 not sure of the official numbering scheme). AT BUW, we were told that the release date for this version was to be the middle of October. I haven't heard that of any slip in the release date so we should hear something at any time. Dave >Date:Wed, 11 Oct 2006 13:49:14 -0700 >From:"McKenzie, James J C-E LCMC HQISEC/L3" <[EMAIL PROTECTED]> >Subject: Re: ARServer 7.0.1 Upgrade Installer > >Axton: > >I don't know. I don't work with Unicode databases, yet. > >I too would like to know about this functionality. > >James McKenzie Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] tyco/Electronics A tyco International LTD Company MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
Getting other nice error messages upgrading to 7.0.1. The isntaller does some changes on the form 'Business Time Workdays', but the installer are looking for the form: 'Business Times Workdays' Of course it fails -- Jarl On 10/11/06, Axton <[EMAIL PROTECTED]> wrote: Has anyone run the ARS 7.0.1 upgrade installer against 6.0.1 on Solaris 9 using a UTF8 database? The installer (arupora) crashed (segmentation fault) during the installation. Looking for someone in the same environment so I can compare notes. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
Title: RE: ARServer 7.0.1 Upgrade Installer ** Axton: I don't know. I don't work with Unicode databases, yet. I too would like to know about this functionality. James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, October 11, 2006 1:47 PM To: arslist@ARSLIST.ORG Subject: Re: ARServer 7.0.1 Upgrade Installer I'm reading the release notes and I'm not seeing anything indicating this. There are items in the release notes that state it is not possible to upgrade your non-unicode db to a unicode db, but not from unicode to unicode. The What's Hot article states the following: "Due to an inconsistency in the way ARS meta data was stored in previous non-Unicode compliant versions of ARS (including ARS 6.3) you currently cannot upgrade to an ARS 7.0 server running on a Unicode database. Even if you are running an older version of ARS on a Unicode database, you can only migrate (not upgrade) your applications to a 7.0 server running Unicode. If you are running an older version of ARS on a non-Unicode database, you can upgrade that server to 7.0 (non-Unicode). If the desired end result is to be running ARS 7.0 on Unicode, you must do a new install of ARS 7.0 on your Unicode DB, then migrate your forms, workflow and data from your old server to the new server. An upgrade utility will be available in the next maintenance release of the ARServer that will resolve this issue when upgrading to ARS 7.0 Unicode. Currently the only way to migrate is to use the BMC Migrator tool." So where is the upgrade utility? Axton Grams On 10/11/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote: > ** > > > Axton: > > It is not possible to upgrade a UTF-8 database at this time. > > James McKenzie > L-3 GSI > > > > -Original Message- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton > Sent: Wednesday, October 11, 2006 12:40 PM > To: arslist@ARSLIST.ORG > Subject: ARServer 7.0.1 Upgrade Installer > > Has anyone run the ARS 7.0.1 upgrade installer against 6.0.1 on > Solaris 9 using a UTF8 database? The installer (arupora) crashed > (segmentation fault) during the installation. Looking for someone in > the same environment so I can compare notes. > > Thanks, > Axton Grams > > __ > _ UNSUBSCRIBE or access ARSlist Archives at > http://www.wwrug.org __20060125___This posting was > submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: ARServer 7.0.1 Upgrade Installer
I'm reading the release notes and I'm not seeing anything indicating this. There are items in the release notes that state it is not possible to upgrade your non-unicode db to a unicode db, but not from unicode to unicode. The What's Hot article states the following: "Due to an inconsistency in the way ARS meta data was stored in previous non-Unicode compliant versions of ARS (including ARS 6.3) you currently cannot upgrade to an ARS 7.0 server running on a Unicode database. Even if you are running an older version of ARS on a Unicode database, you can only migrate (not upgrade) your applications to a 7.0 server running Unicode. If you are running an older version of ARS on a non-Unicode database, you can upgrade that server to 7.0 (non-Unicode). If the desired end result is to be running ARS 7.0 on Unicode, you must do a new install of ARS 7.0 on your Unicode DB, then migrate your forms, workflow and data from your old server to the new server. An upgrade utility will be available in the next maintenance release of the ARServer that will resolve this issue when upgrading to ARS 7.0 Unicode. Currently the only way to migrate is to use the BMC Migrator tool." So where is the upgrade utility? Axton Grams On 10/11/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote: ** Axton: It is not possible to upgrade a UTF-8 database at this time. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, October 11, 2006 12:40 PM To: arslist@ARSLIST.ORG Subject: ARServer 7.0.1 Upgrade Installer Has anyone run the ARS 7.0.1 upgrade installer against 6.0.1 on Solaris 9 using a UTF8 database? The installer (arupora) crashed (segmentation fault) during the installation. Looking for someone in the same environment so I can compare notes. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARServer 7.0.1 Upgrade Installer
Title: RE: ARServer 7.0.1 Upgrade Installer ** Axton: It is not possible to upgrade a UTF-8 database at this time. James McKenzie L-3 GSI -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton Sent: Wednesday, October 11, 2006 12:40 PM To: arslist@ARSLIST.ORG Subject: ARServer 7.0.1 Upgrade Installer Has anyone run the ARS 7.0.1 upgrade installer against 6.0.1 on Solaris 9 using a UTF8 database? The installer (arupora) crashed (segmentation fault) during the installation. Looking for someone in the same environment so I can compare notes. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
ARServer 7.0.1 Upgrade Installer
Has anyone run the ARS 7.0.1 upgrade installer against 6.0.1 on Solaris 9 using a UTF8 database? The installer (arupora) crashed (segmentation fault) during the installation. Looking for someone in the same environment so I can compare notes. Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org