BookmarkSubscribeRSS Feed
kiranragam
Fluorite | Level 6

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;

 

 

2 REPLIES 2
JBailey
Barite | Level 11

Hi @kiranragam ,

 

Are you able to connect using a LIBNAME statement that specifies USER= and PASSWORD=? 

 

Best wishes,
Jeff

kiranragam
Fluorite | Level 6
Yes, LIBNAME is working fine. When I changed the password length to 16 bytes even FASTLOAD also working. But for longer passwords, LIBNAME has no issue but FASTLOAD has.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 924 views
  • 0 likes
  • 2 in conversation