topic Re: CREATE TABLE error when replicating a VIEW from Oracle in Qlik Replicate

CREATE TABLE error when replicating a VIEW from Oracle

slewis — Fri, 04 Oct 2024 16:57:36 GMT

Recently a development team made a change to an existing ORACLE View that was included in a QLIK Replicate task. The result of the View change is that one of the previously existing columns now returns nothing but NULL values in the result set.

I started noticing the task failing and after digging into the Log File (see attached excepts) I saw that Replicate was generating an inaccurate CREATE TABLE statement for the target table that is dropped and recreated each time the full-load task (no CDC) is run.

The brief example is this:

CREATE TABLE "SCHEMA_NAME"."VIEW_NAME" (

"A" VARCHAR(14),

"B" VARCHAR(8),

"C" NUMBER(26,3) NOT NULL,

"D" VARCHAR(10),

"E" , <-- Note No Data Type

"F" VARCHAR(10),

"G" VARCHAR(5) NOT NULL,
...)

I suspect a bug in the process that interrogates the source object to determine the DDL. Since this is an Oracle View and no data types are specified, the process has to infer data types by sampling the data. Since this column has nothing but NULL values a data type cannot be determined. The Bug would be not defaulting to something safe(ish) like a string data type.

Interestingly when in Designer mode and I double click on the VIEW name to "View Settings". The Transformation Tabs Output grid shows column "E" as a STRING(50) but that data type is not being used when the CREATE TABLE statement is sent to my Snowflake target.

So I don't know if the error is on the Oracle SOURCE processing side of the equation or the Snowflake TARGET processing side. Either way, this seems like an issue that should be looked into if not already fixed in the May '24 release.

Re: CREATE TABLE error when replicating a VIEW from Oracle

Dana_Baldwin — Fri, 04 Oct 2024 17:37:06 GMT

Hi @slewis

Thanks for utilizing our Community forum. Unfortunately, we don't have a method of raising potential application defects to our internal support team via the forum. Could you please open a support case for this issue? It is an interesting use case.

Thanks,

Dana

Re: CREATE TABLE error when replicating a VIEW from Oracle

slewis — Fri, 04 Oct 2024 17:45:02 GMT

Would love to add a support case but I've spent over 30 minutes going through the site and cannot find where to do so. The closest I came was this forum where I could post a question and the Get Help/Manage Cases link that, when selected, has 7 options, none of which have anything to do with support cases by name. Ugh...

Re: CREATE TABLE error when replicating a VIEW from Oracle

slewis — Fri, 04 Oct 2024 17:46:09 GMT

I haven't had this sort of problem in the past, but we have a new site now that I'm less familiar with.

Re: CREATE TABLE error when replicating a VIEW from Oracle

slewis — Fri, 04 Oct 2024 17:50:09 GMT

If anyone else can't find the link to open a support case, I FOUND IT!!!

2. Chat

Incidents are supported through our Chat, by clicking Chat Now on any Support Page across Qlik Community.

To raise a new issue, all you need to do is chat with us. With this, we can:

Answer common questions instantly through our chatbot
Have a live agent troubleshoot in real time
With items that will take further investigating, we will create a case on your behalf with step-by-step intake questions.

Re: CREATE TABLE error when replicating a VIEW from Oracle

Dana_Baldwin — Fri, 04 Oct 2024 17:55:46 GMT

@slewis I'm sorry to hear the portal isn't working correctly for you. Please check this link, and if it does not help, please open a case with the team that handles portal access using the chat button or emailing CustomerSupport@qlik.com

How to view cases in Support Portal - Qlik Community - 1717144

Re: CREATE TABLE error when replicating a VIEW from Oracle

slewis — Fri, 04 Oct 2024 18:04:30 GMT

Support case: 00315969

Re: CREATE TABLE error when replicating a VIEW from Oracle

sureshkumar — Sat, 05 Oct 2024 00:54:50 GMT

Hello @slewis

Thanks for opening a support ticket, our support engineer will work on the issue and keep you posted in the case portal.

Regards,

Suresh