Hi ,
I am getting below error while performing upsert on hana table
"SQL submitted to database <> resulted in error <[SAP AG][LIBODBCHDB SO][HDBODBC] General error;274 inserted value too large for column: TrexUpdate failed on table ‘QUOTEEDGE:MTL_SYSTEM_ITEMS_B’ with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length violated on pos 0, value=18683743.0000000,column ‘MUST_USE_APPROVED_VENDOR_FLAG’, table ‘QUOTEEDGE:MTL_SYSTEM_ITEMS_B’,location=phyhanapp02-prd:30003, rc=6959 "
Already check upsert statement value for column MUST_USE_APPROVED_VENDOR_FLAG is getting passed N from one of intermediate inetrnally created DT table
Below is job flow
source table->query transform-> query trasform-> target table(upsert)
Please help me understand this error
regards,
mukta
mukta (BOB member since 2014-08-15)