Error when zooming: The column index is out of range: 1, number of columns: 0

[iqbal muhammad]

Hi Everyone,
I am trying to zoom out from a field in a detail tab to another detail tab in another window, but encounter this error:

SELECT  FROM XYZ WHERE (XYZ_ID=1000000) (<-- There are no columns in the selection)
org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.
        at org.postgresql.jdbc.PgResultSet.checkColumnIndex(PgResultSet.java:2772)
        at org.postgresql.jdbc.PgResultSet.checkResultSet(PgResultSet.java:2792)
        at org.postgresql.jdbc.PgResultSet.getInt(PgResultSet.java:2067)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getInt(NewProxyResultSet.java:425)
        at org.compiere.util.DB.getSQLValueEx(DB.java:1280)
        at org.compiere.util.DB.getSQLValue(DB.java:1321)
        at org.compiere.util.DB.getSQLValue(DB.java:2179)
        at org.compiere.model.MZoomCondition.findZoomWindowByWindowId(MZoomCondition.java:192)
        at org.adempiere.webui.apps.AEnv.zoom(AEnv.java:442)
        at org.adempiere.webui.apps.AEnv.zoom(AEnv.java:447)
        at org.adempiere.webui.apps.AEnv.zoom(AEnv.java:186)
        at org.adempiere.webui.apps.AEnv.actionZoom(AEnv.java:417)
        at org.adempiere.webui.editor.WTableDirEditor.actionZoom(WTableDirEditor.java:522)
        at org.adempiere.webui.adwindow.ADTabpanel$ZoomListener.onEvent(ADTabpanel.java:1609)
        ...

The scenario is
A1   B1
   A2 zoom -> B2  
  
Here are what I've recheck:
1. In zoom Table (B2) I've set its Window value, B, same Window with its parent table.
2. In B2 table I've set some column as its identifier, one of it  is ID from its parent table (B1).
3. In B1 table, I've set documentno field as identifier.

I've set zoom several times and never facing a problem, I have no idea why this happens.
Perhaps someone has encountered the same problem and share the workaround.

Thank you for your help.

Regards,