cancel
Showing results for 
Search instead for 
Did you mean: 

WFA on HANA failed cube

abalasescu2
Explorer
0 Kudos
163

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:35ERROR:: [GIRRU: Hana Destination; Code: Hana Writer] (0) ===================================================
18/11/2024 17:32:35ERROR:: [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:35ERROR:: [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:35ERROR:: [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:35INFORMATION:: [SSIS.Pipeline] (1074016264) Post Execute phase is beginning.

Many thanks in advance!

Kind regards,

Alex

 

View Entire Topic
YSE-1
Product and Topic Expert
Product and Topic Expert
0 Kudos

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.

abalasescu2
Explorer
0 Kudos
Hi, thanks for the reply! I have tried this and calc column length is now 256, still the same error...
abalasescu2
Explorer
0 Kudos
It seems the same: 12/01/2025 15:36:02 ERROR:: [GIRRU: Hana Destination; Code: Hana Writer] (0) =================================================== 12/01/2025 15:36:02 In WstHanaInstanceAgent.ReplenishFromCredServiceWhenToggledOn - Tenant secret read for 33 out of 33 record(s) and replenished in WstHanaInstanceAgent 12/01/2025 15:36:12 ERROR:: [GIRRU: Hana Destination; Code: Hana Writer] (0) =================================================== 12/01/2025 15:36:12 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 52, value='Pick n Pay, Shoprite, Absa, Cashbuild, TFG, Truworths, Woolworths, Mr Price Group, Queenspark & Clicks',column 'FACT_TABLE_1_A_37_BRANCH_ID', table '$table$', rc=6959(input position 246,768) 12/01/2025 15:36:12 ERROR:: [Hana Destination [6347]] (-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 52, value='Pick n Pay, Shoprite, Absa, Cashbuild, TFG, Truworths, Woolworths, Mr Price Group, Queenspark & Clicks',column 'FACT_TABLE_1_A_37_BRANCH_ID', table '$table$', rc=6959(input position 246,768) 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) 12/01/2025 15:36:12 ERROR:: [SSIS.Pipeline] (-1073450974) SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Hana Destination" (6347) failed with error code 0x80131500 while processing input "DefaultInput" (6349). 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. 12/01/2025 15:36:12 INFORMATION:: [SSIS.Pipeline] (1074016264) Post Execute phase is beginning. 12/01/2025 15:36:12 INFORMATION:: [SSIS.Pipeline] (1074016267) "Hana Destination" wrote 0 rows. 12/01/2025 15:36:12 INFORMATION:: [SSIS.Pipeline] (1074016265) Cleanup phase is beginning. 12/01/2025 15:36:12 2025-01-12 14:36:12 Task Process Initial Workforce (FACT_TABLE_1) (0): TaskHost componented failed. 12/01/2025 15:36:12 2025-01-12 14:36:12 Task Process Initial Workforce (FACT_TABLE_1) (0): Task has completed. 12/01/2025 15:36:12 WARNING:: [] (-2147381246) SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (16) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. 12/01/2025 15:36:12 PackageRunner errored: Package exited with result Failure (1). 12/01/2025 15:36:12 In PackageRunner Program.Main - Package runner failed for JobId : 'd358df01-d0f0-11ef-8833-c9fb97ee5dfd' with ExitCode : 'packageExecuteError' 12/01/2025 15:36:12 PackageRunner error. Job Id: d358df01-d0f0-11ef-8833-c9fb97ee5dfd, Job Name: Initial WorkforcePackage 2025-01-12 14:23:42Z, Package Name: Workforce Package BCXT1 12/01/2025 15:36:12 PackageRunner error. System.Exception: Failed to execute SSIS package. ---> System.Exception: Package exited with result Failure (1). at PackageRunner.PackageRunner.RunPackage(String userId) in D:\DCE\workspace\WFA\MNL-PatchRelease\GIT\FrontOffice\b2411\WST\PackageRunner\PackageRunner.cs:line 90 --- End of inner exception stack trace --- at PackageRunner.PackageRunner.RunPackage(String userId) in D:\DCE\workspace\WFA\MNL-PatchRelease\GIT\FrontOffice\b2411\WST\PackageRunner\PackageRunner.cs:line 98 at PackageRunner.Program.Main(String[] args) in D:\DCE\workspace\WFA\MNL-PatchRelease\GIT\FrontOffice\b2411\WST\PackageRunner\Program.cs:line 138 12/01/2025 15:36:12 In VaultApi.Shutdown - CredentialServiceProxy is purged 12/01/2025 15:36:12 In PackageRunner Program.Main - Credential service terminated 12/01/2025 15:36:12 Workforce run failed. 12/01/2025 15:36:13 SSIS Error occured for Process Fact Tables 12/01/2025 15:36:13 System.Exception: Failed to execute SSIS package. ---> System.Exception: Package exited with result Failure (1). at PackageRunner.PackageRunner.RunPackage(String userId) in D:\DCE\workspace\WFA\MNL-PatchRelease\GIT\FrontOffice\b2411\WST\PackageRunner\PackageRunner.cs:line 90 --- End of inner exception stack trace --- at PackageRunner.PackageRunner.RunPackage(String userId) in D:\DCE\workspace\WFA\MNL-PatchRelease\GIT\FrontOffice\b2411\WST\PackageRunner\PackageRunner.cs:line 98 at PackageRunner.Program.Main(String[] args) in D:\DCE\workspace\WFA\MNL-PatchRelease\GIT\FrontOffice\b2411\WST\PackageRunner\Program.cs:line 138 12/01/2025 15:36:13 There was an error while executing the package.
abalasescu2
Explorer
0 Kudos
How do I check that?
abalasescu2
Explorer
0 Kudos
I also found this: Creating function wfa_utc_to_tptz_nvarchar_ts (i_value nvarchar(5000) ) RETURNS e_res TIMESTAMP LANGUAGE SQLSCRIPT SQL SECURITY INVOKER AS BEGIN DECLARE ts TIMESTAMP; DECLARE EXIT HANDLER FOR SQL_ERROR_CODE 303 e_res = null; ts = CAST( i_value AS SECONDDATE); e_res = (CASE WHEN cast(i_value as timestamp) <= '0001-01-02' THEN '0001-01-01 00:00:00' WHEN cast(i_value as timestamp) >= '9999-12-30' THEN '9999-12-31 23:59:59.999999' ELSE UTCTOLOCAL( cast(i_value as timestamp) , 'Europe/Warsaw','platform') END); END;