Not authorized to use ADDRPYLE
Posted: Thu Jan 18, 2018 5:13 pm
Overview
When updating GoAnywhere MFT on the IBM iSeries, the following error may occur:
Not authorized to use ADDRPYLE. Ensure database user has *USE authority for ADDRPYLE. GoAnywhere validation failed. Upgrade was NOT started: Database user isn't authorized to use ADDRPYLE Press ENTER to end terminal session.
GADATA user profile has *USE authority by adding it to authorization list QPGMR which was already defined as *USE and GoAnywhere update process may attempts to add a reply list entry.
Environment
GoAnywhere MFT - iSeries
Resolution
The user profile GADATA (owner of the GADATA DB2 table) need to have *USE authority for the ADDRPYLE command.
During the upgrade process we sometimes do the Alter table command where it will add columns or remove columns. This can produce a CPA32B2 warning message that data might be lost due to dropping old columns or altering attributes. This could normally generate a message in the QSYSOPR messages or a message back to the user screen. To prevent the message from being presented and possibly getting answered incorrectly, we issue the ADDRPYLE command on message CPA32B2 at the beginning of the upgrade. The messages are automatically answered during the upgrade process (do not get written to QSYSOPR). At the end of the upgrade the message in the message file is reverted to its origin state.
Note
To add the auth to user GADATA
GRTOBJAUT OBJ(ADDRPYLE) OBJTYPE(*CMD) USER(GADATA) AUT(*USE)
GRTOBJAUT OBJ(RMVRPYLE) OBJTYPE(*CMD) USER(GADATA) AUT(*USE)
To verify it was added
DSPOBJAUT OBJ(ADDRPYLE) OBJTYPE(*CMD)
DSPOBJAUT OBJ(RMVRPYLE) OBJTYPE(*CMD)
When updating GoAnywhere MFT on the IBM iSeries, the following error may occur:
Not authorized to use ADDRPYLE. Ensure database user has *USE authority for ADDRPYLE. GoAnywhere validation failed. Upgrade was NOT started: Database user isn't authorized to use ADDRPYLE Press ENTER to end terminal session.
GADATA user profile has *USE authority by adding it to authorization list QPGMR which was already defined as *USE and GoAnywhere update process may attempts to add a reply list entry.
Environment
GoAnywhere MFT - iSeries
Resolution
The user profile GADATA (owner of the GADATA DB2 table) need to have *USE authority for the ADDRPYLE command.
During the upgrade process we sometimes do the Alter table command where it will add columns or remove columns. This can produce a CPA32B2 warning message that data might be lost due to dropping old columns or altering attributes. This could normally generate a message in the QSYSOPR messages or a message back to the user screen. To prevent the message from being presented and possibly getting answered incorrectly, we issue the ADDRPYLE command on message CPA32B2 at the beginning of the upgrade. The messages are automatically answered during the upgrade process (do not get written to QSYSOPR). At the end of the upgrade the message in the message file is reverted to its origin state.
Note
To add the auth to user GADATA
GRTOBJAUT OBJ(ADDRPYLE) OBJTYPE(*CMD) USER(GADATA) AUT(*USE)
GRTOBJAUT OBJ(RMVRPYLE) OBJTYPE(*CMD) USER(GADATA) AUT(*USE)
To verify it was added
DSPOBJAUT OBJ(ADDRPYLE) OBJTYPE(*CMD)
DSPOBJAUT OBJ(RMVRPYLE) OBJTYPE(*CMD)