Problems to relaod from QVEMC

Fri, 15 Apr 2011 01:39:02 GMT

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?

Problems to relaod from QVEMC

Fri, 15 Apr 2011 02:14:22 GMT

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

Problems to relaod from QVEMC

erichshiino — Fri, 15 Apr 2011 04:26:13 GMT

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

Problems to relaod from QVEMC

Fri, 15 Apr 2011 04:30:21 GMT

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.

topic Problems to relaod from QVEMC in QlikView

Problems to relaod from QVEMC

Problems to relaod from QVEMC

Problems to relaod from QVEMC

Problems to relaod from QVEMC