cancel
Showing results for 
Search instead for 
Did you mean: 

Error in APL execution via AFM Graph

former_member186543
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186543
Active Contributor
0 Kudos

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?a...

After matching field names, it started working !

achab
Product and Topic Expert
Product and Topic Expert
0 Kudos

Adding frederic.moitel on the doc feedback.

0 Kudos

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

Answers (1)

Answers (1)

vkris215
Participant
0 Kudos

Hello Hasan,

Even, I'm facing the same issue. I have crosschecked the table types and they are good.

But, still facing the same error.

BR,

Krishna.