Hi, 

Encountering a peculiar issue when working with SQL Insert Data component. Our aim is to set up a scheduled protocol which will run regularly to insert new compounds into a specific table.

Problem brief:

When attempting to insert records into a table via the SQL Insert component, the pipeline shows that it has been successful.

When we later query that table using the IDs that were supposedly inserted (still via Pipeline Pilot):

As you can see, nothing comes back.

However, for the purpose of debugging, we then try to query those IDs in the actual table in database (via SQL Developer), they are not found to be present.

Then in order to infer, if this is an issue with the SQL component or the actual data itself, We then tried to run a sample query via Pipeline pilot to retrieve some records from that same table:

We can view the data that comes back from this query. 

So in essence, we are unable to understand why it shows records as being inserted then nothing actually being present when we query that table (via SQL developer) and the SQL General component in Pipeline Pilot. At the time of trying to understand if this was a syntax issue associated with the INSERT statement, I manually tried it via SQL developer by replacing the parameters with actual values:

The record is successfully inserted and retrieved when i query by its ID:

I then tried to insert hardcoded data values using the same INSERT statement via Pipeline Pilot, and it was successful as I could then see that new row present in the database table. 

So it appears that this issue is specific to when inserting records using Parameter values via SQL INSERT component. 

It is rather bizarre and any help would be highly appreciated!

Thanks,

Kashish