Originally posted by: Rav052

I have a WTX 8.4 map on Wmb 8.0 (Linux) server, a simple one which has DB connection in the map through .mrn. 

Issue - When I process a single file, it inserts 2 records in the table with input filename. 

For ex : If input filename is DSTX.20170610:

FileReceive (table)

==

DSTX.20170610

DSTX.20170610

I see the .dbl file where the database connection happens twice with same date and time. This happens on the server.

FYI : We receive the file from WMB. WMB will ftp pull the file and move it to WTX map.

Appreciate your help!!

Originally posted by: PrincesseJane

Activate unique map audit logs, and then we can see how many times the map executes.  Do you have Burst mode on?

Jane.

Originally posted by: Rav052

Hello Jane,

Thank you for the response.

I have an existing setting with Audit Unique and Backup of Input card.

On server, below files are created:

Run_XXXXXX_03_I2.bak

Run_XXXXXX_03.log

Run_XXXXXX_05_I2.bak

All these files creation datetime is same. The above audit log reads the input only once.

Kindly let me know if you need further details. Thank you again.

Originally posted by: PaulBrett

I recommend you reinstall the triggering script in Oracle, after checking that you do not have multiple copies (under different users).  Examine m4ora.sql for clues on procedure names you need to check for.

Thank you.

Paul

Follow me on Twitter

Originally posted by: Rav052

Hi Paul,

Currently, we are inserting data into view. This view or the dependent table doesn't have trigger on it.

Also in the old WMB server (version 6), we inserted data once successfully to same view from WTX 8.2

Thanks,

Rav

Originally posted by: PaulBrett

Sorry, I thought you were double triggering a WTX map from a data insert to a database.

So, your map is triggering from a file, and supposed to insert 1 row, but inserts 2?  Change the target of the map to file.  What results does that show?

Thank you.

Paul

Follow me on Twitter

Originally posted by: TarunB

So the assumption is that your map is triggered only the once from your input file. Is your DB insert performed within a functional map? 

If so, check the parameters that you pass to the functional map to see if there is any chance of it being run more often than you might expect. 

If you need to investigate further, simplify the map and the DB call as far as possible so as to eliminate as many factors as you can.