Solved: Re: Error -128 = - Qlik Community

carlospulgarinz · ‎2019-03-28

Good day, I have a problem, I have some applications that were loading normally, but an error began to appear that does not allow me to load the information.

This is the image

This is the log

2019-03-28 20:32:17      Execution started.
2019-03-28 20:32:17      Qlik Sense Server Version     12.287.2
2019-03-28 20:32:17      CPU Target                    x64
2019-03-28 20:32:17      Operating System              Windows 7 Professional Service Pack 1 (64 bit edition)
2019-03-28 20:32:17      Wow64 mode                    Not using Wow64
2019-03-28 20:32:17      Language                      240a español Spanish
2019-03-28 20:32:17      Country                       COL Colombia Colombia
2019-03-28 20:32:17      MDAC Version                  6.1.7601.17514
2019-03-28 20:32:17      MDAC Full Install Version     6.1.7601.17514
2019-03-28 20:32:17      PreferredCompression          2
2019-03-28 20:32:17      EnableParallelReload          1
2019-03-28 20:32:17      ParallelizeQvdLoads           1
2019-03-28 20:32:17      AutoSaveAfterReload           0
2019-03-28 20:32:17      BackupBeforeReload            0
2019-03-28 20:32:17      EnableFlushLog                0
2019-03-28 20:32:17      UserLogfileCharset            65001
2019-03-28 20:32:17      OdbcLoginTimeout              -1
2019-03-28 20:32:17      OdbcConnectionTimeout         -1
2019-03-28 20:32:17      LongestPossibleLine           1048576
2019-03-28 20:32:17      MaxCoreMask                   -1
2019-03-28 20:32:17      WebFileTimeout                0
2019-03-28 20:32:17      WebFileUserAgent              Mozilla/5.0
2019-03-28 20:32:17      DontUseInternetCache          1
2019-03-28 20:32:17      ScriptWantsDbWrite            false
2019-03-28 20:32:17      ScriptWantsExe                false
2019-03-28 20:32:17      ICU_FOR_CHARACTER_CLASSIFICATION true
2019-03-28 20:32:17      ICU_FOR_CODE_PAGES            true
2019-03-28 20:32:17      ICU_FOR_COLLATION             true
2019-03-28 20:32:17      ICU_FOR_LOCALE_INFO           true
2019-03-28 20:32:17      ICU_FOR_SUPPORT_INFO          true
2019-03-28 20:32:17      ICU_FOR_TIME_ZONE_INFO        true
2019-03-28 20:32:17      LogFile CodePage Used:        65001
2019-03-28 20:32:17      UseMemoryFillPattern          1
2019-03-28 20:32:17      ScriptMode                    Standard (limits system access)
2019-03-28 20:32:17      SequentialThreadCount         14
2019-03-28 20:32:17      NumberOfCores (effective)     4
2019-03-28 20:32:17      ReloadCodebase                Bnf
2019-03-28 20:32:17      Reload Executed By            Personal\Me
2019-03-28 20:32:17      Process Executing             Qlik Sense Server
2019-03-28 20:32:17      Process ID                    6940
2019-03-28 20:32:17      Grpc version                  5.0.0
2019-03-28 20:32:17      Protobuf version              3.4.0
2019-03-28 20:32:17 0004 Base_gestion:
2019-03-28 20:32:17 0005 
2019-03-28 20:32:17 0006             LOAD
2019-03-28 20:32:17 0007                 serie,
2019-03-28 20:32:17 0008                 serie as serie_base,
2019-03-28 20:32:17 0009                 serie as serie_campaña_adicional,
2019-03-28 20:32:17 0010                 if(ano_modelo <= '2013','2013',ano_modelo) as ano_modelo,
2019-03-28 20:32:17 0011                 des_modelo,
2019-03-28 20:32:17 0012                 des_modelo as des_modelo_base,
2019-03-28 20:32:17 0013                 des_marca_comprador as marca,
2019-03-28 20:32:17 0014                 placa,
2019-03-28 20:32:17 0015                 cantidad_entradas,
2019-03-28 20:32:17 0016                 if(isnull(cantidad_entradas),'Sin Entrada Mmto','Entrada Mmto') as Ingreso_mmto,
2019-03-28 20:32:17 0017                 fecha_ultima_entrada,
2019-03-28 20:32:17 0018                 if(isnull(fecha_ultima_entrada),'Ninguna',year(fecha_ultima_entrada)) as año_ultima_entrada,
2019-03-28 20:32:17 0019                 bodega_ultima_entrada,
2019-03-28 20:32:17 0020                 dias_ingreso_promedio,
2019-03-28 20:32:17 0021                 nit_comprador,
2019-03-28 20:32:17 0022                 nit_cliente,
2019-03-28 20:32:17 0023                 trim(nit_cliente) as cedula,
2019-03-28 20:32:17 0024                 nombre,
2019-03-28 20:32:17 0025                 ciudad_saasco,
2019-03-28 20:32:17 0026                 mail_saasco,
2019-03-28 20:32:17 0027                 celular_saasco,
2019-03-28 20:32:17 0028                 telefonos_saasco,
2019-03-28 20:32:17 0029                 telefono_1_dms,
2019-03-28 20:32:17 0030                 telefono_2_dms,
2019-03-28 20:32:17 0031                 celular_dms,
2019-03-28 20:32:17 0032                 celular2_dms,
2019-03-28 20:32:17 0033                 mail_dms,
2019-03-28 20:32:17 0034                 ciudad_ter_dms,
2019-03-28 20:32:17 0035                 autEmail,
2019-03-28 20:32:17 0036                 autSMS,
2019-03-28 20:32:17 0037                 autCelular,
2019-03-28 20:32:17 0038                 autFijo,
2019-03-28 20:32:17 0039                 estadoCRM,
2019-03-28 20:32:17 0040                 estadoCRM as estado_cliente,
2019-03-28 20:32:17 0041                 fecha_ultima_gestion,
2019-03-28 20:32:17 0042                 estado_ultima_gestion,
2019-03-28 20:32:17 0043                 if(isnull(tipificacion_ultima_gestion),'Sin Gestion',tipificacion_ultima_gestion) as tipificacion_ultima_gestion,
2019-03-28 20:32:17 0044                 Fecha_proximo_ingreso,
2019-03-28 20:32:17 0045                 Mes_proximo_ingreso,
2019-03-28 20:32:17 0046                 Estado_dias,
2019-03-28 20:32:17 0047                 Estado_gestion, 
2019-03-28 20:32:17 0048                 Estado_gestion_positiva 
2019-03-28 20:32:17 0049             FROM [lib://PC/qvd\BaseGestion\Base gestion.qvd]
2019-03-28 20:32:17 0050             (qvd)
2019-03-28 20:32:18      	42 fields found: serie, serie_base, serie_campaña_adicional, ano_modelo, des_modelo, des_modelo_base, marca, placa, cantidad_entradas, Ingreso_mmto, fecha_ultima_entrada, año_ultima_entrada, bodega_ultima_entrada, dias_ingreso_promedio, nit_comprador, nit_cliente, cedula, nombre, ciudad_saasco, mail_saasco, celular_saasco, telefonos_saasco, telefono_1_dms, telefono_2_dms, celular_dms, celular2_dms, mail_dms, ciudad_ter_dms, autEmail, autSMS, autCelular, autFijo, estadoCRM, estado_cliente, fecha_ultima_gestion, estado_ultima_gestion, tipificacion_ultima_gestion, Fecha_proximo_ingreso, Mes_proximo_ingreso, Estado_dias, Estado_gestion, Estado_gestion_positiva, 
2019-03-28 20:32:18      24.504 lines fetched
2019-03-28 20:32:18 0054 gestion_positiva:
2019-03-28 20:32:18 0055 
2019-03-28 20:32:18 0056           LOAD
2019-03-28 20:32:18 0057               trim(CEDULA) as cedula,
2019-03-28 20:32:18 0058               date(FECHA) as fecha_ultima_gestion_positiva,
2019-03-28 20:32:18 0059               'si' as con_ult_positiva,
2019-03-28 20:32:18 0060               Estado as estado_ultima_gestion_positiva,
2019-03-28 20:32:18 0061               Nueva as resultado_ultima_gestion_positiva
2019-03-28 20:32:18 0062 
2019-03-28 20:32:18 0063           FROM [lib://PC/qvd\BaseGestion\Base ultima gestion positiva.qvd]
2019-03-28 20:32:18 0064           (qvd) where valido ='si'
2019-03-28 20:32:18      	5 fields found: cedula, fecha_ultima_gestion_positiva, con_ult_positiva, estado_ultima_gestion_positiva, resultado_ultima_gestion_positiva, 
2019-03-28 20:32:18      22.700 lines fetched
2019-03-28 20:32:18 0069 Fecha_Venta:
2019-03-28 20:32:18 0070 
2019-03-28 20:32:18 0071           LOAD Distinct
2019-03-28 20:32:18 0072 			  fec as fecha_venta,
2019-03-28 20:32:18 0073               year(fec) as año_venta,
2019-03-28 20:32:18 0074               monthname(fec) as mes_venta,
2019-03-28 20:32:18 0075               serie,
2019-03-28 20:32:18 0076               serie as serie_venta,
2019-03-28 20:32:18 0077               bodega as bodega_venta
2019-03-28 20:32:18 0078 
2019-03-28 20:32:18 0079           FROM [lib://PC/qvd\Ventas_sql_*.qvd]
2019-03-28 20:32:18 0080           (qvd) where cantidad = '1'
2019-03-28 20:32:18      	6 fields found: fecha_venta, año_venta, mes_venta, serie, serie_venta, bodega_venta, 
2019-03-28 20:32:18      9.545 lines fetched
2019-03-28 20:32:18 0069 Fecha_Venta:
2019-03-28 20:32:18 0070 
2019-03-28 20:32:18 0071           LOAD Distinct
2019-03-28 20:32:18 0072 			  fec as fecha_venta,
2019-03-28 20:32:18 0073               year(fec) as año_venta,
2019-03-28 20:32:18 0074               monthname(fec) as mes_venta,
2019-03-28 20:32:18 0075               serie,
2019-03-28 20:32:18 0076               serie as serie_venta,
2019-03-28 20:32:18 0077               bodega as bodega_venta
2019-03-28 20:32:18 0078 
2019-03-28 20:32:18 0079           FROM [lib://PC/qvd\Ventas_sql_*.qvd]
2019-03-28 20:32:18 0080           (qvd) where cantidad = '1'
2019-03-28 20:32:18      	6 fields found: fecha_venta, año_venta, mes_venta, serie, serie_venta, bodega_venta, 
2019-03-28 20:32:18      11.956 lines fetched
2019-03-28 20:32:18 0084 Bodegas:
2019-03-28 20:32:18 0085 
2019-03-28 20:32:18 0086           LOAD
2019-03-28 20:32:18 0087               Bodega as bodega_ultima_entrada,
2019-03-28 20:32:18 0088               Bodega as bodega_gestiones,
2019-03-28 20:32:18 0089               Marca,
2019-03-28 20:32:18 0090               Sede,
2019-03-28 20:32:18 0091               Influencia,
2019-03-28 20:32:18 0092               Concesionario
2019-03-28 20:32:18 0093           FROM [lib://PC/Bodegas.xlsx]
2019-03-28 20:32:18 0094           (ooxml, embedded labels, table is Hoja1)
2019-03-28 20:32:18      	6 fields found: bodega_ultima_entrada, bodega_gestiones, Marca, Sede, Influencia, Concesionario, 
2019-03-28 20:32:18      65 lines fetched
2019-03-28 20:32:18 0099 Estado_cliente:
2019-03-28 20:32:18 0100 
2019-03-28 20:32:18 0101 
2019-03-28 20:32:18 0102           LOAD
2019-03-28 20:32:18 0103               Nueva as tipificacion_ultima_gestion,
2019-03-28 20:32:18 0104               Omitir
2019-03-28 20:32:18 0105           FROM [lib://PC/Tipificaciones.xlsx]
2019-03-28 20:32:18 0106           (ooxml, embedded labels, table is Hoja1)
2019-03-28 20:32:18      	2 fields found: tipificacion_ultima_gestion, Omitir, 
2019-03-28 20:32:18      3.575 lines fetched
2019-03-28 20:32:18 0112 Ordenes:
2019-03-28 20:32:18 0113 
2019-03-28 20:32:18 0114             LOAD
2019-03-28 20:32:18 0115                 year(entrada) as año_entrada,
2019-03-28 20:32:18 0116                 monthname(entrada) as mes_entrada,
2019-03-28 20:32:18 0117                 numero_orden,
2019-03-28 20:32:18 0118                 clase_trabajo,
2019-03-28 20:32:18 0119                 serie,
2019-03-28 20:32:18 0120                 bodega,
2019-03-28 20:32:18 0121                 serie as serie_orden
2019-03-28 20:32:18 0122             FROM [lib://PC/qvd\entradas_facturadas_sql*.qvd]
2019-03-28 20:32:18 0123             (qvd)
2019-03-28 20:32:19      	7 fields found: año_entrada, mes_entrada, numero_orden, clase_trabajo, serie, bodega, serie_orden, 
2019-03-28 20:32:19      527.960 lines fetched
2019-03-28 20:32:19 0112 Ordenes:
2019-03-28 20:32:19 0113 
2019-03-28 20:32:19 0114             LOAD
2019-03-28 20:32:19 0115                 year(entrada) as año_entrada,
2019-03-28 20:32:19 0116                 monthname(entrada) as mes_entrada,
2019-03-28 20:32:19 0117                 numero_orden,
2019-03-28 20:32:19 0118                 clase_trabajo,
2019-03-28 20:32:19 0119                 serie,
2019-03-28 20:32:19 0120                 bodega,
2019-03-28 20:32:19 0121                 serie as serie_orden
2019-03-28 20:32:19 0122             FROM [lib://PC/qvd\entradas_facturadas_sql*.qvd]
2019-03-28 20:32:19 0123             (qvd)
2019-03-28 20:32:19      	7 fields found: año_entrada, mes_entrada, numero_orden, clase_trabajo, serie, bodega, serie_orden, 
2019-03-28 20:32:19      -128 = 
2019-03-28 20:32:19      Execution Failed
2019-03-28 20:32:19      Execution finished.

carlospulgarinz · ‎2019-03-29

Good morning, yesterday I left you because I ended up giving up, and today magically works perfectly

View solution in original post

vishsaggi · ‎2019-03-28

I can see you were loading same tables twice any reason behind this. Can you just delete your send Ordenes table. Highlighted below:

Ordenes:
2019-03-28 20:32:18 0113
2019-03-28 20:32:18 0114 LOAD
2019-03-28 20:32:18 0115 year(entrada) as año_entrada,
2019-03-28 20:32:18 0116 monthname(entrada) as mes_entrada,
2019-03-28 20:32:18 0117 numero_orden,
2019-03-28 20:32:18 0118 clase_trabajo,
2019-03-28 20:32:18 0119 serie,
2019-03-28 20:32:18 0120 bodega,
2019-03-28 20:32:18 0121 serie as serie_orden
2019-03-28 20:32:18 0122 FROM [lib://PC/qvd\entradas_facturadas_sql*.qvd]
2019-03-28 20:32:18 0123 (qvd)
2019-03-28 20:32:19 7 fields found: año_entrada, mes_entrada, numero_orden, clase_trabajo, serie, bodega, serie_orden,
2019-03-28 20:32:19 527.960 lines fetched
2019-03-28 20:32:19 0112 Ordenes:
2019-03-28 20:32:19 0113
2019-03-28 20:32:19 0114 LOAD
2019-03-28 20:32:19 0115 year(entrada) as año_entrada,
2019-03-28 20:32:19 0116 monthname(entrada) as mes_entrada,
2019-03-28 20:32:19 0117 numero_orden,
2019-03-28 20:32:19 0118 clase_trabajo,
2019-03-28 20:32:19 0119 serie,
2019-03-28 20:32:19 0120 bodega,
2019-03-28 20:32:19 0121 serie as serie_orden
2019-03-28 20:32:19 0122 FROM [lib://PC/qvd\entradas_facturadas_sql*.qvd]
2019-03-28 20:32:19 0123 (qvd)

pradosh_thakur · ‎2019-03-29

Not sure why this error comes, I had faced a similar issue " -129 = error" and restarting the QlikSense server solved it. It might sound like " can you please switch it off and switch it on " 😄 But it worked for me .

Let me know

-Pradosh

Learning never stops.

carlospulgarinz · ‎2019-03-29

Good morning, yesterday I left you because I ended up giving up, and today magically works perfectly