Error:Positive only

[PShepetko]

Dear Comunity,
I installed iDempiere and started for Mac from 32bits because 64bits don't started web service.
32bits started good but in the desktop I have error: Positive only , when I want opening same window.
See my environment and screenshort in attachment.
Maybe Java version isn't suitable for work.

Tnanks,
Peter Shepetko
-------------------------------------------------

Version:1.0.0.v20120904-2022 Database Version : 900_IDEMPIERE-373_User_Locking.sql JVM:Java HotSpot(TM) 64-Bit Server VM 20.8-b03-424 OS : Mac OS X 10.6.8

[Carlos Antonio Ruiz Gomez]

Hi Peter, any clue on the console, or on the error log? (clicking on iDempiere logo)

Regards,

Carlos Ruiz

[Peter Shepetko]

Hi Carlos,
Thanks for your reply.
I looked log and check it.I nave column xposition in AD_Column (see screen).
If I runed idempiere-server instance from Windows XP with connect to same db- all good work(isn't this error).
What do you think about it?
====================================================
13:07:46.526===========> DB.getSQLValue: SELECT MAX(f.XPosition+f.ColumnSpan-case when f.isfieldonly='Y' OR c.ad_reference_id in (20/*yesno*/,28/*button*/) then 1 else 0 end) FROM AD_Field f JOIN AD_Column c ON (f.AD_Column_ID=c.AD_Column_ID) WHERE f.isdisplayed='Y' AND f.isactive='Y' AND c.isactive='Y' AND f.AD_Tab_ID=? [15]
org.postgresql.util.PSQLException: ERROR: column f.xposition does not exist
  Position: 12; State=42703; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:125)
    at $Proxy0.executeQuery(Unknown Source)
    at org.compiere.util.DB.getSQLValueEx(DB.java:1339)
    at org.compiere.util.DB.getSQLValue(DB.java:1382)
    at org.compiere.util.DB.getSQLValue(DB.java:2216)
    at org.compiere.model.GridTab.getColumns(GridTab.java:3249)
    at org.adempiere.webui.panel.ADTabpanel.createUI(ADTabpanel.java:261)
    at org.adempiere.webui.panel.AbstractADWindowPanel.initTab(AbstractADWindowPanel.java:628)
    at org.adempiere.webui.panel.AbstractADWindowPanel.initPanel(AbstractADWindowPanel.java:342)
    at org.adempiere.webui.panel.ADWindowPanel.initPanel(ADWindowPanel.java:230)
    at org.adempiere.webui.window.ADWindow.doCreatePart(ADWindow.java:79)
====================================================
Best regards,
--
Peter Shepetko

[Peter Shepetko]

Screenshort about xposition

[Carlos Antonio Ruiz Gomez]

Peter, you don't have column 200351 created with 892_IDEMPIERE_368.sql

Regards,

Carlos Ruiz

On 05/09/12 05:50, Peter Shepetko wrote:
> Screenshort about xposition

[Peter Shepetko]

Thanks, Carlos.
I will restart this script and will check it.

2012/9/5 Carlos Antonio Ruiz Gomez <car...@gmail.com>

--
Петр Шепетько
Менеджер ERP проектов

тел.:  + 38 096 335 88 78
факс:  + 1 336 868 3339
скайп:  peter.shepetko
почта:  pe...@fina.net.ua
сайт:  http://fina.net.ua

[PShepetko]

Hi Carlos,
Excuse, it is my mistake because I missed this 892nd script.The system works very well.
Thank you huge for the done work and I will be glad to help.

---
Peter Shepetko

среда, 5 сентября 2012 г., 17:07:08 UTC+3 пользователь Carlos Ruiz написал:

[redhuan d. oon]

I hit the same error in my Windows virtual machine trying to test my Installer. I do have that script applied and i manually checked in the PGAdmin and do have that column 200351 with 'X Position'.
I am using the latest iDempiereDaily build, i ran ImportAdempiere that applied up to script 847_ . Therefore i ran all scripts after that. I also ran Hahmed script for OSSP first. I checked the psql.log they seemed OK.
Anything else i should check?