Skip to Content
0

SAP PAL ARIMAX FORECAST :Error in forecast length

Feb 07 at 09:55 AM

39

avatar image

Hi experts,

I am trying to forecast my data set with ARIMA FORECAST.Find the code attached. I am getting the following error: with an exception for forecast length.whatever length its not accepting.

Could not execute 'CALL PAL.PAL_ARIMAXFORECAST_PROC("PAL"."PS_PAL_WEEK", PAL_ARIMAX_MODEL_TBL, "#PAL_CONTROL_TBL", ...' in 328 ms 421 µs . 

SAP DBTech JDBC: [423]: AFL error: search table error: _SYS_AFL.AFLPAL:ARIMAXFORECAST: [423] (range 3) AFL error exception: exception 73001554: PAL error[73001554]:The length of , is not equal to 29
SET SCHEMA PAL; 
DROP TYPE PAL_ARIMAX_DATA_T; 
DROP TYPE PAL_ARIMAX_MODEL_T;
DROP TYPE PAL_ARIMAX_CONTROL_T;
DROP TYPE PAL_ARIMAX_RESULT_T;
DROP TABLE PAL_ARIMAX_PDATA_TBL;

CREATE TYPE PAL_ARIMAX_DATA_T AS TABLE( "ID" INTEGER,"Under_Warranty" INTEGER,"Claims" INTEGER ); 
CREATE TYPE PAL_ARIMAX_MODEL_T AS TABLE("NAME" VARCHAR (50),"VALUE" VARCHAR (5000)); 
CREATE TYPE PAL_ARIMAX_CONTROL_T AS TABLE("NAME" VARCHAR (50),"INTARGS" INTEGER,"DOUBLEARGS" DOUBLE,"STRINGARGS" VARCHAR (100) ); 
CREATE TYPE PAL_ARIMAX_RESULT_T AS TABLE("TIMESTAMP" INTEGER,"MEAN" DOUBLE, "LOW80%" DOUBLE, "HIGH80%" DOUBLE, "LOW95%" DOUBLE, "HIGH95%" DOUBLE ); 


CREATE COLUMN TABLE PAL_ARIMAX_PDATA_TBL("POSITION" INT, "SCHEMA_NAME" NVARCHAR(256), "TYPE_NAME" NVARCHAR(256), "PARAMETER_TYPE" VARCHAR(7)); 

INSERT INTO PAL_ARIMAX_PDATA_TBL VALUES(1,'PAL', 'PAL_ARIMAX_DATA_T','IN');
INSERT INTO PAL_ARIMAX_PDATA_TBL VALUES(2,'PAL', 'PAL_ARIMAX_MODEL_T','IN');
INSERT INTO PAL_ARIMAX_PDATA_TBL VALUES(3,'PAL', 'PAL_ARIMAX_CONTROL_T','IN');
INSERT INTO PAL_ARIMAX_PDATA_TBL VALUES(4,'PAL', 'PAL_ARIMAX_RESULT_T','OUT'); 

CALL SYS.AFLLANG_WRAPPER_PROCEDURE_DROP('PAL', 'PAL_ARIMAXFORECAST_PROC'); 
CALL SYS.AFLLANG_WRAPPER_PROCEDURE_CREATE('AFLPAL', 'ARIMAXFORECAST', 'PAL', 'PAL_ARIMAXFORECAST_PROC',PAL_ARIMAX_PDATA_TBL); 

DROP TABLE #PAL_CONTROL_TBL; 

CREATE LOCAL TEMPORARY COLUMN TABLE #PAL_CONTROL_TBL ( "NAME" VARCHAR (50),"INTARGS" INTEGER,"DOUBLEARGS" DOUBLE,"STRINGARGS" VARCHAR (100)); 

INSERT INTO #PAL_CONTROL_TBL VALUES ('ForecastLength', 29, null,null); 

DROP TABLE PAL_ARIMAX_RESULT_TBL; 
CREATE COLUMN TABLE PAL_ARIMAX_RESULT_TBL LIKE PAL_ARIMAX_RESULT_T; 
SELECT * FROM PAL_ARIMAX_MODEL_TBL; 

CALL PAL.PAL_ARIMAXFORECAST_PROC("PAL"."PS_PAL_WEEK", PAL_ARIMAX_MODEL_TBL, "#PAL_CONTROL_TBL", PAL_ARIMAX_RESULT_TBL) WITH OVERVIEW; 
SELECT * FROM PAL_ARIMAX_RESULT_TBL;
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Antoine CHABERT
Feb 12 at 08:35 AM
0

I think this has no relation with SAP Predictive Analytics, is that correct?

Share
10 |10000 characters needed characters left characters exceeded