Axton, Here is what I got back from our DBA.
"The data in the database is in utf8 characterset. The database would not allow it to be stored other than that. The application would have a failure on the storing of invalid characters which would show up on the (application server). I can run the csscan though. The csscan is used when you want to convert your characterset and we do not want to do that." Dave ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Axton Sent: Thursday, January 28, 2010 10:34 AM To: [email protected] Subject: Re: 7.5 Installation Problems (of course!) ** 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]<mailto:[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]<mailto:[email protected]>] On Behalf Of Kemes, Lisa Sent: Monday, January 25, 2010 2:58 PM To: [email protected]<mailto:[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]<mailto:[email protected]>] On Behalf Of Kemes, Lisa Sent: Friday, January 22, 2010 2:25 PM To: [email protected]<mailto:[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]<mailto:[email protected]>] On Behalf Of Tommy Morris Sent: Friday, January 22, 2010 1:25 PM To: [email protected]<mailto:[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]<mailto:[email protected]>] On Behalf Of Kemes, Lisa Sent: Friday, January 22, 2010 12:20 PM To: [email protected]<mailto:[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]<mailto:[email protected]>] On Behalf Of Tommy Morris Sent: Saturday, January 23, 2010 1:56 AM To: [email protected]<mailto:[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]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected]<mailto:[email protected]> ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected]<mailto:[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"
