Process Flow - mapping not inserting data

10-11  Source: Network gathering  Views:0 

Advertisement
I have a process flow that executes three mappings in sequence i.e Map1 -> Map2 -> Map3.
However, sometimes the process flow will execute and no data will be inserted by MAP2, other times it runs ok. If I run the mappings directly data is always inserted.
The only workaround I've found is to add a WAIT of 10sec between Map1 and Map2 in the process flow.
Has anyone come across anything like this and how did you work around or fix it?
OWB 10.2.0.3 btw.
Cheers
Si
PS. transitions are ok.
Hi
If you have any map inputs make sure they are also declared in the processflow map - you basicly need to bind them.
You probably need to investigate from the beginning to understand your result of incoherent data.
What I would to first is.
1. Generete an intermediete code - choose your table as outgroup.
2. Review the code - are there any loading hints ?
3. Debug the map
Check your locations.
If everything seems right then the problem should lay on your workflow manager.
Remember that the workflow manager has only one namespace, so watchout for mapping name. I had strange executions on my PF because one of my maps had a "½" in the name.
Check the settings of the map - if you have enterd a set based run in your map and a row based run in the processflow.
Remember the setting in the processflow is the "superior" one
Just ideas what you can do.
Cheers
Related articles
  • Process Flow - mapping not inserting data 10-11

    I have a process flow that executes three mappings in sequence i.e Map1 -> Map2 -> Map3. However, sometimes the process flow will execute and no data will be inserted by MAP2, other times it runs ok. If I run the mappings directly data is always ins

  • Calling process flow / mapping from comand line on client machine? 10-11

    Looking to call a process flow / mapping from a commad line on the client machine. Online research has found some attempts at it, but nothing solid. I'd like to test this functionality so that I can eventually build these calls into a wrapper used by

  • BDC not inserting data in mandatory fields of MM01 11-30

    Suddenly My BDC for sales maintenance View is not working as it is not inserting data in Mandatory fields.?can any one tell me the reasonHi Satyanarayan, 1. Check ur code in debug to see if your internal table contains value in mandatory fields 2. Tr

  • Process flow/map performance issues 11-30

    We have some issues with our OWB-based application and we're looking to find out if there are different ways we could be using the tool, or features/options we've missed. We are trying to maintain a near real time feed of data from a front end system

  • Process flows are not running in OWB 10-11

    I have a process flow which has a main process and this main process calls 3 subprocesses and 1 externel process. This workflow was running fine and it suddenly stopped working and when I try to run it from WF monitor it is giving the following error

  • Can not insert Data 10-11

    Hi all ; when tryiing to call a stored procedure from java session bean ,i am getting this error message: [BEA][Oracle JDBC Driver][Oracle]ORA-20000: Records are not inserted into the stagging table ORA-06512: at "APPS3_MTNAOL.MTN_INV_MANAGER",

  • Could not insert Data in to the table 10-11

    hello friends I have some pbm in inserting values in to sqlserver database table.I could not insert values to the table having varchar datatype fields.partyType is a field name of varchar type.when i try to insert "LCL" for that field it throws

  • Running of process flow does not show any Active session in Database 10-11

    Hi Team, I am running a process flow in OWB 11g ( From Design Center ) which is having around 100 maps within it. However, from Control Center I can see the Process Flow is running ( i.e. Green check is visible beside the process flow) but when I run

  • Function to call Process-flows/mapping from SQL 11-30

    Hi All, Can any one of you send me the function to call process-flows/mappings (eg: I have 10 mapping/Process-flows). It is an urgent requirement pending in my final testing. Plz help me in this regard. RegardsHi All information that you need, you ca

  • JDBC Not INSERTING Data 11-30

    Hi All, I'm having a real problem with the below method titled Not Working:. This method will INSERT data into a MS Access data base all day long, but it will always insert it at the same record. It never actually creates a new record, inserts the da

  • Scheduled process flows are not running automaticaly-OWB database clonning 11-30

    What I did: 1.     Cloned the entire OWB repository database from live (bidb01.bh.xyz.com) server to new (green1.bh.xyz.com) server. ******     Source     New Physical Hostname     bidb01.bh.xyz.com     green1.bh.xyz.com DB Logical Hostname     xyzbi

  • Process flow is not working for both workspace. 11-30

    Hello, I really need help. I have prodution issue now. I am using OWB 11g version. I have two wokspace running on the same database. Workspace names are MSSTATE_OWBOWNER, IAEBT_OWBOWNER. The automatic job is not kicking of on both. I scheduled MSSTAT

  • Can not Insert data to Microsoft Access successfully 10-11

    I am using Microsoft Access database, and trying to insert some data into a table with a "while" loop, but every time, the last row can not be inserted although the return value of the "executeUpdate()" is 1, can anyone tell what's wro

  • Concurrent program Do not Insert Data Into Interface Tables! 10-11

    Hi there: I am facing a problem with my concurrent program whenever I execute my stored procedure in SQL/PLUS it's work fine data load into the AP_INTERFACE/LINES. Whenever I try to load data through my concurrent programs it doesn't load into AP_INT

  • Can not insert data to MS Access 10-11

    Hi All, I have create a table by manual in Access , in which I defined souch fields: SORTCODE(text type),FOODNAME(text type)..., and then I use follow statement to insert value : private DefaultTableModel model = new DefaultTableModel(); Vector colle

  • Wrong map being executed in Process Flow 11-30

    I created a Process Flow that executes 3 maps and a PL/SQL procedure. The process flow functions to write data to a Unix file system. The first map when executed by itself writes the correct string as the first header within the file. But when I exec

  • Conversion error in process flow 10-11

    I've build a process flow with the following construction 1. Function call (DB) which returns a date via a OUT parameter (Checked) 2. Bound the OUT parameter to a Process-flow parameter of type date 3. Use the proces-flow parameter to bind a input pa

  • Using a function within a process flow... 11-30

    Hi, I'm trying to figure out a way of using a function (or something else) to return a status before attempting to run a mapping. I'd like to have a table with all my mappings, start date, end date, status, etc. 1. SELECT status FROM table, if the ma

  • OWB 10.1 -- How to make a JOB agains a process flow. 11-30

    Dear All I have created mapping and make a process flow. Deploy and generation done successfully. If i execute my process flow it whole bring data from source table to detination warehouse schema table. I want this process automate and run it daily a

  • OWB Process Flow Execution in Workflow 10-11

    Hi! I hope somebody can help me with this one... I have a process flow designed to load data from a flat file to a db staging table then do some transformation on the data and load the data to the data warehouse. I am using OWB 9.2.0.2.8, 9i DB (9.2.