Trying to dump table contents using Database administration - Forum - OpenEdge RDBMS - Progress Community

Trying to dump table contents using Database administration

 Forum

Trying to dump table contents using Database administration

This question is not answered

11.7

Can anyone tell me how to dump the data using Dump table contents? I am getting an error

Dump Data Failed

Dump terminated

Where do I find more about the error? 

All Replies
  • Look in the current working directory for a file ending in .e

  • I found nothing.... I can see the first table is produced as a xxx.d but nothing else.

  • run below example program in procedure editor

    RUN prodict/dump_d.p("customer", "c:/myDirectory","").

    and the input param explained as below

       file-name                : "ALL" or "<file-name>"

       dot-d-dir                : directory relativ to working-directory

       code-page                : ?, "", "<code-page>"

  • When the dump process ends, it pops up an information screen. What information do you get in this screen?

    Can you also go to the GUI Procedure Editor->Help->Recent Messages and check the most recent error number there?

  • Set SESSION:DEBUG-ALERT = TRUE.

    > I am getting an error

    Stack trace will point out to:

    -> prodict/dump/_dmpdata.p at line 1802  (prodict/dump/_dmpdata.r)

    You can see this procedure in $DLC/src/prodict.pl

    DEFINE VARIABLE stopped     AS LOGICAL   NO-UNDO init true.
    define variable xDumpTerminatedMsg as character no-undo init "Dump terminated.". IF stopped THEN MESSAGE xDumpTerminatedMsg. ELSE MESSAGE "Dump of database contents completed:" cntr "table(s) dumped successfully.".

    Check the code before it sets "stopped" to "false".

  • I don’t have a compiler on the server and that is the reason I try to do it with the management system. I belive I have to make a program that I compile with my dev system and run that on server, if there is no way I can do it with the management system?
     
    //Geir Otto