Error itgenase094

mds · July 17, 2026, 7:30am

I encounter the following message with a client when I try to import data via the Data Hub. I have updated the data hub to 26.0 and everything worked in Invantive Data Hub 24.0.

I’m having issues with this syntax:

create or replace table eol_test@sql
as
select ‘Test’ Test, getdate() SumatraTimeStamp

but also with this syntax:

create or replace table eol_accountsincremental@sql
as
select \*, getdate() SumatraTimeStamp
from   accountsincremental@eol

The user running the SQL connection is SYSADMIN on the Microsoft SQL Server.

The table is being created, however, it is not being populated.

**** 07:19:48.514 Warning itgendhb173: Context: create or replace table eol_test@sql
as
select ‘Test’ Test, getdate() SumatraTimeStamp
07:19:48.598 Error itgenase094: The table cannot be created.

Could not bulk insert 1 rows into the table ‘Invantive.dbo.EOL_TEST’.

Cannot access destination table ‘Invantive.dbo.EOL_TEST’.

Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
EOL_TEST
07:19:50.613 Microsoft.Data.SqlClient.SqlException
System.InvalidOperationException
InvantiveSystemException
ValidationException
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at Microsoft.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
at Microsoft.Data.SqlClient.SqlBulkCopy.CreateAndExecuteInitialQueryAsync(BulkCopySimpleResultSet& result)
at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource\`1 source)
07:19:50.622 itgendhb223: End program execution with exit code 3.
07:19:50.623 itgendhb068: Program finished on 7/17/2026 7:19:50 AM.
itgenpgm001: Application finished

forums · July 17, 2026, 8:34am

The message “Cannot access destination table” indicates that the user has not been granted sufficient permissions.

Could you check if the user you are logged in with has privileges to perform create and insert actions? Is it possible to create a table and add a row with the mentioned user via SQL Server Management Studio or similar apps?

mds · July 17, 2026, 8:58am

I have the following permissions based on this query:

SELECT \*
FROM fn_my_permissions('dbo.EOL_TEST', 'OBJECT')

Result:

dbo.EOL_TEST SELECT
dbo.EOL_TEST UPDATE
dbo.EOL_TEST REFERENCES
dbo.EOL_TEST INSERT
dbo.EOL_TEST DELETE
dbo.EOL_TEST EXECUTE
dbo.EOL_TEST RECEIVE
dbo.EOL_TEST VIEW CHANGE TRACKING
dbo.EOL_TEST VIEW DEFINITION
dbo.EOL_TEST ALTER
dbo.EOL_TEST TAKE OWNERSHIP
dbo.EOL_TEST CONTROL
dbo.EOL_TEST rowid$ SELECT
dbo.EOL_TEST TEST SELECT
dbo.EOL_TEST rowid$ UPDATE
dbo.EOL_TEST TEST UPDATE
dbo.EOL_TEST rowid$ REFERENCES
dbo.EOL_TEST TEST REFERENCES

mds · July 17, 2026, 9:00am

I have the following permissions on the database:

database CREATE TABLE
database CREATE VIEW
database CREATE PROCEDURE
database CREATE FUNCTION
database CREATE RULE
database CREATE DEFAULT
database BACKUP DATABASE
database BACKUP LOG
database CREATE DATABASE
database CREATE TYPE
database CREATE ASSEMBLY
database CREATE XML SCHEMA COLLECTION
database CREATE SCHEMA
database CREATE SYNONYM
database CREATE AGGREGATE
database CREATE ROLE
database CREATE MESSAGE TYPE
database CREATE SERVICE
database CREATE CONTRACT
database CREATE REMOTE SERVICE BINDING
database CREATE ROUTE
database CREATE QUEUE
database CREATE SYMMETRIC KEY
database CREATE ASYMMETRIC KEY
database CREATE FULLTEXT CATALOG
database CREATE CERTIFICATE
database CREATE DATABASE DDL EVENT NOTIFICATION
database CONNECT
database CONNECT REPLICATION
database CHECKPOINT
database SUBSCRIBE QUERY NOTIFICATIONS
database AUTHENTICATE
database SHOWPLAN
database ALTER ANY USER
database ALTER ANY ROLE
database ALTER ANY APPLICATION ROLE
database ALTER ANY COLUMN ENCRYPTION KEY
database ALTER ANY COLUMN MASTER KEY
database ALTER ANY SCHEMA
database ALTER ANY ASSEMBLY
database ALTER ANY DATABASE SCOPED CONFIGURATION
database ALTER ANY DATASPACE
database ALTER ANY EXTERNAL DATA SOURCE
database ALTER ANY EXTERNAL FILE FORMAT
database ALTER ANY MESSAGE TYPE
database ALTER ANY CONTRACT
database ALTER ANY SERVICE
database ALTER ANY REMOTE SERVICE BINDING
database ALTER ANY ROUTE
database ALTER ANY FULLTEXT CATALOG
database ALTER ANY SYMMETRIC KEY
database ALTER ANY ASYMMETRIC KEY
database ALTER ANY CERTIFICATE
database ALTER ANY SECURITY POLICY
database SELECT
database INSERT
database UPDATE
database DELETE
database REFERENCES
database EXECUTE
database ALTER ANY DATABASE DDL TRIGGER
database ALTER ANY DATABASE EVENT NOTIFICATION
database ALTER ANY DATABASE AUDIT
database ALTER ANY DATABASE EVENT SESSION
database KILL DATABASE CONNECTION
database VIEW ANY COLUMN ENCRYPTION KEY DEFINITION
database VIEW ANY COLUMN MASTER KEY DEFINITION
database VIEW DATABASE STATE
database VIEW DEFINITION
database TAKE OWNERSHIP
database ALTER
database ALTER ANY MASK
database UNMASK
database EXECUTE ANY EXTERNAL SCRIPT
database CONTROL

forums · July 17, 2026, 9:07am

It’s not entirely clear from the list, but does the user have the rights to delete tables?

mds · July 17, 2026, 9:11am

I can manually add a table in Microsoft SQL Server:

CREATE TABLE dbo.TestInsert (Waarde varchar(50) );

I can also manually add a row:

INSERT INTO dbo.TestInsert VALUES ('Test');

Invantive Data Hub Multi-Platform (26.0.173-PROD+5992)

forums · July 17, 2026, 9:12am

Forums indicate that when using bulk copy with the SQL Server driver for .NET, the error “Invalid column name ‘graph_type’.” may occur.

SQL Server 2016: Operations failed with Invalid column name ‘graph_type’ because the metadata query referenced a column that doesn’t exist before SQL Server 2017.

See also:

It is still unclear whether this applies to our software release. Which version of SQL Server is being used? And which version of Invantive software?

forums · July 17, 2026, 9:13am

Is it possible to try this version?

https://download.invantive.com/release/msi/Invantive%20Data%20Hub-win-x64-net10.0-windows-26.0.180.zip

mds · July 17, 2026, 9:14am

mds · July 17, 2026, 9:27am

I keep getting this error message:

**** 09:27:25.120 Warning itgendhb173: Context: create or replace table test123@sql
as
select
‘Hallo’ as Text
09:27:25.188 Error itgenase094: The table cannot be created.

Could not bulk insert 1 row into the table ‘Invantive.dbo.TEST123’.

Cannot access destination table ‘Invantive.dbo.TEST123’.

Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
Invalid column name ‘graph_type’.
TEST123
09:27:27.206 Microsoft.Data.SqlClient.SqlException
System.InvalidOperationException
InvantiveSystemException
ValidationException
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at Microsoft.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
at Microsoft.Data.SqlClient.SqlBulkCopy.CreateAndExecuteInitialQueryAsync(BulkCopySimpleResultSet& result)
at Microsoft.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource\`1 source)
09:27:32.917 itgendhb223: End program execution with exit code 3.

forums · July 17, 2026, 9:35am

Which version of SQL Server is being used?

forums · July 17, 2026, 10:48am

The cause was a known bug in a component for SQL Server. This component has been replaced in the next release. When it is ready, it will be available via:

https://download.invantive.com/release/msi/Invantive%20Data%20Hub-win-x64-net10.0-windows-26.0.182.zip

Topic		Replies	Views
Itgenase094 De tabel kan niet worden gemaakt: Invalid column name ‘graph_type’ Vragen (alle) invantive-data-hub , sql-server	2	3	June 30, 2026
Itgensql056 Syntax error op result_set_name(*"ProjectTimeTransactions"*) Vragen (alle) exact-online , invantive-sql	4	9	September 8, 2026
Itgenfby111: Statement #5 'create or rep...ncremental@eol' starting on line 19 caused an error Vragen (alle) exact-online , invantive-query-tool , invantive-data-hub	4	12	May 29, 2026
Itgendid354 bij uitlezen SnelStart SQL-server database op SQL Server 2014 Vragen (alle) invantive-sql , snelstart , microsoft-sql-server	3	28	January 29, 2026
Foutmelding itgenfby111 Exact Online na update Vragen (alle) exact-online , invantive-sql	4	33	January 29, 2026

Error itgenase094

Related topics