System is creating new records automatically with empty "Created" and "Created by" fields
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2020 07:35 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2020 07:49 AM
Hi,
possibly some scheduled job script is creating or updating the records and clearing those fields
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2020 07:55 AM
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2020 08:28 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2020 09:13 AM
Hi,
try raising a HI ticket and ServiceNow should help you debug
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-26-2020 08:03 AM
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