Dear team,

We have encountered this error suddenly a few hours ago, and only one replication task is experiencing this issue with the same target (Azure SQL Managed Instance). The database is still functioning normally with other tasks, but only this one is affected.

Failed to update database "FLXXX" because the database is read-only

I need advice on what to do to resolve this. 

Please help. Thank you

Hi guys,

i'm stucking ni this simple situation where i need ta have bars from a date range (2014-now) but not all date have data in them, how do i generate a local autogenareted table with a date range?

in Oracle i would do someting like this:

SELECT

(to_date(sysdate,'DD-MM-YYYY') - level + 1) AS day

FROM

dual

CONNECT BY LEVEL <= (to_date(sysdate,'DD-MM-YYYY') - to_date('01-01-2014','DD-MM-YYYY') + 1);

Hello, I need to calculate the new value of the cell, but I am not able to make it work, can you help me?

Hi Team,

A common issue which every organization is facing is applications which are holding memory which are unused and unpublished in the work stream, and also the task which user is creating and not deleting once the work is completed, could you please suggest how to delete these.

I should delete the unused apps which is not modified in the last 30 days and not published, and also the task, which is pointing to that application, And the QVD's related to that application.

I think it would be really useful to those who are all managing QMC and every time ask the user to delete those, instead is it possible to create an application which runs on a particular period, and it automatically detects apps and delete it.

=Sum({$<PAID={1,2},FISCAL_MONTH=,FISCAL_YEAR=,QTR_NAME=,
PARENT_FISCAL_MONTH={">=$(=date(addmonths(max({<PAID={1,2}>}Date#(PARENT_FISCAL_MONTH,'YYYYMM')),-12),'YYYYMM'))
<=$(=date(max({<PAID={1,2}>}Date#(PARENT_FISCAL_MONTH,'YYYYMM')),'YYYYMM'))"} >}DISCOUNT_TAKEN_USD_AMOUNT)

Hi,

We recently encountered an issue with our Replicate task, where the source is a "SQL Server" and the target is a "csv file." During the generation of the CSV file, we noticed that certain columns were missing. Upon further analysis, we identified that these missing columns were LOB columns, and the "LOB replication option" was not enabled in our replicate task.

To address this, we are consider enabling the "Replicate LOB columns" option. However, we have a few questions and need your guidance on the following:

1. How to check the LOB size in the source table?

   We would like to understand how we can determine the size of LOB columns in the source SQL Server table.

2. How to decide the "Replicate LOB columns" option?

   We need your inputs on determining whether we should go with "Allow unlimited LOB size" or "Limit LOB size to (KB)" .

3. If we select "Allow unlimited LOB size," how should we calculate and provide the chunk size?

   For the scenario where we choose to "Allow unlimited LOB size," we would like to know how to calculate and specify the chunk size.

4. If we select "Limit LOB size to (KB)," how can we calculate and provide the value?

   In the case of selecting "Limit LOB size to (KB)," we need guidance on how to calculate and set an appropriate value.

If possible, we are also interested in any SQL queries that can assist in gathering the necessary information.

Thanks,

I want to add color to the bar graph by entering the Expression background color.

The conditions are If the bar graph shows data for the year, include rgb(30,144,255) and if the graph shows data for the month, enter Rgb(70,130,180) and if the graph shows data for the day, enter rgb(135,206,250)

This is the code that displays the data in a bar graph.

please help me

Hello Qlik world. I am trying to understand what the purpose of dec_sep & the thou_sep is in the function syntax: Num(number[, format[, dec_sep [, thou_sep]]]). I have looked everywhere and cannot find where it is clearly explained. Thanks in advance.