I am getting "Unique Key violation" "Duplicate entry" error. How to fix that?

[Vaishnavi35]

Hi,

I am getting this error when I click on "Accept" button on Idea form. 

How to fix this?

Thanks,

Vaishnavi

[James Chun]

Thanks @Vaishnavi35,

Nothing looks out of the ordinary, for the first BR (the one that creates demand), does it run on before or after?

Also, in the error message, I can see a sys_id.

Which table can you find a record with that sys_id? I am assuming it could be the [idea], [dmn_demand], or [sc_req_item] table

[Vaishnavi35]

Hi James,

Both BR's run on before.

be74fb5d87b64a10ed64da473cbb356a - Idea sysid
e645ea7847773510b77ff8f5536d43fe - sysid in the error
c4d47f5d87b64a10ed64da473cbb35a9 - sysid of the demand
230fab5587b64a10ed64da473cbb35a2 - sysid of RITM 

sysid of the error always remains same for few records and then changes. Whenever I accept the idea I meant.

Thanks,

Vaishnavi

[James Chun]

So which table does the sys_id in the error message belong to?

That would give us where the duplicate is being created.

[Vaishnavi35]

How do I check which table it belongs to?

I tried a background script, it says table is "null"

function findTableBySysId(sysId) {
var tables = GlideDBObjectManager.get().getAllTables(); // Get all table names
var tableName = null;

// Iterate through all tables
for (var i = 0; i < tables.length; i++) {
var table = tables[i];
var gr = new GlideRecord(table);

// Check if the record with the given sys_id exists in the current table
if (gr.isValid() && gr.get(sysId)) {
tableName = table;
break;
}
}

return tableName;
}

// Example usage
var sysId = '0ccea27d87a20a909e70c91acebb357c'; // Replace with your actual sys_id
var tableName = findTableBySysId(sysId);
gs.info('Table Name: ' + tableName);

Thanks,

Vaishnavi

Thanks,

Vaishnavi

[James Chun]

@Vaishnavi35, there is a Chrome plugin (maybe on other browsers too) called SN Utils.

You can use it to find where the record resides.

If you can't install the plugin for whatever reason, try to search by the sys_id in the the following tables:

• Demand
• Request & Requested item
• Attachment
• Idea

Cheers