Skip to Content
0
Jul 27, 2023 at 03:08 PM

Internal Error when viewing data in Remote Table in Datasphere

124 Views Last edit Jul 27, 2023 at 03:09 PM 2 rev

We have a functioning connection between AWS Athena and SAP Datasphere.

Using this connection, we have imported around 26 remote tables and all work normally.
However there are two imported remote tables that cannot load data. When trying to view data in the remote table, the following error message shows:
"transaction rolled back by an internal error: (worker1: basic_ios::clear)"

When trying to load a snapshot of the table, the following error message shows (under Status):
"An error occurred during snapshot replication.
On Thu Jul 27 2023 at 11:35:59 GMT+0200 (Central European Summer Time), an SQL error code (71000129) occurred while replicating data for the remote table 'table_name'. Use the links below to view the detailed error message, and to check the replication task logs of remote table 'table_name'.
SQLException; (worker1: basic_ios::clear)(worker2: basic_ios::clear) "


Q uestions:

  • Could we understand why is this happening?
  • How can we resolve this issue?