AFL error: [423] : registration finished with errors, see indexserver trace

[former_member208872]

Hi All,

     I am trying to Call an AFL Procedure and i am getting the following error

Could not execute 'call SYSTEM.afl_wrapper_generator('PAL_ANOMALY_DETECTION', 'AFLPAL', 'ANOMALYDETECTION', ...' in 267 ms 10 µs .

SAP DBTech JDBC: [423]: AFL error:  [423] "SYSTEM"."AFL_WRAPPER_GENERATOR": line 61 col 5 (at pos 1844): [423] (range 3) AFL error exception: AFL error:  [423] "SYSTEM"."AFLPM_CREATOR": line 10 col 5 (at pos 193): [423] (range 3) AFL error exception: AFL error: registration finished with errors, see indexserver trace

Here's the code

SET SCHEMA i311482;

DROP TYPE PAL_AD_RESULT_T;

CREATE TYPE PAL_AD_RESULT_T AS TABLE( "ProductId" VARCHAR (10),

"Quantity" Double, "GrossAmount" Double);

DROP TYPE PAL_AD_DATA_T;

CREATE TYPE PAL_AD_DATA_T AS TABLE( "ProductId" VARCHAR (10), "Quantity"

Double, "GrossAmount" Double);

DROP TYPE PAL_AD_CONTROL_T;

CREATE TYPE PAL_AD_CONTROL_T AS TABLE( "NAME" VARCHAR (50),

"INTARGS" INTEGER, "DOUBLEARGS" DOUBLE, "STRINGARGS" VARCHAR (100));

DROP TABLE PAL_AD_PDATA_TBL;

CREATE COLUMN TABLE PAL_AD_PDATA_TBL( "ID" INT, "TYPENAME" VARCHAR(100), "DIRECTION" VARCHAR(100) );

INSERT INTO PAL_AD_PDATA_TBL VALUES (1, 'i311482.PAL_AD_DATA_T', 'in');

INSERT INTO PAL_AD_PDATA_TBL VALUES (2, 'i311482.PAL_AD_CONTROL_T', 'in');

INSERT INTO PAL_AD_PDATA_TBL VALUES (3, 'i311482.PAL_AD_RESULT_T', 'out');

call SYSTEM.afl_wrapper_eraser('PAL_ANOMALY_DETECTION');

call SYSTEM.afl_wrapper_generator('PAL_ANOMALY_DETECTION', 'AFLPAL', 'ANOMALYDETECTION', PAL_AD_PDATA_TBL);

[former_member208872 · Accepted solution]

Hi and ,

     Thanks for your help.

I am using Rev90 HANA System and in that system AFM model is depricated and we need to use Flowgraph model.

So that was the issue.

Regards,

Ramya G

[achab · Accepted solution]

Good to know Ramya!

Can you please share information (doc, URL, SCN posts) on what flowgraph model means? I am sure this will be helpful for the community.

Thanks & regards

Antoine

[former_member208872]

SAP HANA Developer Guide for SAP HANA Studio - SAP Library

[former_member191717]

Thanks a lot for the clarification

[former_member191717]

Hi Ramya,

if you still have this issue you can have a look at the Note below:

1930665 - Labor Demand Planning - determination of planned execution times unsuccessful

https://service.sap.com/sap/support/notes/1930665

The same error is also resolved in this blog:

http://scn.sap.com/thread/3657025

And also resolved here: https://scn.sap.com/thread/3311619

Test this construction :

call SYSTEM.afl_wrapper_generator ('PAL_ANOMALY_DETECTION1', 'AFLPAL', 'ANOMALYDETECTION', PDATA)

and check PDATA(only distinct values in it)

Hope that helps

Cheers

Kingsley

[achab]

Hi,

I am sorry not to be an expert in this area.

However via SCN search, I have found some related posts:

http://scn.sap.com/community/predictive-analytics/blog/2013/08/01/setting-up-hana-pal-for-use-with-s...

As you are a SAP employee and so are the submitters, you can see via their posts or get in touch with them directly.

Please let us know how it goes.

Thanks & regards

Antoine

[former_member208872]

Hi,

     Thanks for the links.

      I did try all of them, but i am still getting the same error.

Thanks,

Ramya G

[Former Member]

Hi Ramya & Antoine,

We're also receiving the exact same error at the exact same line number, after migrating to SAP HANA release 9:

CALL SYSTEM.AFL_WRAPPER_GENERATOR('TEST_DTW', 'INTRO_AREA', 'DTW', SIGNATURE);

Could not execute 'CALL SYSTEM.AFL_WRAPPER_GENERATOR('TEST_DTW', 'INTRO_AREA', 'DTW', SIGNATURE)' in 176 ms 377 µs .

SAP DBTech JDBC: [423]: AFL error: [423] "SYSTEM"."AFL_WRAPPER_GENERATOR": line 61 col 5 (at pos 1844): [423] (range 3) AFL error exception: AFL error: [423] "SYSTEM"."AFLPM_CREATOR": line 10 col 5 (at pos 193): [423] (range 3) AFL error exception: AFL error: registration finished with errors, see indexserver trace.

The indexserver trace does not really reveal much of why this error is occurring. It mostly repeats the same error message that we get inside HANA Studio. The trace also points out that the error occurs at the following part of "SYSTEM"."AFLPM_CREATOR":

#pragma location " line 10 col 5 (at pos 193)"
    {
        CallableStatement stmt0 = conn.prepareCall(String("{ call \"SYS\".\"AFLPM_CREATOR_NOTHROW_DEV\" (?, ?, ?, ?, ?) }"), "static", "");
        stmt0.setRSString(1z, vAREA);
        stmt0.setRSString(2z, vFUNC);
        stmt0.setRSString(3z, expr::constructor_<RSString>("_SYS_AFL",8));
        stmt0.setRSString(4z, vPROC);
        stmt0.setRSString(5z, vPARS);
        stmt0.execute();
    }

I re-checked the parameters for our function call, and they were all in order and works fine on SAP HANA release 8.

We extended AFL by deploying our own function, which used to work fine on SAP HANA release 8. But, now after we migrated to release 9 (version 1.00.091.00.1418659308), we're having this registration error.

Please let us know in case you find any solution to this problem.

Regards,

Ishrar

[former_member208872]

Hi Ishrar Hussain,

     With SPS09, the function calls that you are using are deprecated.

Please use these functions

     SYS.AFLLANG_WRAPPER_PROCEDURE_DROP

     SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE

You can find detailed information in the following link

https://help.sap.com/hana/SAP_HANA_Predictive_Analysis_Library_PAL_en.pdf

Let me know if this works.

Thanks and Regards,

Ramya G