strange behavior when run task in qmc

[sunilkumarqv]

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

[sunilkumarqv]

please advice something here

[Miguel_Angel_Baeyens]

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?

[sunilkumarqv]

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

[Miguel_Angel_Baeyens]

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.

[sunilkumarqv]

HI Miguel,

We are loading normal xlsx file

[marcus_sommer]

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

[sunilkumarqv]

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?

No

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?

no

[marcus_sommer]

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

[sunilkumarqv]

Hi marcus,

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