Bij het uploaden van XAF auditfiles in PostgreSQL via de volgende code:
--
-- Upload all XAF files.
--
begin
for r in
( select name
, lower
( case
when length(name) < 50
then name
else left(name, 20) || md5(name)
end
) sqlname
from systemtables@datadictionary
where provider_name = 'Xaf32'
order
by name
)
loop
execute immediate 'create or replace table xaf32' || r.sqlname || '@sql as select * from ' || r.name || '@xaf32';
end loop;
end;
krijg ik de volgende foutmelding:
itgenase094: Statement #1 '--
-- Upload...nd loop;
end;' beginnend op regel 1 veroorzaakte een fout.
De tabel kan niet worden gemaakt.
Onderhoud van de tabel 'XAF32COUNTERPARTYHISTORIES' is mislukt.
Identifier 'customersupplierhistory_customersupplier_changeinfo_changedatetime' op database met alias 'sql' is langer dan maximaal 63 tekens.
Bericht ID: fe5a0a8c-b6e6-4c17-b107-22d450fdc0c1
Opgetreden (UTC): 17-2-2023 14:39:27
Invantive.Basics.InvantiveSqlException
ValidationException
ValidationException
ValidationException
bij Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String url)
bij Invantive.Basics.InvantiveSqlException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId)
bij Invantive.Data.GenericProvider.GetStandardizedIdentifier(GlobalState owner, ExecutionOptions executionOptions, String identifierName, Boolean failOnInvalidAfterStandardizing)
bij Invantive.Data.Providers.PostgreSql.PostgreSqlProvider.CZK(GlobalState , ExecutionOptions , String , ColumnSpecification , Int32 , ParameterList& )
bij Invantive.Data.Providers.PostgreSql.PostgreSqlProvider.EnsureTableExists(GlobalState owner, ExecutionOptions executionOptions, String nonStandardizedPartitionCode, TableSpecification tableSpecification, Int32 preferredSqlDdlPerBatch)
bij Invantive.Data.AnsiSqlProviderBase.CreateTable(GlobalState owner, ExecutionOptions executionOptions, String applicationCode, String nonStandardizedPartitionCode, String tableName, String code, ResultSet resultSet, Nullable`1 maxBatchSizeRows)
bij Invantive.Sql.V1.DdlStatementTree.<CreateTable>d__102.MoveNext()
bij Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
bij Invantive.Sql.V1.FirehoseResultSet.LR.MoveNext()
bij Invantive.Sql.V1.QueryPlan.VY.MoveNext()
bij Invantive.Data.ExtensionMethods.NKG`1.JKG.MoveNext()
bij System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
bij System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
bij Invantive.Data.ConnectionManager.TI.S(QueryPlan )
bij System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
bij System.Linq.Buffer`1..ctor(IEnumerable`1 source)
bij System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
bij Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, QueryPlan[] queryPlans, String sqlStatement, ParameterList parameters)
bij Invantive.Data.ConnectionManager.MS(GlobalState , ExecutionOptions , QueryPlan[] , String , ParameterList )
bij Invantive.Sql.V1.PSqlParser.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, IProviderManager manager, String sqlStatement, ISparseArray variablesRow, DatabaseColumn[] intoVariables, PSqlBindVariableDeclaration[] bindVariables)
bij LambaExecutePSqlTree45(Closure , GlobalState , ExecutionOptions , IQueryStatePerExecution , ISparseArray , ISparseArray )
bij Invantive.Sql.V1.PSqlStatementTree.<Fetch>d__29.MoveNext()
bij Invantive.Data.CompressedEnumerable`1.<GetEnumerator>d__10.MoveNext()
bij Invantive.Sql.V1.FirehoseResultSet.LR.MoveNext()
bij Invantive.Sql.V1.QueryPlan.VY.MoveNext()
bij Invantive.Data.ExtensionMethods.NKG`1.JKG.MoveNext()
bij System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
bij System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
bij Invantive.Data.ConnectionManager.TI.S(QueryPlan )
bij System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
bij System.Linq.Buffer`1..ctor(IEnumerable`1 source)
bij System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
bij Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, QueryPlan[] queryPlans, String sqlStatement, ParameterList parameters)
bij Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
bij Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)
bij Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters)
bij Invantive.Producer.Windows.Forms.QueryToolResults.SEW(GlobalState , ExecutionOptions , IProgressNotifier , String , ParameterList , Boolean , Boolean , Boolean , Boolean )
bij Invantive.Producer.Windows.Forms.QueryToolResults.XEW(GlobalState , ExecutionOptions , String , String , Boolean )
bij Invantive.Producer.Windows.Forms.QueryToolResults.ExecuteStatements(GlobalState owner, ExecutionOptions executionOptions)
bij Invantive.Producer.Windows.Forms.QueryToolDocumentViewModel.XM.EM.MoveNext()
bij System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bij System.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
bij System.Threading.ThreadPoolWorkQueue.Dispatch()
bij Invantive.Data.GenericProvider.GetStandardizedIdentifier(GlobalState owner, ExecutionOptions executionOptions, String identifierName, Boolean failOnInvalidAfterStandardizing)
bij Invantive.Data.Providers.PostgreSql.PostgreSqlProvider.CZK(GlobalState , ExecutionOptions , String , ColumnSpecification , Int32 , ParameterList& )
bij Invantive.Data.Providers.PostgreSql.PostgreSqlProvider.EnsureTableExists(GlobalState owner, ExecutionOptions executionOptions, String nonStandardizedPartitionCode, TableSpecification tableSpecification, Int32 preferredSqlDdlPerBatch)