I had a tough time while resolving Informatica repository & Integration services issues. I installed Informatica on Linux platform with no issues but after creating repository, integration service was not getting up. After scrutinizing the issue I found that basically its environmet and language settings at OS and repository services level that was causing the issue so these settings must be properly defined. During repository creation and integration services configuration I faced a problem “UTF-8 encoding of Unicode”, below is the steps how I coped with this issue and made my day happy J
Hope
this will be helpful for the visitors of this page.
Environment:
Informatica 9.0.1
Platform: Linux 5.3 64 bit
Database: Oracle 11.2.0.3 64 bit
client
Informatica Power User:
Oracle
Oracle Client User: Oracle
Step 1: Repository Services
is Up but Integration service is down.
Step 2: Click on Repository
Service “pow_rep” at left pane, “UTF-8 encoding of Unicode” error is appearing.
It shows that its related to some language setting issue because in repository
code page “MS Window Latin 1 (ANSI)” is set and somewhere in the system UTF-8
is set that is not compatible to repository code page language.
Step 3: Click on Integration service “pow_int” at left pane,
it shows Powercenter Integration Service is unavailable.
Step 4: Check environment settings, we found that LANG=en
US.UTF-8 is set in our environment settings.
Step 5: Unset the LANG setting.
[oracle@sun2 bin]$ unset LANG
Step 6: Restart informatica services:
Step 7: Restart repository & integration services, both
went up with no issue.
Please put your comment if this blog is useful for you.
Yours,
Saurabh
“Knowledge brings the power, attitude respect.”
No comments:
Post a Comment