Empty record gets created with record producer

Jonas VK
Tera Guru

Hi all, 

I have this strange issue that every time I use my record producer to create records, it will always create an empty record.
The other records also get created but with an error of duplicate key because of it.
I can't seem to figure out where it comes from, and I wonder if anybody could have some tips on tracking where this comes from. 

this is a record that always gets created
find_real_file.png

1 ACCEPTED SOLUTION

Hajar BENJAHHAR
Mega Sage

Hello, 

An empty field will be always created because there is no mapping except the script  you have shared. 

So I propose this solution for your requirement : 

  Create a business rule that delete the empty record.

For my case I create a record producer that points to the incident table : 

find_real_file.png

Businnes rule : 

find_real_file.png

find_real_file.png

 

Here the test when business rule is inactive : 

find_real_file.png

as you can see there is two records : The extra empty record. 

Now after activating the business rule : 

find_real_file.png

if it meets your needs, change only the conditions that allow to identify well the empty record. 

 

View solution in original post

13 REPLIES 13

Can you share the script here?

What happens if you don't use script?

are you having some other fields which are mapped?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

here is the script. Without the script, it won't add the new records that are created.
these are the only fields used

(function() {

	var rowsInt = producer.stats.getRowCount();

	for(var i = 0; i < rowsInt; i++) {
		var grStat = new GlideRecord('x_pl4_snps_fact');
		grStat.initialize();
		grStat.setValue('date', producer.registration_date);
		grStat.setValue('competency', producer.stats.getRow(i).competency);
		grStat.setValue('metric', producer.stats.getRow(i).metric);
		grStat.setValue('current', producer.stats.getRow(i).current);
		grStat.insert();
	}

})();

Jonas,

Would appreciate screenshot of variable page.

As Sandeep replied, are all fields mapped to a table column? Can it be Field is not specified?

If so, there shouldn't be a need to have a script.

find_real_file.png

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

Is it always for this record producer or all record producers in the instance?

check this out

Record Producer submitting a blank record. Variable values are not mapped to the fields on the targe...

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

only this particular record producer