top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica Powercenter data truncation/overflow error

+3 votes
1,131 views

I'm trying to make a simple data loading with an IPC mapping from one Oracle DB to another.

The source table structure is following:
ID NUMBER;
C_VALUE VARCHAR2 (16);
C_CODE VARCHAR2 (16);
SN NUMBER;
SU NUMBER;

The target table structure is following:
ID NUMBER
C_VALUE VARCHAR2 (20)
SSID NUMBER
LOADID NUMBER
LOADROWNUMBER NUMBER
DATEBEGIN DATE
DATEEND DATE

When I'm running the workflow I'm getting the following error:

8340||Error: Target table [TYPE_ACC_RRB] data truncation/overflow error.

When I'm trying to debug my mapping, I'm seing that my input string in the c_value field is presented by the unicode characters and it's length is doubled in bytes.

Does the Informatica count chars of bytes as the length of it's string fields? How to make it see for chars, not for bytes?

What I see from the session log is:
Server Mode: [UNICODE]
Server Code page: [UTF-8 encoding of Unicode]
The session sort order is [Binary].
Source database connection [RBO01] code page: [MS Windows Cyrillic (Slavic)]
Target database connection [STG1] code page: [MS Windows Cyrillic (Slavic)]

My mapping:
enter image description here

posted Nov 27, 2014 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

If you are expectung multilingual content, Your integration service should be configured to run in unicode mode. This should also sync up with the character set of your source and target databases. Check with ur admin.

answer Dec 3, 2014 by Raghvendra Sharma
Similar Questions
+1 vote

I get this error at the moment of create domain on informatica Powercenter 8.6.1 silent install :

Informatica PowerCenter 8.6.1

Cannot create domain.

The installer could not create the domain. Correct the error below and select
Retry. You must successfully create the domain to continue the installation.
DEFINE_NODE_STDOUT:
DEFINE_NODE_STDERR:java.lang.UnsatisfiedLinkError: pmjrepn (A parameter must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)
at java.lang.ClassLoader.loadLibraryWithClassLoader(ClassLoader.java:921)
at java.lang.System.loadLibrary(System.java:452)
        at com.informatica.powercenter.sdkint.repository.ILocaleManager.<clinit>(ILocaleManager.java:38)
at java.lang.J9VMInternals.initializeImpl(Native Method)
at java.lang.J9VMInternals.initialize(J9VMInternals.java:187)
        at
com.informatica.pcsf.infacmd.InfaCmdMainLoop.mainLoop(InfaCmdMainLoop.java:100)
at com.informatica.pcsf.infacmd.InfaSetupMain.main(InfaSetupMain.java:34)
Exception in thread "main" java.lang.UnsatisfiedLinkError: pmjrepn (A parameter
must be a directory.)
at java.lang.ClassLoader.loadLibraryWithPath(ClassLoader.java:952)

Any ideas?

0 votes

Teradata : JANUVIA - 50MG – TABLET - 1 BLISTER - 28 TABLET (28.TA) ORacle: JANUVIA - 50MG ? TABLET - 1 BLISTER - 28 TABLET (28.TA)

We are using code page 'ms windows latin 1 (ansi) superset of latin1' for source connection i.e. Teradata.

We are using code page UTF 8 for target

+2 votes

I'm trying to load within an Oracle XE 10g database. When I run an Informatica PowerCenter Workflow, I get a following error:

CMN_1022    Database driver error...
CMN_1022 [Database driver event...Error occurred loading library [pmora8.dll]. System error encountered is 193. Error text is %1 is not a valid Win32 application.
.]

Any ideas what might be causing this error? My environment is as follows:
•Windows Server 2008 R2
•Informatica PowerCenter 9.5
•Oracle XE 10 G

Powercenter repository is on SQL Server 2012.

+2 votes

Can you please help me to find out solution for the below error message.

UTY4014 Access module error '34' received during 'set position' operation: 'pmUnxDskSetPos: fseek error (System error message detected: 29)'

Overview of the mapping: My Source is Oracle and Teradata, I am joining both the tables in my mapping and loading it into the teradata table.

Any suggestion?

...