Question Re: Datasphere Partition Error - unexpected value: decfloat34 has invalid format in Technology Q&A

Datasphere Partition Error - unexpected value: decfloat34 has invalid format

bhat_vaidya2 — Mon, 11 Sep 2023 08:26:17 GMT

Hi,

I am new to SAP Datasphere and getting below error when trying to replicate table from ECC into Datasphere using Replication flow.

I do not understand when there has to be a field check in the amount field. Shouldn't replication be a copy of source table to target table ?

Re: Datasphere Partition Error - unexpected value: decfloat34 has invalid format

natalia_cristiano2 — Mon, 11 Sep 2023 14:01:29 GMT

Hi bhat.vaidya2

Several weeks ago, we encountered an error and had to change the precision to the data type. Our error says:

General error;314 numeric overflow: TrexColumnUpdate failed on table 'SPACE_PRD:BT_x' with error: AttributeEngine: overflow in numeric calculation;exception 1000013: cannot convert the value to DECIMAL(15, 5) in checkDecimalColumn(): got invalid value 11050000000 on pos 53966,column 'NETx'; $table$=SPACE_PRD:BT_x, rc=6944>

We identified the case y solve it changing it the precision to the data type. Maybe it helps.

Natalia.

Re: Datasphere Partition Error - unexpected value: decfloat34 has invalid format

bhat_vaidya2 — Mon, 18 Sep 2023 07:04:41 GMT

Hi,

How did you manage to change the data type as I am not able to do that or have the option of updating it.

thanks.,

Re: Datasphere Partition Error - unexpected value: decfloat34 has invalid format

bhat_vaidya2 — Mon, 16 Oct 2023 10:08:13 GMT

Hi,

Issue is now resolved after implementation of SAP notes.

thanks

Re: Datasphere Partition Error - unexpected value: decfloat34 has invalid format

Anil1 — Fri, 16 Feb 2024 22:37:40 GMT

what is the Note number you implemented.

Re: Datasphere Partition Error - unexpected value: decfloat34 has invalid format

danielb98 — Fri, 23 Feb 2024 13:49:49 GMT

3391648