Hi Team,
We are facing an issue while loading data into a Teradata table with FASTLOAD option. When the password length in Authdomain is 16bytes or less it is working well. If the password length is more than 16bytes facing below error. For all other operations(like multiload, select, etc..) there is no issue with the lengthy password. Please help us if you have any idea.
ERROR: Teradata connection: MTDP: EM_SSOLOGONFAIL(244): SSO logon failed by gateway
Code:
LIBNAME TERALIB TERADATA AUTHDOMAIN=TERAAUTH SERVER="XYZ.ABC.NET" MODE=TERADATA CONNECTION=GLOBAL DATABASE=ABC123 SCHEMA="XYZ_SCHEMA";
PROC APPEND BASE=TERALIB.TERADATA_NEW_TBL(TPT=YES FASTLOAD = YES TPT_MAX_SESSIONS = 4 SLEEP = 5 TENACITY = 4)
DATA=TERALIB.TERADATA_OLD_TBL;
RUN;