# Latest **URL:** https://forum.cloverdx.com/latest.md [Latest](https://forum.cloverdx.com/latest.md) · [Categories](https://forum.cloverdx.com/categories.md) --- ## [Welcome to CloverDX Forum! 👋](https://forum.cloverdx.com/t/welcome-to-cloverdx-forum/5)
**Author:** [@system](https://forum.cloverdx.com/u/system)\ **Replies:** 0\ **Last updated:** [October 3, 2024, 5:03pm UTC](https://forum.cloverdx.com/t/welcome-to-cloverdx-forum/5 "2024-10-03T17:03:13Z")
CloverDX Forum This is a place where you can share all your CloverDX and data related experiences. Here are some things you can do to get started: :speaking\_head: Introduce yourself by adding your picture and informa… --- ## [Integrating Museum POS Data with Membership and Visitor Systems](https://forum.cloverdx.com/t/integrating-museum-pos-data-with-membership-and-visitor-systems/3324)
**Author:** [@tepos\_clint](https://forum.cloverdx.com/u/tepos_clint)\ **Replies:** 1\ **Last updated:** [August 13, 2026, 8:29pm UTC](https://forum.cloverdx.com/t/integrating-museum-pos-data-with-membership-and-visitor-systems/3324 "2026-08-13T20:29:19Z")
Hi everyone, I’m exploring a data integration setup for museums where the POS system needs to work alongside membership, ticketing, CRM, and visitor-management systems. A typical museum may have POS transactions from t… --- ## [Mass Update Listener Errors](https://forum.cloverdx.com/t/mass-update-listener-errors/3312)
**Author:** [@Tamara\_Rosenberger](https://forum.cloverdx.com/u/Tamara_Rosenberger)\ **Replies:** 3\ **Last updated:** [June 23, 2026, 9:10am UTC](https://forum.cloverdx.com/t/mass-update-listener-errors/3312 "2026-06-23T09:10:04Z")
We have over 300 Event Listeners that errored out while updating the server. Is there a way we can mass update these instead of resetting the state one by one? --- ## [Query about look up joins - Join keys](https://forum.cloverdx.com/t/query-about-look-up-joins-join-keys/3307)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 3\ **Last updated:** [April 22, 2026, 6:50pm UTC](https://forum.cloverdx.com/t/query-about-look-up-joins-join-keys/3307 "2026-04-22T18:50:17Z")
Dear Forum Members I have a look up table which i have created and i have two join keys i.e. “SupplierID” and “ProductNo”. When we do look up join do we have to have the same name column to do the join? I am having an … --- ## [Why JSONExtract fails on OpenAI output (and how to debug + fix it)?](https://forum.cloverdx.com/t/why-jsonextract-fails-on-openai-output-and-how-to-debug-fix-it/3303)
**Author:** [@CloverDX\_team](https://forum.cloverdx.com/u/CloverDX_team)\ **Replies:** 2\ **Last updated:** [March 2, 2026, 3:56pm UTC](https://forum.cloverdx.com/t/why-jsonextract-fails-on-openai-output-and-how-to-debug-fix-it/3303 "2026-03-02T15:56:15Z")
I’m using OpenAIClient in my CloverDX graph to auto-tag incoming tickets. I’m being very explicit in the prompt and asking the model to return JSON that matches a fixed structure (including allowed values), something lik… --- ## [Write fieldnames when using append with the FlatFile & Spreadsheet Writer does not work?](https://forum.cloverdx.com/t/write-fieldnames-when-using-append-with-the-flatfile-spreadsheet-writer-does-not-work/3302)
**Author:** [@Michel\_van\_Gent](https://forum.cloverdx.com/u/Michel_van_Gent)\ **Replies:** 2\ **Last updated:** [February 9, 2026, 12:45pm UTC](https://forum.cloverdx.com/t/write-fieldnames-when-using-append-with-the-flatfile-spreadsheet-writer-does-not-work/3302 "2026-02-09T12:45:37Z")
Hi! I am trying to write some aggregated data to a file using the FlatFileWriter and then add all records as details to the same file using a second FlatFileWritter having a higher phase with the setting to append. I h… --- ## [Erroring out reading huge data](https://forum.cloverdx.com/t/erroring-out-reading-huge-data/3277)
**Author:** [@Balaji\_R](https://forum.cloverdx.com/u/Balaji_R)\ **Replies:** 2\ **Last updated:** [February 4, 2026, 8:14pm UTC](https://forum.cloverdx.com/t/erroring-out-reading-huge-data/3277 "2026-02-04T20:14:34Z")
Hi, I’m facing some issue while trying to read the flat file lets say csv which is of 47.5 GB in total size , trying to read this file and filter on based on some condition and loading into respective database table. Bu… --- ## [Processing several files - one at a time](https://forum.cloverdx.com/t/processing-several-files-one-at-a-time/3287)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [November 6, 2025, 5:05pm UTC](https://forum.cloverdx.com/t/processing-several-files-one-at-a-time/3287 "2025-11-06T17:05:19Z")
Dear Forum Members, I have a graph which works on a single file. I wanted it to work for multiple files but one at a time. I have tried using ListFile component to list all the files in the source folder but unable to … --- ## [Create record structure within CTL2 code](https://forum.cloverdx.com/t/create-record-structure-within-ctl2-code/1671)
**Author:** [@etl\_1234](https://forum.cloverdx.com/u/etl_1234)\ **Replies:** 3\ **Last updated:** [August 27, 2025, 7:40pm UTC](https://forum.cloverdx.com/t/create-record-structure-within-ctl2-code/1671 "2025-08-27T19:40:57Z")
Hi, I am trying to find the way to create record type within CTL2. Currently, we have following record structure in Ab Initio : record decimal(10) abc; decimal(10) xyz; end \[int\] test = allocate; Here we want to ha… --- ## [Issue with Sending Integer Value via Multipart Entity in HTTP Connector](https://forum.cloverdx.com/t/issue-with-sending-integer-value-via-multipart-entity-in-http-connector/3272)
**Author:** [@Peter\_Baan](https://forum.cloverdx.com/u/Peter_Baan)\ **Replies:** 2\ **Last updated:** [August 20, 2025, 12:08pm UTC](https://forum.cloverdx.com/t/issue-with-sending-integer-value-via-multipart-entity-in-http-connector/3272 "2025-08-20T12:08:46Z")
Hi, I’m currently working on performing a POST request to an API using the HTTP Connector component with a multipart entity. Based on the edge and the data I need to provide to the API, I’ve configured the correct fiel… --- ## [Subgraph in jobflow runs very slow](https://forum.cloverdx.com/t/subgraph-in-jobflow-runs-very-slow/3253)
**Author:** [@Bob\_Shuka](https://forum.cloverdx.com/u/Bob_Shuka)\ **Replies:** 1\ **Last updated:** [June 6, 2025, 12:36pm UTC](https://forum.cloverdx.com/t/subgraph-in-jobflow-runs-very-slow/3253 "2025-06-06T12:36:35Z")
I have a subgraph that, when I run it from within a graph take about 10 seconds to run. When I run the same subgraph from within a jobflow it takes about 7 minutes to run. Is there a setting somewhere that causes subgrap… --- ## [Producing excel file using Custom headers](https://forum.cloverdx.com/t/producing-excel-file-using-custom-headers/3247)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 2\ **Last updated:** [May 21, 2025, 9:44pm UTC](https://forum.cloverdx.com/t/producing-excel-file-using-custom-headers/3247 "2025-05-21T21:44:10Z")
Dear Forum members, I am creating a dataset for which i have headers within the dataset, I want to add additional two rows as additional header information on top of the dataset headers and produce an excel file. Examp… --- ## [Multiplying percentage values](https://forum.cloverdx.com/t/multiplying-percentage-values/3249)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [May 18, 2025, 8:33pm UTC](https://forum.cloverdx.com/t/multiplying-percentage-values/3249 "2025-05-18T20:33:21Z")
Dear Forum members, Do we have a percentage function? I calculate everything in decimal and then multiply it by 100 to get a percentage value but I wanted to keep it as a percentage while multiplying it to other number. … --- ## [Custom Logs](https://forum.cloverdx.com/t/custom-logs/3243)
**Author:** [@Crystal\_Choo](https://forum.cloverdx.com/u/Crystal_Choo)\ **Replies:** 1\ **Last updated:** [April 17, 2025, 1:09pm UTC](https://forum.cloverdx.com/t/custom-logs/3243 "2025-04-17T13:09:35Z")
Hi, I’m very new to CloverDX platform and I am currently playing around with the components to figure out how to conduct a complex transformation for large datasets. I want to create custom logs to the log each failure a… --- ## [HTTP Connector Java Bind Exemption CloverDX Designer](https://forum.cloverdx.com/t/http-connector-java-bind-exemption-cloverdx-designer/3241)
**Author:** [@Gabby\_Tuff](https://forum.cloverdx.com/u/Gabby_Tuff)\ **Replies:** 1\ **Last updated:** [April 16, 2025, 12:24pm UTC](https://forum.cloverdx.com/t/http-connector-java-bind-exemption-cloverdx-designer/3241 "2025-04-16T12:24:06Z")
CloverDX Designer When sending concurrent requests (via multiple HTTP Connectors) I am getting the following error for a subset of the requests: java.net.BindException: Address already in use: connect. My understanding… --- ## [How can we limit the number of graphs running concurrently on CloverDX Server?](https://forum.cloverdx.com/t/how-can-we-limit-the-number-of-graphs-running-concurrently-on-cloverdx-server/3237)
**Author:** [@CloverDX\_team](https://forum.cloverdx.com/u/CloverDX_team)\ **Replies:** 1\ **Last updated:** [March 28, 2025, 9:34am UTC](https://forum.cloverdx.com/t/how-can-we-limit-the-number-of-graphs-running-concurrently-on-cloverdx-server/3237 "2025-03-28T09:34:36Z")
We have a requirement to restrict the number of graphs running in parallel on our CloverDX Server. Specifically, we want to limit concurrent executions to 30. We’re aware of parameters like jobqueue.maxLoadStep, jobqueu… --- ## [Can a Data App input field allow selection from a list or database query?](https://forum.cloverdx.com/t/can-a-data-app-input-field-allow-selection-from-a-list-or-database-query/3234)
**Author:** [@CloverDX\_team](https://forum.cloverdx.com/u/CloverDX_team)\ **Replies:** 1\ **Last updated:** [March 27, 2025, 9:07am UTC](https://forum.cloverdx.com/t/can-a-data-app-input-field-allow-selection-from-a-list-or-database-query/3234 "2025-03-27T09:07:16Z")
I’m working on a Data App where I need the user to select a file from a remote SFTP server. I can retrieve the list of files and store it in a list or database table. Is there a way to configure an input field in the Dat… --- ## [Error on opening CloverDX Designer: “Registry Directory not available”](https://forum.cloverdx.com/t/error-on-opening-cloverdx-designer-registry-directory-not-available/3236)
**Author:** [@CloverDX\_team](https://forum.cloverdx.com/u/CloverDX_team)\ **Replies:** 1\ **Last updated:** [March 27, 2025, 2:37pm UTC](https://forum.cloverdx.com/t/error-on-opening-cloverdx-designer-registry-directory-not-available/3236 "2025-03-27T14:37:56Z")
After installing a new version of CloverDX Server, I am getting the following error: An internal error occurred during: “Update Job”. Registry Directory not available: C:\\Users\\Mr%20Smith.eclipse\\org.eclipse.platform\_4… --- ## [Unexpected duplicate timestamps and missing hour around daylight-saving time](https://forum.cloverdx.com/t/unexpected-duplicate-timestamps-and-missing-hour-around-daylight-saving-time/3235)
**Author:** [@CloverDX\_team](https://forum.cloverdx.com/u/CloverDX_team)\ **Replies:** 1\ **Last updated:** [March 27, 2025, 1:03pm UTC](https://forum.cloverdx.com/t/unexpected-duplicate-timestamps-and-missing-hour-around-daylight-saving-time/3235 "2025-03-27T13:03:59Z")
We’re seeing unexpected behavior when querying datetime values from a SQL Server database through CloverDX—specifically around the daylight-saving time transition. Instead of receiving a record with a timestamp for 2:00… --- ## [How to retry HTTP Connector calls based on API response codes (e.g., 500 errors)?](https://forum.cloverdx.com/t/how-to-retry-http-connector-calls-based-on-api-response-codes-e-g-500-errors/3233)
**Author:** [@CloverDX\_team](https://forum.cloverdx.com/u/CloverDX_team)\ **Replies:** 1\ **Last updated:** [March 27, 2025, 8:26am UTC](https://forum.cloverdx.com/t/how-to-retry-http-connector-calls-based-on-api-response-codes-e-g-500-errors/3233 "2025-03-27T08:26:54Z")
We’re currently using the HTTP Connector to make requests to an API, and we’d like to implement retry logic based on the API’s response. Specifically, we want to retry the request if we receive a 500 Internal Server Erro… --- ## [SQL Query Parameters and SQL injection](https://forum.cloverdx.com/t/sql-query-parameters-and-sql-injection/3231)
**Author:** [@Mark\_Palermo](https://forum.cloverdx.com/u/Mark_Palermo)\ **Replies:** 1\ **Last updated:** [March 26, 2025, 7:49am UTC](https://forum.cloverdx.com/t/sql-query-parameters-and-sql-injection/3231 "2025-03-26T07:49:29Z")
I am attempting to create a re-usable subgraph for retrieving a database value based on a query parameter passed in. For scalability reasons, it is not reasonable to read the whole table and then filter in CloverDX. Th… --- ## [Serverless SQL (Oracle)](https://forum.cloverdx.com/t/serverless-sql-oracle/3222)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 1\ **Last updated:** [March 19, 2025, 2:42pm UTC](https://forum.cloverdx.com/t/serverless-sql-oracle/3222 "2025-03-19T14:42:22Z")
Dear Forum Members, I have few questions, please do let me know whether this is possible using CloverDX: Can we use Serverless SQL within CloverDX Designer? How will the connections work for E2E ETL jobs? Serverless S… --- ## [Capture & Parse PDF file](https://forum.cloverdx.com/t/capture-parse-pdf-file/3224)
**Author:** [@CloverDX\_team](https://forum.cloverdx.com/u/CloverDX_team)\ **Replies:** 1\ **Last updated:** [March 19, 2025, 1:53pm UTC](https://forum.cloverdx.com/t/capture-parse-pdf-file/3224 "2025-03-19T13:53:14Z")
We are building a flow where I need to download a file from an sFTP site and parse it into a Base64 string before sending it to a REST API endpoint. I can’t seem to find a suitable reader so I can then use the byte2base… --- ## [Plugin for Custom CTL](https://forum.cloverdx.com/t/plugin-for-custom-ctl/1719)
**Author:** [@cloverdm](https://forum.cloverdx.com/u/cloverdm)\ **Replies:** 4\ **Last updated:** [September 24, 2024, 6:45am UTC](https://forum.cloverdx.com/t/plugin-for-custom-ctl/1719 "2024-09-24T06:45:38Z")
Hello Support , Thanks for the great Product , We made a java plugin for custom ctl function , currenly i deployed it in eclipse plugin folder , its works fine with internal jetty server, My question is when i use that … --- ## [Is xlsb format reable now?](https://forum.cloverdx.com/t/is-xlsb-format-reable-now/3201)
**Author:** [@Zhixin.Chen](https://forum.cloverdx.com/u/Zhixin.Chen)\ **Replies:** 1\ **Last updated:** [January 2, 2025, 3:55pm UTC](https://forum.cloverdx.com/t/is-xlsb-format-reable-now/3201 "2025-01-02T15:55:19Z")
how to read xlsb data? i saw a topic from 2020, ur replys are is considered as furture funktion, is that possible now? --- ## [Stored Procedure Returning Rows](https://forum.cloverdx.com/t/stored-procedure-returning-rows/3185)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 6\ **Last updated:** [November 30, 2024, 6:04pm UTC](https://forum.cloverdx.com/t/stored-procedure-returning-rows/3185 "2024-11-30T18:04:04Z")
Hi I’m trying to Execute a SQL sproc that has 3 arguments. The return data is 1000’s of rows, multiple columns. so the purpose of this sproc is to read data. Is this possible with the Clover designer as I’m having a few … --- ## [CloverDX connectivity to MS Teams/Share folders](https://forum.cloverdx.com/t/cloverdx-connectivity-to-ms-teams-share-folders/3193)
**Author:** [@CloverDxNewBie](https://forum.cloverdx.com/u/CloverDxNewBie)\ **Replies:** 3\ **Last updated:** [December 12, 2024, 9:43am UTC](https://forum.cloverdx.com/t/cloverdx-connectivity-to-ms-teams-share-folders/3193 "2024-12-12T09:43:40Z")
Dear Forum Members, We need to connect to MS Teams share folders in order to read the files and further to process, Is it possible to connect using CloverDX? Kind regards --- ## [S/sheet Writer Multiple Sheets](https://forum.cloverdx.com/t/s-sheet-writer-multiple-sheets/3188)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 6\ **Last updated:** [December 4, 2024, 6:46pm UTC](https://forum.cloverdx.com/t/s-sheet-writer-multiple-sheets/3188 "2024-12-04T18:46:57Z")
When I populate a sheet in Excel, I seem to run out of memory. In my example I have about 50k items. I’ve updated the component to do “streaming mode” which is quick and doesn’t error, but then it won’t allow me to prese… --- ## [SQL Query containing the output of a previous SQL query](https://forum.cloverdx.com/t/sql-query-containing-the-output-of-a-previous-sql-query/3184)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 2\ **Last updated:** [November 26, 2024, 9:39pm UTC](https://forum.cloverdx.com/t/sql-query-containing-the-output-of-a-previous-sql-query/3184 "2024-11-26T21:39:59Z")
Hi I’m using the DatabaseReader to read the following data from SQL: Field 1,2,3,4,5 I then send this to the input port of another DatabaseReader component but i’m trying to use the output from the previous component … --- ## [Can't connect to Azure SQL Server](https://forum.cloverdx.com/t/cant-connect-to-azure-sql-server/3181)
**Author:** [@nick.williams](https://forum.cloverdx.com/u/nick.williams)\ **Replies:** 2\ **Last updated:** [November 21, 2024, 10:04am UTC](https://forum.cloverdx.com/t/cant-connect-to-azure-sql-server/3181 "2024-11-21T10:04:40Z")
Hi we currently use other tools like PowerAutomate etc. to connect to to an Azure SQL Server. I’m now trying to use CloverDX Designer. I choose “New Connection” in the Connections outline pane and then click “MS SQL Ser… [Next page](https://forum.cloverdx.com/latest.md?page=1)