Skip to Content
0
May 24, 2018 at 03:13 PM

Error:Cyclic dependency found in a runtime procedure

651 Views

Hello everyone:

Please your help, I have an error when I call a store procedure that has internally other store procedure and flowgraph, the store procedure and flograph are dependent, so when I run the store procedure parent, I get the following error:

(SQL Editor) Could not execute 'CALL "ETL_CONTROL"."Procesos_T3"()'
Error: (dberror) 129 - transaction rolled back by an internal error: search table error: "ETL_CONTROL"."Procesos_T3": line 10 col 2 (at pos 213): "ETL_CONTROL"."SP_CARACT": line 13 col 3 (at pos 348): [129] (range 3): transaction rolled back by an internal error: transaction rolled back by an internal error: "PREDICTIVE"."T3B_DS": line 7 col 5 (at pos 138): [129] (range 3): transaction rolled back by an internal error: Cyclic dependency found in a runtime procedure: Not allowed to call/modify runtime procedure ETL_CONTROL.Procesos_T3 during its execution.

The code of the store procedure of the father is:

CREATE PROCEDURE "ETL_CONTROL"."Procesos_T3" () LANGUAGE SQLSCRIPT SQL SECURITY INVOKER DEFAULT SCHEMA ETL_CONTROL AS BEGIN --EJECUTAR FLOWGRAPHS DEL PROCESO DE LA CAPA T3

--1. Proceso Caracteristicas

CALL "ETL_CONTROL"."SP_CARACT"();

--2. Proceso de Actualizacion las caracteristicas

CALL "ETL_CONTROL"."SP_UPDATE_CARACT"();

--3. Proceso de variable peso objetivo

CALL "ETL_CONTROL"."SP_PESO_OBJ"();

--4. Proceso de variable sobrevivencia objetivo CALL "ETL_CONTROL"."SP_SOBREV_OBJ"();

--5. Proceso Data set Histórico

TRUNCATE TABLE "PREDICTIVE"."T3_DATASET_OUT" ;COMMIT;

CALL"PREDICTIVE"."DataProvisioningPRD.ExtraccionesSecundarias::ET_DATA_SET_OUT_SP"();

END

This error that comes out I think it's because all store procedures are executed in parallel, because when I run them one by one, I have no problem, but I'm not sure if that's what you mean, but as I mentioned each store procedure is dependent on the another and it has to be SEQUENTIAL, could you please help me if the error refers to what I mention or what it is about? And another query more how would you do to call the store procedure sequentially?


thank you very much for your help

regards