3 Replies Latest reply: Apr 15, 2011 12:30 AM by Marcos Herrera RSS

    Problems to relaod from QVEMC

      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?