Versions Compared

Old Version 3

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

compared with

New Version 4

changes.mady.by.user Morgan Mackeson-Ellis

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added upgrade step

...

  • All ODBC, Database, Extensible Source Connection and Scheduler Configuration credentials have moved to the RED Profile, therefore each user of RED should generate their own local profile file (see the user guide for details) to continue using RED.
  • All Azkaban components require upgrading and the encrypted Scheduler profile records added to redadmin.ws_scheduler_profile (see the user guide for details) in order for jobs to run.
  • Post upgrade it is encouraged to remove all credentials from the metadata since these should now reside in the in-memory session level credentials only. Run the following update on the metadata to achieve this: 
    Code Block
    languagesql
    titleRemove credentials after upgrade
    -- Remove credentials from Database, ODBC and Extensible Source connections
UPDATE red.ws_dbc_connect
SET dc_extract_userid='', dc_extract_pwd='', dc_admin_userid='', dc_admin_pwd=''
WHERE dc_type IN ('D','O','Z');

-- Remove credentials from Scheduler Configuration
UPDATE red.ws_wrk_external_scheduler
SET wes_dashboard_userid='', wes_dashboard_pwd='', wes_restapi_userid='', wes_restapi_pwd='';

Version 10.1.0.0 has potentially breaking changes for upgraded repositories; therefore, upgrades should be tested thoroughly before upgrading production environments. The potential issues after the upgrade are the following:

...