Itgenase094: The table can not be created

Vragen
, ,
1

Bij het uitvoeren van:

create or replace table Invantive..Items@sql
as
select *
from   ItemsIncremental@eol

krijg ik de foutmelding op SQL Server 2016 (release 2017-08-08):

itgenase094: The table can not be created.

Maintenance of the table 'INVANTIVE..ITEMS' failed.

Incorrect syntax near '.'.
Incorrect syntax near '.'.
Incorrect syntax near '.'.
Incorrect syntax near '.'.
Incorrect syntax near '.'.

Message ID: ae9326c5-4e3f-46b9-b527-9241a66666cd

Occurred (UTC): 7/19/2023 8:33:18 AM

System.Data.SqlClient.SqlException
ValidationException
ValidationException
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Invantive.Data.AnsiSqlProviderBase.PassthroughSqlAction(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String loggingTableName)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Invantive.Data.AnsiSqlProviderBase.PassthroughSqlAction(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String loggingTableName)
   at Invantive.Data.Providers.SqlServer.SqlServerProvider.EnsureTableExists(GlobalState owner, ExecutionOptions executionOptions, String nonStandardizedPartitionCode, TableSpecification tableSpecification, Int32 preferredSqlDdlPerBatch)
2

De SQL-statements die een foutmelding geven zijn:

if not exists ( select 'x' c from sys.indexes idx where idx.name = 'INVANTIVE..ITEMS2_Timestamp') create index INVANTIVE..ITEMS2_Timestamp on INVANTIVE..ITEMS2 ([Timestamp]);

if not exists ( select 'x' c from sys.indexes idx where idx.name = 'INVANTIVE..ITEMS2_ID') create index INVANTIVE..ITEMS2_ID on INVANTIVE..ITEMS2 (ID);

if not exists ( select 'x' c from sys.indexes idx where idx.name = 'INVANTIVE..ITEMS2_ItemGroup') create index INVANTIVE..ITEMS2_ItemGroup on INVANTIVE..ITEMS2 (ItemGroup);

if not exists ( select 'x' c from sys.indexes idx where idx.name = 'INVANTIVE..ITEMS2_Modified') create index INVANTIVE..ITEMS2_Modified on INVANTIVE..ITEMS2 (Modified);

if not exists ( select 'x' c from sys.indexes idx where idx.name = 'INVANTIVE..ITEMS2_StartDate') create index INVANTIVE..ITEMS2_StartDate on INVANTIVE..ITEMS2 (StartDate);