Skip to Content
0
May 07, 2013 at 08:54 AM

PAL - SAP DBTech JDBC: [423]: liveCache error: [423] SYSTEM.AFL_WRAPPER_GENERATOR:

46 Views

Hi,

when trying to exectute the following script (sample from the help document):

SET

SCHEMA AGS_SYSTEM;


DROP

TYPE PAL_AD_RESULT_T;


CREATE

TYPE PAL_AD_RESULT_T AS TABLE(


"ID"

INT,


"V000"

DOUBLE,


"V001"

DOUBLE


)

;


DROP

TYPE PAL_AD_DATA_T;


CREATE

TYPE PAL_AD_DATA_T AS TABLE(


"ID"

INT,


"V000"

DOUBLE,


"V001"

DOUBLE,


primary

key("ID")


)

;


DROP

TYPE PAL_CONTROL_T;


CREATE

TYPE PAL_CONTROL_T AS TABLE(


"NAME"

VARCHAR (50),


"INTARGS"

INTEGER,


"DOUBLEARGS"

DOUBLE,


"STRINGARGS"

VARCHAR (100)


)

;


-- create procedure


DROP

TABLE PDATA;


CREATE

COLUMN TABLE PDATA(


"ID"

INT,


"TYPENAME"

VARCHAR(100),


"DIRECTION"

VARCHAR(100) );


INSERT

INTO PDATA VALUES (1, 'DM_PAL.PAL_AD_DATA_T', 'in');


INSERT

INTO PDATA VALUES (2, 'DM_PAL.PAL_CONTROL_T', 'in');


INSERT

INTO PDATA VALUES (3, 'DM_PAL.PAL_AD_RESULT_T', 'out');


GRANT

SELECT ON AGS_SYSTEM.PDATA to SYSTEM;


call

SYSTEM.afl_wrapper_generator('PAL_ANOMALY_DETECTION', 'AFLPAL', 'ANOMALYDETECTION', PDATA);


DROP

TABLE PAL_AD_DATA_TAB;


CREATE

COLUMN TABLE PAL_AD_DATA_TAB (


"ID"

INT,


"V000"

DOUBLE,


"V001"

DOUBLE,


primary

key("ID")


)

;


INSERT

INTO PAL_AD_DATA_TAB VALUES (0 , 0.5, 0.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (1 , 1.5, 0.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (2 , 1.5, 1.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (3 , 0.5, 1.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (4 , 1.1, 1.2);


INSERT

INTO PAL_AD_DATA_TAB VALUES (5 , 0.5, 15.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (6 , 1.5, 15.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (7 , 1.5, 16.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (8 , 0.5, 16.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (9 , 1.2, 16.1);


INSERT

INTO PAL_AD_DATA_TAB VALUES (10, 15.5, 15.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (11, 16.5, 15.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (12, 16.5, 16.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (13, 15.5, 16.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (14, 15.6, 16.2);


INSERT

INTO PAL_AD_DATA_TAB VALUES (15, 15.5, 0.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (16, 16.5, 0.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (17, 16.5, 1.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (18, 15.5, 1.5);


INSERT

INTO PAL_AD_DATA_TAB VALUES (19, 15.7, 1.6);


INSERT

INTO PAL_AD_DATA_TAB VALUES (20,-1.0, -1.0);


DROP

TABLE PAL_CONTROL_TAB;


CREATE

COLUMN TABLE PAL_CONTROL_TAB (


"NAME"

VARCHAR (50),


"INTARGS"

INTEGER,


"DOUBLEARGS"

DOUBLE,


"STRINGARGS"

VARCHAR (100)


)

;


INSERT

INTO PAL_CONTROL_TAB VALUES ('THREAD_NUMBER',2,null,null);


INSERT

INTO PAL_CONTROL_TAB VALUES ('GROUP_NUMBER',4,null,null);


INSERT

INTO PAL_CONTROL_TAB VALUES ('INIT_TYPE',4,null,null);


INSERT

INTO PAL_CONTROL_TAB VALUES ('DISTANCE_LEVEL',2,null,null);


INSERT

INTO PAL_CONTROL_TAB VALUES ('MAX_ITERATION',100,null,null);


DROP

TABLE PAL_AD_RESULT_TAB;


CREATE

COLUMN TABLE PAL_AD_RESULT_TAB (


"ID"

INT,


"V000"

DOUBLE,


"V001"

DOUBLE


)

;


CALL

_SYS_AFL.PAL_ANOMALY_DETECTION(PAL_AD_DATA_TAB, PAL_CONTROL_TAB, PAL_AD_RESULT_TAB) with overview;


select

* from PAL_AD_RESULT_TAB;

I am getting an error:

Could not execute 'call SYSTEM.afl_wrapper_generator('PAL_ANOMALY_DETECTION', 'AFLPAL', 'ANOMALYDETECTION', PDATA)' in 86 ms 466 µs . SAP DBTech JDBC: [423]: liveCache error: [423] SYSTEM.AFL_WRAPPER_GENERATOR: line 34 col 1 (at pos 1472): liveCache error exception: liveCache error: registration finished with errors, see indexserver trace

Anybody any idea?

Thanks, Arno