top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

Error while loading the data through informatica mapping

+2 votes
371 views

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?

posted Sep 26, 2014 by Sachin

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

1 Answer

0 votes

If it's MLOAD, the release the MLOAD lock, drop the target table, error tables, log table etc and then rerun the job

answer Oct 6, 2014 by Shweta Singh
Similar Questions
0 votes

I have found the mapping sdk code samples, however without any documentation whatsoever.

Currently working with 9.0, I am looking for more info.

For one of the current issues, when I try to save the mapping to repository, (with pcconfig.properties lying in the same folder where the xml file is being generated), I am getting the following error:

Written the file..

Caught an exception in run() method

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

java.io.IOException: Cannot run program ""C:\Informatica\pmrep"" (in directory "C:\Informatica"): CreateProcess error=2, The system cannot find the file specified

com.informatica.powercenter.sdk.mapfwk.exception.MapFwkOutputException: Error saving to repository :  Failed to connect to repository

    at com.informatica.powercenter.sdk.mapfwk.xml.XMLWriter.save(Unknown Source)

    at com.informatica.powercenter.sdk.mapfwk.repository.Repository.save(Unknown Source)

    at TestRaghavExample.generateOutput(TestRaghavExample.java:259)

    at TestRaghavExample.create(TestRaghavExample.java:64)

    at TestRaghavExample.main(TestRaghavExample.java:272)

Caught an exception in run() method
This is my initial example.. trying to find my way through the API..

+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.

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 am new to informatica. I am using INFORMATICA 9.1.0 and oracle 11g as source and target database. I tried to create one table in target database and tried to load data from source to target. Table is getting created in target database. and I created mapping and workflow which is valid and i start work flow but it gave me following error.

Message Code RR_4036

Message

Error connecting to database [ Arun ORA-00900: invalid SQL statement Database driver error... Function Name : executeDirect SQL Stmt : Arun Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error ].

please help me with good solutions.

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...