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
View Error Server Configuration Changes
user
03-06-2019 12:44:06 -0400
code

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! **UPDATE**: In Denodo 8.0 and upper versions this property must never be changed as changing identifiers length has additional implications due to support of external databases for metadata.
Denodo Team
 Edited on: 01-02-2021 09:42:38 -0500
code
That works fine and fixed my problem. thanks a lot!
user
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