topic Re: strange behavior when run task in qmc in QlikView

strange behavior when run task in qmc

sunilkumarqv — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

End of the table Field not loading on the qmc task but same is working fine when run application on locally,we are just wondering this is a bug or any other issues , please let me know any of you are facing the similar issues.

Regards,

Sunil S

Re: strange behavior when run task in qmc

sunilkumarqv — Thu, 27 Sep 2018 08:50:48 GMT

please advice something here

Re: strange behavior when run task in qmc

Miguel_Angel_Baeyens — Thu, 27 Sep 2018 09:00:26 GMT

Locally you are using your own account, while Publisher is using the service account. If you have mapped drives or UNC paths, the service account might not have access to those, or not the proper rights (modify/write).

Anyway, posting only the relevant lines of the log that display the error could help: is it reading from a file, if so, XLS, QVD? Is it connecting to a database, if so, with which account?

Re: strange behavior when run task in qmc

sunilkumarqv — Thu, 27 Sep 2018 10:33:14 GMT

Hi Migule ,

thanks for you replay,

However there is no error in log it will load successfully ,only issue is column filed at the end is not loading in to the application

Example :

Load A,B,C from data;

all fields will load expect the column C , however we tried rename the column name and updated some dummy values in that columns not worked

Re: strange behavior when run task in qmc

Miguel_Angel_Baeyens — Thu, 27 Sep 2018 10:58:25 GMT

If it's not loading 1 single column, be aware that the SQL part is executed by the driver or connector, while the LOAD part is done by QlikView.

If the SQL statement, regardless how you capitalize it, returns the column "Field" but you are doing LOAD FIELD it will fail: field names are also case sensitive. Check if they may have quotes, dots, numbers that differ in the LOAD statement.

To troubleshoot, comment the LOAD part and see if the SQL runs just right.

Re: strange behavior when run task in qmc

sunilkumarqv — Fri, 28 Sep 2018 05:59:01 GMT

HI Miguel,

We are loading normal xlsx file

Re: strange behavior when run task in qmc

marcus_sommer — Fri, 28 Sep 2018 06:42:54 GMT

Do you mean the field is missing (checked in tableviewer ?) or that there are no fieldvalues?

What says the script-log about how many fields (and which one) are loaded?

Is any section access implemented?

Do you load the xlsx as flat-file or with a odbc-driver?

Are there any fieldnames repeated within the excel (a flat-file load will then add a counter to the fieldname)?

Is any kind of sheet-protection within the excel enabled?

- Marcus

Re: strange behavior when run task in qmc

sunilkumarqv — Fri, 28 Sep 2018 09:12:22 GMT

Hi Marcus ,

Please check below for your questions

Do you mean the field is missing (checked in tableviewer ?) or that there are no fieldvalues?

when we reload it in qlikview desktop all fields get reloaded with data. But when reloading it from QMC it failed showing that field is not present.

What says the script-log about how many fields (and which one) are loaded?

Each field except the last one is getting loaded. We checked removing 1-2 fields from Excel source but still giving error while fetching last field

Is any section access implemented?

Do you load the xlsx as flat-file or with a odbc-driver?

yes, we are loading xlsx as flat-file

Are there any fieldnames repeated within the excel (a flat-file load will then add a counter to the fieldname)?

no. no repeated fieldnames.

Is any kind of sheet-protection within the excel enabled?

Re: strange behavior when run task in qmc

marcus_sommer — Fri, 28 Sep 2018 10:40:43 GMT

Are you sure that it is really the same file which you are loading from desktop and from server. By using from variables for the filepaths they may vary in both environments. Similar things might happens by loading the file in different applications by using relative paths. Also if not unc-paths are used else mapped drives that they point to a different location.

A quite easy check could be done by adding some filefunctions to the load, for example: filepath(), filesize(), filetime() - is it really the same file?

- Marcus

Re: strange behavior when run task in qmc

sunilkumarqv — Mon, 01 Oct 2018 05:12:39 GMT

Hi marcus,

we are using absolute path , we are also tried changing with different file location didn't worked either

Re: strange behavior when run task in qmc

marcus_sommer — Mon, 01 Oct 2018 06:48:34 GMT

Just check if an extra storing of the file made any difference - see here to what is meant: Re: Call a function with parms in script. If this didn't help I would create a new load-statement with the file-wizard - if it doesn't work you may get any hint or even an error-message of what's going wrong.

Should this not be successful I suggest to repeat all above mentioned checkings again because there was something overlooked.

- Marcus

Re: strange behavior when run task in qmc

sunilkumarqv — Wed, 03 Oct 2018 10:54:08 GMT

currently we are able fix the issue after recreating data with new file