BusinessObjects Board

Broken Pipe error While executing

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 :netherlands: (BOB member since 2014-08-15)