BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
wrosario
Calcite | Level 5

I'm trying to add a port on the lookup DI component and the sas is not adding the same, presents no mistake, someone has been there?


addinputports.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
wrosario
Calcite | Level 5

Ok, is this reproducible - happens every time in new jobs? yes

Chosing "Connections" - what does the pop-up window show? displays a single connection

What happends if you chose to add input port? nothing

redid the product installation SAS Data Integration Studio Server Date and worked



View solution in original post

4 REPLIES 4
LinusH
Tourmaline | Level 20

Lookup always comes with two input ports. In your job have two input tables. Can't you connect the second one? You have to describe in more detail  what you are doing and what's happening.

Data never sleeps
wrosario
Calcite | Level 5

when I add the lookup component in my job it's only allowing me to connect a single table, the second port is disabled as the image above, I have been in add input ports option and it does not add another.

I know that by default the lookup component has to come with two inputs, but he was only come with one.

LinusH
Tourmaline | Level 20

Ok, is this reproducible - happens every time in new jobs?

Chosing "Connections" - what does the pop-up window show?

What happends if you chose to add input port?

This feels like something wrong with your configuration. Looking into your DataIntegrationStudio_Log.txt file (\Users\User\AppData\Roaaming\SAS\SASDataIntegrationStudio\4.9\) might give you some clues.

In case of metadata error, something might show up in the metadata server log.

Next step could be a ticket to SAS tech support.

Data never sleeps
wrosario
Calcite | Level 5

Ok, is this reproducible - happens every time in new jobs? yes

Chosing "Connections" - what does the pop-up window show? displays a single connection

What happends if you chose to add input port? nothing

redid the product installation SAS Data Integration Studio Server Date and worked



sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 2070 views
  • 0 likes
  • 2 in conversation