System is creating new records automatically with empty "Created" and "Created by" fields

Farah5
Tera Contributor

I'm dealing with a very strange issue I've never seen before. We have a custom table where you can save a form as a "Draft" (current status = draft). Several fields are required to be filled out before you can even save it as a draft. However, we've noticed that there are a bunch of empty Draft records being automatically created in the system. The record is active, but not a single field on the form is filled out. The strangest thing is that the "Created" and "Created by" fields are empty, and there is no history whatsoever on the record. This makes it extremely difficult to pinpoint when and how these tickets are created. 

Does anyone have any idea of what could cause a record to be automatically created without a "Created" or "Created by" date? This is happening in our DEV, TEST, and PROD instances. There doesn't seem to be any pattern for when these are created. 

 

find_real_file.png

23 REPLIES 23

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

possibly some scheduled job script is creating or updating the records and clearing those fields

Regards
Ankur

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

asifnoor
Kilo Patron

Hi,

Enable Audit log on the table and watch it for a specific period. you might khow if those are being created empty or getting cleared after creating.

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/security/task/t_Ena...

Also to debug further you can create a event on your table and create 1 notification and listen to that event. And then trigger that event from after insert Br. 

 

Farah5
Tera Contributor

Auditing is already enabled for the table. If I try to access the calendar history for those blank records, I am brought to a totally blank page (screenshot below). The system is almost acting like they don't even exist, even though they're right there. 

 

I've gone ahead and created a notification, just so I can see when these records are being created. 

 

find_real_file.png

Hi,

try raising a HI ticket and ServiceNow should help you debug

Regards
Ankur

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

DirkRedeker
Mega Sage

Hi

Try to reset your view. Certainly, the columns in your view will point to wrong or invalid fields.

I cannot imagine, that the field is not filled at all.

Maybe you are showing a VIEW in your list, which joins two tables, and one of the tables is empty.

Or your "created" field/column in your list is a dot-walked field.

Clear your view and remove all fields.

Then move back the fields and check the "created" field values.

Maybe you also cheated with a display BR, or fields that are named with the same label "created".

System fields are always filled in - I cannot imagine different 🙂

Also, try to GlideRecord to that table and print out the JSON with

gs.info(JSON.stringify(gr, null, 4);

Let me know what comes out.

BR

Dirk