Itgenase094 when copying Exact Online to local Oracle RDBMS database

Questions
, ,
1

When copying Exact Online-data from Exact Online Germany table ProjectsIncremental to a table in Oracle RDBMS, the following error occurs:

itgenase094
The value of the parameter with name ‘:w7ACCOUNT’ with key ‘:w7ACCOUNT’ must match the data type ‘System.Guid’.
The value currently has data type ‘System.String’.

Statement:

create or replace table test2@ora
as
select *
from projectsincremental@eol
2

This error can occur when data in GUID-format is presented as text. Depending on the ANSI SQL-database platform, this can lead to an itgenase094 error during insert.

A fix has been included in the next maintenance release 23.0.111. It will also be available in BETA-releases after November 30, 2023.