Problem

Invalid RAS date

Resolution

The fix for this issue includes the following steps:

1. "Transfer date" has to be renamed to "Archive transfer date" and this field will be added to the standard search:

• change SQL files used to set up the database;
• modify the commands used to put the package information into the database (commands should be adapted to an existing installation).

2. If a package is moved to a long term storage the date of this movement should be added to the database:

• an extra set of workflows needs to be configured and activated;
• these workflows should be adapted to the long term archive the customer uses;
• add a new column to all database tables and fill it when the package is moved to the long term archive.

Modifications related to the long term storage should be performed by technical consultants, as each installation of RAS is customized.

If the client wants to enable the renaming of the field from TRANSFER DATE to ARCHIVE TRANSFER DATE, the following steps should be executed:

1. Add to RAPServer.properties the new parameter:
   #.Default: FALSE
   #.Type ENUM
   #.Value TRUE
   #.Value FALSE
   #.Required: no
   #.Used-by: RAPServer.java
   #.Example: TRANSFER-DATE-FIELD-CHANGE-ENABLED=FALSE
   #.
   TRANSFER-DATE-FIELD-CHANGE-ENABLED=TRUE
2. Run the update_RAS_tables.sql script on RAS DB(it should be adapted to an existing installation).
3. Run the update_RAS_views.sql script on RAS DB(it also should be adapted to an existing installation).
4. Modify the database commands for all BP:
   
   • Go to $ACTISEDI/internet/server/config and edit all BP configuration files rap_bp_XX.cfg, renaming "TRANSFER_DATE" to "ARCHIVE_TRANSFER_DATE" only in case of DB column names, not given parameters in queries.
5. Call $ACTISEDI/bin/loadDBConfig
6. Call talk2webedi DBServer command=updatecfg.
7. Restart AJAS.

Find all the examples and specified files in the archive "TSIM-61-Fix.rar", in case of unsuccessful operations on DB, run the unupdate.sql script and revert the changes for rap_bp_XX.cfg files with specified commands.