Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi folks
I am building a task which extracts data from a CSV source which fails at run time. In the logs i see a number of errors which I can't interpret - log is attached and an extract is pasted at the end of my post. The basic task details are as follows:
SOURCE
TARGET
TASK
I have tried all kinds of alterations to the task and the source endpoint but can't seem to make any head way. All help would be greatly appreciated.
Thanks very much, jonna
Date and Time Level Message
05/05/2022 14:30:38 ERROR_GENERAL "Cannot refresh source table (1) metadata
Failed on getting table definition for table id: 1
Getting DB object (''QlikSense Server File Location'.'Web Chat'') info from repository failed."
05/05/2022 14:30:38 ERROR_GENERAL Could not get object: 'QlikSense Server File Location'.'Web Chat' from repository.
05/05/2022 14:30:38 ERROR_GENERAL "Stream component 'st_1_QlikSense Server File Location' terminated
I @Steve_Nguyen - I just built a brand new CSV, it has the same number of columns (two), it has a different name and is comma delimited. I also built a new task, stepped through it in case i missed something obvious but still getting the same result. Thanks for your help so far, I am finished for the day and will get back on this first thing. cheers, jonna
1. could you provide the task Diagnostic Package?
2. could you provide a same of your CSV file ?
I want too see if i can duplicate the issue .
Here is the source file (nb - in .txt format, couldn't attach CSV
Here is the diagnostics package.
Hey @jonna
Within your source file endpoint -> Tables tab -> open up 'Web Chat CSV'
Location of full load data file(s):
You need to reference the file name in your path, not just the folder.
current: \\VVL-QS-FS\QlikShare\Project Layer\Application Layer\Avaya\Reference Files
update to: \\VVL-QS-FS\QlikShare\Project Layer\Application Layer\Avaya\Reference Files\WebChat.csv
Ref: https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/File/Advanced_Settings.htm
Try pointing to the exact file path and let us know if able to run without error.
Best,
Kelly
thanks @KellyHobson - i am on it now 👍
@KellyHobson and @Steve_Nguyen - fantastic it worked a treat. Really impressed how you sorted out what should have been staring me in the face.
You folks are great.
Thanks, jonna
Do NOT use Excel to visualize CSV files for support/understanding purposes. It tries to 'help' too much
Please just use NOTEPAD(++) or similar to show the exact contents with all details like quoted columns, seperators, dates which turn out to be day numbers and so on.
Hein.
Hey @jonna ,
Glad to hear it is working now and appreciate the kind feedback! Keep asking away, we are happy to help.
All the best,
Kelly