Repeat export of KO21 file

• Find out what transfer numbers are to be repeated.
• Set the host_xfer status of those records back to NULL.
• Re-run the export batch.

Open a command line on the scheduler pc by the windows startmenu:

• Click Start
• Click Execute…
• In the open: entryfield enter cmd
• Click OK

On the command line, change into the BPS programm folder and start the TSS sql query tool (you might use sqlplus as well):

  Microsoft Windows 2000 [Version 5.00.2195]
  (C) Copyright 1985-2000 Microsoft Corp.
  
  C:\Dokumente und Einstellungen\kochp>C:
  C:\Dokumente und Einstellungen\kochp>cd \programme\bps175d
  C:\Programme\BPS175d>tss
  Tini SQL Shell V1.3
  Copyright (C) 1995-1997 by IBK-Landquart-Switzerland
  Enter "?" or "HELP" for instructions.
  TSS>

In TSS do some basic settings and connect to the BPS db. (Replace the connect string by the correct one for your BPS database):

  TSS> set database oracle
  TSS> set charwidth 20
  TSS> connect plc/****@gmnf_plc
  connected to ORACLE
  TSS>

Now select all transmissions that have been run on the day in question:

  TSS> select ident, to_char(xdate,'yyyy.mm.dd-hh24:mi:ss'), tablename, application
       from hostxfers where to_char(xdate,'yyyy.mm.dd')='2006.05.17' order by 1;
      IDENT TO_CHAR(XDATE,'YYYY TABLENAME            APPLICATION
  --------- ------------------- -------------------- --------------------
       3704 2006.05.17-04:56:52 orderdets            RwwExpInvoices
       3705 2006.05.17-11:58:56 historderdets        RwwExpInvoices
  2 row(s) selected.
  TSS>

You can see that there have been 2 exports on this date by RwwExpInvoices. One was at 4:56 and took data from the open trips, and the other one was at 11:58 and exported from archived trips (history).

If you want to re-export the one from the history data, you need use the ident (XID) number 3705 to reset the records as:

  TSS> update historderdets set host_xfer=null where host_xfer=3705;
  3684 row(s) processed.
  TSS> commit;
  commited.
  TSS>

In case you want to reset the transmission that was taken from the open trips, you need to run 2 update commands, since the trip may or may not yet have been archived:

  TSS> update orderdets set host_xfer=null where host_xfer=3704;
  0 row(s) processed.
  TSS> update historderdets set host_xfer=null where host_xfer=3704;
  1245 row(s) processed.
  TSS> commit;
  commited.
  TSS>

Now you can repeat the export by running RwwExpInvoices.cmd again, or by executing the scheduler batch that is calling RwwExpInvoices respectively.