Hi everyone, I made a sheet and give all access to my friend ,  to make sure they can edit and delete whatever they want through the management console in qlik cloud  but they are still not able to edit it . What to do?

We have an existing task that replicates from SQL Server 2019 to Snowflake AWS. It has been running fine with CDC. But lately the CDC latency has been increasing and we are seeing error below. I believe some changes we made at the source.

How can we find out more information based on the error below?

It looks like the table doesn't has PK that's explain the slow CDC.

mssql_approve_table_full_logging_setup(...) failed in checking PK presence for table identified by ID '114515887'

Also further checking, showed that the following errors in the logs for several tables.

MS-REPLICATION is not enabled for table 'dbo.TABLE'. Therefore, UPDATE changes to it will not be captured. If you want UPDATE changes to be captured, either define a Primary Key for the table (if missing) or enable Microsoft CDC instead.

I went to each of the table and notice there is already PK defined over them. How can we resolve this please?

The DBA provided 1500 tables for replication, for which we have separate endpoint connections for full load and CDC. The full load is completed and we have started CDC in batch mode 12 days ago. We have CDC logs from 16th Jun till date, and the task is currently processing the logs of June 18th. We request your assistance in increasing the speed and performance of the CDC tasks.
Task settings for CDC:
1)Enabled Apply changes using SQL MERGE
2)
Transaction Offload Tuning
Offload transactions in progress to disk if:
Total transactions memory size exceeds (MB): 5000
Transactions duration exceeds (seconds): 60000

3)
Apply batched changes in intervals:
Longer than (seconds): 59
But less than (seconds): 60
Force apply a batch when processing memory exceeds (MB): 2048
 
4) started the CDC task with provided SCN

PFA logs and diagnostic package.

We are unable to load the data using the target lookup getting an error

target_lookup('NO_CACHING','TargetSchema','TargetTable','max(load_date)','','') < $LOAD_DATE

We are using the following Target lookup  to load the table only when the Load date from the source table is greater than Load date in Target table.

We are using this target_lookup in FullLoad Filter

Here is the error.

Stream component 'st_1_ORA_FINCAPRD' terminated
Stream component failed at subtask 1, component st_1_ORA_FINCAPRD
Error executing source loop
Endpoint is disconnected
Failed to init unloading table 'SNAPLOGIC'.'WEEKLY_CCS_EXPEND'
ORA-00911: invalid character

I have a Listbox filter pane with strings.

'Standards 1'

'Standards 2'

'Standards 3'

'Below Standards'

I need to have the dropdown list in the order above. If I order it alphabetically, it shows as Below Standards, 1, 2, 3. If I sort it alphabetically descending it is 3, 2, 1, Below Standards.  How can I get it to sort 1, 2, 3, Below Standards?

I have been attempting to connect to SQL Server via Direct Access Gateway but have been unsuccessful. The database is only accessible on VPN. For my laptop with SQL Server Management Studio, the connection required encryption to be set to "optional". I have tried a SQL Server connection, an Azure SQL Server connection, and an ODBC connection. Nothing is working, and the error messages aren't very helpful. 

When I try to connect with ODBC, I get this error at least: Invalid connection string attribute - ERROR [08001] [Microsoft][ODBC SQL Server Driver]Neither DSN nor SERVER keyword supplied

Hello

I am currently building a bar chart that counts the amount of events organized per theme. However, sometimes an event has two themes. So, if for example there is an event "Valentine, Christmas", I would like for it to be counted in the Christmas bar and the Valentine bar. Is there a way to have them counted in both ? 

Hope I was clear!

hello.
I would like to change the logo image displayed when an error occurs.

Please refer to the attached file

If anyone knows how to change it, I would appreciate it if you could share it.

thank you.

Morning!

I upgraded late last year from May 20 to Aug 22.  We didn't go further as I suspected we needed to upgrade the Postgresql database too.  We're clustered and have a dedicated DB server set up by a third party.

However, i've now realised that we are on Postgresql 11.  Struggling to login using psql to check exactly. But it looks to be...

First of all it looks to me that May & November 23 look to allow version 11.  I see much later versions are bundled in, but 11 looks to be allowed.

Am I good to go from August 22 to either of these to buy myself some time to pluck up the courage to upgrade the databse?  (I'm not DBA and don't want to be!)

Would some features not be available due to the db version being 11?
Will it make upgrading the DB more difficult later?

Any help appreciated.

Many thanks
Stu