hard coded sql throws errors

[StabilisOne]

Especially for pqsql 9.6+ stronger casting of types sql is recommended in older classes.

1) /org.adempiere.base/src/org/compiere/model/MAcctProcessor.java [164]

2) /org.adempiere.base.process/src/org/compiere/process/NoteDelete.java [73]

3) /org.adempiere.server/src/main/server/org/compiere/server/RequestProcessor.java [153], [432]

4) /org.adempiere.base/src/org/compiere/wf/MWorkflowProcessor.java [129]

5) /org.adempiere.base/src/org/compiere/model/MRequestProcessor.java [212]

and many more there are.

Best Regards AWieclawski

[Carlos Antonio Ruiz Gomez]

As discussed in the previous thread, I think you have a problem with the database imported that didn't create a required operator.

El 12/03/20 a las 8:38, StabilisOne escribió:

--

[StabilisOne]

Does migration scripts affect code inside iD classes?

 - Thrown exceptions during Jetty startup regards their hard coded sql, while PostgreSQL 9.6+ can not recognize queries generated by them.

Best Regards,

AWieclawski

BTW.

After correction (stronger casting) in code exceptions disappeared.

The same regards your HouseKeeping. 

[Carlos Antonio Ruiz Gomez]

Based on the errors you are reporting, my thinking is that you imported into a pg9.6 a dump exported with pg11 - and that results in the required operators not being created.

I explained the fix here:

https://groups.google.com/d/msg/idempiere/DeqZmqTU7Sk/__j-Nil5DwAJ

Or you can (I think maybe that's better) import the dump in a pg11 version.

Regards,

Carlos Ruiz

El 13/03/20 a las 9:09, StabilisOne escribió: