a month ago
Hello,
@YSE-1trying to build a pretty straightforward dimension based on a picklist field.
All the other dimensions were fine, this one breaks the build at around 19 minutes.
Tried creating a calculated column to bring the value from it, same. Tried fresh template and redo, same. Can t really see any reason for it..
18/11/2024 17:32:35 | ERROR:: [GIRRU: Hana Destination; Code: Hana Writer] (0) =================================================== |
18/11/2024 17:32:35 | ERROR:: [Hana Destination] (0) Exception occured in Girru: SAP DBTech JDBC: [274]: inserted value too large for column: TrexUpdate failed on table 'BCXT1_OLAP_NEXT:FACT_TABLE_1_TEMP' with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length (100) violated on pos 231, value='Pick n Pay, Shoprite, Absa, Cashbuild, TFG, Truworths, Woolworths, Mr Price Group, Queenspark & Clicks',column 'FACT_TABLE_1_A_33_BRANCH_ID', table '$table$', rc=6959(input position 246,522) |
18/11/2024 17:32:35 | ERROR:: [Hana Destination [6293]] (-1073450910) InfoHRM.Girru.Components.InputProcessingException: Uncaught exception during input processing; Component=Hana Destination ---> com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: SAP DBTech JDBC: [274]: inserted value too large for column: TrexUpdate failed on table 'BCXT1_OLAP_NEXT:FACT_TABLE_1_TEMP' with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length (100) violated on pos 231, value='Pick n Pay, Shoprite, Absa, Cashbuild, TFG, Truworths, Woolworths, Mr Price Group, Queenspark & Clicks',column 'FACT_TABLE_1_A_33_BRANCH_ID', table '$table$', rc=6959(input position 246,522) at com.sap.db.jdbc.CallableStatementSapDB.executeBatch() at com.sap.db.jdbc.trace.PreparedStatement.executeBatch() at HanaClientIkvm.IkvmHanaClient.CommitTransaction(Action`1 logger) at InfoHRM.Girru.Components.CoreWorkforce.HanaDestination.HanaWriter.Start(PipelineBuffer buffer) at InfoHRM.Girru.Components.SingleOutputWriter.ProcessInput(Int32 inputID, PipelineBuffer buffer) --- End of inner exception stack trace --- at InfoHRM.Girru.Components.PipelineComponentUtil.ReportDebugInfo(InputProcessingException e, Logger logger) at InfoHRM.Girru.Components.SingleOutputWriter.ProcessInput(Int32 inputID, PipelineBuffer buffer) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostProcessInput(IDTSManagedComponentWrapper100 wrapper, Int32 inputID, IDTSBuffer100 pDTSBuffer, IntPtr bufferWirePacket) |
18/11/2024 17:32:35 | ERROR:: [SSIS.Pipeline] (-1073450974) SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Hana Destination" (6293) failed with error code 0x80131500 while processing input "DefaultInput" (6295). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. |
18/11/2024 17:32:35 | INFORMATION:: [SSIS.Pipeline] (1074016264) Post Execute phase is beginning. |
Many thanks in advance!
Kind regards,
Alex
Request clarification before answering.
Hi @abalasescu2 - as per the error message:
inserted value too large for column: TrexUpdate failed on table 'BCXT1_OLAP_NEXT:FACT_TABLE_1_TEMP' with error: AttributeEngine: indexed value not within specified range;checkCesu8StringColumn(): max length (100) violated on pos 231, value='Pick n Pay, Shoprite, Absa, Cashbuild, TFG, Truworths, Woolworths, Mr Price Group, Queenspark & Clicks',column 'FACT_TABLE_1_A_33_BRANCH_ID', table '$table$', rc=6959(input position 246,522)
the value is too large for the calculated column. There is example value mentioned in the error message as well (see red bold text above). Try to increase the length of the calculated column.
Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.