API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 24th, 2017
80
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 43.08 KB | None | 0 0
raw download clone embed print report
  1.  
  2. Buildfile: C:\REPOSITORIOS\TIRUNA\main\build.xml
  3.  
  4. set.code.rev:
  5.  
  6. code.rev:
  7.  
  8. init:
  9.  
  10. eclipse.compile:
  11.  
  12. build.jar:
  13.  
  14. build.jar:
  15.  
  16. build.jar:
  17.  
  18. init:
  19.  
  20. wadvalidation:
  21.  
  22. wad:
  23. [java] 0 [main] INFO org.openbravo.wad.WadConnection - Loading driver: org.postgresql.Driver
  24. [java] 475 [main] INFO org.openbravo.wad.WadConnection - Getting Connection: jdbc:postgresql://localhost:5432/tiruna,tad
  25. [java] 722 [main] INFO org.openbravo.wad.Wad - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  26. [java] 740 [main] INFO org.openbravo.wad.Wad - jsDateFormat: %d-%m-%Y
  27. [java] 750 [main] INFO org.openbravo.wad.Wad - sqlDateFormat: DD-MM-YYYY
  28. [java] 761 [main] INFO org.openbravo.wad.Wad - File connection: C:\REPOSITORIOS\TIRUNA\main\config
  29. [java] 779 [main] INFO org.openbravo.wad.Wad - window: Subfamily
  30. [java] 792 [main] INFO org.openbravo.wad.Wad - module: %
  31. [java] 803 [main] INFO org.openbravo.wad.Wad - directory destiny: C:\REPOSITORIOS\TIRUNA\main\srcAD/org/openbravo/erpWindows
  32. [java] 811 [main] INFO org.openbravo.wad.Wad - directory reference: C:\REPOSITORIOS\TIRUNA\main\srcAD/org/openbravo/erpCommon\reference
  33. [java] 819 [main] INFO org.openbravo.wad.Wad - directory web.xml: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  34. [java] 826 [main] INFO org.openbravo.wad.Wad - directory ActionButtons: C:\REPOSITORIOS\TIRUNA\main\srcAD/org/openbravo/erpCommon/ad_actionButton
  35. [java] 923 [main] INFO org.openbravo.wad.Wad - generate web.xml: true
  36. [java] 964 [main] INFO org.openbravo.wad.Wad - generate tabs: true
  37. [java] 975 [main] INFO org.openbravo.wad.Wad - File separator: \
  38. [java] 985 [main] INFO org.openbravo.wad.Wad - Attach path: C:/opt/openbravo/attachments
  39. [java] 993 [main] INFO org.openbravo.wad.Wad - Web path: @actual_url_context@/web
  40. [java] 1000 [main] INFO org.openbravo.wad.Wad - Quick mode: false
  41. [java] 1032 [main] INFO org.openbravo.wad.Wad - 2 tabs to compile.
  42. [java] 1048 [main] INFO org.openbravo.wad.Wad - Updating table identifiers
  43. [java] 5865 [main] INFO org.openbravo.wad.Wad - Re-generating audit trail infrastructure
  44. [java] 5875 [main] INFO org.openbravo.wad.Wad - Processig combo reloads for action buttons
  45. [java] 6220 [main] INFO org.openbravo.wad.Wad - Processing ActionButton_data.xml
  46. [java] 6352 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonXml
  47. [java] 7663 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonHtml
  48. [java] 9467 [main] INFO org.openbravo.wad.Wad - Processing ActionButton_Responser.xml
  49. [java] 9776 [main] INFO org.openbravo.wad.Wad - Processing ActionButton_ResponserJava.xml
  50. [java] 9908 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonXml Generics
  51. [java] 10179 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonHtml for generics
  52. [java] 10722 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonDefault_data.xsql
  53. [java] 10733 [main] INFO org.openbravo.wad.Wad - Processing web.xml
  54. [java] 11318 [main] INFO org.openbravo.wad.Wad - Processing Window: Subfamily - Tab: Subfamily - id: 8A98804F3142305E01314241EDF90068
  55. [java] 12426 [main] INFO org.openbravo.wad.Wad - Processing Window: Subfamily - Tab: Surcharge - id: 8A98804F3142305E0131424CBB3D00C1
  56.  
  57. postwad:
  58. [copy] Copying 95 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\src-loc\design
  59. [copy] Copying 95 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\src-loc\design
  60.  
  61. sqlc:
  62. [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  63. [java] 1873 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy
  64. [java] 1934 [main] INFO org.openbravo.data.Sqlc - directory source: .
  65. [java] 1941 [main] INFO org.openbravo.data.Sqlc - directory destiny: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  66. [java] 1947 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql
  67. [java] 1955 [main] INFO org.openbravo.data.Sqlc - file connection: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  68. [java] 1962 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false
  69. [java] 1969 [main] INFO org.openbravo.data.Sqlc - QueryExecutionStrategy: optimized
  70. [java] 1980 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver
  71. [java] 1993 [main] INFO org.openbravo.data.Sqlc - Driver loaded
  72. [java] 2117 [main] INFO org.openbravo.data.Sqlc - connect made
  73. [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  74. [java] 1622 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy
  75. [java] 1638 [main] INFO org.openbravo.data.Sqlc - directory source: C:\REPOSITORIOS\TIRUNA\main\modules
  76. [java] 1649 [main] INFO org.openbravo.data.Sqlc - directory destiny: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  77. [java] 1657 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql
  78. [java] 1664 [main] INFO org.openbravo.data.Sqlc - file connection: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  79. [java] 1670 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false
  80. [java] 1678 [main] INFO org.openbravo.data.Sqlc - QueryExecutionStrategy: traditional
  81. [java] 1687 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver
  82. [java] 1764 [main] INFO org.openbravo.data.Sqlc - Driver loaded
  83. [java] 1882 [main] INFO org.openbravo.data.Sqlc - connect made
  84.  
  85. buildAD:
  86. [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  87. [java] 1762 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy
  88. [java] 1776 [main] INFO org.openbravo.data.Sqlc - directory source: ../srcAD
  89. [java] 1784 [main] INFO org.openbravo.data.Sqlc - directory destiny: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  90. [java] 1791 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql
  91. [java] 1798 [main] INFO org.openbravo.data.Sqlc - file connection: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  92. [java] 1805 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false
  93. [java] 1812 [main] INFO org.openbravo.data.Sqlc - QueryExecutionStrategy: traditional
  94. [java] 1850 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver
  95. [java] 1859 [main] INFO org.openbravo.data.Sqlc - Driver loaded
  96. [java] 1970 [main] INFO org.openbravo.data.Sqlc - connect made
  97. [java] 2392 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpCommon\reference\ActionButton_data.xsql processed
  98. [java] 3491 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\es\conasa\extproduct\Subfamily\Subfamily8A98804F3142305E01314241EDF90068_data.xsql processed
  99. [java] 3603 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\es\conasa\extproduct\Subfamily\Surcharge8A98804F3142305E0131424CBB3D00C1_data.xsql processed
  100. [java] 3640 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(epr_surcharge.Created, ?) as created,
  101. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.CreatedBy) as CreatedByR,
  102. [java] to_char(epr_surcharge.Updated, ?) as updated,
  103. [java] to_char(epr_surcharge.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  104. [java] epr_surcharge.UpdatedBy,
  105. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.UpdatedBy) as UpdatedByR,
  106. [java] epr_surcharge.AD_Org_ID,
  107. [java] (CASE WHEN epr_surcharge.AD_Org_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Org_IDR,
  108. [java] COALESCE(epr_surcharge.Isactive, 'N') AS Isactive,
  109. [java] epr_surcharge.EPR_Subfamily_ID,
  110. [java] (CASE WHEN epr_surcharge.EPR_Subfamily_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table2.Fname), ''))),'') ) END) AS EPR_Subfamily_IDR,
  111. [java] epr_surcharge.Datefrom,
  112. [java] epr_surcharge.Dateto,
  113. [java] epr_surcharge.Junksurcharge,
  114. [java] epr_surcharge.Alloysurcharge,
  115. [java] epr_surcharge.EPR_Surcharge_ID,
  116. [java] epr_surcharge.AD_Client_ID,
  117. [java] ? AS LANGUAGE
  118. [java] FROM epr_surcharge left join (select AD_Org_ID, Name from AD_Org) table1 on (epr_surcharge.AD_Org_ID = table1.AD_Org_ID) left join (select EPR_Subfamily_ID, value, Fname from epr_subfamily) table2 on (epr_surcharge.EPR_Subfamily_ID = table2.EPR_Subfamily_ID)
  119. [java] WHERE 2=2
  120. [java] AND 1=1
  121. [java] AND epr_surcharge.EPR_Surcharge_ID = ?
  122. [java] AND epr_surcharge.AD_Client_ID IN (
  123. [java] '1')
  124. [java] AND epr_surcharge.AD_Org_ID IN (
  125. [java] '1')
  126. [java] org.postgresql.util.PSQLException: ERROR: no existe la columna «value»
  127. [java] Position: 1218
  128. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  129. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  130. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  131. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  132. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  133. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  134. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  135. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  136. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  137. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  138. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  139. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  140. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  141. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  142. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  143. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  144. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  145. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  146. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  147. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  148. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  149. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  150. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  151. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  152. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  153. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  154. [java] 3782 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT (table1.value || ' - ' || TO_CHAR(COALESCE(TO_CHAR(table1.Fname), ''))) AS NAME FROM epr_subfamily left join (select EPR_Subfamily_ID, value, Fname from epr_subfamily) table1 on (epr_subfamily.EPR_Subfamily_ID = table1.EPR_Subfamily_ID) WHERE epr_subfamily.EPR_Subfamily_ID = ?
  155. [java] org.postgresql.util.PSQLException: ERROR: no existe la columna «value»
  156. [java] Position: 151
  157. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  158. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  159. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  160. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  161. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  162. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  163. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  164. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  165. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  166. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  167. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  168. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  169. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  170. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  171. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  172. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  173. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  174. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  175. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  176. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  177. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  178. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  179. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  180. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  181. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  182. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  183. [java] 4022 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT (table1.value || ' - ' || TO_CHAR(COALESCE(TO_CHAR(table1.Fname), ''))) AS NAME FROM epr_subfamily left join (select EPR_Subfamily_ID, value, Fname from epr_subfamily) table1 on (epr_subfamily.EPR_Subfamily_ID = table1.EPR_Subfamily_ID) WHERE epr_subfamily.EPR_Subfamily_ID = ?
  184. [java] org.postgresql.util.PSQLException: ERROR: no existe la columna «value»
  185. [java] Position: 151
  186. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  187. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  188. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  189. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  190. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  191. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  192. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  193. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  194. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  195. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  196. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  197. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  198. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  199. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  200. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  201. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  202. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  203. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  204. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  205. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  206. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  207. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  208. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  209. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  210. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  211. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  212. [java] 4235 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\es\conasa\extproduct\Surcharge\Surcharge8A98804F3142305E013142442AEB007C_data.xsql processed
  213. [java] 4502 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(epr_surcharge.Created, ?) as created,
  214. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.CreatedBy) as CreatedByR,
  215. [java] to_char(epr_surcharge.Updated, ?) as updated,
  216. [java] to_char(epr_surcharge.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  217. [java] epr_surcharge.UpdatedBy,
  218. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.UpdatedBy) as UpdatedByR,
  219. [java] epr_surcharge.AD_Org_ID,
  220. [java] (CASE WHEN epr_surcharge.AD_Org_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Org_IDR,
  221. [java] COALESCE(epr_surcharge.Isactive, 'N') AS Isactive,
  222. [java] epr_surcharge.EPR_Subfamily_ID,
  223. [java] (CASE WHEN epr_surcharge.EPR_Subfamily_ID IS NULL THEN '' ELSE () END) AS EPR_Subfamily_IDR,
  224. [java] epr_surcharge.Datefrom,
  225. [java] epr_surcharge.Dateto,
  226. [java] epr_surcharge.Junksurcharge,
  227. [java] epr_surcharge.Alloysurcharge,
  228. [java] epr_surcharge.EPR_Surcharge_ID,
  229. [java] epr_surcharge.AD_Client_ID,
  230. [java] ? AS LANGUAGE
  231. [java] FROM epr_surcharge left join (select AD_Org_ID, Name from AD_Org) table1 on (epr_surcharge.AD_Org_ID = table1.AD_Org_ID) left join (select EPR_Subfamily_ID from EPR_Subfamily) table2 on (epr_surcharge.EPR_Subfamily_ID = table2.EPR_Subfamily_ID)
  232. [java] WHERE 2=2
  233. [java] AND 1=1
  234. [java] AND epr_surcharge.EPR_Surcharge_ID = ?
  235. [java] AND epr_surcharge.AD_Client_ID IN (
  236. [java] '1')
  237. [java] AND epr_surcharge.AD_Org_ID IN (
  238. [java] '1')
  239. [java] org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «)»
  240. [java] Position: 760
  241. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  242. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  243. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  244. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  245. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  246. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  247. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  248. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  249. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  250. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  251. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  252. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  253. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  254. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  255. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  256. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  257. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  258. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  259. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  260. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  261. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  262. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  263. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  264. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  265. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  266. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  267. [java] 6239 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\Product_data.xsql processed
  268. [java] 6260 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(M_Product.Created, ?) as created,
  269. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.CreatedBy) as CreatedByR,
  270. [java] to_char(M_Product.Updated, ?) as updated,
  271. [java] to_char(M_Product.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  272. [java] M_Product.UpdatedBy,
  273. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.UpdatedBy) as UpdatedByR,
  274. [java] M_Product.AD_Org_ID,
  275. [java] (CASE WHEN M_Product.AD_Org_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Org_IDR,
  276. [java] M_Product.Value,
  277. [java] M_Product.Name,
  278. [java] M_Product.C_UOM_ID,
  279. [java] (CASE WHEN M_Product.C_UOM_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL2.Name IS NULL THEN TO_CHAR(table2.Name) ELSE TO_CHAR(tableTRL2.Name) END)), ''))),'') ) END) AS C_UOM_IDR,
  280. [java] M_Product.M_Product_Category_ID,
  281. [java] (CASE WHEN M_Product.M_Product_Category_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table3.Name), ''))),'') ) END) AS M_Product_Category_IDR,
  282. [java] M_Product.C_TaxCategory_ID,
  283. [java] (CASE WHEN M_Product.C_TaxCategory_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL4.Name IS NULL THEN TO_CHAR(table4.Name) ELSE TO_CHAR(tableTRL4.Name) END)), ''))),'') ) END) AS C_TaxCategory_IDR,
  284. [java] COALESCE(M_Product.IsPurchased, 'N') AS IsPurchased,
  285. [java] COALESCE(M_Product.IsSold, 'N') AS IsSold,
  286. [java] M_Product.Description,
  287. [java] M_Product.ProductType,
  288. [java] (CASE WHEN M_Product.ProductType IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list1.name),'') ) END) AS ProductTypeR,
  289. [java] COALESCE(M_Product.IsStocked, 'N') AS IsStocked,
  290. [java] M_Product.Weight,
  291. [java] M_Product.Costtype,
  292. [java] (CASE WHEN M_Product.Costtype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list2.name),'') ) END) AS CosttypeR,
  293. [java] M_Product.Coststd,
  294. [java] M_Product.M_AttributeSet_ID,
  295. [java] (CASE WHEN M_Product.M_AttributeSet_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table5.Name), ''))),'') ) END) AS M_AttributeSet_IDR,
  296. [java] M_Product.Attrsetvaluetype,
  297. [java] (CASE WHEN M_Product.Attrsetvaluetype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list3.name),'') ) END) AS AttrsetvaluetypeR,
  298. [java] M_Product.M_AttributeSetInstance_ID,
  299. [java] (CASE WHEN M_Product.M_AttributeSetInstance_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table6.Description), ''))),'') ) END) AS M_AttributeSetInstance_IDR,
  300. [java] COALESCE(M_Product.IsActive, 'N') AS IsActive,
  301. [java] M_Product.UPC,
  302. [java] M_Product.SalesRep_ID,
  303. [java] M_Product.C_BPartner_ID,
  304. [java] M_Product.ImageURL,
  305. [java] M_Product.DescriptionURL,
  306. [java] M_Product.AD_Image_ID,
  307. [java] COALESCE(M_Product.Production, 'N') AS Production,
  308. [java] M_Product.MA_Processplan_ID,
  309. [java] (CASE WHEN M_Product.MA_Processplan_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table7.Name), ''))),'') ) END) AS MA_Processplan_IDR,
  310. [java] COALESCE(M_Product.IsSummary, 'N') AS IsSummary,
  311. [java] M_Product.M_Locator_ID,
  312. [java] M_Product.Volume,
  313. [java] M_Product.ShelfWidth,
  314. [java] M_Product.ShelfHeight,
  315. [java] M_Product.ShelfDepth,
  316. [java] M_Product.UnitsPerPallet,
  317. [java] COALESCE(M_Product.Discontinued, 'N') AS Discontinued,
  318. [java] M_Product.DiscontinuedBy,
  319. [java] COALESCE(M_Product.IsBOM, 'N') AS IsBOM,
  320. [java] COALESCE(M_Product.IsInvoicePrintDetails, 'N') AS IsInvoicePrintDetails,
  321. [java] COALESCE(M_Product.IsPickListPrintDetails, 'N') AS IsPickListPrintDetails,
  322. [java] COALESCE(M_Product.IsVerified, 'N') AS IsVerified,
  323. [java] M_Product.Processing,
  324. [java] M_Product.S_ExpenseType_ID,
  325. [java] M_Product.S_Resource_ID,
  326. [java] M_Product.EM_Epr_Family_ID,
  327. [java] (CASE WHEN M_Product.EM_Epr_Family_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table8.Fname), ''))),'') ) END) AS EM_Epr_Family_IDR,
  328. [java] M_Product.EM_Epr_Subfamily_ID,
  329. [java] (CASE WHEN M_Product.EM_Epr_Subfamily_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table9.Fname), ''))),'') ) END) AS EM_Epr_Subfamily_IDR,
  330. [java] M_Product.EM_Epr_Productimg,
  331. [java] COALESCE(M_Product.EM_Epr_Exccommcalc, 'N') AS EM_Epr_Exccommcalc,
  332. [java] M_Product.EM_Epr_Europedesc,
  333. [java] COALESCE(M_Product.EM_Epr_Budgeting, 'N') AS EM_Epr_Budgeting,
  334. [java] M_Product.EM_Epr_Asmedesc,
  335. [java] M_Product.EM_Epr_Addinfo,
  336. [java] M_Product.GuaranteeDays,
  337. [java] M_Product.VersionNo,
  338. [java] M_Product.Help,
  339. [java] M_Product.DocumentNote,
  340. [java] M_Product.Classification,
  341. [java] M_Product.SKU,
  342. [java] M_Product.Stock_Min,
  343. [java] M_Product.AD_Client_ID,
  344. [java] COALESCE(M_Product.Enforce_Attribute, 'N') AS Enforce_Attribute,
  345. [java] M_Product.Name2,
  346. [java] COALESCE(M_Product.Ispriceprinted, 'N') AS Ispriceprinted,
  347. [java] M_Product.M_FreightCategory_ID,
  348. [java] M_Product.M_Product_ID,
  349. [java] M_Product.DownloadURL,
  350. [java] ? AS LANGUAGE
  351. [java] FROM M_Product left join (select AD_Org_ID, Name from AD_Org) table1 on (M_Product.AD_Org_ID = table1.AD_Org_ID) left join (select C_UOM_ID, Name from C_UOM) table2 on (M_Product.C_UOM_ID = table2.C_UOM_ID) left join (select C_UOM_ID,AD_Language, Name from C_UOM_TRL) tableTRL2 on (table2.C_UOM_ID = tableTRL2.C_UOM_ID and tableTRL2.AD_Language = ?) left join (select M_Product_Category_ID, Name from M_Product_Category) table3 on (M_Product.M_Product_Category_ID = table3.M_Product_Category_ID) left join (select C_TaxCategory_ID, Name from C_TaxCategory) table4 on (M_Product.C_TaxCategory_ID = table4.C_TaxCategory_ID) left join (select C_TaxCategory_ID,AD_Language, Name from C_TaxCategory_TRL) tableTRL4 on (table4.C_TaxCategory_ID = tableTRL4.C_TaxCategory_ID and tableTRL4.AD_Language = ?) left join ad_ref_list_v list1 on (M_Product.ProductType = list1.value and list1.ad_reference_id = '270' and list1.ad_language = ?) left join ad_ref_list_v list2 on (M_Product.Costtype = list2.value and list2.ad_reference_id = '800025' and list2.ad_language = ?) left join (select M_AttributeSet_ID, Name from M_AttributeSet) table5 on (M_Product.M_AttributeSet_ID = table5.M_AttributeSet_ID) left join ad_ref_list_v list3 on (M_Product.Attrsetvaluetype = list3.value and list3.ad_reference_id = '5AD08D5DF85549E0BCC0DEBDE4C0D340' and list3.ad_language = ?) left join (select M_AttributeSetInstance_ID, Description from M_AttributeSetInstance) table6 on (M_Product.M_AttributeSetInstance_ID = table6.M_AttributeSetInstance_ID) left join (select MA_Processplan_ID, Name from MA_Processplan) table7 on (M_Product.MA_Processplan_ID = table7.MA_Processplan_ID) left join (select EPR_Family_ID, value, Fname from epr_family) table8 on (M_Product.EM_Epr_Family_ID = table8.EPR_Family_ID) left join (select EPR_Subfamily_ID, value, Fname from epr_subfamily) table9 on (M_Product.EM_Epr_Subfamily_ID = table9.EPR_Subfamily_ID)
  352. [java] WHERE 2=2
  353. [java] AND 1=1
  354. [java] AND M_Product.M_Product_ID = ?
  355. [java] AND M_Product.AD_Client_ID IN (
  356. [java] '1')
  357. [java] AND M_Product.AD_Org_ID IN (
  358. [java] '1')
  359. [java] org.postgresql.util.PSQLException: ERROR: no existe la columna «value»
  360. [java] Position: 6158
  361. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  362. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  363. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  364. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  365. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  366. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  367. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  368. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  369. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  370. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  371. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  372. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  373. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  374. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  375. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  376. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  377. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  378. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  379. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  380. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  381. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  382. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  383. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  384. [java] 6364 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(M_Product.Created, ?) as created,
  385. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.CreatedBy) as CreatedByR,
  386. [java] to_char(M_Product.Updated, ?) as updated,
  387. [java] to_char(M_Product.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  388. [java] M_Product.UpdatedBy,
  389. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.UpdatedBy) as UpdatedByR,
  390. [java] M_Product.AD_Org_ID,
  391. [java] (CASE WHEN M_Product.AD_Org_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table1.Name), ''))),'') ) END) AS AD_Org_IDR,
  392. [java] M_Product.Value,
  393. [java] M_Product.Name,
  394. [java] M_Product.C_UOM_ID,
  395. [java] (CASE WHEN M_Product.C_UOM_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL2.Name IS NULL THEN TO_CHAR(table2.Name) ELSE TO_CHAR(tableTRL2.Name) END)), ''))),'') ) END) AS C_UOM_IDR,
  396. [java] M_Product.M_Product_Category_ID,
  397. [java] (CASE WHEN M_Product.M_Product_Category_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table3.Name), ''))),'') ) END) AS M_Product_Category_IDR,
  398. [java] M_Product.C_TaxCategory_ID,
  399. [java] (CASE WHEN M_Product.C_TaxCategory_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR((CASE WHEN tableTRL4.Name IS NULL THEN TO_CHAR(table4.Name) ELSE TO_CHAR(tableTRL4.Name) END)), ''))),'') ) END) AS C_TaxCategory_IDR,
  400. [java] COALESCE(M_Product.IsPurchased, 'N') AS IsPurchased,
  401. [java] COALESCE(M_Product.IsSold, 'N') AS IsSold,
  402. [java] M_Product.Description,
  403. [java] M_Product.ProductType,
  404. [java] (CASE WHEN M_Product.ProductType IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list1.name),'') ) END) AS ProductTypeR,
  405. [java] COALESCE(M_Product.IsStocked, 'N') AS IsStocked,
  406. [java] M_Product.Weight,
  407. [java] M_Product.Costtype,
  408. [java] (CASE WHEN M_Product.Costtype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list2.name),'') ) END) AS CosttypeR,
  409. [java] M_Product.Coststd,
  410. [java] M_Product.M_AttributeSet_ID,
  411. [java] (CASE WHEN M_Product.M_AttributeSet_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table5.Name), ''))),'') ) END) AS M_AttributeSet_IDR,
  412. [java] M_Product.Attrsetvaluetype,
  413. [java] (CASE WHEN M_Product.Attrsetvaluetype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list3.name),'') ) END) AS AttrsetvaluetypeR,
  414. [java] M_Product.M_AttributeSetInstance_ID,
  415. [java] (CASE WHEN M_Product.M_AttributeSetInstance_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table6.Description), ''))),'') ) END) AS M_AttributeSetInstance_IDR,
  416. [java] COALESCE(M_Product.IsActive, 'N') AS IsActive,
  417. [java] M_Product.UPC,
  418. [java] M_Product.SalesRep_ID,
  419. [java] M_Product.C_BPartner_ID,
  420. [java] M_Product.ImageURL,
  421. [java] M_Product.DescriptionURL,
  422. [java] M_Product.AD_Image_ID,
  423. [java] COALESCE(M_Product.Production, 'N') AS Production,
  424. [java] M_Product.MA_Processplan_ID,
  425. [java] (CASE WHEN M_Product.MA_Processplan_ID IS NULL THEN '' ELSE (COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table7.Name), ''))),'') ) END) AS MA_Processplan_IDR,
  426. [java] COALESCE(M_Product.IsSummary, 'N') AS IsSummary,
  427. [java] M_Product.M_Locator_ID,
  428. [java] M_Product.Volume,
  429. [java] M_Product.ShelfWidth,
  430. [java] M_Product.ShelfHeight,
  431. [java] M_Product.ShelfDepth,
  432. [java] M_Product.UnitsPerPallet,
  433. [java] COALESCE(M_Product.Discontinued, 'N') AS Discontinued,
  434. [java] M_Product.DiscontinuedBy,
  435. [java] COALESCE(M_Product.IsBOM, 'N') AS IsBOM,
  436. [java] COALESCE(M_Product.IsInvoicePrintDetails, 'N') AS IsInvoicePrintDetails,
  437. [java] COALESCE(M_Product.IsPickListPrintDetails, 'N') AS IsPickListPrintDetails,
  438. [java] COALESCE(M_Product.IsVerified, 'N') AS IsVerified,
  439. [java] M_Product.Processing,
  440. [java] M_Product.S_ExpenseType_ID,
  441. [java] M_Product.S_Resource_ID,
  442. [java] M_Product.EM_Epr_Family_ID,
  443. [java] (CASE WHEN M_Product.EM_Epr_Family_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table8.Fname), ''))),'') ) END) AS EM_Epr_Family_IDR,
  444. [java] M_Product.EM_Epr_Subfamily_ID,
  445. [java] (CASE WHEN M_Product.EM_Epr_Subfamily_ID IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(TO_CHAR(COALESCE(TO_CHAR(table9.Fname), ''))),'') ) END) AS EM_Epr_Subfamily_IDR,
  446. [java] M_Product.EM_Epr_Productimg,
  447. [java] COALESCE(M_Product.EM_Epr_Exccommcalc, 'N') AS EM_Epr_Exccommcalc,
  448. [java] M_Product.EM_Epr_Europedesc,
  449. [java] COALESCE(M_Product.EM_Epr_Budgeting, 'N') AS EM_Epr_Budgeting,
  450. [java] M_Product.EM_Epr_Asmedesc,
  451. [java] M_Product.EM_Epr_Addinfo,
  452. [java] M_Product.GuaranteeDays,
  453. [java] M_Product.VersionNo,
  454. [java] M_Product.Help,
  455. [java] M_Product.DocumentNote,
  456. [java] M_Product.Classification,
  457. [java] M_Product.SKU,
  458. [java] M_Product.Stock_Min,
  459. [java] M_Product.AD_Client_ID,
  460. [java] COALESCE(M_Product.Enforce_Attribute, 'N') AS Enforce_Attribute,
  461. [java] M_Product.Name2,
  462. [java] COALESCE(M_Product.Ispriceprinted, 'N') AS Ispriceprinted,
  463. [java] M_Product.M_FreightCategory_ID,
  464. [java] M_Product.M_Product_ID,
  465. [java] M_Product.DownloadURL,
  466. [java] '' AS TR_BGCOLOR, '' as total_count,
  467. [java] ? AS LANGUAGE, '' AS AD_USER_CLIENT, '' AS AD_ORG_CLIENT
  468. [java] FROM M_Product left join (select AD_Org_ID, Name from AD_Org) table1 on (M_Product.AD_Org_ID = table1.AD_Org_ID) left join (select C_UOM_ID, Name from C_UOM) table2 on (M_Product.C_UOM_ID = table2.C_UOM_ID) left join (select C_UOM_ID,AD_Language, Name from C_UOM_TRL) tableTRL2 on (table2.C_UOM_ID = tableTRL2.C_UOM_ID and tableTRL2.AD_Language = ?) left join (select M_Product_Category_ID, Name from M_Product_Category) table3 on (M_Product.M_Product_Category_ID = table3.M_Product_Category_ID) left join (select C_TaxCategory_ID, Name from C_TaxCategory) table4 on (M_Product.C_TaxCategory_ID = table4.C_TaxCategory_ID) left join (select C_TaxCategory_ID,AD_Language, Name from C_TaxCategory_TRL) tableTRL4 on (table4.C_TaxCategory_ID = tableTRL4.C_TaxCategory_ID and tableTRL4.AD_Language = ?) left join ad_ref_list_v list1 on (M_Product.ProductType = list1.value and list1.ad_reference_id = '270' and list1.ad_language = ?) left join ad_ref_list_v list2 on (M_Product.Costtype = list2.value and list2.ad_reference_id = '800025' and list2.ad_language = ?) left join (select M_AttributeSet_ID, Name from M_AttributeSet) table5 on (M_Product.M_AttributeSet_ID = table5.M_AttributeSet_ID) left join ad_ref_list_v list3 on (M_Product.Attrsetvaluetype = list3.value and list3.ad_reference_id = '5AD08D5DF85549E0BCC0DEBDE4C0D340' and list3.ad_language = ?) left join (select M_AttributeSetInstance_ID, Description from M_AttributeSetInstance) table6 on (M_Product.M_AttributeSetInstance_ID = table6.M_AttributeSetInstance_ID) left join (select MA_Processplan_ID, Name from MA_Processplan) table7 on (M_Product.MA_Processplan_ID = table7.MA_Processplan_ID) left join (select EPR_Family_ID, value, Fname from epr_family) table8 on (M_Product.EM_Epr_Family_ID = table8.EPR_Family_ID) left join (select EPR_Subfamily_ID, value, Fname from epr_subfamily) table9 on (M_Product.EM_Epr_Subfamily_ID = table9.EPR_Subfamily_ID)
  469. [java] WHERE 2=2
  470. [java] AND 1=1
  471. [java] AND M_Product.AD_Client_ID IN (
  472. [java] '1')
  473. [java] AND M_Product.AD_Org_ID IN (
  474. [java] '1')
  475. [java] ORDER BY
  476. [java] 1, 1
  477. [java] org.postgresql.util.PSQLException: ERROR: no existe la columna «value»
  478. [java] Position: 6246
  479. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  480. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  481. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  482. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  483. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  484. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  485. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  486. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  487. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  488. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  489. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  490. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  491. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  492. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  493. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  494. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  495. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  496. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  497. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  498. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  499. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  500. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  501. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  502. [java] 7818 [main] ERROR org.openbravo.data.Sqlc - 6 errors found!
  503. [java] Java Result: 1
  504.  
  505. postsrc.modules:
  506. [copy] Copying 52 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\src-loc\design
  507. [copy] Copying 73 files to C:\REPOSITORIOS\TIRUNA\main\build\classes
  508.  
  509. postsrc:
  510.  
  511. build.local.context:
  512. [copy] Copying 1 file to C:\REPOSITORIOS\TIRUNA\main\WebContent\WEB-INF
  513. [copy] Copying 15 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\WEB-INF\lib
  514.  
  515. build.web.folder:
  516.  
  517. build.web.folder.skins:
  518. [delete] Deleting directory C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins
  519. [mkdir] Created dir: C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins
  520. [mkdir] Created dir: C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins\ltr
  521. [copy] Copying 598 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins\ltr
  522. [mkdir] Created dir: C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins\rtl
  523. [copy] Copying 598 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins\rtl
  524.  
  525. build.web.folder.base:
  526. [copy] Copying 2697 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\web
  527. [copy] Copying 72 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins\ltr
  528. [copy] Copying 72 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins\rtl
  529. [java] 0 [main] INFO org.openbravo.translate.Translate - RTL Skin directory source: C:\REPOSITORIOS\TIRUNA\main\WebContent/web/skins/rtl
  530. [java] 1935 [main] INFO org.openbravo.translate.Translate - LTR Skin directory source: C:\REPOSITORIOS\TIRUNA\main\WebContent/web/skins/ltr
  531. [java] 1944 [main] INFO org.openbravo.translate.Translate - Processing RTL skin Default
  532. [java] 1953 [main] INFO org.openbravo.translate.Translate - Processing RTL skin Default
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!