AnsweredAssumed Answered

Maximum SQL Password Length for AF Table Connections?

Question asked by Steve Boyko Champion on Apr 2, 2019
Latest reply on Apr 27, 2020 by bbregenzer

We are trying to set up a table connection in PI AF but we're running into a weird error. "Unable to link to external table: Bad Length."

 

We are using a SQL login and supplying the user name and password. When we built the table connection, click "Allow Saving Password" and click "Test Connection", it is OK and we can select the database we want. Once we click OK and go back into defining the connection and test the connection, it fails with a bad password.

 

We tried selecting Supply Password under the Security section after building the connection string, but when we enter the password and try to check it in, we get the message "Unable to link to external table: Bad Length". The password is 20 characters long.

 

The kicker is that if we enter a shorter password, we do not get that message. It's the wrong password, so it doesn't connect.

 

Is there a maximum SQL password length for AF table connections?

 

We also tried directly defining the connection in the table. Here's a screen shot of that effort with the same results - selectively blurred to hide client details.

unable-to-link.png

 

Thanks for your help!

Outcomes