My Oracle Support Banner

ODEE On SQL Server Throws Errors During Out Of Box Installation. (Doc ID 2799178.1)

Last updated on AUGUST 13, 2021

Applies to:

Oracle Documaker - Version 12.6.4 and later
Information in this document applies to any platform.

Symptoms

An out of box installation of ODEE on SQL Server 2020 throws errors, such as:

“Invalid column meta data for column <SYS_ID> in table and schema <DMKR_ADMIN>”

The dmkr_asline.sql is apparently not assigning the ODEE on SQL Server the proper grants that Documaker needs.

After a lot of triage, the only way to make these errors go away is to apply 'sysadmin' to the dmkr_asline user (even 'db_owner' throws errors).

This is:
SQL Server 2020 on Windows Server 2020

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.