Denodo community Q&A RSS feed

Ai SDK chatbot limitations for Denodo Express Enterprise subscription.

2025-12-10T06:00:57Z

Hi, I'm using denodo ai sdk chatbot and would like to know limitations regarding my subscription and chatbot itself. There seems to be a limit of just 15 rows, what can i do if i want for example 500 rows. Is there any specified limit? is it possible? there isn't any reliable source available to get to know it. Also it throws errors like " I'm sorry i was unable to retrieve data" etc. How to get rid of these issues? Kindly help me in this matter as it is really important. Thanks.

join condition

2025-12-08T07:37:51Z

what stored procedure in denodo 9.3 can provide information on the join conditions applied on derived views. I am usign element_metadata(), which I have used in previous versions of denodo. it is working but gives error after fetching some rows. Received exception with message 'com.denodo.vdb.engine.storedprocedure.StoredProcedureException'

AI SDK failed to start within 30 seconds

2025-12-04T08:15:45Z

I'm getting this error while starting ai sdk and chatbot. [2025-12-04 12:46:09 +0500] [27468] [INFO] [system] Initializing new embedding model: googleaistudio/gemini-embedding-001 [2025-12-04 12:46:11 +0500] [27468] [ERROR] [system] Traceback (most recent call last): File "C:\Users\Downloads\aisdk\venv\Lib\site-packages\langchain_google_genai\embeddings.py", line 227, in embed_documents google.api_core.exceptions.InvalidArgument: 400 * BatchEmbedContentsRequest.model: unexpected model name format * BatchEmbedContentsRequest.requests[0].model: unexpected model name format raise GoogleGenerativeAIError(f"Error embedding content: {e}") from e langchain_google_genai._common.GoogleGenerativeAIError: Error embedding content: 400 * BatchEmbedContentsRequest.model: unexpected model name format * BatchEmbedContentsRequest.requests[0].model: unexpected model name format [2025-12-04 12:46:11 +0500] [27468] [ERROR] [system] Application startup failed. Exiting. According to the logs, it related to the model anme format. i have tried changing model, writing name in a different manner like but still not able to resolve the issue. [2025-12-04 12:46:09 +0500] [27468] [INFO] [system] Initializing new embedding model: googleaistudio/gemini-embedding-001 This the model i am using. Any sort of help would be appreciated

Remote Table Issue

2025-12-03T13:40:06Z

Hi , I am unable to create remote table in MySQL database ,my source table is in Azure SQL and want target database as MySQL ,please assist. Error : Cannot invoke "com.denodo.vdb.vdbinterface.common.clientResult.vo.descriptions.view.TableFieldVO.getFieldName()" because "tableField" is null Step 1 of 3: Created remote table 'xxxx' successfully. Step 2 of 3: Inserted 1234580 rows into remote table 'xxx'. Step 3 of 3: Cannot invoke "com.denodo.vdb.vdbinterface.common.clientResult.vo.descriptions.view.TableFieldVO.getFieldName()" because "tableField" is null Also please suggest if we can use remote table alongwith data movement option ?and also when to use cache and when to use remote table ?

Data-Movement

2025-12-02T11:45:10Z

Hi , Before applying data movement do I need to calculate number of rows in each table and then determine large and small table ? Also data movement works by moving data from smaller table to larger table data source so in that scenario in order to enable data movement should I enable data movement option under small table or larger table under 'Options' tab of derived view ? Can data movement be applied on joining of more than two tables ?

java.sql.SQLException: For input string: "2025-11-18" on Data Catalog

2025-12-01T12:19:50Z

Hi, I am encountering the following error while exporting results to Excel/CSV from Data Catalog when passing a date to the localdate parameter with the value '2025-11-18': `java.sql.SQLException: For input string: "2025-11-18".` However, I am able to download the same view without any issues from Design Studio. Kindly suggest a solution to resolve this error in Data Catalog.

errorhandling

2025-11-30T08:42:16Z

Hi , How to do error handling in Denodo 8 when one of the source either JDBC or API fails and gives error.

simple question regarding certification

2025-11-29T00:14:20Z

simple question regarding certification

custom Denodo File System Custom Wrapper - base view

2025-11-24T14:41:59Z

Hi, I created a custom datasource using the following JAR: denodo-filesystem-customwrapper. I would like to create a base view, but I need some help. When defining the search method, I see that the constraints require parentfolder = and recursive = . I�??m not sure what values I should provide for these parameters. Could you please guide me on what they represent and how to set them correctly? Also, is it possible to use just the filename as a filter? Thanks!

Inconsistent Date & Number Formatting Between Design Studio and Data Catalog

2025-11-21T12:26:17Z

Hi folks, We are currently facing the following two issues: **1. Date Format** We need guidance on configuring a consistent date format for all date_time columns. Our requirement is to display dates in the format **yyyy-MM-dd** across both Design Studio and the Data Catalog. At the moment, the same view displays different date formats in each tool. Additionally, if a timestamp column has a time component of **00:00:00**, we want it to display only the date (**yyyy-MM-dd**) instead of the full timestamp. Please guide us on how to configure this at a global or view level to avoid setting the format for each column individually. **2. Double Data Type (Decimal Digit Issue)** Our base tables contain several columns with the double data type. Most of these values do not have decimal digits. Design Studio shows them correctly, but the Data Catalog displays them with a trailing decimal�??for example, **564.0 instead of 564**. Although casting to int removes the decimal point, we have many such columns and applying this transformation manually to each one is not feasible. Kindly suggest a better, centralized configuration or approach to handle this formatting consistently across all views.