API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 24th, 2017
128
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 46.31 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. [WADValidation] 0 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - The following errors are violations to the Openbravo naming rules.
  22. [WADValidation] 36 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - They do not stop the build process but they should be fixed
  23. [WADValidation] 38 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - as soon as possible.
  24. [WADValidation] 39 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - +++++++++++++++++++++++++++++++++++++++++++++++++++
  25. [WADValidation] 42 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - Errors for Validation type: Missing Identifier
  26. [WADValidation] 43 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - +++++++++++++++++++++++++++++++++++++++++++++++++++
  27. [WADValidation] 45 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - Table epr_family has not identifier.
  28. [WADValidation] 46 [Thread-84] ERROR org.openbravo.wad.validation.WADValidationResult - Table epr_range has not identifier.
  29. [WADValidation] 47 [Thread-84] INFO org.openbravo.wad.validation.WADValidationResult - Module Extended Product does not comply with Openbravo naming rules.
  30. [WADValidation] 48 [Thread-84] INFO org.openbravo.wad.validation.WADValidationResult - The rebuild process has completed successfully but this module
  31. [WADValidation] 48 [Thread-84] INFO org.openbravo.wad.validation.WADValidationResult - might cause conflicts with other modules in the future.
  32. [WADValidation] 49 [Thread-84] INFO org.openbravo.wad.validation.WADValidationResult - Please request the author of this module to produce a new version
  33. [WADValidation] 50 [Thread-84] INFO org.openbravo.wad.validation.WADValidationResult - that addresses these violations.
  34.  
  35. wad:
  36. [java] 0 [main] INFO org.openbravo.wad.WadConnection - Loading driver: org.postgresql.Driver
  37. [java] 489 [main] INFO org.openbravo.wad.WadConnection - Getting Connection: jdbc:postgresql://localhost:5432/tiruna,tad
  38. [java] 697 [main] INFO org.openbravo.wad.Wad - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  39. [java] 718 [main] INFO org.openbravo.wad.Wad - jsDateFormat: %d-%m-%Y
  40. [java] 726 [main] INFO org.openbravo.wad.Wad - sqlDateFormat: DD-MM-YYYY
  41. [java] 733 [main] INFO org.openbravo.wad.Wad - File connection: C:\REPOSITORIOS\TIRUNA\main\config
  42. [java] 740 [main] INFO org.openbravo.wad.Wad - window: Product
  43. [java] 747 [main] INFO org.openbravo.wad.Wad - module: %
  44. [java] 757 [main] INFO org.openbravo.wad.Wad - directory destiny: C:\REPOSITORIOS\TIRUNA\main\srcAD/org/openbravo/erpWindows
  45. [java] 768 [main] INFO org.openbravo.wad.Wad - directory reference: C:\REPOSITORIOS\TIRUNA\main\srcAD/org/openbravo/erpCommon\reference
  46. [java] 787 [main] INFO org.openbravo.wad.Wad - directory web.xml: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  47. [java] 799 [main] INFO org.openbravo.wad.Wad - directory ActionButtons: C:\REPOSITORIOS\TIRUNA\main\srcAD/org/openbravo/erpCommon/ad_actionButton
  48. [java] 807 [main] INFO org.openbravo.wad.Wad - generate web.xml: true
  49. [java] 855 [main] INFO org.openbravo.wad.Wad - generate tabs: true
  50. [java] 863 [main] INFO org.openbravo.wad.Wad - File separator: \
  51. [java] 870 [main] INFO org.openbravo.wad.Wad - Attach path: C:/opt/openbravo/attachments
  52. [java] 878 [main] INFO org.openbravo.wad.Wad - Web path: @actual_url_context@/web
  53. [java] 885 [main] INFO org.openbravo.wad.Wad - Quick mode: false
  54. [java] 987 [main] INFO org.openbravo.wad.Wad - 13 tabs to compile.
  55. [java] 1008 [main] INFO org.openbravo.wad.Wad - Updating table identifiers
  56. [java] 5557 [main] INFO org.openbravo.wad.Wad - Re-generating audit trail infrastructure
  57. [java] 5567 [main] INFO org.openbravo.wad.Wad - Processig combo reloads for action buttons
  58. [java] 5897 [main] INFO org.openbravo.wad.Wad - Processing ActionButton_data.xml
  59. [java] 6002 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonXml
  60. [java] 7320 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonHtml
  61. [java] 9148 [main] INFO org.openbravo.wad.Wad - Processing ActionButton_Responser.xml
  62. [java] 9437 [main] INFO org.openbravo.wad.Wad - Processing ActionButton_ResponserJava.xml
  63. [java] 9624 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonXml Generics
  64. [java] 9942 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonHtml for generics
  65. [java] 10453 [main] INFO org.openbravo.wad.Wad - Processing ActionButtonDefault_data.xsql
  66. [java] 10465 [main] INFO org.openbravo.wad.Wad - Processing web.xml
  67. [java] 11180 [main] INFO org.openbravo.wad.Wad - Processing Window: Bill of Materials Production - Tab: BOM Production - id: 319
  68. [java] 12726 [main] INFO org.openbravo.wad.Wad - Processing Window: Bill of Materials Production - Tab: Production Plan - id: 320
  69. [java] 14193 [main] INFO org.openbravo.wad.Wad - Processing Window: Bill of Materials Production - Tab: I/O Products - id: 321
  70. [java] 15470 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Product - id: 180
  71. [java] 16892 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Price - id: 183
  72. [java] 17668 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Accounting - id: 210
  73. [java] 19187 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Costing - id: 800057
  74. [java] 20240 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Transactions - id: 289
  75. [java] 21388 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Org Specific - id: 800241
  76. [java] 22641 [main] INFO org.openbravo.wad.Wad - Processing Window: Product - Tab: Translation - id: 235
  77. [java] 23513 [main] INFO org.openbravo.wad.Wad - Processing Window: Product Category - Tab: Product Category - id: 189
  78. [java] 24223 [main] INFO org.openbravo.wad.Wad - Processing Window: Product Category - Tab: Accounting - id: 324
  79. [java] 25549 [main] INFO org.openbravo.wad.Wad - Processing Window: Product Category - Tab: Assigned Products - id: 407
  80.  
  81. postwad:
  82. [copy] Copying 128 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\src-loc\design
  83. [copy] Copying 128 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\src-loc\design
  84.  
  85. sqlc:
  86. [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  87. [java] 1489 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy
  88. [java] 1505 [main] INFO org.openbravo.data.Sqlc - directory source: .
  89. [java] 1513 [main] INFO org.openbravo.data.Sqlc - directory destiny: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  90. [java] 1520 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql
  91. [java] 1527 [main] INFO org.openbravo.data.Sqlc - file connection: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  92. [java] 1534 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false
  93. [java] 1542 [main] INFO org.openbravo.data.Sqlc - QueryExecutionStrategy: optimized
  94. [java] 1550 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver
  95. [java] 1559 [main] INFO org.openbravo.data.Sqlc - Driver loaded
  96. [java] 1681 [main] INFO org.openbravo.data.Sqlc - connect made
  97. [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  98. [java] 1730 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy
  99. [java] 1794 [main] INFO org.openbravo.data.Sqlc - directory source: C:\REPOSITORIOS\TIRUNA\main\modules
  100. [java] 1820 [main] INFO org.openbravo.data.Sqlc - directory destiny: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  101. [java] 1828 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql
  102. [java] 1837 [main] INFO org.openbravo.data.Sqlc - file connection: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  103. [java] 1850 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false
  104. [java] 1868 [main] INFO org.openbravo.data.Sqlc - QueryExecutionStrategy: traditional
  105. [java] 1886 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver
  106. [java] 1920 [main] INFO org.openbravo.data.Sqlc - Driver loaded
  107. [java] 2044 [main] INFO org.openbravo.data.Sqlc - connect made
  108.  
  109. buildAD:
  110. [java] 0 [main] INFO org.openbravo.data.Sqlc - strFileProperties: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  111. [java] 1760 [main] INFO org.openbravo.data.Sqlc - javaDateFormat: dd-MM-yyyy
  112. [java] 1773 [main] INFO org.openbravo.data.Sqlc - directory source: ../srcAD
  113. [java] 1780 [main] INFO org.openbravo.data.Sqlc - directory destiny: C:\REPOSITORIOS\TIRUNA\main\build\javasqlc/src
  114. [java] 1787 [main] INFO org.openbravo.data.Sqlc - file termination: .xsql
  115. [java] 1794 [main] INFO org.openbravo.data.Sqlc - file connection: C:\REPOSITORIOS\TIRUNA\main\config/Openbravo.properties
  116. [java] 1801 [main] INFO org.openbravo.data.Sqlc - Write TXT Files: false
  117. [java] 1808 [main] INFO org.openbravo.data.Sqlc - QueryExecutionStrategy: traditional
  118. [java] 1829 [main] INFO org.openbravo.data.Sqlc - Loading driver: org.postgresql.Driver
  119. [java] 1877 [main] INFO org.openbravo.data.Sqlc - Driver loaded
  120. [java] 1976 [main] INFO org.openbravo.data.Sqlc - connect made
  121. [java] 2416 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpCommon\reference\ActionButton_data.xsql processed
  122. [java] 3042 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\BillofMaterialsProduction\BOMProduction_data.xsql processed
  123. [java] 3184 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\BillofMaterialsProduction\IOProducts_data.xsql processed
  124. [java] 3386 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\BillofMaterialsProduction\ProductionPlan_data.xsql processed
  125. [java] 3968 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\es\conasa\extproduct\Subfamily\Surcharge8A98804F3142305E0131424CBB3D00C1_data.xsql processed
  126. [java] 4004 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(epr_surcharge.Created, ?) as created,
  127. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.CreatedBy) as CreatedByR,
  128. [java] to_char(epr_surcharge.Updated, ?) as updated,
  129. [java] to_char(epr_surcharge.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  130. [java] epr_surcharge.UpdatedBy,
  131. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.UpdatedBy) as UpdatedByR,
  132. [java] epr_surcharge.AD_Org_ID,
  133. [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,
  134. [java] COALESCE(epr_surcharge.Isactive, 'N') AS Isactive,
  135. [java] epr_surcharge.EPR_Subfamily_ID,
  136. [java] (CASE WHEN epr_surcharge.EPR_Subfamily_ID IS NULL THEN '' ELSE () END) AS EPR_Subfamily_IDR,
  137. [java] epr_surcharge.Datefrom,
  138. [java] epr_surcharge.Dateto,
  139. [java] epr_surcharge.Junksurcharge,
  140. [java] epr_surcharge.Alloysurcharge,
  141. [java] epr_surcharge.EPR_Surcharge_ID,
  142. [java] epr_surcharge.AD_Client_ID,
  143. [java] ? AS LANGUAGE
  144. [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)
  145. [java] WHERE 2=2
  146. [java] AND 1=1
  147. [java] AND epr_surcharge.EPR_Surcharge_ID = ?
  148. [java] AND epr_surcharge.AD_Client_ID IN (
  149. [java] '1')
  150. [java] AND epr_surcharge.AD_Org_ID IN (
  151. [java] '1')
  152. [java] org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «)»
  153. [java] Position: 760
  154. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  155. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  156. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  157. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  158. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  159. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  160. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  161. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  162. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  163. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  164. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  165. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  166. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  167. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  168. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  169. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  170. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  171. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  172. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  173. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  174. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  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.main(Sqlc.java:189)
  180. [java] 4041 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT () AS NAME FROM epr_subfamily left join (select EPR_Subfamily_ID from EPR_Subfamily) table1 on (epr_subfamily.EPR_Subfamily_ID = table1.EPR_Subfamily_ID) WHERE epr_subfamily.EPR_Subfamily_ID = ?
  181. [java] org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «)»
  182. [java] Position: 17
  183. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  184. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  185. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  186. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  187. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  188. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  189. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  190. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  191. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  192. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  193. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  194. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  195. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  196. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  197. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  198. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  199. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  200. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  201. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  202. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  203. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  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.main(Sqlc.java:189)
  209. [java] 4139 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT () AS NAME FROM epr_subfamily left join (select EPR_Subfamily_ID from EPR_Subfamily) table1 on (epr_subfamily.EPR_Subfamily_ID = table1.EPR_Subfamily_ID) WHERE epr_subfamily.EPR_Subfamily_ID = ?
  210. [java] org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «)»
  211. [java] Position: 17
  212. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  213. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  214. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  215. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  216. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  217. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  218. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  219. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  220. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  221. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  222. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  223. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  224. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  225. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  226. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  227. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  228. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  229. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  230. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  231. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  232. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  233. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  234. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  235. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  236. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  237. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  238. [java] 4391 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\es\conasa\extproduct\Surcharge\Surcharge8A98804F3142305E013142442AEB007C_data.xsql processed
  239. [java] 4432 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(epr_surcharge.Created, ?) as created,
  240. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.CreatedBy) as CreatedByR,
  241. [java] to_char(epr_surcharge.Updated, ?) as updated,
  242. [java] to_char(epr_surcharge.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  243. [java] epr_surcharge.UpdatedBy,
  244. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = epr_surcharge.UpdatedBy) as UpdatedByR,
  245. [java] epr_surcharge.AD_Org_ID,
  246. [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,
  247. [java] COALESCE(epr_surcharge.Isactive, 'N') AS Isactive,
  248. [java] epr_surcharge.EPR_Subfamily_ID,
  249. [java] (CASE WHEN epr_surcharge.EPR_Subfamily_ID IS NULL THEN '' ELSE () END) AS EPR_Subfamily_IDR,
  250. [java] epr_surcharge.Datefrom,
  251. [java] epr_surcharge.Dateto,
  252. [java] epr_surcharge.Junksurcharge,
  253. [java] epr_surcharge.Alloysurcharge,
  254. [java] epr_surcharge.EPR_Surcharge_ID,
  255. [java] epr_surcharge.AD_Client_ID,
  256. [java] ? AS LANGUAGE
  257. [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)
  258. [java] WHERE 2=2
  259. [java] AND 1=1
  260. [java] AND epr_surcharge.EPR_Surcharge_ID = ?
  261. [java] AND epr_surcharge.AD_Client_ID IN (
  262. [java] '1')
  263. [java] AND epr_surcharge.AD_Org_ID IN (
  264. [java] '1')
  265. [java] org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «)»
  266. [java] Position: 760
  267. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  268. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  269. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  270. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  271. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  272. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  273. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  274. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  275. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  276. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  277. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  278. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  279. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  280. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  281. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  282. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  283. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  284. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  285. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  286. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  287. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  288. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  289. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  290. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  291. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  292. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  293. [java] 5992 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\Accounting_data.xsql processed
  294. [java] 6049 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\Costing_data.xsql processed
  295. [java] 6159 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\OrgSpecific_data.xsql processed
  296. [java] 6223 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\Price_data.xsql processed
  297. [java] 6270 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\Product_data.xsql processed
  298. [java] 6322 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(M_Product.Created, ?) as created,
  299. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.CreatedBy) as CreatedByR,
  300. [java] to_char(M_Product.Updated, ?) as updated,
  301. [java] to_char(M_Product.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  302. [java] M_Product.UpdatedBy,
  303. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.UpdatedBy) as UpdatedByR,
  304. [java] M_Product.AD_Org_ID,
  305. [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,
  306. [java] M_Product.Value,
  307. [java] M_Product.Name,
  308. [java] M_Product.C_UOM_ID,
  309. [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,
  310. [java] M_Product.M_Product_Category_ID,
  311. [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,
  312. [java] M_Product.C_TaxCategory_ID,
  313. [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,
  314. [java] COALESCE(M_Product.IsPurchased, 'N') AS IsPurchased,
  315. [java] COALESCE(M_Product.IsSold, 'N') AS IsSold,
  316. [java] M_Product.Description,
  317. [java] M_Product.ProductType,
  318. [java] (CASE WHEN M_Product.ProductType IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list1.name),'') ) END) AS ProductTypeR,
  319. [java] COALESCE(M_Product.IsStocked, 'N') AS IsStocked,
  320. [java] M_Product.Weight,
  321. [java] M_Product.Costtype,
  322. [java] (CASE WHEN M_Product.Costtype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list2.name),'') ) END) AS CosttypeR,
  323. [java] M_Product.Coststd,
  324. [java] M_Product.M_AttributeSet_ID,
  325. [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,
  326. [java] M_Product.Attrsetvaluetype,
  327. [java] (CASE WHEN M_Product.Attrsetvaluetype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list3.name),'') ) END) AS AttrsetvaluetypeR,
  328. [java] M_Product.M_AttributeSetInstance_ID,
  329. [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,
  330. [java] COALESCE(M_Product.IsActive, 'N') AS IsActive,
  331. [java] M_Product.UPC,
  332. [java] M_Product.SalesRep_ID,
  333. [java] M_Product.C_BPartner_ID,
  334. [java] M_Product.ImageURL,
  335. [java] M_Product.DescriptionURL,
  336. [java] M_Product.AD_Image_ID,
  337. [java] COALESCE(M_Product.Production, 'N') AS Production,
  338. [java] M_Product.MA_Processplan_ID,
  339. [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,
  340. [java] COALESCE(M_Product.IsSummary, 'N') AS IsSummary,
  341. [java] M_Product.M_Locator_ID,
  342. [java] M_Product.Volume,
  343. [java] M_Product.ShelfWidth,
  344. [java] M_Product.ShelfHeight,
  345. [java] M_Product.ShelfDepth,
  346. [java] M_Product.UnitsPerPallet,
  347. [java] COALESCE(M_Product.Discontinued, 'N') AS Discontinued,
  348. [java] M_Product.DiscontinuedBy,
  349. [java] COALESCE(M_Product.IsBOM, 'N') AS IsBOM,
  350. [java] COALESCE(M_Product.IsInvoicePrintDetails, 'N') AS IsInvoicePrintDetails,
  351. [java] COALESCE(M_Product.IsPickListPrintDetails, 'N') AS IsPickListPrintDetails,
  352. [java] COALESCE(M_Product.IsVerified, 'N') AS IsVerified,
  353. [java] M_Product.Processing,
  354. [java] M_Product.S_ExpenseType_ID,
  355. [java] M_Product.S_Resource_ID,
  356. [java] M_Product.EM_Epr_Family_ID,
  357. [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,
  358. [java] M_Product.EM_Epr_Subfamily_ID,
  359. [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,
  360. [java] M_Product.EM_Epr_Productimg,
  361. [java] COALESCE(M_Product.EM_Epr_Exccommcalc, 'N') AS EM_Epr_Exccommcalc,
  362. [java] M_Product.EM_Epr_Europedesc,
  363. [java] COALESCE(M_Product.EM_Epr_Budgeting, 'N') AS EM_Epr_Budgeting,
  364. [java] M_Product.EM_Epr_Asmedesc,
  365. [java] M_Product.EM_Epr_Addinfo,
  366. [java] M_Product.GuaranteeDays,
  367. [java] M_Product.VersionNo,
  368. [java] M_Product.Help,
  369. [java] M_Product.DocumentNote,
  370. [java] M_Product.Classification,
  371. [java] M_Product.SKU,
  372. [java] M_Product.Stock_Min,
  373. [java] M_Product.AD_Client_ID,
  374. [java] COALESCE(M_Product.Enforce_Attribute, 'N') AS Enforce_Attribute,
  375. [java] M_Product.Name2,
  376. [java] COALESCE(M_Product.Ispriceprinted, 'N') AS Ispriceprinted,
  377. [java] M_Product.M_FreightCategory_ID,
  378. [java] M_Product.M_Product_ID,
  379. [java] M_Product.DownloadURL,
  380. [java] ? AS LANGUAGE
  381. [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)
  382. [java] WHERE 2=2
  383. [java] AND 1=1
  384. [java] AND M_Product.M_Product_ID = ?
  385. [java] AND M_Product.AD_Client_ID IN (
  386. [java] '1')
  387. [java] AND M_Product.AD_Org_ID IN (
  388. [java] '1')
  389. [java] org.postgresql.util.PSQLException: ERROR: no existe la columna «value»
  390. [java] Position: 6158
  391. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  392. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  393. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  394. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  395. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  396. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  397. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  398. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  399. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  400. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  401. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  402. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  403. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  404. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  405. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  406. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  407. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  408. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  409. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  410. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  411. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  412. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  413. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  414. [java] 6491 [main] ERROR org.openbravo.data.Sqlc - SQL error in query: SELECT to_char(M_Product.Created, ?) as created,
  415. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.CreatedBy) as CreatedByR,
  416. [java] to_char(M_Product.Updated, ?) as updated,
  417. [java] to_char(M_Product.Updated, 'YYYYMMDDHH24MISS') as Updated_Time_Stamp,
  418. [java] M_Product.UpdatedBy,
  419. [java] (SELECT NAME FROM AD_USER u WHERE AD_USER_ID = M_Product.UpdatedBy) as UpdatedByR,
  420. [java] M_Product.AD_Org_ID,
  421. [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,
  422. [java] M_Product.Value,
  423. [java] M_Product.Name,
  424. [java] M_Product.C_UOM_ID,
  425. [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,
  426. [java] M_Product.M_Product_Category_ID,
  427. [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,
  428. [java] M_Product.C_TaxCategory_ID,
  429. [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,
  430. [java] COALESCE(M_Product.IsPurchased, 'N') AS IsPurchased,
  431. [java] COALESCE(M_Product.IsSold, 'N') AS IsSold,
  432. [java] M_Product.Description,
  433. [java] M_Product.ProductType,
  434. [java] (CASE WHEN M_Product.ProductType IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list1.name),'') ) END) AS ProductTypeR,
  435. [java] COALESCE(M_Product.IsStocked, 'N') AS IsStocked,
  436. [java] M_Product.Weight,
  437. [java] M_Product.Costtype,
  438. [java] (CASE WHEN M_Product.Costtype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list2.name),'') ) END) AS CosttypeR,
  439. [java] M_Product.Coststd,
  440. [java] M_Product.M_AttributeSet_ID,
  441. [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,
  442. [java] M_Product.Attrsetvaluetype,
  443. [java] (CASE WHEN M_Product.Attrsetvaluetype IS NULL THEN '' ELSE ( COALESCE(TO_CHAR(list3.name),'') ) END) AS AttrsetvaluetypeR,
  444. [java] M_Product.M_AttributeSetInstance_ID,
  445. [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,
  446. [java] COALESCE(M_Product.IsActive, 'N') AS IsActive,
  447. [java] M_Product.UPC,
  448. [java] M_Product.SalesRep_ID,
  449. [java] M_Product.C_BPartner_ID,
  450. [java] M_Product.ImageURL,
  451. [java] M_Product.DescriptionURL,
  452. [java] M_Product.AD_Image_ID,
  453. [java] COALESCE(M_Product.Production, 'N') AS Production,
  454. [java] M_Product.MA_Processplan_ID,
  455. [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,
  456. [java] COALESCE(M_Product.IsSummary, 'N') AS IsSummary,
  457. [java] M_Product.M_Locator_ID,
  458. [java] M_Product.Volume,
  459. [java] M_Product.ShelfWidth,
  460. [java] M_Product.ShelfHeight,
  461. [java] M_Product.ShelfDepth,
  462. [java] M_Product.UnitsPerPallet,
  463. [java] COALESCE(M_Product.Discontinued, 'N') AS Discontinued,
  464. [java] M_Product.DiscontinuedBy,
  465. [java] COALESCE(M_Product.IsBOM, 'N') AS IsBOM,
  466. [java] COALESCE(M_Product.IsInvoicePrintDetails, 'N') AS IsInvoicePrintDetails,
  467. [java] COALESCE(M_Product.IsPickListPrintDetails, 'N') AS IsPickListPrintDetails,
  468. [java] COALESCE(M_Product.IsVerified, 'N') AS IsVerified,
  469. [java] M_Product.Processing,
  470. [java] M_Product.S_ExpenseType_ID,
  471. [java] M_Product.S_Resource_ID,
  472. [java] M_Product.EM_Epr_Family_ID,
  473. [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,
  474. [java] M_Product.EM_Epr_Subfamily_ID,
  475. [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,
  476. [java] M_Product.EM_Epr_Productimg,
  477. [java] COALESCE(M_Product.EM_Epr_Exccommcalc, 'N') AS EM_Epr_Exccommcalc,
  478. [java] M_Product.EM_Epr_Europedesc,
  479. [java] COALESCE(M_Product.EM_Epr_Budgeting, 'N') AS EM_Epr_Budgeting,
  480. [java] M_Product.EM_Epr_Asmedesc,
  481. [java] M_Product.EM_Epr_Addinfo,
  482. [java] M_Product.GuaranteeDays,
  483. [java] M_Product.VersionNo,
  484. [java] M_Product.Help,
  485. [java] M_Product.DocumentNote,
  486. [java] M_Product.Classification,
  487. [java] M_Product.SKU,
  488. [java] M_Product.Stock_Min,
  489. [java] M_Product.AD_Client_ID,
  490. [java] COALESCE(M_Product.Enforce_Attribute, 'N') AS Enforce_Attribute,
  491. [java] M_Product.Name2,
  492. [java] COALESCE(M_Product.Ispriceprinted, 'N') AS Ispriceprinted,
  493. [java] M_Product.M_FreightCategory_ID,
  494. [java] M_Product.M_Product_ID,
  495. [java] M_Product.DownloadURL,
  496. [java] '' AS TR_BGCOLOR, '' as total_count,
  497. [java] ? AS LANGUAGE, '' AS AD_USER_CLIENT, '' AS AD_ORG_CLIENT
  498. [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)
  499. [java] WHERE 2=2
  500. [java] AND 1=1
  501. [java] AND M_Product.AD_Client_ID IN (
  502. [java] '1')
  503. [java] AND M_Product.AD_Org_ID IN (
  504. [java] '1')
  505. [java] ORDER BY
  506. [java] 1, 1
  507. [java] org.postgresql.util.PSQLException: ERROR: no existe la columna «value»
  508. [java] Position: 6246
  509. [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
  510. [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
  511. [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
  512. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
  513. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
  514. [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
  515. [java] at org.openbravo.data.Sqlc.query(Sqlc.java:712)
  516. [java] at org.openbravo.data.Sqlc.endElement(Sqlc.java:532)
  517. [java] at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
  518. [java] at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
  519. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
  520. [java] at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
  521. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  522. [java] at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
  523. [java] at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
  524. [java] at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
  525. [java] at org.openbravo.data.Sqlc.parseSqlFile(Sqlc.java:339)
  526. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:264)
  527. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  528. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  529. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  530. [java] at org.openbravo.data.Sqlc.listDir(Sqlc.java:243)
  531. [java] at org.openbravo.data.Sqlc.main(Sqlc.java:189)
  532. [java] 6617 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\Transactions_data.xsql processed
  533. [java] 6731 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\Product\Translation_data.xsql processed
  534. [java] 6784 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\ProductCategory\Accounting_data.xsql processed
  535. [java] 6840 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\ProductCategory\AssignedProducts_data.xsql processed
  536. [java] 6883 [main] INFO org.openbravo.data.Sqlc - File: ..\srcAD\org\openbravo\erpWindows\ProductCategory\ProductCategory_data.xsql processed
  537. [java] 8026 [main] ERROR org.openbravo.data.Sqlc - 6 errors found!
  538. [java] Java Result: 1
  539.  
  540. postsrc.modules:
  541. [copy] Copying 52 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\src-loc\design
  542. [copy] Copying 73 files to C:\REPOSITORIOS\TIRUNA\main\build\classes
  543.  
  544. postsrc:
  545.  
  546. build.local.context:
  547. [copy] Copying 1 file to C:\REPOSITORIOS\TIRUNA\main\WebContent\WEB-INF
  548. [copy] Copying 15 files to C:\REPOSITORIOS\TIRUNA\main\WebContent\WEB-INF\lib
  549.  
  550. build.web.folder:
  551.  
  552. build.web.folder.skins:
  553. [delete] Deleting directory C:\REPOSITORIOS\TIRUNA\main\WebContent\web\skins
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!