Log Error

[parvez933]

Hi!

I am unable to decode the below error from Log.

Request help in understanding the same

Error: There were no fields to load in the given source.

There were no fields to load in the given source.

But, when I tried to fetch the data from DB the DB is showing me data based on the script.

PFA

[JuanGerardo]

Hi, are you sure the following query is returning any record?

SELECT
Printer.SerialNumber as 'Printer.SerialNumber',
PrinterModel.ProductNumber as 'PrinterModel.ProductNumber',
DATE(InkUsageFact.ETLDateTime) AS 'ETLDateTime',
InkUsageFact.DeltaInkUsedSupportedLiters AS 'DeltaInkUsedSupportedLiters',
Replace(CartridgeType.InkColor,'MatteBlack','Black') as 'InkColor'

FROM InkUsageFact

LEFT JOIN Printer ON Printer.idPrinter=InkUsageFact.idPrinter
LEFT JOIN PrinterModel ON PrinterModel.idPrinterModel=Printer.idPrinterModel
LEFT JOIN CartridgeType ON CartridgeType.idCartridgeType=InkUsageFact.idCartridgeType

Where ETLDateTime>='2021-01-01'
 and ETLDateTime<'2021-02-01'
 and (PrinterModel.ProductNumber='M0E30A' or PrinterModel.ProductNumber='B4H69A' or PrinterModel.ProductNumber='E2X76A' or PrinterModel.ProductNumber='B4H70A' or PrinterModel.ProductNumber='L4R41A' or PrinterModel.ProductNumber='1QE01A' or PrinterModel.ProductNumber='1QE01B' or PrinterModel.ProductNumber='1QE01C' or PrinterModel.ProductNumber='1QE01D' or PrinterModel.ProductNumber='V7L46A' or PrinterModel.ProductNumber='V7L46B' or PrinterModel.ProductNumber='V7L46C' or PrinterModel.ProductNumber='V7L46D' or PrinterModel.ProductNumber='V7L47A' or PrinterModel.ProductNumber='V7L47B' or PrinterModel.ProductNumber='V7L47C' or PrinterModel.ProductNumber='V7L47D' or PrinterModel.ProductNumber='V8L39A' or PrinterModel.ProductNumber='V8L39B' or PrinterModel.ProductNumber='V8L39C' or PrinterModel.ProductNumber='V8L39D' or PrinterModel.ProductNumber='V8N83A' or PrinterModel.ProductNumber='V8N83B' or PrinterModel.ProductNumber='V8N83C' or PrinterModel.ProductNumber='V8N83D' or PrinterModel.ProductNumber='M0E29A' or PrinterModel.ProductNumber='M0E29B' or PrinterModel.ProductNumber='M0E29C' or PrinterModel.ProductNumber='M0E29D' or PrinterModel.ProductNumber='N2G70A' or PrinterModel.ProductNumber='N2G70B' or PrinterModel.ProductNumber='N2G70C' or PrinterModel.ProductNumber='N2G70D' )
and  ETLDateTime is not null   and  PrinterModel.ProductNumber is not null   and  Printer.SerialNumber is not null  
GROUP BY Printer.SerialNumber, PrinterModel.ProductNumber, CartridgeType.InkColor, DATE(InkUsageFact.ETLDateTime)

JG

[parvez933]

Hi!

Yes! I too was in the same assumption that there will be no records
available in DB when I run this query

But the fact is after running for a quiet long hours, it should few records
in DB.

If you want me to make sure again. Yes will re run the query again and
share the status here. But as said in DB it is taking atleast an hour to
execute the query.

[PadmaPriya]

Hello @parvez933 

There seems to be similar query posted in another thread mentioned below:

https://community.qlik.com/t5/New-to-Qlik-Sense/Field-not-Found/td-p/1263376

Thanks,

Padma Priya

[parvez933]

Hi @PadmaPriya,

Thank You! the shared https://community.qlik.com/t5/New-to-Qlik-Sense/Field-not-Found/td-p/1263376 post is helpful.

[PadmaPriya]

@parvez933  Thanks for your reply. Let us know if it works for you so that we can assist you else please share the solution in case resolved.

Thanks,

Padma Priya

[parvez933]

Hi @PadmaPriya ,

I was trying to run the script as @JuanGerardo mentioned. But as said the query is running from long hour.

If the query fails to load in DB, I will check with DB team and

If the query completes successfully in DB, I will start trying the solutions shared in the https://community.qlik.com/t5/New-to-Qlik-Sense/Field-not-Found/td-p/1263376

[parvez933 · Accepted solution]

Hi @PadmaPriya  and @JuanGerardo ,

Unsure how the task completed successfully on QMC after 20 days.

I was concentrating on running the query for the period for which the error was showing.