Skip to Content

SAP HANA APL AFM Errors

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 04 at 09:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded