About folder paths in the database

Build 1501 on 14/Nov/2017  This topic last edited on: 11/Nov/2014, at 17:17

In the GN4 database there are various places (objects, i.e. tables ) where folder paths can be stored.

These paths may not be the same on the secondary system, so we need to change them when switching to use the secondary system.

The quickest way to change them is directly running queries in the database.

Ideally you should have a copy of the objects’ xml with the correct paths, and import those xml once the dr is promoted live, but this is error prone (these files may be outdated).

Back4 paths:

Input/park/error folders, stored in the s_DatasrcfilesTable.

E-mail and feed urls checked by back4 are stored in the s_DatasrcfeedTable and s_DatasrcemailTable

Volumes path:

gn_volumetable

Parameters of publishing destinations (where to save files, or logs…):

s_PubdestParamsList

Parameters of the print queues (where to generate the files):

s_PrintqueueParamsList

Extract destinations (crop dest paths):

s_ExtractdestTable.s_url

Parameters of users/groups(sometimes used for exporting data):

s_SecurityParamsList

Other paths/urls

Other paths/urls are written in the configuration file serverconfig (Exalead, temporary folder).

Have a patched copy and import the config in the secondary server, once it goes live.

The back4 http interface may be different on the secondary server, so update the relevant object from Edadmin or /Int, or do it directly in the s_Back4configTable.