Oracle error in action block

[Anon Anon]

Hi All,

One of our actional blocks in an operations library is failing with the following error:

 

TIRM034E:  LAST OR CURRENT DATABASE STATEMENT =      31

TIRM035E:   CURRENT STATEMENT BEING PROCESSED =      0000000031

TIRM038E:   ** FATAL DATABASE ERROR WAS ENCOUNTERED **

TIRM039E:                      DB LAST STATUS =      DB

--------------------------------------------------------------------------------

ORA-03113: end-of-file on communication channel

ORA-03114: not connected to ORACLE

--------------------------------------------------------------------------------

We have tried executing it from multiple programs but always get the same error.

All other transactions are working fine. The program hasn't changed in years and I have compared the code with another environment where this is working. Any idea what could be causing this?

[Anon Anon]

Apologies. I forgot to mention that the program works for a while if I re-start the transaction enabler but stops working after some time.

[Lynn Williams]

Hi Ankur,

I see you logged an issue for this error back in December 2010 using Gen 7.6 under AIX.

It sounds more like an Oracle/Network/TCPIP sockets related problem than a Gen problem.

 

> The program hasn't changed in years and I have compared the code with another environment where this is working. Any idea what could be causing this?

the program works for a while if I re-start the transaction enabler but stops working after some time.

Assuming the data being processed is similar all the time this could indicate a resource problem e.g. file descriptors for open sockets to the Oracle database/listener being exhausted for the aefad process after some time has past. That might also be consistent with problem only occurring in 1 environment.

 

• What version of Gen, AIX & Oracle (full 4 digits) are you currently using?
• Is the Oracle database local to the TE server hosting Gen load modules or remote?
• For the AIX user that starts the TE/aefad what is the output of the command "ulimit -a"
• Have you asked advice from IBM or Oracle on how to diagnose the root cause?

 

Thanks

[Anon Anon]

Hi Lynn,

Thanks for your reply.

1. We are using Gen 7.6, AIX 7.1, Oracle 11g 11.2.0.4.0. Oracle client installed on the application servers is 10.2.0.3.0.

2. Oracle database is on a remote server. Coolgen is on a solaris server.

3. Please see the output on ulimit command on Solaris server:

time(seconds)        unlimited

file(blocks)         unlimited

data(kbytes)         unlimited

stack(kbytes)        8192

coredump(blocks)     unlimited

nofiles(descriptors) 256

vmemory(kbytes)      unlimited

4. IBM is working with us to diagnose the issue.

 

We are using a scan configuration for the 11g database. IBM thinks this is because of known issues between Oracle 10g client and 11G scan-configuration. Do you know if this is the case? Also, could you please advised if CA Gen 7.6 is likely to work with 11g client?

 

Thanks for all your help.

Ankur Taneja

[Lynn Williams]

Hi Ankur,

> nofiles(descriptors) 256

That value seems very low to me & it could be causing open TCP/IP socket limits to be hit. I would discuss raising it with IBM

 

>  could you please advised if CA Gen 7.6 is likely to work with 11g client?

7.6 Build Tool PTF RTR76009 / RO14952 will enable you to use 7.6 with Oracle 11g under AIX after you rebuild the DBMS runtimes per the instructions.

https://support.ca.com/irj/portal/solncdndtls?aparNo=RO14952&os=AIX&fc=2&actionID=3

It is actually superseded by consolidation PTF RTR76011 / RO17194 you can find on the main 7.6 patch page.

http://www.ca.com/us/support/ca-support-online/product-content/recommended-reading/technical-document-index/ca-gen-76-solutions-patches.aspx

 

Hope this helps.