Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
jonna
Partner - Creator
Partner - Creator

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

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

Labels (2)
2 Solutions

Accepted Solutions
KellyHobson
Support
Support

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

View solution in original post

Heinvandenheuvel
Specialist
Specialist

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.

View solution in original post

18 Replies
KellyHobson
Support
Support

Hey @jonna ,

Is it possible to attach the task log for the Replicate task?

Thanks, 

Kelly 

 

jonna
Partner - Creator
Partner - Creator
Author

Hi @KellyHobson

 

thanks for taking a look - here is the file as requested

 

cheerr, jonna 

Steve_Nguyen
Support
Support

@jonna

 

from the log :

 

00006152: 2022-05-05T17:00:34 [SOURCE_UNLOAD   ]E:  Failed to write record id: 2195, Number of values: 1 is not equal to number of columns: 2. [1020417]  (file_unload.c:344)
00006152: 2022-05-05T17:00:34 [SOURCE_UNLOAD   ]E:  Failed to init unloading table. [1020417]  (file_unload.c:395)

 

this indicate that when you set the table it does not have the correct number of columns as compare to your csv file.

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
jonna
Partner - Creator
Partner - Creator
Author

thanks @Steve_Nguyen 

I have take a look at the task, the source and the target they all appear to have 2 columns.

cheers, jonna

jonna_0-1651768359247.png

 

Steve_Nguyen
Support
Support

do you have your table set in the endpoint?

 

see example screen-shot?

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!
jonna
Partner - Creator
Partner - Creator
Author

hi again @Steve_Nguyen 

 

here is a screen shot of the table set up in Manage Endpoint Connections

jonna_0-1651771209328.png

 

KellyHobson
Support
Support

Hey @jonna 

When you are in Task Designer-> Table Settings-> Transform

Do you see both columns in the input and output panes?

Thanks,

Kelly

jonna
Partner - Creator
Partner - Creator
Author

yes @KellyHobson  the pair of columns are in both input and output

Steve_Nguyen
Support
Support

@jonna

 

This could be that your csv file have more column or the delimiter is not correctly.

 

1. lets try to isolate the issue, could you create a small csv file with the two column and data (example 5 records) , using the delimiter that you define in your source endpoint.

 

2. then use the sample csv, does the task works ?

 

3. if the test sample csv works then it is your source CSV file that have more delimiter (causing more column) , therefore, error message.

 

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!