Restituisci
-
Titolo
Ledger database, updatable ledger tables, and append-only ledger tables are not supported -
Descrizione
Microsoft SQL Server, Microsoft Azure SQL and Microsoft SQL Managed Instance provide a feature called Ledger with components like Ledger database, updatable ledger tables, and append-only ledger tables.
Database with this feature enabled are not supported for installing or running One Identity Manager.
-
Causa
This feature breaks compatibility with One Identity Manager. Ledger brings various predefined columns and tables that cannot be removed. Also, various DML and DDL SQL statements (e.g. TRUNCATE TABLE) are not available. This can lead to error messages.
Processing step 'QBM SchemaIndexes (create indexes for schema)' failed.
[810143] Database error 50000: String or binary data would be truncated in table '<DBName>.sys.TT_QBM_YCursorBuffer_6383C8BA', column 'Ident1'. Truncated value: 'MSSQL_LedgerHistoryFor_2130822'.
Setup soon will fail as the features Ledger database causes SQL Server to add additional columns to tables on creation and creates an additional table for every table created by setup. Those have names longer than 30 characters (in contradiction to OneIM naming convention) but contain the same column definition as our tables. This causes the call of QBM_PIndexCreateGenerated_XO to find hundreds of columns named XObjectKey on tables violating table name restrictions.
-
Risoluzione
Do not enable this feature for databases which are in preparation for or already are in use by One Identity Manager.
Reference links:
Refer to Microsoft article for Ledger Overview:
https://learn.microsoft.com/en-us/sql/relational-databases/security/ledger/ledger-landing-sql-server