on 05-24-2018 4:13 PM
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
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.