Itgenase094: El identificador 'langwoord' en la base de datos con alias 'sql' es más largo que el máximo de 63 caracteres

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)