Skip to Content
0

SAP HANA APL AFM Errors

Jan 04 at 05:08 AM

116

avatar image

Hi Experts,

I am getting below error while executing AFM APL procedure call.

Procedure call error:

Could not execute 'CALL "_SYS_BIC"."AFL::Forecast"(?, ?, ?, ?)' in 8.957 seconds . SAP DBTech JDBC: [423]: AFL error: search table error: _SYS_AFL.APL_AREA:FORECAST: [423] (range 3) AFL error exception: [APL error] Automated Analytics error (-2147467259): phase 'KxCPPInterf::IKxenModel::sendMode()' [[Kxen.UserSpace[7f7e43717000]:cannot change table column count][:An error has occurred when accessing a dataset in the store managed by and the current actioon has been stopped.]]

INPUT sample :

INSERT into "_SYS_BIC"."TIME_SERIES" values ( TO_DATE('02/01/2001 00:00:00', 'DD/MM/YYYY HH:MI:SS') , 0, 21, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4586.144145 );

Input Table:

CREATE COLUMN TABLE "_SYS_BIC"."TIME_SERIES" ( "Date" TIMESTAMP, "WorkingDaysIndices" INTEGER , "ReverseWorkingDaysIndices" INTEGER , "MondayMonthInd" INTEGER , "TuesdayMonthInd" INTEGER , "WednesdayMonthInd" INTEGER , "ThursdayMonthInd" INTEGER , "FridayMonthInd" INTEGER , "BeforeLastMonday" INTEGER , "LastMonday" INTEGER , "BeforeLastTuesday" INTEGER , "LastTuesday" INTEGER , "BeforeLastWednesday" INTEGER , "LastWednesday" INTEGER , "BeforeLastThursday" INTEGER , "LastThursday" INTEGER , "BeforeLastFriday" INTEGER , "LastFriday" INTEGER , "Last5WDaysInd" INTEGER , "Last5WDays" INTEGER , "Last4WDaysInd" INTEGER , "Last4WDays" INTEGER , "LastWMonth" INTEGER , "BeforeLastWMonth" INTEGER , "Cash" Double );

AFM Screenshots:

Kindly help me on this..

Thanks,

Raja

afm.png (38.0 kB)
1.png (8.0 kB)
2.png (9.3 kB)
3.png (15.9 kB)
4.png (25.0 kB)
5.png (38.7 kB)
6.png (22.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Marc DANIAU
Jan 04 at 09:53 AM
0

Hi Raja,

I suggest you use a dedicated HANA user for running APL as described in the guide instead of using the SYS_BIC internal HANA user.

https://help.sap.com/viewer/cb31bd99d09747089754a0ba75067ed2/3.3/en-US/eee835c3877a4abaa8f893af85acc4fb.html

The APL component comes with sample data and scripts.

You can import the cash flow table from: …\samples\data

You will find the script: apl_forecast.sql under: …\samples\sql\direct\apl_samples\timeseries

I would recommend you run that sample script as a first check before going into AFM.

About the forecast function:

https://help.sap.com/viewer/cb31bd99d09747089754a0ba75067ed2/3.3/en-US/34ec8a14b4a442a29351bb26bb082e6e.html

Best Regards

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hey guys have same issue

Automated Analytics error (-2147467259): phase 'KxCPPInterf::IKxenModel::sendMode()' [[Kxen.UserSpace[7f003fa70800]:cannot change table column count][:An error has occurred when accessing a dataset in the store managed by APLStore and the current action has been stopped.]]

and with APL.. so please provide a non-sales answer

0

Hello Sergio, thanks for your comment. Can you please further clarify? did you use a dedicated HANA user for running APL like it was suggested by Marc? Thanks & regards Antoine

0