I have a fresh install of estimate v2.1.1 with FreeBSD 12.2, openjdk11, and Mysql 5.7.26.
When I try to add a resource I get an error "ADD: system error" and catalina.out shows:
checkAndInsert:Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
addMaterialToAnalysis: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
Checking permissions for User: 1 Menu Item:20281
appLink: CostBookAction
12-Feb-2021 00:11:17.745 INFO [http-nio-8080-exec-8] com.wanhive.basic.utils.licensing.Application.writeLog [user]: accessing PATH:20281 METHOD:addMaterialToAnalysis
Redirecting to: CostBookAction
METHOD_TO_CALL: addMaterialToAnalysis
PATH: 20281
Found: 3.0
3.0
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
checkAndInsert:Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
addMaterialToAnalysis: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
root@web-dev3:/usr/local/apache-tomcat-9.0/logs #
Kindly try an older version (2.1.0) and see if the error goes away.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2021-02-16
The errors happen in 2.10 and 2.0.0. Maybe it is a database setup problem? I have a few entries in mysql.err:
2021-02-16T19:01:44.155789Z 3375136 [Note] Aborted connection 3375136 to db: 'estimate' user: 'estimate' host: 'web-dev3' (Got an error reading communication packets)
I'm not sure if that means anything.
Everything else works fine as far as I can tell. Let me know which database settings would be helpful to post. I cannot delete resources from the sample costbooks, It gives the same error.
Thank you for the help
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2021-06-13
Post awaiting moderation.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
Anonymous
-
2021-06-13
Post awaiting moderation.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have a fresh install of estimate v2.1.1 with FreeBSD 12.2, openjdk11, and Mysql 5.7.26.
When I try to add a resource I get an error "ADD: system error" and catalina.out shows:
checkAndInsert:Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
addMaterialToAnalysis: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
Checking permissions for User: 1 Menu Item:20281
appLink: CostBookAction
12-Feb-2021 00:11:17.745 INFO [http-nio-8080-exec-8] com.wanhive.basic.utils.licensing.Application.writeLog [user]: accessing PATH:20281 METHOD:addMaterialToAnalysis
Redirecting to: CostBookAction
METHOD_TO_CALL: addMaterialToAnalysis
PATH: 20281
Found: 3.0
3.0
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
checkAndInsert:Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
addMaterialToAnalysis: Operation not allowed for a result set of type ResultSet.TYPE_FORWARD_ONLY.
root@web-dev3:/usr/local/apache-tomcat-9.0/logs #
Any help would be appreciated.
Thanks!
Kindly try an older version (2.1.0) and see if the error goes away.
The errors happen in 2.10 and 2.0.0. Maybe it is a database setup problem? I have a few entries in mysql.err:
2021-02-16T19:01:44.155789Z 3375136 [Note] Aborted connection 3375136 to db: 'estimate' user: 'estimate' host: 'web-dev3' (Got an error reading communication packets)
I'm not sure if that means anything.
Everything else works fine as far as I can tell. Let me know which database settings would be helpful to post. I cannot delete resources from the sample costbooks, It gives the same error.
Thank you for the help