Hi FS Team, When i try commit datasource changes (api_datasource.docommit(ds);) , get error "An error occurred. Please contact your system administrator." error from catalina.out java.sql.SQLRecoverableException: No more data to read from socket Maybe can help ? tomcat version: apache-tomcat-8.0.32, ojdbc6.jar, Oracle 11.2.0.4.0 Thanks |
SOLVED on logon formspider session execute this EXECUTE IMMEDIATE 'alter session set "_optimizer_cost_based_transformation" = off'; -- MOS #2255216.1 Cool! Happy to hear the problem is resolved. So When do you exactly execute this statment? Do you execute it right after a new database session is created?
(27 Mar '20, 14:04)
formspider ♦♦
|
From first put in trigger on_long for schema Formspider. But after this i see that FS application start slowly. Remove from trigger and put in code before api_datasource.docommit: EXECUTE IMMEDIATE 'alter session set "_optimizer_cost_based_transformation" = off'; api_datasource.docommit(ds); EXECUTE IMMEDIATE 'alter session set "_optimizer_cost_based_transformation" = on'; This exception i get just in one place. Interesting -when i do api_datasource.docommit: 1) trigger fire for updating - get error "An error occurred. Please contact your system administrator." .. 2) trigger fire for insert - trigger fire 2 times. get error ORA-00001: unique constraint (...) violated (primary key ...) After this trick "_optimizer_cost_based_transformation" is all ok Info from trace Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x0] [PC:0x6910D10, kxtifir()+1338] [flags: 0x0, count: 1] DDE: Problem Key 'ORA 7445 [kxtifir()+1338]' was flood controlled (0x2) (incident: 306) ORA-07445: exception encountered: core dump [kxtifir()+1338] [SIGSEGV] [ADDR:0x0] [PC:0x6910D10] [Address not mapped to object] [] ssexhd: crashing the process... Shadow_Core_Dump = PARTIAL Administrator found this solution on Oralce Suport |