I want to clone a report in Designer but I can't. I get this error:
RME-02124: Failed to execute SQL statement: insert into ck_temporary_set (trans_ref, id, type_of, el_str, read_only, pass, marked, new_parent_id) values (:REF,:ELID,:TYPE, :ELSTR, :RO,:PASS, 'Y', :PARENT)
RME-02105: Oracle error occurred...
ORA-00001: unique constraint (REPOS.CK_TEMPORARY_SET_PK) violated
ORA-00001: unique constraint (.) violated
Can I just delete the rows in ck_temporary_set? I counted them, there are 1886 right now....
Which version of the Oracle Database do you have?
Which version of Oracle Designer do you have?
Don't delete the rows. In the post RME-02124: Failed to execute SQL statement they state that RME-02124 looks like a permission problem.
I am using Designer 10gR2 and in my case the table ck_temporary_set is completely empty.
It’s a temporary table and it is also on the tempory tables tablespace. But I can’t tell you if you could delete the records without getting problems.