Task for CSV source fails - "cannot refresh metadata" and "could not get object"

[jonna]

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

• Source is a CSV file, it lives on a network server
• the CSV file has two columns, it is comma separated and has less than 1,000 rows of data
• "Test Connection" is successful  when editing the endpoint
• Only one tab exists in the CSV

TARGET

• SQL server database, well established
• Target table was created by the task, presume this was done  before the task failed

TASK

• No special processing included, other than chnage schema name
• When editing the task after failure this error is thrown and shown on QEM >>> SYS-E-HTTPFAIL, Getting DB object (''QlikSense Server File Location'.'Web Chat'') info from repository failed.
• The target table has been  created on the Target but with no data
• Log file attached

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

[jonna]

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

[Steve_Nguyen]

@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 .

[jonna]

Here is the source file (nb - in .txt format, couldn't attach CSV

[jonna]

Here is the diagnostics package.

[KellyHobson · Accepted solution]

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

[jonna]

thanks @KellyHobson  - i am on it now 👍

[jonna]

@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 

[Heinvandenheuvel · Accepted solution]

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.

[KellyHobson]

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