Since Thursday we have started seeing a number of Oracle Errors in the Database Alert Log. This appears to be when a user queries a screen with an Object Connection to DocReferenceObject If the Attachment pane is open on the users screen the error is show in the foreground, however if it is minimized it logs the error in the background and the user is unaware (fortunately) Given that it started just last week it would make sense that it is related to a change, new report, event, but i have searched and cannot find anything that might be causing it. I have a ticket open with support but in case others have experienced the same issue or have any ideas on how to troubleshoot. The following is the contents of the Database Alert Log --Text2--sample parameters--DocReferenceObject--CustomerOrder--ORDER_NO=N720488^BEGIN :1 := IFSAPP.OBJECT_CONNECTION_SYS.GET_CLIENT_HIT_COUNT (:2 ,:3 ,:4 ,:5 );END;--Text1ORA-06511: PL/SQL: cursor already openORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 10ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 304ORA-06512: at "IFSAPP.OBJ_CONNECT_LU_TRANSFORM_API", line 2622ORA-06512: at "IFSAPP.OBJ_CONNECT_LU_TRANSFORM_API", line 2644ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 4954ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 5079ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 5092ORA-06512: at line 1ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 761ORA-06512: at line 1 Any pointers would be much appreciated.

Solved

ORA-06511: PL/SQL: cursor already open

5 years ago
June 29, 2020
4 replies
1483 views

+9

Harley
Hero (Customer)
27 replies

Since Thursday we have started seeing a number of Oracle Errors in the Database Alert Log. This appears to be when a user queries a screen with an Object Connection to

DocReferenceObject

If the Attachment pane is open on the users screen the error is show in the foreground, however if it is minimized it logs the error in the background and the user is unaware (fortunately)

Given that it started just last week it would make sense that it is related to a change, new report, event, but i have searched and cannot find anything that might be causing it. I have a ticket open with support but in case others have experienced the same issue or have any ideas on how to troubleshoot.

The following is the contents of the Database Alert Log

1--Text2
2--sample parameters
3--DocReferenceObject
4--CustomerOrder
5--ORDER_NO=N720488^
6
7BEGIN :1  := IFSAPP.OBJECT_CONNECTION_SYS.GET_CLIENT_HIT_COUNT (
8:2 ,
9:3 ,
10:4 ,
11:5 );
12END;
13
14--Text1
15ORA-06511: PL/SQL: cursor already open
16ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 10
17ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 304
18ORA-06512: at "IFSAPP.OBJ_CONNECT_LU_TRANSFORM_API", line 2622
19ORA-06512: at "IFSAPP.OBJ_CONNECT_LU_TRANSFORM_API", line 2644
20ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 4954
21ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 5079
22ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 5092
23ORA-06512: at line 1
24ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 761
25ORA-06512: at line 1
26

Any pointers would be much appreciated.

Best answer by Anders Blom

From the stack trace it looks like it might have something to do with Application Base Setup > System Setup > Object Connection Transformations. Have any transformations been added recently? Look e.g. for System Defined: not checked. Maybe there’s a circular reference or something like that. Which applications version and update is it?

View original

Did this topic help you find an answer to your question?

A

+4

Anders Blom
Do Gooder (Former Employee)
2 replies
Answer
5 years ago
June 30, 2020

From the stack trace it looks like it might have something to do with Application Base Setup > System Setup > Object Connection Transformations. Have any transformations been added recently? Look e.g. for System Defined: not checked. Maybe there’s a circular reference or something like that. Which applications version and update is it?

+9

Harley
Author
Hero (Customer)
27 replies
5 years ago
June 30, 2020

Hi @Anders Blom . Thanks for the info. I have checked the Object Connection Transformations, no custom entries and the last modified dates tally with the last update we applied (back in May which was IFS9 Update 16)

However, looking at the Target LUs these appear to be the screens where we are seeing errors. CustomerOrderLine, PurchaseReceipt for example.
I will deactivate the Transformations related to these screens and monitor to see if the errors stop.

Thanks again

+9

Harley
Author
Hero (Customer)
27 replies
5 years ago
June 30, 2020

@Anders Blom - I deactivated all of the Object Connection Transformations this morning and the error hasn’t appeared since. I will still need to reactivate selectively and understand whether there is a particular one that is causing the issue, but it is great this this has put a stop to the errors for now.

Thanks again for your help

+6

jhainsworth
Do Gooder (Customer)
13 replies
3 years ago
February 23, 2022

@Harley _ We just started getting this error today, Updated to UPD18 in January. Were you able to identify the cause? We also have no custom transforms and don’t understand why it started today.

Since Thursday we have started seeing a number of Oracle Errors in the Database Alert Log. This appears to be when a user queries a screen with an Object Connection to

DocReferenceObject

If the Attachment pane is open on the users screen the error is show in the foreground, however if it is minimized it logs the error in the background and the user is unaware (fortunately)

Given that it started just last week it would make sense that it is related to a change, new report, event, but i have searched and cannot find anything that might be causing it. I have a ticket open with support but in case others have experienced the same issue or have any ideas on how to troubleshoot.

The following is the contents of the Database Alert Log

1--Text2--sample parameters--DocReferenceObject--CustomerOrder--ORDER_NO=N720488^BEGIN :1  := IFSAPP.OBJECT_CONNECTION_SYS.GET_CLIENT_HIT_COUNT (:2 ,:3 ,:4 ,:5 );END;--Text1ORA-06511: PL/SQL: cursor already openORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 10ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 304ORA-06512: at "IFSAPP.OBJ_CONNECT_LU_TRANSFORM_API", line 2622ORA-06512: at "IFSAPP.OBJ_CONNECT_LU_TRANSFORM_API", line 2644ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 4954ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 5079ORA-06512: at "IFSAPP.DOC_REFERENCE_OBJECT_API", line 5092ORA-06512: at line 1ORA-06512: at "IFSAPP.OBJECT_CONNECTION_SYS", line 761ORA-06512: at line 1

Any pointers would be much appreciated.

Page 1 / 1

From the stack trace it looks like it might have something to do with Application Base Setup > System Setup > Object Connection Transformations. Have any transformations been added recently? Look e.g. for System Defined: not checked. Maybe there’s a circular reference or something like that. Which applications version and update is it?

Hi @Anders Blom . Thanks for the info. I have checked the Object Connection Transformations, no custom entries and the last modified dates tally with the last update we applied (back in May which was IFS9 Update 16)

However, looking at the Target LUs these appear to be the screens where we are seeing errors. CustomerOrderLine, PurchaseReceipt for example.
I will deactivate the Transformations related to these screens and monitor to see if the errors stop.

Thanks again

@Anders Blom - I deactivated all of the Object Connection Transformations this morning and the error hasn’t appeared since. I will still need to reactivate selectively and understand whether there is a particular one that is causing the issue, but it is great this this has put a stop to the errors for now.

Thanks again for your help

@Harley _ We just started getting this error today, Updated to UPD18 in January. Were you able to identify the cause? We also have no custom transforms and don’t understand why it started today.

ORA-06511: PL/SQL: cursor already open

4 replies

Reply

Cookie policy

Cookie settings

Reply

Related Topics

Cursor error - cursor already openicon

Issue with PLSQL

Import configuration erroricon

Cannot add a new column to invoice_tab 24R1icon

DBMS_SQL access deniedicon

Did you find what you're looking for? If not:

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded

Cookie policy

Cookie settings