Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
VamsiBhagavathula1

Tables to Query for Task reloads status

Hello All,

 

I would like to know what metadata tables are involved for  tasks reloads in qliksense. I would like to build a query to get the status of task'sreload by date along with the error message info if any.

 

Please share if any such queries were  already made. I can customize it as per  my requirements and continue on it

 

Best Regards

Vamsi

Labels (5)
5 Replies
mato32188
Specialist
Specialist

Hi @VamsiBhagavathula1 ,

sure, you can create Postgre SQL connection in data load editor to your Postgre DB and then query reload task metadata.

br

m

ECG line chart is the most important visualization in your life.
VamsiBhagavathula1
Author

@mato32188 ,yes i do have  the postgres sql connection but i want to know table names where we could find this task reload execution details & its status??

mato32188
Specialist
Specialist

@VamsiBhagavathula1 ,

"public"."ExecutionResults" and "public"."ReloadTasks"

ECG line chart is the most important visualization in your life.
nmartini
Partner - Contributor II
Partner - Contributor II

Hi, I made a test and it seems there are only the last 4 run of the tasks in ExecutionResults.

I can't find anything about that in documentation, do you know about that?

Sander_Persgroep
Contributor II
Contributor II

@nmartini This is also my observation. I was looking for more info and found your question about this. I'm also curious about the documentation on this.