top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Getting error while importing workflow into QA environment from DEV

+2 votes
409 views

I am getting below error while I am trying to import workflow from DEV environment to QA. I was able to import once successful but someone deleted that and now I am trying it again, then it is giving error:

  04/04/2012 16:56:46 ** Importing Mapping: m_BTTC_Load_T3_T1 ...
     : Could not find Transformation definition for: TEMP_BTTC_TABLE_1
     ** Failed to Import: m_BTTC_Load_T3_T1

I tried importing it from Repository Manager. 1st time it was successful exported from Dev and then I imported in QA. But someone deleted whole folder from QA, now I am tring to do it again, but getting above error.

posted Mar 28, 2014 by Madhavi Kumari

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

This typically happens when your mapping is referring to a reusable components (transformation) which is found to be missing. Not necessarily shortcuts, but they can also be the reason of such behavior.

My suggestion is, Re-export (so that the changed dependencies are refreshed in the export file) the workflow from Repository Manager, and then re-import it.

answer Apr 2, 2014 by Shweta Singh
Similar Questions
+1 vote

The command to convert from .xlsx to csv works in putty, but the same when given in informatica fails....I am getting exit error code 32512.

The workflowlog >>

Severity    Timestamp   Node    Thread  Message Code    Message
INFO    9/8/2016 5:28:20 PM Node_BIDEV  140284941813504 LM_36621    Command task instance [Convert_csv]: started command [convert], with pid [14121] on node [Node_BIDEV].
ERROR   9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36623    Command task instance [Convert_csv]: execution of command [convert] did not complete successfully with exit code [32512]
WARNING 9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36626    Command task instance [Convert_csv]: previous command [convert] failed and "run if previous command succeeded" option is set, the remaining commands will not be run.
ERROR   9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36320    Command task instance [Convert_csv]: Execution failed.
WARNING 9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36373    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles] is suspended.
INFO    9/8/2016 5:28:22 PM Node_BIDEV  140285390595840 LM_36375    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles]: Sent suspension email to email user 
WARNING 9/8/2016 5:28:27 PM Node_BIDEV  140284973283072 LM_36371    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles] is aborting.
WARNING 9/8/2016 5:28:27 PM Node_BIDEV  140284973283072 LM_36322    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles]: Execution aborted.

The command script I am using is

libreoffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":"126,0,76,1,2" /var/opt/load/Sourcedata/CUSTOMER_SURVEY/2016Q2_ML_V1.xlsx

Please help me...

+1 vote

I'm loading a file into oracle DB 11g via informatica 9.

The source file contains a polish char in a column given below:
US1_GPBAS - GPRS - dostęp do publicznych APN
When loading into DB, it gets converted to following data:
US1_GPBAS - GPRS - dostęp do publicznych APN
The file encoding of source file is UTF-8. In the DB NLS_CHARACTERSET is AL32UTF8

What could be the issue here.

0 votes

I am working in Informatica project, and we use to trigger the workflow from Autosys and if workflow fails we get the mail. After that we used to check the session log and find out the error message. Generally the error message is a Network error like failed to connect to Database. My Question is there any way to extract only the error message from the session log like "Failed to Connect to database" and send this in mail.

+1 vote

I have to import a stored procedure from Oracle database into Informatica. But when I try to use the Stored Procedure Transformation I cannot view the respective stored procedure. I am using the correct oracle driver since I don't have any trouble in importing target database tables. I tried viewing the stored procedures in the oracle database using select * from all_objects where object_type='FUNCTION' but could not find the function I am looking for. Please advise me on these:

Can we view the list and code of Stored procedure(s)/function(s) in Oracle, what am I missing in Informatica stored procedure transformation?

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