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
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.
This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.