You can translate the question and the replies:

Missing VQL properties while validating revision

I am getting the below error while validating the revision in Denodo 7 Missing Vql properties: 'config.PROPERTY.com.denodo.security.file.privilege.generalaccess', 'config.PROPERTY.com.denodo.vdb.cache.cacheMaintainerPeriodInSecs', 'config.PROPERTY.com.denodo.vdb.cache.cacheMaintenance', 'config.PROPERTY.com.denodo.vdb.cache.cacheStatus', 'config.PROPERTY.com.denodo.vdb.cache.jdbc.cacheDataSourceName', 'config.PROPERTY.com.denodo.vdb.cache.jdbc.cacheDatabaseDataSourceName', 'config.PROPERTY.com.denodo.vdb.cache.jdbc.customCacheDataSourceName', 'config.PROPERTY.com.denodo.vdb.cache.jdbc.derbyCachePort', 'config.PROPERTY.com.denodo.vdb.cache.jdbc.derbyCacheRemoteAccess', 'config.PROPERTY.com.denodo.vdb.cache.timeToLiveInSecs', 'config.PROPERTY.com.denodo.vdb.catalog.database.identifiersCharset', 'config.PROPERTY.com.denodo.vdb.engine.RowQueueSizeInMB', 'config.PROPERTY.com.denodo.vdb.engine.resource.queryMemoryLimit', 'config.PROPERTY.com.denodo.vdb.engine.session.restriction.ResourceManagerEngine.resourceManagerStatus', 'config.PROPERTY.com.denodo.vdb.engine.swap.SwapManager.maxBlockSizeInKB', 'config.PROPERTY.com.denodo.vdb.engine.swap.SwapManager.swappingResultMaxSizeInMB', 'config.PROPERTY.com.denodo.vdb.engine.swap.SwapManager.swappingStatus', 'config.PROPERTY.com.denodo.vdb.engine.wrapper.raw.ldap.LDAPAccess.LDAPDefaultPageSize', 'config.PROPERTY.com.denodo.vdb.interpreter.execution.SelectAction.costoptimization', 'config.PROPERTY.com.denodo.vdb.interpreter.execution.SelectAction.dataMovement', 'config.PROPERTY.com.denodo.vdb.interpreter.execution.SelectAction.simplify', 'config.PROPERTY.com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.concurrentQueriesLimit', 'config.PROPERTY.com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.maxConcurrentQueries', 'config.PROPERTY.com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.maxWaitingQueries', 'config.PROPERTY.com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.waitingQueriesLimit', 'config.PROPERTY.com.denodo.vdb.misc.I18nParametersManager.i18nDefault', 'config.PROPERTY.com.denodo.vdb.proxy.proxyHost', 'config.PROPERTY.com.denodo.vdb.proxy.proxyPacUri', 'config.PROPERTY.com.denodo.vdb.proxy.proxyPassword', 'config.PROPERTY.com.denodo.vdb.proxy.proxyPort', 'config.PROPERTY.com.denodo.vdb.proxy.proxyStatus', 'config.PROPERTY.com.denodo.vdb.proxy.proxyUser', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.VDBManagerImpl.factoryPort', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.VDBManagerImpl.odbcPort', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryPort', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.VDBManagerImpl.registryURL', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.VDBManagerImpl.shutdownPort', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.encryptedPassword', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.environment', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.localRepositoriesHome', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.password', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.system', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.url', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.useUserAndPassword', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.useVCS', 'config.PROPERTY.com.denodo.vdb.vdbinterface.server.vcs.VCSConfigurationManager.user', 'config.PROPERTY.com.denodo.wsgenerator.restfulws.timezone', 'config.PROPERTY.java.env.DENODO_OPTS_START', 'config.PROPERTY.java.env.DENODO_OPTS_STOP', 'config.PROPERTY.queryOptimization.parallelProcessing.customDataSource.dataSourceName', 'config.PROPERTY.queryOptimization.parallelProcessing.customDataSource.databaseName', 'config.PROPERTY.queryOptimization.parallelProcessing.dataSource', 'config.PROPERTY.queryOptimization.parallelProcessing.enabled', 'config.PROPERTY.storedProcedures.defaultChunkSize', 'config.PROPERTY.storedProcedures.defaultChunkTimeout', 'config.PROPERTY.storedProcedures.defaultQueryTimeout', 'databases.admin.folder.1..data sources.folder.go_erp.datasources.jdbc.go_erp.DATABASEURI', 'databases.admin.folder.1..data sources.folder.go_erp.datasources.jdbc.go_erp.USERNAME', 'databases.admin.folder.1..data sources.folder.go_erp.datasources.jdbc.go_erp.USERPASSWORD', 'databases.admin.folder.1..data sources.folder.go_erp.datasources.jdbc.go_erp.USERPASSWORD.ENCRYPTED', 'databases.admin.folder.2..base_views.views.jdbc.sales_target.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product_brand.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.country.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.order_method.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.branch.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product_size_lookup.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.return_reason.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product_color_lookup.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product_line.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.euro_conversion.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.conversion_rate.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.currency_lookup.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.inventory_levels.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.order_details.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.order_header.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product_forecast.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product_name_lookup.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.product_type.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.returned_item.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.sales_region.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.time_dimension.CATALOGNAME', 'databases.admin.folder.2..base_views.views.jdbc.time_quarter_lookup.CATALOGNAME' Please suggest what is that I am missing here.
user
23-07-2019 06:42:53 -0400

1 Answer

Hi, I came across the same error while validating revision without adding the property file to the target environment. To solve this error, I followed these steps 1. Exported the Properties file from Virtual Dataport by selecting File > Export. 2. Checked the “Export environment specific properties separately” box. This will generate the Virtual Dataport property file. 3. In Denodo Solution Manager, Imported the properties File to the target environment by selecting the environment and navigated to Virtual DataPort Properties tab > Import. 4. Browsed to file generated in step 2 and imported the environment property. Alternatively, you can also manually enter properties by selecting Virtual DataPort Properties tab > New. For more information refer to the User Manual [Configuring Virtual DataPort Properties](https://community.denodo.com/docs/html/browse/7.0/solution_manager/administration/environments/configuring_environments/configuring_vdp_properties) section of the Solution Manager Administration Guide. Hope this helps!
Denodo Team
24-07-2019 00:58:31 -0400
You must sign in to add an answer. If you do not have an account, you can register here