Record Producer Creating multiple empty records along with original record

Nikhil Sharma
Tera Contributor

Hi,

 

I am trying to build a record producer for inserting records into a table. I am able to see the records, however along with original records there are plenty (50 or 60) of new empty records being generated every time record producer submit button is pressed.

 

I see some articles which suggests to write a business rule to delete empty records however it does not seem to be a good solution, I am not able to understand why is this even happening, is that a bug or by design, please help. Below is the snapshot of the empty records being created.

 

NikhilSharma_0-1668778725465.png

 

5 REPLIES 5

RaghavSh
Kilo Patron

Which table are you working one?

There is probably some BR or some other server script or wf or flow designer is being triggered when a record is created in table.

One thing needs to be checked, if you create a record manually on this table without record producer do you see same behaviour?


Raghav
MVP 2023

vikrantsharma
Kilo Guru

Need more information on this, have you tried to Debug business rule and see what transaction might be running multiple times?

Please make it correct or helpful if this solves or help you with your issue for other to make use it.

Thanks & Regards,
Vikrant Sharma

I have not created any business rule, I just created a record producer. Do you mean that current business rule might be interfering and causing this issue?

Like Raghav has said, it can be anything. You need to isolate that are you sure creating the record producer is causing this? Or is there something else running in parallel. This can be anything.

 

Please make it correct or helpful if this solves or help you with your issue for other to make use it.

Thanks & Regards,
Vikrant Sharma