SYMPTOM
Error “Failed to insert table DSSMDOBJLOCK” is found in DSSErrors log when triggering multiple subscriptions to a user who doesn’t have Profile folder.
Normally this error will be recorded when an object is locked by one operation and at the same time, another operation is trying to lock the same object also.
Here is a scenario where this error may be reproduced in Strategy:
1.Log in as Administrator and create a new user. Do not log in as this user to ensure there is no Profile folder created under this user account. Or manually remove the profile folders for this user from Developer.
2.Create two subscriptions which are set to this new user using a same schedule.
3.Trigger the schedule. Below error will be recorded in DSSErrors log:
2018-11-30 00:16:01.848-05:00 [HOST:ENV-118230WAIOU][SERVER:CastorServer][PID:4348][THR:3268][Database Classes][Error] Execute Query failed.
Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [23000:1: on SQLHANDLE] [Strategy][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint (XILINOCA12.SYS_C002305191) violated
ORA-06512: at line 1 Connection String: DSN=XILINOCA12;UID=XILINOCA12;ENABLENCHARSUPPORT=1;ENABLEDESCRIBEPARAM=1;HOST=10.27.10.104;PORT=1521;SID=unicode;. SQL Statement: BEGIN INSERT INTO DSSMDOBJLOCK VALUES ('38A062302D4411D28E71006008960167', '9E2A92DB433EABE84AFC91BEF883E15B', 34, 0, 1, 7, TO_TIMESTAMP('2018-11-30 05:16:01.817','YYYY-MM-DD HH24:MI:SS.FF'), '16B8C8A0C509319025849029649B13E3', '00000000000000000000000002000000', 'ENV-118230WAIOU', 'Lock the profile folders because we''ll serialize profile creation.'); END;.
2018-11-30 00:35:43.383-05:00 [HOST:ENV-118230WAIOU][SERVER:CastorServer][PID:4348][THR:3268][MSql][Error] Error executing SQL: BEGIN INSERT INTO DSSMDOBJLOCK VALUES ('38A062302D4411D28E71006008960167', '9E2A92DB433EABE84AFC91BEF883E15B', 34, 0, 1, 7, TO_TIMESTAMP('2018-11-30 05:16:01.817','YYYY-MM-DD HH24:MI:SS.FF'), '16B8C8A0C509319025849029649B13E3', '00000000000000000000000002000000', 'ENV-118230WAIOU', 'Lock the profile folders because we''ll serialize profile creation.'); END;