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 <
dave.shell...@tycoelectronics.com> 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:
> arsl...@arslist.org] *On Behalf Of *Kemes, Lisa
> *Sent:* Monday, January 25, 2010 2:58 PM
>
> *To:* arslist@ARSLIST.ORG
> *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:
> arsl...@arslist.org] *On Behalf Of *Kemes, Lisa
> *Sent:* Friday, January 22, 2010 2:25 PM
> *To:* arslist@ARSLIST.ORG
> *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:
> arsl...@arslist.org] *On Behalf Of *Tommy Morris
> *Sent:* Friday, January 22, 2010 1:25 PM
> *To:* arslist@ARSLIST.ORG
> *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:
> arsl...@arslist.org] *On Behalf Of *Kemes, Lisa
> *Sent:* Friday, January 22, 2010 12:20 PM
> *To:* arslist@ARSLIST.ORG
> *Subject:* Re: 7.5 Installation Problems (of course!)
>
>
>
> **
>
> Thank Tommy! What file is this in?
>
>
>
> Lisa
>
>
>
>
> ------------------------------
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> arsl...@arslist.org] *On Behalf Of *Tommy Morris
> *Sent:* Saturday, January 23, 2010 1:56 AM
> *To:* arslist@ARSLIST.ORG
> *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: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the
> Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where
> the Answers Are"_
> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers
> Are"_
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
