[301]: unique constraint violated: Table(y)

[Former Member]

When i try sql command running (F8) below,

insert into "x"."y" values('a','b');

I am getting error message like below

Could not execute 'insert into "x"."y" values ('a','b')' in 13 ms 156 µs .

[301]: unique constraint violated: Table(y)

Here x is schema name and y is table name inside the schema and

        a is authoring schema and b is physical schema

Can anyone please help me with the error message solution?

Thanks & Regards,

Naveen

[Former Member · Accepted solution]

Hi Naveen,

Mostly unique constraint issue come because of primary key violation. I can see you are trying to insert the values into table M_SCHEMA_MAPPING under _SYS_BI schema where AUTHORING_SCHEMA is primary key. Make sure you don't have any record with the same authoring schema in the table.

Regards,

Venkat N.

[Former Member · Accepted solution]

thanks.. actually the same thing is already executed by others in the earlier in the system..

so when i am trying it, this was the error coming.

i have just checked the results in particular place, it was already has the same.

thanks,

Naveen