topic Re: ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA. in SAS Programming

ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA.

ChandraBera — Thu, 19 Oct 2023 11:56:12 GMT

MPRINT(_M_CREATESIM_REF): CREATE TABLE CES0123.SIM_MAP_COINS ( coinsrCode CHARACTER(10) LABEL = 'coinsrCode', systemCoinsrCode
CHARACTER(10) LABEL = 'systemCoinsrCode' ) ;
ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA.
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
SYMBOLGEN: Macro variable IN_SIMID resolves to CES0123

Hi Team,

After creating the datasets, we are getting error like ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA. even we have not set any alter password.

Could you please check and update why this issue came.

Regards,

Chandra

Re: ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA.

Kurt_Bremser — Thu, 19 Oct 2023 12:28:10 GMT

Plesse show the complete log of the step that creates the dataset, and the complete log of the failing step. Copy/paste the log text into a window opened with this button:

Re: ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA.

Quentin — Thu, 19 Oct 2023 13:18:17 GMT

Is CES0123.SIM_MAP_COINS a SAS dataset? If so, please run PROC CONTENTS and show the output, it should show if there is a password under PROTECTION.

Are you able to recreate this problem? If so, please run a small example that replicates the problem and post the full code and log. The code should create a dataset that did not exist previously, and then attempt to insert data into that dataset (or overwrite it), and trigger the error.

Re: ERROR: Invalid or missing ALTER password on member CES0123.SIM_MAP_COINS.DATA.

Amir — Thu, 19 Oct 2023 13:22:51 GMT

Hi,

A similar looking issues appears to have been resolved here:

https://communities.sas.com/t5/SAS-Programming/ERROR-invalid-or-missing-alter-password-on-member/td-p/572826?lightbox-message-images-572826=30986iE0BCAA59AC003CF6

It might be of help.

Thanks & kind regards,

Amir.