Input Tool DB : invalid length for connection option 'user id', maximum length is 30

[ashirsat9]

I am getting the following error when trying to use input tool to log into an Oracle Database: 

In-database : invalid length for connection option 'user id', maximum length is 30

[alexnajm]

The error looks like an error with how you set up the connection. Did you type a user ID that is over 30 characters when you set up the connection?

[ashirsat9]

Yes, the user_id/schema name is 31 characters and do not have an option to rename it. It works on one person's local designer and does not work on another where the error blocks any changes to the SQL query or connection. 

[alexnajm]

As long as it works on someone else’s computer, I would match the configuration. If the only thing different is the username, I would get with your IT to change it - not sure that’s an Alteryx issue, more of an Oracle limitation

[alexnajm]

Possible Solution here: https://community.alteryx.com/t5/Alteryx-Server-Discussions/In-database-invalid-length-for-connectio...

[ashirsat9]

Thanks for the reply. the limitation seems to be on the Alteryx side and yes, there's no explanation on why the same username (ex: abcd12330chars) is not working for 1 person while it works for another on Alteryx. Yes, i tried pasting the connection string and it still kept prompting with error when you try to close it and try to adjust the query string using the Table/File name dropdown under Options. I will check if there's any other solutions and hope a restart or something will fix it for the user.