My Oracle Support Banner

Issue with Promotion and Verification Of SQL Server Resource Library (Doc ID 1584665.1)

Last updated on FEBRUARY 26, 2020

Applies to:

Oracle Documaker - Version 12.1 and later
Information in this document applies to any platform.
Documaker Server, Documaker Studio, Promotion, SQL Server, Resource, Library


We were able to successfully export the 12.1 Studio resource library from UDB Database to the SQL Server database using the promotion wizard.

Although the databases (both UDB and SQL Server) reside on a database at a different location, the promotion wizard was run from a workstation in a different physical location (India).

The ODBC DB Handlers for this promotion were set up and tested to be fine. The promotion logs also showed no errors.

These promoted resources in SQL Server database was then verified using the SQL Server 2008 R2 Client.

Records for the different components were readable from the SQL Server client in all the index, data, catalog & log tables (an exception being CARDATA field which is generally not readable as it uses the compressed bit data format).

In the Studio 12.1 wizard, these resources were listed on the ‘Library’ window but are not available for ‘Read’ or ‘Checkout’.

A blank screen appears when the components are previewed (i.e. on the ‘Preview’ tab).

The ‘Checkout’ option is not listed on right-clicking the components.

When ‘Read’ is clicked on any of these components, the component does not show up. Instead the screen remains inactive.

The DB Handler connectivity to the database has been verified from the workstation. This issue occurs only when the promotion wizard is run from a different physical location than the databases. For example, in this case, the databases were in Fortworth and the promotion wizard was run from a workstation in India.


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

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