Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
jaragono
New Contributor II

Password error on server

Hi,

I have a file that works OK on the QV app, but not on the reload from the Management Console.

This file loads *.CSV files from a remote server which is available through a URL (\\10.156.61.12\gdlvi\) I used to work OK until a password change on the remote server. The QV server has a connection to the remote folder, so the file executes correctly on the QV app.

Where on the Management Console should I add the new password??

22/01/2015  5:58:35 PM: 0108  CALL Hechos

22/01/2015  5:58:35 PM: 0036    Estadistica:

22/01/2015  5:58:35 PM: 0037    LOAD

22/01/2015  5:58:35 PM: 0038         55 as Cod_Hotel,

22/01/2015  5:58:35 PM: 0039         NUMEROHABITACION,

22/01/2015  5:58:35 PM: 0040   

22/01/2015  5:58:35 PM: 0041        

22/01/2015  5:58:35 PM: 0042         MakeDate(mid(FECHAS,1,4),mid(FECHAS,5,2),mid(FECHAS,7,2)) as Fechas,

22/01/2015  5:58:35 PM: 0043         TOTALCUARTOS,

22/01/2015  5:58:35 PM: 0044         ADULTOS,

22/01/2015  5:58:35 PM: 0045         KIDS,

22/01/2015  5:58:35 PM: 0046         TIPODCUARTO,

22/01/2015  5:58:35 PM: 0047         NOMBREAGENCIA,

22/01/2015  5:58:35 PM: 0048         CIUDAD,

22/01/2015  5:58:35 PM: 0049   

22/01/2015  5:58:35 PM: 0050         SEGMENTODEMERCADO,

22/01/2015  5:58:35 PM: 0051         ESTADO,

22/01/2015  5:58:35 PM: 0052         PAIS

22/01/2015  5:58:35 PM: 0053    FROM

22/01/2015  5:58:35 PM: 0054    \\10.156.61.12\gdlvi\OCUPACION*.CSV

22/01/2015  5:58:35 PM: 0055    (txt, codepage is 1252, embedded labels, delimiter is '|', msq)

<<< Here is the incorrect password error:

22/01/2015  5:58:35 PM:         Error: Cannot open file '\\10.156.61.12\gdlvi\OCUPACION*.CSV' Error de inicio de sesión: nombre de usuario desconocido o contraseña incorrecta.

22/01/2015  5:58:35 PM:         General Script Error

22/01/2015  5:58:35 PM:         Execution Failed

22/01/2015  5:58:35 PM:      Execution finished.

Regards,

3 Replies
Partner
Partner

Re: Password error on server

Your service account does not have access to \\10.156.61.12\gdlvi\OCUPACION*.CSV'

It has nothing to do with QlikView platform.

Log on to your server and try to access \\10.156.61.12\gdlvi, it will give you an error.

Re: Password error on server

The servervwill access the file using the login account of the QlikView Distribution Service (QDS).

You need to give the service account permissions to read the file \\10.156.61.12\gdlvi\OCUPACION*.CSV'.


The problem is on the remote file location not on the QlikView server.

jaragono
New Contributor II

Re: Password error on server

Found the issue!

Thank you both.