Skip to main content

Avatar Data Warehouse Middleware Update 2024.1.001 Summary

  1. Last updated
  2. Save as PDF
NEW13 CHANGED0 FIXED2
New (13)
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
Value Added: Improvements to Data Warehouse Table Processing and files
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
Value Added: Improvements to Data Warehouse Table Processing and files
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 "
Value Added: Improvements to Data Warehouse Internal files
Topics
• Data Warehouse
 
Data Warehouse Middleware - log files
The Data Warehouse Middleware log files have been updated with enhanced encryption.
KB0063812
Value Added: Improvements to Data Warehouse Table Processing and files
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.
Value Added: Improvements to Data Warehouse Internal files
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.
Value Added: Improvements to Data Warehouse Internal files
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.
Value Added: Improvements to Data Warehouse Internal files
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.
Value Added: Improvements to Data Warehouse Internal files
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
Value Added: Improvements to Data Warehouse Table Processing and files
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.
Value Added: Improvements to Data Warehouse Table Processing and files
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
Value Added: Improvements to Data Warehouse Table Processing and files
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.
Value Added: Improvements to Data Warehouse Table Processing and files
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"
Value Added: Improvements to Data Warehouse Internal files
Topics
• Data Warehouse
 
Fixed (2)
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
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.
Topics
• Data Warehouse
 

Avatar_Data_Warehouse_Middleware_Update_2024.1.001_Details.csv