Tuesday, 31 January 2017

[ICMD_10033] Command [defineDomain] failed

ERROR: "[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002] 
       Cannot create the domain because of the following error: [DATAUPGRADE_00023] Internal error. 
  The upgrade handler with unique resource name" in Informatica 9.5.1
While installing Informatica 9.5.1, when using the infasetup.sh upgradedomainmetadata command 
or DefineDomain command, they fail with the following error: 
[ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002] 
Cannot create the domain because of the following error: [DATAUPGRADE_00023] Internal error. 
The upgrade handler with unique resource name 
['rn:publicid:com.informatica//ISPApplicationServiceUpgrade//IMF_Java//2.1.0to2.3.0'] 
and class ['com.informatica.isp.upgradehandlers.version910.ApplicationServiceUpgradeCallback'] 
either does not implement a public no-argument constructor or throws an exception when used..].


Cause:

This issue occurs if the number of open files is set to a lower value. 
Check the value set for open files(descriptors) parameter on the Informatica server 
using ulimit -a or limit command.

This issue is caused due to not having the minimum file descriptor set ?to 8192.
For installations prior to PowerCenter 9.x, it was sufficient 
if the minimum file descriptor was set to 4096. However, 
PowerCenter 9.5.1 needs a minimum setting of 8192 for both hard and soft file descriptors.

Sample ULIMIT output:  
core file size          (blocks, -c) 0  data seg size   
        (kbytes, -d) unlimited  scheduling priority             (-e) 0  file size  (blocks, -f) unlimited  pending signals                 (-i) 262397  max locked memory       (kbytes, -l) 32  max memory size         (kbytes, -m) unlimited  open files                      (-n) 8192            (It should be 16000)  pipe size            (512 bytes, -p) 8  POSIX message queues     (bytes, -q) 819200  real-time priority              (-r) 0  stack size              (kbytes, -s) 10240  cpu time               (seconds, -t) unlimited  max user processes              (-u) 262397  virtual memory          (kbytes, -v) unlimited  file locks                      (-x) unlimited


Solution 

To resolve this issue, set the ulimit for soft and hard file descriptors to a 
minimum of 8192 or a recommended value of 16,000 before continuing the installation.
Informatica 9.5.1 recommends 16000 as the value for file descriptor per process.

Sunday, 29 January 2017

​Code page in file:UTF-8 not compatible with repository code page: MS1252

Problem:

​​
Code page in file:UTF-8 not compatible with repository code page: MS1252
Error encountered while Parsing file


Reason:

This happens when we try to import UTF-8 Code page object to MS1252 Code Page


Solution: Have to Update Encoding and Code Page Details in the XML

Actual File:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">
<POWERMART CREATION_DATE="01/27/2017 12:31:55" REPOSITORY_VERSION="184.93">
<REPOSITORY NAME="RS_etlprod" VERSION="184" CODEPAGE="UTF-8" DATABASETYPE="Oracle">

Update it Like below and Try importing the XML in Repo Manager: 

<?xml version="1.0" encoding="Windows-1252"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">
<POWERMART CREATION_DATE="01/27/2017 12:31:55" REPOSITORY_VERSION="184.93">
<REPOSITORY NAME="RS_etlprod" VERSION="184" CODEPAGE="MS1252" DATABASETYPE="Oracle">



Monday, 23 January 2017

Handling Schema Names in Source and Target of Informatica


on Source side :
Owner Name  :  SCOTT (Schema)
Source Table Name  : Emp (table)
On Target Side :
Table Name Prefix : Scott(schema)
Target Table Name  :  DEPt (schema)
On Lookup :
Lookup table name  needs to be changed.
Keep the OWNER name infront. ie
Example  : 
Lookup table name  :  SCOTT.LOCATIONS

Table looking priority if no owner name is provided
1) Under own schema
2) Public synonym.

Monday, 9 January 2017

Profiling in MySql



​​
SET GLOBAL log_output = 'TABLE';
​​
 SET GLOBAL general_log = 'ON';

SELECT * FROM  mysql.general_log  
Take a look at the table mysql.general_log