Home Informatica rules
Welcome to my repository
Informatica rules

Informatica rules (22)

Informatica rules section groups all articles defining important rules concerning informatica

Children categories

Flat Files rules

Flat Files rules (5)

Flat file category contains all, important, rulles about flat files in informatica.

View items...
Code Page rules

Code Page rules (5)

Code Page rules in Informatica.

View items...
PowerExchange rules

PowerExchange rules (5)

Important PowerExchange rules

View items...
Java and MQ Series

Java and MQ Series (3)

Rules concerning Java and MQ Series.

View items...
Informatica PowerCenter administration

Informatica PowerCenter administration (3)

The category covers Informatica PowerCenter administration issues.

View items...

Errors (1)

In some cases Power Center behaves not according to requirements. The category contains solutions to such cases

View items...

Informatica PowerExchange can integrate PowerCenter with i5/OS. PWX listener job which runs on I5/OS (as/400, iseries) takes part in code page conversion. Setting CCSID for the job equal to 65535 causes peculiar errors. It is due to lack of the code page conversion when there is no interaction witch physical files. For instance, following sql sentence written in Source Qualifier SQL Overide


select  'something'  from existingtable


returns to PowerCenter string 'something' but as HEX representation of the string being in EBCDIC code page. It means we receive not 9 chatacters but 18. Therefore, we can have erros informing about field to long while reading data or confusing, unexpected string of characters (for instance HEX string).


The soluting is setting code page other then 65535. Of cource the code page should be compatible with data read from the i5/OS machine.    

The "unable to create new native Thread" error can be caused by linux maximum number of allowed processes. Check ulimit -a.

Problem description.

The following error was found in the session log.


Lookup query is about to be executed.

Database driver event...

FnName: Execute -- [Informatica][ODBC SQL Server Driver]20152

FnName: Execute -- 523 158]

Error in lookup sql statement execute.


There were 5 fields read by lookup transformation from MSSQL database. When removed any 3, no errors noticed. When removed only 2, above errors where generated.


The failing transformation was removed and created again. No errors noticed.

In a well known financial institution was developed workflow with 47 concurrently running sessions. Each session was populating one table by doing table copy between source and target. The purpose of the workflow was to make full target refresh, which is usually required before incremental replication. As full refresh is a very rare operation, the workflow had not been run for months. One day, the workflow was going to be used. As there was no modification to the workflow, no one expected any errors.

Our workflow was ended with following error:


[Informatica][SCLI PWX Driver] PWX-33312 xxxxxxxxx:42915 : Partially completed network transmission timed out after 1322 seconds (bytes completed: 72484 mode: R)

Database driver error...

Function Name : Fetch

SQL Stmt : …..

PowerExchange (PWX) can be configured to capture changes from journal located on as/400. In the case I am writing, it was necessary to change just journal and tables library from which data were to be read. Let's say old library was named OLDLIB and new library was named NEWLIB. Data library that is library with CFG file was named DATALIB. Mention above configuration change can achieved by following update


replace(CCTDTA ,'"OLDLIB.','"NEWLIB.')

There is additional condition. Length of CCTDTA must be the same before and after update.


The above update is not mentioned in any manual I am aware of. Additionally, there are two locations where journal name and library is configured and it must be updated to new value:

  • dbmover member in cfg file.
  • Condense configuration in condense library.

Licence of Informatica PowerExchange for i5/OS (as/400) is defined using i5/OS machine IP address. 

After domain name change, PowerExchange did not start. In the PWX log was pointed out that licence key is not correct.


Problem was solved by adding full host name (with domain name) to the host table.  

In some cases, we seems to experience code page issue. Once, I had to run PowerCenter workflow which read data from db2 database to a flat file.  The problem was with vargraphic field defined as nstring in source qualifier. Changing nstring type to string solved the problem. Nstring and string are treated differently by Integration Service.

It is worth to notice a paragraph in the MQ Series configuration file located in folder <MQ Series Installation folder>\conv\table\ccsid.tbl

It is said as follows:

The most likely reason for the following error in "Domain logs":

Service Process [IS_ascii] output error [ERROR: Unexpected condition at file:[..\utils\pmmetrics.cpp] line:[2111]. Application terminating. Contact Informatica Technical Support for assistance.].

Page 1 of 2