We'll keep that as an option. Thanks, Dave
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Misi Mladoniczky Sent: Thursday, January 28, 2010 11:57 AM To: [email protected] Subject: Re: 7.5 Installation Problems (of course!) Hi Dave, This thing is not really something you can change on the fly, I think... I would setup a parallel server, against a new database instance, reimport the definitions and then SYNC the data using the API (RRR|Chive). When you are done do one of the following: 1. switch to the new server 2. redirect your old server against the new dbinstance 3. maybe export/import your new db to the old instance Best Regards - Misi, RRR AB, http://rrr.se ps. Doing an incremental data sync with RRR|Chive against 250 forms and a total of 10 million records took 23 minutes to complete when I last did it two weeks ago. ds. > AMERICAN_AMERICA.WE8MSWIN1252 allows characters that do not translate > properly in AMERICAN_AMERICA.AL32UTF8. Examples are all your 8-bit ascii > characters. The code points are different between the two localizations > which means that some other characters may not render properly depending > on > how things were written and are now being read. Try running Oracle's > csscan > utility against the db to see what comes back. > > Do you see checksum errors in the logs (i.e., invalid definition) in the > arerror.log? > > Axton Grams > > The opinions, statements, and/or suggested courses of action expressed in > this E-mail do not necessarily reflect those of BMC Software, Inc. My > voluntary participation in this forum is not intended to convey a role as > a > spokesperson, liaison or public relations representative for BMC Software, > Inc. > > On Thu, Jan 28, 2010 at 9:15 AM, Shellman, David < > [email protected]> wrote: > >> ** >> We have finally identified the root of the failed installations. Now to >> figure out how to correct this issue. >> >> A couple of years ago we installed 7.01 on a new app server and to a >> separate DB server. We went through the steps of setting the servers up >> to >> for Unicode. We are a world wide company with helpdesks in the US, >> Europe, >> China, Japan, Thailand, etc. We asked questions to support and backline >> engineers to make sure that we had it setup correctly. Last fall we >> upgraded to 7.01. >> >> Turns out we missed a registry setting. On our app servers (development >> and production) NLS_LANG is set to AMERICAN_AMERICA.WE8MSWIN1252. When >> we >> change make the registry setting change to >> NLS_LANG=AMERICAN_AMERICA.AL32UTF8 >> as noted in the installation guide, we start seeing all sorts of errors >> in >> the arerror log about missing forms, missing data, missing workflow, >> etc. >> >> We've not seen a few issues with languages that we can directly relate >> to >> having an incorrect NLS_LANG. We have seen a few issues that were bugs >> in >> the email engine. >> >> Any thoughts on how to correct? >> >> Dave >> ------------------------------ >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *Kemes, Lisa >> *Sent:* Monday, January 25, 2010 2:58 PM >> >> *To:* [email protected] >> *Subject:* Re: 7.5 Installation Problems (of course!) >> >> ** >> >> BMC looked at our logs and among many errors, said that one of the >> errors >> is "because either the Group, User, ReportType, ReportCreator, has bad >> entries or duplicate entries on them." >> There were no duplicates per se, but there were records with duplicate >> Unique Id's in the Unique Identifier (on the Group Form). Not sure why >> the >> system would allow this, but we think it's from doing Copy to New >> actions on >> some of the Groups. Not 100% sure yet is this is one of the culprits >> but we >> are looking into this.... >> >> Lisa >> >> >> ------------------------------ >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *Kemes, Lisa >> *Sent:* Friday, January 22, 2010 2:25 PM >> *To:* [email protected] >> *Subject:* Re: 7.5 Installation Problems (of course!) >> >> ** >> I couldn't find any RIK files under the TEMP directory (should be under >> the >> Utilities folder correct?) >> >> But I did find these logs.... >> >> All the RIK files we can find are: >> ARServer-RIK_PostUpgrade.log >> ARServer-RIK_PostUgradeInstall.log >> ARServer-RIK_PostUpgrade_error.log >> ARServer-RIK_PostUpgrade_apps.log >> >> In the ARServer-RIK_PostUpgrade Log: >> **** Cannot get target schema details from the server specified. >> **** Status List : 1 items >> **** ERROR: #303 ReportType - Form does not exist on server >> **** >> **** Attempting import from schema ReportType in file to ReportType on >> server >> **** The command line option for schema is not valid. Cannot import >> **** Loading Mappings failed: The import was not attempted >> **** >> >> >> If only I can find the command line that is not working... >> >> Lisa >> >> >> ------------------------------ >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *Tommy Morris >> *Sent:* Friday, January 22, 2010 1:25 PM >> *To:* [email protected] >> *Subject:* Re: 7.5 Installation Problems (of course!) >> >> ** >> >> It was in a RIK file. I think that this one in particular was created >> using >> an install utility that BMC provided but you can check in your temp >> directory to see if you can find one there. >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *Kemes, Lisa >> *Sent:* Friday, January 22, 2010 12:20 PM >> *To:* [email protected] >> *Subject:* Re: 7.5 Installation Problems (of course!) >> >> >> >> ** >> >> Thank Tommy! What file is this in? >> >> >> >> Lisa >> >> >> >> >> ------------------------------ >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *Tommy Morris >> *Sent:* Saturday, January 23, 2010 1:56 AM >> *To:* [email protected] >> *Subject:* Re: 7.5 Installation Problems (of course!) >> >> ** >> >> I will apologize for the length of this response but maybe this >> information >> will help BMC to check for the issue that we had first so it will not >> take >> as long to get you up and running. Here is what BMC found during our two >> months of troubleshooting: >> >> >> >> "By the way, Here is the info that tells me difference between this >> build >> vs previous build as even though your installer shows worked sometimes >> but >> it actually were not really was working as expected: >> >> >> >> Here is the working version: >> >> >> >> ***before processing : char-set: windows-1252 >> >> # >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : begin schema >> >> name : Group >> >> >> >> ***type of object 1 >> >> >> >> ***Processing schema : >> >> begin schema >> >> name : Group >> >> core-version : 2 >> >> upgrade-version: 0 >> >> num-fields : 38 >> >> timestamp : 1137189702 >> >> owner : ARSERVER >> >> last-changed : ARSERVER >> >> default-vui : Default Admin View1 >> >> num-vuis : 1 >> >> export-version : 9 >> >> schema-type : 1 >> >> next-field-id : 536870919 >> >> index : 1\179\0 >> >> get-list-flds : >> 7\105\30\0\\106\10\0\\107\10\0\\120\10\0\\115\12\0\\116\17\0\\7\8\0\ >> >> help-text : The "Group" form is a very special form which is >> used >> primarily to define user access to the various features of the Action >> Request System, including fo >> >> help-text : rms, guides, applications, fields within a form, and >> active links. Five special groups are provided by the AR System - >> Public, >> Administrator, Customiz >> >> help-text : e, Submitter and Assignee. The administrator of the >> AR >> System may set up additional groups to reflect various functional >> groups, >> such as a "HD Staff" o >> >> help-text : r "Tech Support" group.For more information on how >> this >> form works to provide access control for your AR System, please refer to >> the >> Action Request Sy >> >> help-text : stem Workflow Administrator's Guide. >> >> object-prop : >> 6\60006\4\0\\60008\40\0\60009\4\0\\60010\4\0\\60018\4\5\Group\60022\4\38\1\33\AR:HN >> ~ c} \ >> >> archive : 0\0\0 >> >> arch-time : 0\0\0\0 >> >> arch-from : >> >> audit : 0\0\0\ >> >> vui { >> >> >> >> >> >> Here is the log that shows it is skipping processing schema because >> missing >> "b" - "before processing : egin schema" >> >> >> >> ***before processing : char-set: windows-1252 >> >> # >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : egin schema >> >> name : Group >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : ui { >> >> id : 20002 >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing : >> >> field { >> >> >> >> ***type of object 0 >> >> >> >> ***before processing :" >> >> >> >> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers >> Are"_ >> >> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers >> Are"_ >> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers >> Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the >> Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: >> "Where >> the Answers Are"_ >> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers >> Are"_ >> > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
