top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Error while loading the data through informatica mapping

+2 votes
420 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.

0 votes

While Installing Informatica i am getting this ERROR....

The command to create the domain failed. Select OK to correct the domain information and try the command again. Select Continue to continue the installation without creating the domain. You can run the command to create the domain after installation. Review the log files for more information.

Informatica_9.0.1_Services_HotFix2.log [LOG FILES SAY'S]

Domain name: : Domain_SONY 
Node host name: : SONY 
Node name: : node01_SONY 
Node port number: : 6005 
NODE_ADDRESS : SONY:6005
LOGS_DIRECTORY : C:\Informatica\9.0.1\isp\logs 
BACKUP_DIRECTORY : C:\Informatica\9.0.1\server\infa_shared\Backup 
DOMAIN_USER : Administrator 
  DOMAIN_PSSWD : ***** 
    NODEOPTIONS_XML : C:\Informatica\9.0.1\isp\bin\nodeoptions.xml 
Exit Code : -1

OutPut : [ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002} Cannot create domain, operation failed with error: [INFASETUP_10000] C:\Informatica\9.0.1\tomcat\conf\server.xml (The system cannot find the file specified).]. Error :

I Think i need to fix server.xml file but HOW?
ANY HELP WOULD BE APPRECIATED..

...