Skip to Content
0

Error in APL execution via AFM Graph

Sep 27, 2017 at 10:29 AM

84

avatar image

Hello,

We have created an AFM graph to call "CREATE_MODEL" function of the APL. The graph successfully got activated but while running gave the below error:

Could not execute 'CALL "HRAFIQ"."ml_hasan::pal_grir_trial"() with overview' in 942 ms 817 µs . 
SAP DBTech JDBC: [423]: AFL error: search table error: "HRAFIQ"."ml_hasan::pal_grir_trial": line 5 col 1 (at pos 105): [423] (range 3) 
AFL error exception: _SYS_AFL.APL_AREA:CREATE_MODEL: [423] (range 3) AFL error exception: [APL error] Automated Analytics error (-2147467259): 
phase 'KxCPPInterf::IKxenModel::saveSpaceDescription()'  [[Kxen.UserSpace[7f4dfabe0000]:cannot change table column count][:An error has occurred when accessing a data set in the store managed by 
and the current action has been stopped.]] 

We guessed that the error could be because the Guessed description table was missing the OID optional column, after we added the column. The error message changed.

Could not execute 'CALL "HRAFIQ"."ml_hasan::pal_grir_trial"()' in 675 ms 722 µs . 
SAP DBTech JDBC: [423]: AFL error: search table error: "HRAFIQ"."ml_hasan::pal_grir_trial": line 6 col 1 (at pos 438): [423] (range 3) AFL error exception: _SYS_AFL.APL_AREA:CREATE_MODEL: [423] (range 3) AFL error exception: 
[APL error] Automated Analytics error (-2147024809): 
phase 'KxCPPInterf::IKxenModel::saveSpaceDescription()'  [[:APL_OutputVarDescriptions already exists and is not an Automated Analytics description.]] 


Can you please advise?

Thanks,

Hasan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Hasan Rafiq Sep 28, 2017 at 04:25 AM
0

Solved myself ! It's no where mentioned in the documentation that the table types of outputs should match exactly as https://cp.hana.ondemand.com/dps/d/preview/5b8e06cae5be43f5af9dbe72d73bb7a9/2.5/en-US/frameset.htm?a838906e3ecc49d199aa8627a579a2de.html

After matching field names, it started working !

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

Adding Frederic MOITEL on the doc feedback.

0

Hi Rafiq,

Have you read this section, which gives more details about table types ?https://cp.hana.ondemand.com/dps/d/preview/5b8e06cae5be43f5af9dbe72d73bb7a9/2.5/en-US/frameset.htm?1ee3b5077a8d486caa9873941c87bb04.html.

Best Regards,

Frederic

0