ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '471029' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '471029' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '471029' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '471029' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '471029']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '471029'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 471029 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 471029]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 471029 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 471029

Título del libro: Proceedings Of The 2002 International Joint Power Generation Conference
Título del capítulo: Integrated diagnostic system for the equipment of power plants: Part I - Foundation and algorithms

Autores UNAM:
ALFONSO GARCIA GUTIERREZ;

---

Autores externos:

---

Idioma:
Inglés

---

Año de publicación:
2002

---

Palabras clave:

Algorithms; Deterioration; Electric power plant equipment; Expert systems; Identification (control systems); Vibrations (mechanical); Fault detection; Fault identification; Integrated diagnostic system; Combined cycle power plants

---

Resumen:

The output capacity of combined cycle power plants is reduced in many cases, and sometimes forced to outages, when its main components are affected by faults, i.e., when the rotating equipment such as turbines, generators, compressors, pumps, and fans suffer a failure. Normally, the overall reduction of the efficiency, and sometimes the component efficiencies, is monitored but it is difficult to identify the primary causes of the fault of the specific equipment that causes the reduction of plant efficiency. Therefore, to reduce the time of faulty operation, a precise diagnostic tool is needed. One such tool is an expert system approach, which is presented in this work. It consists of several expert systems for the identification of the faults caused by deterioration of the inner parts of the equipment, Fig. 1. Such faults not only reduce the plant efficiency but in many cases also increase the vibrations of the rotor- bearing system. Based on knowledge, the various expert systems have been constructed and their algorithms (efficiency reduction) developed for the following equipment: steam turbines, gas turbines and compressors, condenser, pumps and water cooling system. An expert system for detecting faults that increase the vibration of the rotor - bearing system is also presented. As far as the turbo compressor expert system is concerned the fault hybrid patterns previously developed were implemented and described elsewhere.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
0791836177
Editorial:

Tipo de producto:
Conference Paper