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.

3

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.

4

Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.