Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004034Openbravo ERPZ. Otherspublic2008-06-18 08:332008-06-18 09:44
Reporterjpabloae 
Assigned Tocromero 
PriorityimmediateSeveritycriticalReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS30OS VersionGentoo - 2.6.24
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004034: Register_data.xsql fails con compile
Description     [java] 5917 [main] INFO org.openbravo.data.Sqlc - File: ../srcAD/org/openbravo/erpWindows/Register/Register_data.xsql processed
     [java] 5922 [main] ERROR org.openbravo.data.Sqlc - SQL error in query:
     [java] SELECT COALESCE(AD_Registration_Info.Isregistrationactive, 'N') AS Isregistrationactive,
     [java] AD_Registration_Info.Registration_ID,
     [java] AD_Registration_Info.Contactfirstname,
     [java] AD_Registration_Info.ContactLastName,
     [java] AD_Registration_Info.Contactjobtitle,
     [java] AD_Registration_Info.Contactphone,
     [java] AD_Registration_Info.Contactemail,
     [java] AD_Registration_Info.Companyname,
     [java] AD_Registration_Info.Companywebsite,
     [java] AD_Registration_Info.Companycountry,
     [java] (CASE WHEN AD_Registration_Info.Companycountry IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL1.Name IS NULL THEN TO_CHAR(table1.Name) ELSE TO_CHAR(tableTRL1.Name) END)), ''))),'') ) END) AS CompanycountryR,
     [java] AD_Registration_Info.Companyindustry,
     [java] (CASE WHEN AD_Registration_Info.Companyindustry IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list1.name),'') ) END) AS CompanyindustryR,
     [java] AD_Registration_Info.Companynum_Employees,
     [java] (CASE WHEN AD_Registration_Info.Companynum_Employees IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list2.name),'') ) END) AS Companynum_EmployeesR,
     [java] COALESCE(AD_Registration_Info.Wanttopartner, 'N') AS Wanttopartner,
     [java] COALESCE(AD_Registration_Info.Isevaluating, 'N') AS Isevaluating,
     [java] AD_Registration_Info.Comments,
     [java] COALESCE(AD_Registration_Info.Contactme, 'N') AS Contactme,
     [java] COALESCE(AD_Registration_Info.OB_Vision, 'N') AS OB_Vision,
     [java] COALESCE(AD_Registration_Info.OB_Development, 'N') AS OB_Development,
     [java] COALESCE(AD_Registration_Info.OB_Development_Announce, 'N') AS OB_Development_Announce,
     [java] COALESCE(AD_Registration_Info.OB_Commits, 'N') AS OB_Commits,
     [java] AD_Registration_Info.Registernow,
     [java] AD_Registration_Info.AD_Org_ID,
     [java] AD_Registration_Info.AD_Client_ID,
     [java] AD_Registration_Info.AD_Registration_Info_ID,
     [java] COALESCE(AD_Registration_Info.IsActive, 'N') AS IsActive,
     [java] AD_Registration_Info.Postpone_Date,
     [java]
     [java] '' AS TR_BGCOLOR, '' as total_count,
     [java] AD_Registration_Info.Created,
     [java] AD_Registration_Info.CreatedBy,
     [java] AD_Registration_Info.Updated,
     [java] AD_Registration_Info.UpdatedBy, ? AS LANGUAGE, '' AS AD_USER_CLIENT, '' AS AD_ORG_CLIENT
     [java] FROM AD_Registration_Info left join (select C_Country_ID, Name from C_Country) table1 on (AD_Registration_Info.Companycountry = table1.C_Country_ID) left join (select C_Country_ID,AD_Language, Name from C_Country_TRL) tableTRL1 on (table1.C_Country_ID = tableTRL1.C_Country_ID and tableTRL1.AD_Language = ?) left join ad_ref_list_v list1 on (AD_Registration_Info.Companyindustry = list1.value and list1.ad_reference_id = 1000300003 and list1.ad_language = ?) left join ad_ref_list_v list2 on (AD_Registration_Info.Companynum_Employees = list2.value and list2.ad_reference_id = 1000300001 and list2.ad_language = ?)
     [java] WHERE 2=2
     [java] AND 1=1
     [java] AND AD_Registration_Info.AD_Client_ID IN ('1')
     [java] AND AD_Registration_Info.AD_Org_ID IN ('1')
     [java]
     [java] ORDER BY 1, 1
     [java]
     [java] Exception:org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric
     [java] org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = numeric
Steps To ReproduceCheck out r5133 and run ant "install.source"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-18 08:33jpabloaeNew Issue
2008-06-18 08:33jpabloaeAssigned To => cromero
2008-06-18 08:33jpabloaesf_bug_id0 => 1996751
2008-06-18 09:37jpabloaeNote Added: 0007822
2008-06-18 09:44jpabloaeStatusnew => closed
2008-06-18 09:44jpabloaeNote Added: 0007825
2008-06-18 09:44jpabloaeDuplicate ID0 => 4036
2008-06-18 09:44jpabloaeResolutionopen => duplicate

Notes
(0007822)
jpabloae   
2008-06-18 09:37   
The changes made to the Register window / table don't work in PostgreSQL.
(0007825)
jpabloae   
2008-06-18 09:44   
Confusion with duplicates: 4036 as marked as dup of this, but then as marked as resolved by a svnbot commit. To make this easier, let's mark this one as duplicate.