Miscellany

Server Error in '/' Application.
Error executing query:
select "to" from pertinence where id_entity =40
ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: Error executing query:
select "to" from pertinence where id_entity =40
ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Source Error:

Line 170:        APIClass api = new APIClass();
Line 171:
Line 172:        DataTable datosAttName = api.Query(5, "42,40^66", "103", sysAttName);
Line 173:        DataRow[] attName = datosAttName.Select();
Line 174:        if (attName.Length > 0)


Source File: e:\appex\CRM\beta\previewForms\dynamicForm.aspx.cs    Line: 172

Stack Trace:

[Exception: Error executing query:
select "to" from pertinence where id_entity =40

ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block]
   Humano2.Core.Db.pgsqlConnection.doSelect(String query) in E:\Tigabytes\Liberty\core\db\pgsql\pgsqlConnection.cs:69
   Humano2.Core.Db.absComplex.doSelect(String query) in E:\Tigabytes\Liberty\core\db\absComplex.cs:448
   Humano2.Core.Db.pgsqlComplex.GetPertinenceClassForAttribute(String attributeId) in E:\Tigabytes\Liberty\core\db\pgsql\pgsqlComplex.cs:942
   Humano2.Components.ViewTools.ViewTools.fillSortedListWithPertAttributes(SortedList list, String[] attributes, Int32 index) in E:\Tigabytes\Liberty\components\viewTools\ViewTools.cs:341
   Humano2.Components.ViewTools.ViewTools.getSQLVars(String[] drCols) in E:\Tigabytes\Liberty\components\viewTools\ViewTools.cs:310
   Humano2.Components.ViewTools.ViewTools.initSQLVars(String[] drCols) in E:\Tigabytes\Liberty\components\viewTools\ViewTools.cs:774
   Humano2.Components.ViewTools.ViewTools.ParseQuery(DataTable Params) in E:\Tigabytes\Liberty\components\viewTools\ViewTools.cs:809
   Humano2.Components.ViewTools.ViewTools.GetSQLDataTable(DataTable parametros, Boolean retry) in E:\Tigabytes\Liberty\components\viewTools\ViewTools.cs:383
   Humano2.Components.ViewTools.ViewTools.GetSQLDataTable(DataTable parametros) in E:\Tigabytes\Liberty\components\viewTools\ViewTools.cs:378
   X.API.APIClass.Query(Int32 classid, String atributteshowid, String atributteid, String valor) in E:\Tigabytes\Liberty\API\API.cs:173
   dynamicForm.DisplayAttName(String sysAttName) in e:\appex\CRM\beta\previewForms\dynamicForm.aspx.cs:172
   ASP.previewforms_55526_55658_aspx.__Render__control7(HtmlTextWriter __w, Control parameterContainer) in e:\appex\CRM\beta\previewForms\55526-55658.aspx:28
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +2068267
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.HtmlControls.HtmlForm.RenderChildren(HtmlTextWriter writer) +59
   System.Web.UI.HtmlControls.HtmlForm.Render(HtmlTextWriter output) +68
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.HtmlControls.HtmlForm.RenderControl(HtmlTextWriter writer) +37
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.HtmlControls.HtmlContainerControl.Render(HtmlTextWriter writer) +29
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +130
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +24
   System.Web.UI.Page.Render(HtmlTextWriter writer) +26
   System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1896


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210