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. |