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

asked 26 Mar, 17:00

AlfAbetas's gravatar image

AlfAbetas
961830
accept rate: 11%


SOLVED on logon formspider session execute this EXECUTE IMMEDIATE 'alter session set "_optimizer_cost_based_transformation" = off'; -- MOS #2255216.1

link

answered 27 Mar, 03:54

AlfAbetas's gravatar image

AlfAbetas
961830
accept rate: 11%

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, 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

link

answered 27 Mar, 16:49

AlfAbetas's gravatar image

AlfAbetas
961830
accept rate: 11%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×67

Asked: 26 Mar, 17:00

Seen: 231 times

Last updated: 27 Mar, 16:49


© Copyright Gerger 2017