OI 7.2

My system consists of two parts a 'Live' area (LEDGERS) and a DEMO area which contains a set of example records where I can run reports - practice data entry etc.

I need to keep the dictionary area synchronized with my LIVE area. During the last upgrade, as defined in the Help section, I edited the %PROCESS% record in SYSUPGRADE under COPY.TABLES as follows.

COPY TABLES

.\DEMO/DICT.MONTH_YEAR/WA

.\LEDGERS/DICT.MONTH_YEAR/WA

COPY OSFILE

BMPS/VIEW1.BMP

BMPS/40X40!.BMP

Unfortunately it did not work. The LIVE area was properly updated but not the DEMO area. I checked that I could update the dictionary manually using COPY_TABLE and that worked fine.

I changed the order in the COPY.TABLES section. No success.

What am I doing wrong?

After the engine loads and before you enter your username and password, start an engine log. Alternatively, set up a LHx.log if appropriate for your network driver. When the upgrade is finished, the log file should report the error on the COPYTABLE. One we know the FS code, we should be able to find a solution.

The Sprezzatura Group

World leaders in all things RevSoft

Maybe you need to check the "Require Users to Log Out" checkbox on the deployment definition?

The LH3.log file would be useful. What stops/starts it working? - I have switched off my HIPS program to no avail. The ENGINE Log file does not appear to have any relevant information.

Did you try the "Require Users to log out" flag on the deployment definition? Dictionary updates usually do not deploy unless this is checked.

Thanks Warren

Yes but so far no difference - and remember the first dictionary deployed successfully without the flag being set. The RDK is full of anomalies so I want to knock them off one at a time.

John,

Have you had a good look in the RDK folder and confirmed that both sets of tables have been copied in? ie is the issue RDKExtract or is it in the RDKDeploy?

Richard Bright

John,

A further reflection - you have headed up 'Updating Dict Tables' but we seem to be talking about Copy Table. If the table already exists then all you need to do is to copy the Table/Dicts into the SYSUPGRADE table - as created in the RDK. Please note that the key structure is:

DICT.TABLENAME/DICT.KEY

Provided the target table is attached on the deploy system the dict items should make it to the right place.

Richard Bright

Richard Bright

One and the same Dict Table is to be copied into 2 directories - Live & Demo. It is there in the Upgrades directory. I can attach and read it, from the syseditor exec line. For some reason which I am still working on, the LH3.log file is populated on my laptop when OI is run but not my desktop. Something is confounding the process.

Answers

1. LH3.LOG was actually LH3.LOG.TXT as .TXT suffix was well hidden by the folder view

2. Fortunately Revelation Software provide the source code and in the RDKINSTALLMODULE code I found:

if File1, 5=DICT." then

• known RDK bug: cannot deploy just a dictionary

• work-around: create the dictionary in the deployment

• and copy all of the dictionary records into

• the SYSUPGRADE table; this will also create

• any indexes on that table that existed in

• the development system

• simply add to .dbt

QED

Thanks everyone for your help

View this thread on the forum...