ARCMAIN-----ARC1239:Orphan dictionary row discarded.

Tools
sky
Fan

ARCMAIN-----ARC1239:Orphan dictionary row discarded.

hi all,
when I resore table from backup tape.
there are the following error msg.
The restore script is
COPY DATA TABLES (ac4cpms.CALLRPT) (from (prdcpms.CALLRPT),NO FALLBACK)....

The log is:

06/15/2007 15:41:39 STARTING TO COPY DATABASE "AC4CPMS"
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:41:53 *** Warning ARC1239: Orphan dictionary row discarded.
06/15/2007 15:42:02 DICTIONARY COPY COMPLETED
06/15/2007 15:42:03 *** Error 3807: Object 'AC4CPMS.CALLRPT' does not exist.
06/15/2007 15:42:03 "AC4CPMS"."CALLRPT" - LOCK NOT RELEASED
06/15/2007 15:42:03 "AC4CPMS" - DATABASE SKIPPED.

Thx
2 REPLIES
N/A

Re: ARCMAIN-----ARC1239:Orphan dictionary row discarded.

I was wondering if you found out anything on this? We have had the same type of message on a resent restore.
sky
Fan

Re: ARCMAIN-----ARC1239:Orphan dictionary row discarded.

I have resolved it.
It is due to we restore table with journal table to table with no journal table.
we can use the following restore table SQL(Notes:use the parameter "NO JOURNAL").
COPY DATA TABLES (ac4cpms.CALLRPT) (from (prdcpms.CALLRPT),NO FALLBACK,NO JOURNAL).