Unable to Copy an OTM Domain

(Doc ID 736417.1)

Last updated on MAY 01, 2017

Applies to:

Oracle Transportation Management - Version 5.5.03 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Oct-2013***


Symptoms


When trying to copy a database using the steps below, the first attempt fails with the following error:

java.sql.SQLException: ORA-00942: table or view does not exist

In reviewing the logs, the table that this error is failing on is from the following SQL statement:

Exception select script_Text from domain_copy_script where copy_mode = 'SCHEMA' order by line_number

When the copy is attempted again, the following is printed to the screen and it is found that the domain is not copied:

FROM_DOMAIN TO_DOMAIN
<SOURCE_DOMAIN> to <COPY_DOMAIN>

Where <SOURCE_DOMAIN> and <COPY_DOMAIN> are the inputs selected on the Domain Copy
screen.

-- Steps To Reproduce:
1. Configuration and Administration > Domain Management > Add Domain.
2. Enter a Domain Name.
3. Select a Domain from the Copy-From Domain drop-down.
4. Click Copy Domain.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms