Avatar Data Warehouse Middleware Update 2024.1.001 Details
- Last updated
-
-
Save as PDF
Data Warehouse - Middleware "Incremental" table logs
The Data Warehouse Middleware has been updated to skip rows that encounter an error while processing an "Incremental" loaded table and write the audit data to a 'SQL' server 'dw_error_log' table and a Cache server 'DW.dw_error_log" table
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - Middleware "Full" load table logs
The Data Warehouse Middleware has been updated to skip rows that encounter an error while processing a "Full" load table and write the audit data to a 'SQL' server 'dw_error_log' table and a Cache server 'DW.dw_error_log" table
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Date warehouse version
The Data Warehouse Middleware has been updated to save the Middleware version within Avatar in a new "internal" Global "^DWVersion "
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse Middleware - log files
The Data Warehouse Middleware log files have been updated with enhanced encryption.
KB0063812
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - Loading tables containing stream properties (signatures)
Resolves an issue to ensure a Data Warehouse load for tables that contain a stream property is successful.
KB0074410 v0.01
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Middleware - internal properties file
The maximum length of the free text fields within the Data Warehouse Middleware "dss.properties" file has been increased to allow up to 3,641,144.
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Middleware - internal file updates
The 'NTInstall'and' UnixInstall bat files within the "/bin" folder have been updated to include the 'sunjce_provider.jar' library.
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Middleware - new internal files
New ".bat" files, "NTTestConnection" and "UnixTestConnection" within the bin folder have been created, which can be used to test the current database connections from the Data Warehouse Middleware properties file.
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Date Warehouse Middleware - installation files
The middleware file 'dssinc.jar' has been moved to the "/dist" folder and the file "dss.properties" has been moved to the "/ bin" folder.
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - Loading tables with decimal type fields
Resolves an issue to ensure a Data Warehouse load for tables containing decimal properties is successful.
KB0074415 v0.01
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - Loading tables with field named with SQL type Keywords
Resolves an issue to ensure a Data Warehouse load for tables with column names that contain SQL Keywords is successful.
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - Loading fields with tables containing Special characters
Resolves an issue to ensure a Data Warehouse load for tables with property names that have special characters is successful.
KB0074421 v0.01
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - The "dss_inc_full_load_history table' data added on SQL server for queries
The "dss_inc_full_load_history table' data is updated to be pushed to the Data Warehouse Server after the middleware table load completes.
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - properties file
For Data Warehouse processing using SQL Server, there are now two new properties that can be set to adjust the JDBC URL, "sqlServer.serverEncrypt" and "sqlServer.serverCertificate"
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
Data Warehouse - Processing Tables with fields that are Double or Float type
The Data Warehouse Middleware has been updated to process Double and Float type properties within Avatar tables successfully.
Please Note: "Avatar Data Warehouse Update 26" is required for full functionality
|
Topics
• Data Warehouse
|
| |
Avatar_Data_Warehouse_Middleware_Update_2024.1.001_Details.csv
