SAP HANA AFL error: Registration of AFLLANG wrapper procedure "DM_PAL"."PAL_PCA_PROC" failed with error 'no matching overload found'.

[Former Member]

Please help me... This is direct example from documentation. Main Error: Could not execute 'CALL SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','PCA','DM_PAL','PAL_PCA_PROC',PAL_PCA_PDATA_TBL)' in 226 ms 729 µs . SAP DBTech JDBC: [423]: AFL error:  [423] "SYS"."AFLLANG_WRAPPER_PROCEDURE_CREATE": line 156 col 5 (at pos 5073): [423] (range 3) AFL error exception: AFL error: Registration of AFLLANG wrapper procedure "DM_PAL"."PAL_PCA_PROC" failed with error 'no matching overload found'. CODE: SET SCHEMA "DM_PAL"; DROP TYPE PAL_PCA_DATA_T; DROP TYPE PAL_CONTROL_T; DROP TYPE PAL_PCA_LOADINGS_T; DROP TYPE PAL_PCA_LOADINGS_INFO_T; DROP TYPE PAL_PCA_SCORES_T; DROP TYPE PAL_PCA_SCALING_INFO_T; DROP TABLE PAL_PCA_PDATA_TBL; DROP TABLE #PAL_CONTROL_TBL; DROP TABLE PAL_PCA_DATA_TBL; DROP TABLE PAL_PCA_LOADINGS_TBL; DROP TABLE PAL_PCA_LOADINGS_INFO_TBL; DROP TABLE PAL_PCA_SCORES_TBL; DROP TABLE PAL_PCA_SCALING_INFO_TBL; CREATE TYPE PAL_PCA_DATA_T AS TABLE("ID" INTEGER, "X1" DOUBLE, "X2" DOUBLE, "X3" DOUBLE, "X4" DOUBLE, "X5" DOUBLE, "X6" DOUBLE); CREATE TYPE PAL_CONTROL_T AS TABLE("NAME" VARCHAR(50), "INTARGS" INTEGER, "DOUBLEARGS" DOUBLE, "STRINGARGS" VARCHAR(100)); CREATE TYPE PAL_PCA_LOADINGS_T AS TABLE("PCID" VARCHAR(50), "X1_WEIGHT" DOUBLE, "X2_WEIGHT" DOUBLE, "X3_WEIGHT" DOUBLE, "X4_WEIGHT" DOUBLE, "X5_WEIGHT" DOUBLE, "X6_WEIGHT" DOUBLE); CREATE TYPE PAL_PCA_LOADINGS_INFO_T AS TABLE("PCID" VARCHAR(50),"SDEV" DOUBLE, "PROPORTION" DOUBLE, "CUM_PROPORTION" DOUBLE); CREATE TYPE PAL_PCA_SCORES_T AS TABLE("ID" INTEGER, "Comp1" DOUBLE, "Comp2" DOUBLE, "Comp3" DOUBLE, "Comp4" DOUBLE, "Comp5" DOUBLE, "Comp6" DOUBLE); CREATE TYPE PAL_PCA_SCALING_INFO_T AS TABLE("ID" INTEGER, "MEAN_VECTOR" DOUBLE, "SCALE_VECTOR" DOUBLE); CREATE COLUMN TABLE PAL_PCA_PDATA_TBL("POSITION" INT, "SCHEMA_NAME" NVARCHAR(256), "TYPE_NAME" NVARCHAR(256), "PARAMETER_TYPE" VARCHAR(7)); INSERT INTO PAL_PCA_PDATA_TBL VALUES(1, 'DM_PAL', 'PAL_PCA_DATA_T', 'IN'); INSERT INTO PAL_PCA_PDATA_TBL VALUES(2, 'DM_PAL', 'PAL_CONTROL_T', 'IN'); INSERT INTO PAL_PCA_PDATA_TBL VALUES(3, 'DM_PAL', 'PAL_PCA_LOADINGS_T', 'OUT'); INSERT INTO PAL_PCA_PDATA_TBL VALUES(4, 'DM_PAL', 'PAL_PCA_LOADINGS_INFO_T', 'OUT'); INSERT INTO PAL_PCA_PDATA_TBL VALUES(5, 'DM_PAL', 'PAL_PCA_SCORES_T', 'OUT'); INSERT INTO PAL_PCA_PDATA_TBL VALUES(6, 'DM_PAL', 'PAL_PCA_SCALING_INFO_T', 'OUT'); CALL SYS.AFLLANG_WRAPPER_PROCEDURE_DROP('DM_PAL','PAL_PCA_PROC'); CALL SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','PCA','DM_PAL','PAL_PCA_PROC',PAL_PCA_PDATA_TBL); Could not execute 'CALL SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL','PCA','DM_PAL','PAL_PCA_PROC',PAL_PCA_PDATA_TBL)' in 226 ms 729 µs . SAP DBTech JDBC: [423]: AFL error:  [423] "SYS"."AFLLANG_WRAPPER_PROCEDURE_CREATE": line 156 col 5 (at pos 5073): [423] (range 3) AFL error exception: AFL error: Registration of AFLLANG wrapper procedure "DM_PAL"."PAL_PCA_PROC" failed with error 'no matching overload found'. CREATE COLUMN TABLE PAL_PCA_DATA_TBL LIKE PAL_PCA_DATA_T; INSERT INTO PAL_PCA_DATA_TBL VALUES (1, 12, 52, 20, 44, 48, 16); INSERT INTO PAL_PCA_DATA_TBL VALUES (2, 12, 57, 25, 45, 50, 16); INSERT INTO PAL_PCA_DATA_TBL VALUES (3, 12, 54, 21, 45, 50, 16); INSERT INTO PAL_PCA_DATA_TBL VALUES (4, 13, 52, 21, 46, 51, 17); INSERT INTO PAL_PCA_DATA_TBL VALUES (5, 14, 54, 24, 46, 51, 17); INSERT INTO PAL_PCA_DATA_TBL VALUES (6, 22, 52, 25, 54, 58, 26); INSERT INTO PAL_PCA_DATA_TBL VALUES (7, 22, 56, 26, 55, 58, 27); INSERT INTO PAL_PCA_DATA_TBL VALUES (8, 17, 52, 21, 45, 52, 17); INSERT INTO PAL_PCA_DATA_TBL VALUES (9, 15, 53, 24, 45, 53, 18); INSERT INTO PAL_PCA_DATA_TBL VALUES (10, 23, 54, 23, 53, 57, 24); INSERT INTO PAL_PCA_DATA_TBL VALUES (11, 25, 54, 23, 55, 58, 25); CREATE LOCAL TEMPORARY COLUMN TABLE #PAL_CONTROL_TBL ( "NAME" VARCHAR (100), "INTARGS" INTEGER, "DOUBLEARGS" DOUBLE, "STRINGARGS" VARCHAR (100)); INSERT INTO #PAL_CONTROL_TBL VALUES ('SCALING', 1, NULL, NULL); INSERT INTO #PAL_CONTROL_TBL VALUES ('SCORES', 1, NULL, NULL); CREATE COLUMN TABLE PAL_PCA_LOADINGS_TBL LIKE PAL_PCA_LOADINGS_T; CREATE COLUMN TABLE PAL_PCA_LOADINGS_INFO_TBL LIKE PAL_PCA_LOADINGS_INFO_T; CREATE COLUMN TABLE PAL_PCA_SCORES_TBL LIKE PAL_PCA_SCORES_T; CREATE COLUMN TABLE  PAL_PCA_SCALING_INFO_TBL LIKE PAL_PCA_SCALING_INFO_T; CALL DM_PAL.PAL_PCA_PROC(PAL_PCA_DATA_TBL,"#PAL_CONTROL_TBL", PAL_PCA_LOADINGS_TBL, PAL_PCA_LOADINGS_INFO_TBL, PAL_PCA_SCORES_TBL, PAL_PCA_SCALING_INFO_TBL) WITH OVERVIEW; Could not execute 'CALL DM_PAL.PAL_PCA_PROC(PAL_PCA_DATA_TBL,"#PAL_CONTROL_TBL", PAL_PCA_LOADINGS_TBL, ...' SAP DBTech JDBC: [328]: invalid name of function or procedure: PAL_PCA_PROC: line 1 col 13 (at pos 12) SELECT * FROM PAL_PCA_LOADINGS_TBL; SELECT * FROM PAL_PCA_LOADINGS_INFO_TBL; SELECT * FROM PAL_PCA_SCORES_TBL; SELECT * FROM PAL_PCA_SCALING_INFO_TBL;

[achab]

Hi, it seems no-one has clues to help you - maybe you should describe your problem more in details? Also when you say this is a direct example from the documentation, can you please describe which document?

Thanks & regards

Antoine

[achab]

Looping in

Thanks & regards

Antoine