Bookshelf: Unicode Issues with Informatica and the Siebel Data Warehouse

Siebel Data Warehouse Installation and Administration Guide > Troubleshooting the Siebel Data Warehouse > Running the Data Migration Workflow for Preconfigured Siebel Industry Applications Content >

Unicode Issues with Informatica and the Siebel Data Warehouse

Problem. Task fails and generates the error message: "TRANSF_1_1_1_1> TE_7073 Aggregate Error: Expecting keys to be ascending." Tasks known to fail are SDE_DtlForecastFact and SDE_CostList

Workaround. In Informatica Mapping Designer, open the corresponding mapping and in the Aggregator transformation, remove the check from the Sortedinput check box.

Problem. In the Windows 2000 environment, with a double-byte language, such as Japanese, when you try to input the path for the directory where Informatica is installed (such as c:\Program Files\Informatica\Informatica PowerMart 6.2.1 Siebel XXX(JPN char) OEM - Server) for the value $PMRootDir in the Workflow Manager, the double-byte characters are converted to question marks. This causes the ETL to fail because it cannot find the Informatica PowerMart 6.2.1 Siebel OEM - Server folder and its subdirectories.

Workaround. Share the folder under a new name with no double-byte characters, and use the network share as the value for $PMRootDir.

Problem. When Configuring the Informatica Server or Informatica Repository Server, there are major truncations in some of the tabs.

For example, in the Server tab and the Repository tab in the Configure Informatica Service screen (Start > Programs > Informatica Server > Informatica Server Setup > Configure Informatica Service), the field names are truncated.

Workaround. Informatica 6.x does not support non-English messages and resources. Delete the following files to display all messages in English.

PC/PM client folder\*411.dll

PMServer folder\bin\*411.dll

PMRepServer folder\bin\*411.dll

Problem. Unable to start the Informatica repository with the Informatica Repository Server on UNIX.

The Siebel_DW_Rep (MS Windows Japanese and superset of Shift-JIS) is not compatible with that of pmrepagent (UTF-8 encoding of Unicode).

Solution. Make sure Japanese locales are installed on the UNIX machine. The environment variables on the UNIX machine are not complete. Set the environment variable PM_CODEPAGENAME to MS932. For other languages, set the variable appropriately.

Problem. The database connection code page is incorrect for Unicode/Non-Latin code pages.

Workaround. The database connection code page has to be set manually through the informatica Workflow Manager.

Start the Workflow Manger.
Connect to the Siebel_DW_Rep using Administrator as the user.
Click Menu Connection > Select Relational.
Select the appropriate OLTP connection (DB2_OLTP for DB2, ORA_OLTP for Oracle, MSSQL_OLTP or ODBC_OLTP for MSSQL).
For the code page select the UTF-8 encoding of Unicode or the appropriate code page, and then click OK.
Select the OLAP connection (DB2_OLAP for DB2, ORA_OLAP for Oracle, MSSQL_OLAP or ODBC_OLTP for MSSQL).
For the code page select the UTF-8 encoding of Unicode or the appropriate code page, and then click OK.

Problem. Unable to install Informatica PowerMart on non-English UNIX locales (for example, ESN, DEU, FRA, ITA). The following error message appears: "FATAL ERROR during initialization, Invalid language specified, Application terminated."

Workaround. This error will occur when the locale environment variables are set inconsistently or not at all. These settings are determined by entering the command locale at the UNIX command prompt. Make sure the correct locales are installed on the UNIX machine. Set the environment variable PM_CODEPAGENAME correctly (For example set it to MS932 for Japanese).

Siebel Data Warehouse Installation and Administration Guide
Published: 11 March 2004