How to remove the no-sysID record?

[kelvin_du]

Hi friends,

I got a record without sys_id in my table (I haven't found the reason yet). I want to delete it but I cannot do it. Tried a lot of ways (wrote an Scheduled job / Business rule to delete it, used "Delete all records" etc), but they all didn't work as well.

By the way this is my table, it's not the OOB one.

Thanks

[bernyalvarado]

Hi Kelvin, it will be interesting to know what type of scripts have you run against that table.

It almost appears that what you have in there is a little bit of a data corruption since now record should exist in a table without a sys_id.

By any chance, do you run any type of direct sql command in that table?

Thanks,

Berny

[bernyalvarado]

It may also be possible that you have something wrong on your browser that's causing that.

You may want to try the following:

a) Try to retrieving the sys_id for other record.

b) Checking in your browser console to see if you're getting any errors

c) Try using a different browser

Thanks,

Berny

[bernyalvarado]

Another thought:

You may want to try to do a GlideRecord to query the table and see if you're able to retrieve the record.

Also... it will be interesting to know if you can actually edit on the list a field (column) of that record.

Thanks,

Berny