Initial Client Setup Exception

Irritating Error Message in Command Window during Initial Client Setup

Error Message

Apache Derby

erbox_253b-*

MCostElement

getMaterialCostElement(...)

During the Initial Client Setup an error message like the following is produced as output in the command window:

===========> MCostElement.getMaterialCostElement: SELECT * FROM M_CostElement \\
WHERE AD_Client_ID=? AND CostingMethod=? ORDER BY AD_Org_ID_TrxName:Setup_1155906516109 [12]
org.apache.derby.client.am.SqlException: Invalid operation:result set closed; \\
State=null; ErrorCode=-99999
  at org.apache.derby.client.am.ResultSet.checkForClosedResultSet(Unknown Source)
  at org.apache.derby.client.am.ResultSet.nextX(Unknown Source)
...

This is due to the following code sequence in MCostElement.getMaterialCostElement(...):

...
if (rs.next ())
  retValue = new MCostElement (po.getCtx(), rs, po.get_TrxName());
if (rs.next())
  s_log.warning("More then one Material Cost Element for CostingMethod=" + CostingMethod);
...

If the result set rs is empty the second call to rs.next() throws an SqlException because the Derby JDBC driver automatically closes the result set when the end is reached. (The JDBC implementations for Oracle and PostgreSQL are more forgiving in this case.)

The message can be safely ignored.