Error deleting an Application Model

Author: gianni.sandigliano@unifacesolutions.com (gianni)

I'm building some test cases and trying to delete a model from a repo hosted from Solid with U9.6.08, including 7 entities + many fields and few relationships, I've got an error. The message frame includes these: I/O function: F, mode: 1, on file/table: UNIFACE.OUCFIELD index: 1 = (439 lines more always identical) I/O function: F, mode: 1, on file/table: UNIFACE.OUCFIELD index: 1 = I/O function: F, mode: 1, on file/table: UNIFACE.OUCKEY index: 1 = (9) lines more always identical) I/O function: F, mode: 1, on file/table: UNIFACE.OUCKEY index: 1 = I/O function: F, mode: 1, on file/table: UNIFACE.OUCRELSH index: 1 = I/O function: F, mode: 1, on file/table: UNIFACE.OUCRELSH index: 1 = I/O function: F, mode: 1, on file/table: UNIFACE.OUCTABLE index: 1 = (5) lines more always identical) I/O function: F, mode: 1, on file/table: UNIFACE.OUCTABLE index: 1 = I/O function: F, mode: 1, on file/table: UNIFACE.OUCSCH index: 1 = [20-jan-16 12:55:46] [UUCONC03 - DELE: 1] 2012 - occurrence mismatch. Call stack:     _delete, DELE:1, [delete ] Comp: UUCONC03     _execute, DO_PROCESS:200, [erase/e "UCDTYP"] Comp: UUCONC03     _execute, EXEC:46, [call DO_PROCESS()] Comp: UUCONC03     _delete, RUNFORM:4, [activate "%%$LP_4S$"."EXEC"(  ) ] Comp: UUCONC20     _delete, DELE:9, [call RUNFORM()] Comp: UUCONC20     _accept, STO_CMP0:1, [store/e/complete "UCSCH"] Comp: UUCONC20     _accept, DO_STO_0:1, [call STO_CMP0()] Comp: UUCONC20     _accept, DO_SAVE1:9, [call DO_STO_0()] Comp: UUCONC20     _accept, DO_CLOS:10, [call DO_SAVE1()] Comp: UUCONC20     _accept, ACPT:1, [call DO_CLOS()] Comp: UUCONC20     ... and 4 more preceding calls 2012 - occurrence mismatch in component [UUCONC03], entity [UCDTYP], see message frame for more information. It was the first action done after starting Udevelopment, working as single user and $ioprint is = 0. What's wrong here? Gianni

2 Comments

  1. Hi Gianni, Long time since we have last spoken, how are you? Do you perform the delete actions from within the IDF or are you performing these actions directly on the (repository-) database? (Because I think I see some referential integrety rules on the database firing in your error log) In the last case overflow tables (name beginning with 'O') have to be deleted first, before their 'main' table that they are connected to, because of these referential integrity rules (that are obviously defined on the Solid database). Cheers, Arjen


    Author: Arjen van Vliet (arjen.van.vliet@uniface.com)
  2. Ciao Arjen, nice to hear from you again! Everything is fine on my side...hope ok also on your side... :-) I had just used IDF for everything...at least up to the error! I was building one small example with one model with few entities and two forms using a quick & dirty repository on SEQ to test XML saving and loading. I've found a small problem compiling a complex form in this first environment and because of this I've exported everything from SEQ and re-imported to a Solid to double check the problem found; after having confirmed on Solid my testcase was properly working I've deleted: - the 2 forms -> OK- tried to delete the model -> with results already explained I manually deleted proper rows from UCFIELD, UCKEYS, UCRELA, UCTABLE, UCGROUP, UCSCH and related Overflow tables...and concluded deleting various Field Templates again from within IDF. I solved my small issue but I thinked it was a valuable thing to comment it for the Ulab. The most unusual thing are those trace lines I've found in my message frame; I've supposed someone was already trying to found an issue exactly where I've found it... :-) ...but it could be I am wandering too much with ideas. Gianni


    Author: gianni (gianni.sandigliano@unifacesolutions.com)