Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
Found the issue!
Thank you both.