Dear All,
we just upgraded to SP13 and we have some issue in Data Transfer transform process.
We use a varchar(3) variable named '$Sourcesystem' because we load data from different postgresql Dbs to HANA 2.0 and in some DF's we have created a varchar(20) field using the variable in this way:
$Sourcesystem || lpad (registration_person.id, 17, 0)
where registration_person is the source table, so we populate the field like 'PRD00000000000012345' (12345 is the id).
It works fine also after the upgrade except in DFs where we use the data transfer transform with the error:
General error;274 inserted value too large for column: TrexUpdate failed on table 'SCOPE:ZT_TEST_DATA_TRANSFER_TER' with error:
AttributeEngine: indexed value not within specified range;checkStringColumn(): max length violated on pos 0,
value=䕙き ㈀, rc=6959
if we modify the mapping in:
'PRD' || lpad (registration_person.id, 17, 0)
It works fine.
Do you have any idea about this issue?
Best Regards
Lica