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"
