QlikView App Dev

[#1]

Hi for all

I tried to reload from QVEMC and the log result is:

---

4/04/2011 7:32:03 PM: Execution started.
14/04/2011 7:32:03 PM: QlikView Version:9.00.7646.9
14/04/2011 7:32:03 PM: 0017 SET ThousandSep='.'
14/04/2011 7:32:03 PM: 0018 SET DecimalSep=','
14/04/2011 7:32:03 PM: 0019 SET MoneyThousandSep='.'
14/04/2011 7:32:03 PM: 0020 SET MoneyDecimalSep=','
14/04/2011 7:32:03 PM: 0021 SET MoneyFormat='$ #.##0,00;($ #.##0,00)'
14/04/2011 7:32:03 PM: 0022 SET TimeFormat='hh:mm:ss TT'
14/04/2011 7:32:03 PM: 0023 SET DateFormat='DD/MM/YYYY'
14/04/2011 7:32:03 PM: 0024 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT'
14/04/2011 7:32:03 PM: 0025 SET MonthNames='Ene;Feb;Mar;Abr;May;Jun;Jul;Ago;Sep;Oct;Nov;Dic'
14/04/2011 7:32:03 PM: 0026 SET DayNames='Lun;Mar;Mié;Jue;Vie;Sáb;Dom'
14/04/2011 7:32:03 PM: 0295 ODBC CONNECT*
14/04/2011 7:32:03 PM: 0301 ODBC CONNECT*
14/04/2011 7:32:03 PM: 0308 Negocio:
14/04/2011 7:32:03 PM: 0309 LOAD
14/04/2011 7:32:03 PM: 0310 pedisucu & '-' & pedinume as LlaveProyectoNegocio,
14/04/2011 7:32:03 PM: 0311 pedisucu & '-' & pedinume as LlaveProyectoNegocioTransaccion,
14/04/2011 7:32:03 PM: 0312 pedisucu & '-' & pedinume as LlaveProyectoNegocioCliente,
14/04/2011 7:32:03 PM: 0313 pedisucu as CodigoProyecto,
14/04/2011 7:32:03 PM: 0314 pedinume as CodigoNegocio,
14/04/2011 7:32:03 PM: 0315 pedivalo as ValorProyecto,
14/04/2011 7:32:03 PM: 0316 pediobse as ObservacionesProyecto,
14/04/2011 7:32:03 PM: 0317 pedibono as BonoNegocio,
14/04/2011 7:32:03 PM: 0318 peditipo as TipoProyecto,
14/04/2011 7:32:03 PM: 0319 pedidesc as DescuentoNegocio,
14/04/2011 7:32:03 PM: 0320 pediinic as CoutaInicialNegocio,
14/04/2011 7:32:03 PM: 0321 'PRODESIC' as Fuente,
14/04/2011 7:32:03 PM: 0322 If (pedidesi='1',If(pedicesi=0,'Desistidos'),
14/04/2011 7:32:03 PM: 0323 If(pediescr=0,if(num(pedifase)>=1,'Prometido','Separado'),'Escriturado')) as EstadoVentaActual
14/04/2011 7:32:03 PM: 0324 SQL SELECT pedisucu, pedinume,pediclie,pedifech,pedivalo,pediobse, pedidesi, pedidate,pedidesc,pedibono, pediarra, peditipo,pediescr,pedifase,pedidesc,pediinic,pedicesi
14/04/2011 7:32:03 PM: 0325 FROM pedidos
14/04/2011 7:32:03 PM: 0326 WHERE (pedisucu <> 'ARR' AND
14/04/2011 7:32:03 PM: 0327 pedisucu <> 'PC8' AND
14/04/2011 7:32:03 PM: 0328 pedisucu <> 'PCP' AND
14/04/2011 7:32:03 PM: 0329 pedisucu <> 'PLC' AND
14/04/2011 7:32:03 PM: 0330 pedisucu <> 'PP3' AND
14/04/2011 7:32:03 PM: 0331 pedisucu <> 'PP5' AND
14/04/2011 7:32:03 PM: 0332 pedisucu <> 'PPA' AND
14/04/2011 7:32:03 PM: 0333 pedisucu <> 'PPB' AND
14/04/2011 7:32:03 PM: 0334 pedisucu <> 'PD1' AND
14/04/2011 7:32:03 PM: 0335 pedisucu <> 'PZB')

14/04/2011 7:32:03 PM: Error: SQL Error:[Microsoft][ODBC Visual FoxPro Driver]Cannot open file \\192.168.0.4\prodesic\datos\dato.dbc.
14/04/2011 7:32:03 PM: SQL State:S1000
14/04/2011 7:32:03 PM: General Script Error
14/04/2011 7:32:03 PM: Execution Failed
14/04/2011 7:32:03 PM: Execution finished.

---

When i try load from QV Developer in the server machine works ok. May i assing some access to the Admin User Account?

[#2]

The Qlikview server are installed in a Widows Server 2008 r1 x64 Machine in the INVERSORA Domain, the Admin User is INVERSORA\ADMININVERSORA. The database is located in other server \\192.168.0.4 in the diferent Domain called ICSA.

I tried to configActive Directory add Directory Service add LDAP for the other Domain ICSA. but not work

[erichshiino]

When you load it manually using QV Developer on the server machine are you using the same user that runs the services?

[#4]

Yes Erich i installed the QV Developer in the Server Machine and run the script then works fine!1

The Server is QV9 SR 6x32 and Developer is QV9 SR7x32.