SAP DSP: 1CL_OVEN003 (0VENDOR_ATTR) Remote Table: Error while accessing at ptime

[cjfaurie_1616]

Good morning,

In SAP Datasphere, in a DEV space connecting to the S/4HANA DEV system, we have created a remote table SAPI.1CL_OVEN003 (0VENDOR_ATTR Client: 160 Class type: 010) and attempted to display the data and to load snapshot, but the actions fail with error:

"Error: {"timestamp":"2023-10-06 06:09:50.7679110", "origin":"_sys_task", "message":"internal error: Error while accessing at ptime/query/plan_executor/dml/hex/qe_hex_search.cc:484; Statement: ,INSERT INTO \"SCM\".\"1CL_OVEN003$CT\" (\"LIFNR\", \"BBBEE_CERTIF003\", \"BBBEE_CONTR_001\", \"BBBEE_EXPIRY005\", \"BEE_CLASS001\", \"BLACK_YOUTH_001\", \"ENTERPR_SIZE001\", \"NON_DISCRETI001\", \"OTHER_YOUTH_002\", \"SA_BLK_MEN010\", \"SA_BLK_MEN_Y013\", \"SA_BLK_OWN009\", \"SA_BLK_WOMEN011\", \"SA_BLK_WOMEN014\", \"SA_BLK_YOUTH012\", \"BEE_STATUS\", \"MULTI_NATIONAL\", \"CUOBJ\") SELECT \"LIFNR\", \"BBBEE_CERTIF003\", \"BBBEE_CONTR_001\", \"BBBEE_EXPIRY005\", \"BEE_CLASS001\", \"BLACK_YOUTH_001\", \"ENTERPR_SIZE001\", \"NON_DISCRETI001\", \"OTHER_YOUTH_002\", \"SA_BLK_MEN010\", \"SA_BLK_MEN_Y013\", \"SA_BLK_OWN009\", \"SA_BLK_WOMEN011\", \"SA_BLK_WOMEN014\", \"SA_BLK_YOUTH012\", \"BEE_STATUS\", \"MULTI_NATIONAL\", \"CUOBJ\" FROM (WITH _SYS_WITH_1 AS (SELECT \"LIFNR\" , \"BBBEE_CERTIF003\" , \"BBBEE_CONTR_001\" , \"BBBEE_EXPIRY005\" , \"BEE_CLASS001\" , \"BLACK_YOUTH_001\" , \"ENTERPR_SIZE001\" , \"NON_DISCRETI001\" , \"OTHER_YOUTH_002\" , \"SA_BLK_MEN010\" , \"SA_BLK_MEN_Y013\" , \"SA_BLK_OWN009\" , \"SA_BLK_WOMEN011\" , \"SA_BLK_WOMEN014\" , \"SA_BLK_YOUTH012\" , \"BEE_STATUS\" , \"MULTI_NATIONAL\" , \"CUOBJ\" FROM \"SCM\".\"1CL_OVEN003$VT\" AS \"1CL_OVEN003$VT\") , _SYS_WITH_0 AS (SELECT \"SCM_1CL_OVEN003$VT_SRC\".\"LIFNR\" AS \"LIFNR\", \"SCM_1CL_OVEN003$VT_SRC\".\"BBBEE_CERTIF003\" AS \"BBBEE_CERTIF003\", \"SCM_1CL_OVEN003$VT_SRC\".\"BBBEE_CONTR_001\" AS \"BBBEE_CONTR_001\", \"SCM_1CL_OVEN003$VT_SRC\".\"BBBEE_EXPIRY005\" AS \"BBBEE_EXPIRY005\", \"SCM_1CL_OVEN003$VT_SRC\".\"BEE_CLASS001\" AS \"BEE_CLASS001\", \"SCM_1CL_OVEN003$VT_SRC\".\"BLACK_YOUTH_001\" AS \"BLACK_YOUTH_001\", \"SCM_1CL_OVEN003$VT_SRC\".\"ENTERPR_SIZE001\" AS \"ENTERPR_SIZE001\", \"SCM_1CL_OVEN003$VT_SRC\".\"NON_DISCRETI001\" AS \"NON_DISCRETI001\", \"SCM_1CL_OVEN003$VT_SRC\".\"OTHER_YOUTH_002\" AS \"OTHER_YOUTH_002\", \"SCM_1CL_OVEN003$VT_SRC\".\"SA_BLK_MEN010\" AS \"SA_BLK_MEN010\", \"SCM_1CL_OVEN003$VT_SRC\".\"SA_BLK_MEN_Y013\" AS \"SA_BLK_MEN_Y013\", \"SCM_1CL_OVEN003$VT_SRC\".\"SA_BLK_OWN009\" AS \"SA_BLK_OWN009\", \"SCM_1CL_OVEN003$VT_SRC\".\"SA_BLK_WOMEN011\" AS \"SA_BLK_WOMEN011\", \"SCM_1CL_OVEN003$VT_SRC\".\"SA_BLK"}

There is no ST22 dump in the S/4HANA system to analyse.

We've done the same in a QA space and the snapshot was loaded without any errors.

Your guidance will be appreciated.

Kind regards

Neels Faurie

[cardoso]

Hello,

Could you check the DPAgent log file (framework.trc)?
Perhaps it should contain additional info.

BR.

[cjfaurie_1616]

Good morning BR.

Thanks for the tip.

Kind regards

Neels Faurie