Product Info error

[Naim Berisha]

Hi,

This is my first post in this group, and I would like to congratulate to iDempiere leaders and community about the development of this project so far.

While testing iDempiere webui  I came to an error in Product info window when hitting refresh button.

It seems happen only in oracle database.

Issue is in testCount() method, more precisely in 

String sqlCount = "SELECT COUNT(*) FROM (" + countSql + ")  as ProductInfo";

which when executed throws  an SQL exception.

By modifying it like :

String sqlCount = "SELECT COUNT(*) FROM (" + countSql + ") ;

works ok.

Regards,

Naim

[Carlos Antonio Ruiz Gomez]

Thanks Naim, although that Info Product window is now deprecated, it can still be enabled, so, I fixed your reported problem here:
https://bitbucket.org/idempiere/idempiere/commits/1885285

Regards,

Carlos Ruiz