SG-381 Data Lake Upload Setup | Tables - SQLException for R5ADDETAILS synchronization - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

SG-381 Data Lake Upload Setup | Tables - SQLException for R5ADDETAILS synchronization

 Description 

When ADD_TEXT is added to the list of fields for table R5ADDETAILS, the sync over to data lake fails with error "_There is an error getting Tenant data for table R5ADDETAILSAn SQLException occurred getting the Tenant Data from table R5ADDETAILS._ _Check Tenant connection information._ _Exception Message Stream has already been closed_"

*Steps to reproduce:*

# go to Data Lake Upload Setup screen and create a new schedule

# on the tables tab add a record for R5ADDETAILS table, and verify all the fields have been added, including ADD_TEXT (which is a LONG data type field)

# on the ION Desk, add the eam_R5ADDETAILS data catalog element to the eam_ims connection point and to the data lake flow, and restart the data lake flow

# on EAM, activate both the schedule and the table

*Expected result:*

Data should get synchronized over to data lake

*Actual result:*

The table remains in an error status. Already tried to add the ADD_TEXT field after the ADD_LASTSAVED one, and restarted the data lake flow, but it made no difference.