You can translate the question and the replies:

Error: Invalid identifier (too long)

Hi team, I was trying to rename a view to a name with more than 100 characters and I got this error: Syntax error: invalid identifier: 'xxxxxxxxxxx' (too long) Is there any character restriction for object name in Denodo? Can I change something, i.e. in server configuration to change that? Cheers
03-06-2019 12:44:06 -0400

2 Answers

Hi, I am able to rename a view with more than 100 characters by following below steps: * In Virtual DataPort Administration Tool, open VQL shell and execute the below command. For Example: view name with 110 characters.(You can choose your desired character length) `set 'com.denodo.vdb.catalog.Catalog.identifiersMaxLength' = '110'` * Restart the Virtual DataPort Server. * Now you will be able to rename the view up to 110 characters. Hope this helps!
Denodo Team
04-06-2019 08:36:02 -0400
That works fine and fixed my problem. thanks a lot!
04-06-2019 11:53:41 -0400
You must sign in to add an answer. If you do not have an account, you can register here