Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I’ve configured a Log Stream task to read from a Microsoft Azure SQL database, along with a replication task that reads from this Log Stream and replicates data to a Databricks Lakehouse (Delta) endpoint.
Both tasks were running correctly until this week, when I stopped and resumed them for maintenance on the Qlik Replicate server.
After resuming the tasks, the replication task started logging the following error for all tables, and replication is now suspended for each of them:
Failed (retcode -1) to execute statement: CREATE OR REPLACE TABLE `schema_name`.`table_name` ([fields]) USING DELTA LOCATION 'abfss://location_for_tables' TBLPROPERTIES (delta.autoOptimize.optimizeWrite = true)
RetCode: SQL_ERROR SqlState: 42KD7 NativeError: 80 Message: [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: org.apache.hive.service.cli.HiveSQLException: Error running query: [DELTA_CREATE_TABLE_WITH_DIFFERENT_PROPERTY] com.databricks.sql.transaction.tahoe.DeltaAnalysisException: The specified properties do not match the existing properties at abfss://location_for_tables.
== Specified ==
delta.autoOptimize.optimizeWrite=true
== Existing ==
delta.autoOptimize.optimizeWrite=true
delta.enableChangeDataFeed=trueThe Databricks target endpoint is configured with the internal parameter $info.query_syntax.create_table, using the following statement:
CREATE or REPLACE ${TABLE_TYPE} TABLE ${QO}${TABLE_OWNER}${QC}.${QO}${TABLE_NAME}${QC} ( ${COLUMN_LIST} ) USING DELTA TBLPROPERTIES (delta.autoOptimize.optimizeWrite = true)I then tried adding the missing property to match the existing table metadata, but the same error still occurs. Specifically, I tested the following statement:
CREATE or REPLACE ${TABLE_TYPE} TABLE ${QO}${TABLE_OWNER}${QC}.${QO}${TABLE_NAME}${QC} ( ${COLUMN_LIST} ) USING DELTA TBLPROPERTIES (delta.enableChangeDataFeed=true, delta.autoOptimize.optimizeWrite = true)I even tried removing the internal parameter entirely, but the same error continues to occur.
Is there a supported way to force Qlik Replicate to recreate the tables (or align with existing ones) while preserving or explicitly setting the missing property?
Any guidance or best practices for handling this scenario with Databricks targets would be greatly appreciated.
Thank you very much in advance for your help.
Best regards
Hola Fabián, tengo la siguiente consulta: me conecto a una API utilizando el conector REST, pero siempre me trae solo 100 registros, sabiendo que hay más de mil. Y como 100 es un número "cerrado" pienso que puede ser algún tipo de seteo de Qlik que no puedo encontrar. ¿Me puedes ayudar?
The new Content Monitor loads from the APIs and logs to present key metrics on the content, configuration, and usage of your platform, allowing administrators to understand the evolution and origin of specific behaviors of the platform.
This new monitoring app comes pre-installed with the latest version (November 2025 onwards) of Qlik Sense Enterprise on Windows.
If you are running previous versions of Qlik Sense Enterprise on Windows, the Content Monitor is also available on Qlik's Downloads page here: Content Monitor (download page) - note, this must be manually installed and a weekly reload is recommended.
Hi All,
Our firm's is on Qlik Sense Enterprise Feb 2024 SR17, with issues extracting data from our Service Now cloud SaaS instance. We are able to connect successfully to the Service Now database, however when trying to select a Schema (Actual) and the DB view its spinning endlessly and wont even release the window when cancelled.
The below is inside the Data load editor Service-Now data selector window. The Service now URL has been allowed listed in the QMC aswell and servers rebooted.
Can anyone suggest on how to proceed further to debug this issue?
This is the 5th and final part in the "Taking action on your data series" - It recaps the the four basic action types that can be achieved with Qlik Automation and Qlik Cloud Analytics and shows you how others can reuse your automations by creating them as templates.
Resources:
See this link for all previous episodes and resources.
Hello,
We are trying to use Qlik Cloud Services within Qlik Application Automation. Some blocks work correctly and pass the domain in the URL as expected, but others do not. For example, we receive the following error when using the Get Space block. We are not sure if we are missing a configuration or setting. Appreciate any help. Thanks.
Sum(Aggr(max( {<GLaccountCode={'121001','117000'}>}If((YearEndDate>=NetDueDate and [Clearing Date]>YearEndDate and Arrears>0) or AROverdue='Overdue',ARAmountLC)
),YearFilter,ARKey))
Above is my expression i use on charts and its very slow when there are no filters.
I'm using an As-of table and when i apply filters inside the if-clause, the amount is duplicated(guessing its due to many-to-many joins) and I'm forced to use Max() inside the AGGR() function.
My data model looks like below,
TIA,
Hi, how change sheet title font colour / style in Qlik Sense November 2025?
I swear I was able to do this in the 2022 version, then I didn't use it for a long time and now I can't find this option, and what I found on the forum is probably not up to date.
I
Qlik Sense Enterprise on Windows November 2025 Patch 1
Cannot export charts as images or pdf files.
Added settings in Printing.exe.config:
<add key="webrenderer-args" value="-l=trace" />
<add key="webrenderer-grpc-call-timeout-secs" value="300" />
[2025-12-15 21:23:59] serving url: https://myserver/resources/assets/mapconf.json from file system provider for prefix /resources/, file path: C:\Program Files\Qlik\Sense\client\assets/mapconf.json
[2025-12-15 21:23:59] successfully downloaded resource from local path: C:\Program Files\Qlik\Sense\client\assets/mapconf.json for url: https://myserver/resources/assets/mapconf.json
[2025-12-15 21:23:59] PaintHandler::OnResourceLoadComplete id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df worker=worker_47_1w url=https://myserver/resources/assets/mapconf.json?1765826639052&xrfkey=LlbQsjiygAtNzqI5 bytes=87 response_status=OK
[2025-12-15 21:23:59] PaintHandler::OnBeforeResourceLoad id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df worker=worker_47_1w url=https://maps.qlikcloud.com/ravegeo/webmap5/maps?key=may21-K8DU2D3jU9PWhr&listMaps method=GET
[2025-12-15 21:24:58] exit due to timeout id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df
[2025-12-15 21:24:58] processed request id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df valid=false render_msec=60012
[2025-12-15 21:24:58] error, LoadAndRenderChart failed id=worker_47_1w_imgidx_025_rid_adf3092a9de94d6ea557f032e53866df error=task LOAD_URL_TIMEOUT, result: ERROR_LOADURL_TIMEOUT_RESULT, the rendering page could not be loaded, check the URL
Welcome to our first-ever Qlik Community Scavenger Hunt! We’ve hidden secret letters all around the Community, and each clue below will point you toward a different location in the navigation. Follow the trail, collect every letter, and crack the final phrase to reveal the mystery phrase. Submit your answer for a chance to score some exclusive prizes!
Ready to get started? Here's some helpful tips:
Now, for the fun! Here are the clues. Good luck!
Do you have all the letters?
FREE TRIAL
Data has stories to tell—let Qlik help you hear them. Start your FREE TRIAL today!
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Data Integration Tool.
Trends 2026 Alert! Plug into this rewired framework for driving ROI from AI.
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader.
With Qlik Public ILT Passport, embark on live sessions with our top trainers — helping you grow faster and get the most out of Qlik. See where your passport can take you.
Solve the real-world need for real-time data with Change Data Capture (CDC). What is CDC and how to master it?
Your journey awaits! Join us by Logging in and let the adventure begin.
Afcons Infrastructure partnered with Qlik to unify its data and build dynamic dashboards, reducing review times from weeks to hours and enabling on-demand reporting across its global operations.
By implementing Qlik Analytics, Atria Convergence Technologies improves insight into churn, revenue, and downtime, driving faster decisions and more proactive customer support.
Hydronorth uses Qlik to replace disconnected data systems with a single source of truth, improving alignment, speeding up decisions, and reducing manual work.
With Qlik Cloud Analytics, Rexel boosts performance by enabling self-service analysis, reducing prep time, and giving 3,000 users access to trusted insights.
Join one of our Location and Language groups. Find one that suits you today!
Únete a la conversación con usuarios de Qlik en todo México: comparte ideas, haz preguntas y conéctate en español.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Connectez-vous avec des utilisateurs francophones de Qlik pour collaborer, poser des questions et partager des idées.
The Qlik Product Recap showcases the newest features with quick demos and shareable resources to help you stay current?
You can test-drive Qlik for free? Try Qlik Talend Cloud to integrate and clean data without code, or explore Qlik Cloud Analytics to create AI-powered visualizations and uncover insights hands-on.
Salesforce’s acquisition of Informatica could put your flexibility on hold? Qlik makes it easy to keep your data initiatives moving forward.
You can move beyond batch processing and harness real-time data to power AI and faster decisions? Discover how in our new eBook, Mastering Change Data Capture.