Hello folks,

when switching app into stateless app, a below error started to occur in most of our forms.

Are we doing something incorrectly?

ERROR : 05-10-2015 10:21:16  (  ) :  =>  :  (  ) =>  Formspider Engine => "ORA-00060: deadlock detected while waiting for resource"

Thanks, Tomas

asked 05 Oct '15, 04:35

Tomeo's gravatar image

Tomeo
162353
accept rate: 3%


Hi Tomas,

Do you have any information regarding where the error is happening? Package, Line number?

Kind Regards,
Yalim

link

answered 05 Oct '15, 09:07

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Hi Yalim,

unfortunately I don't have more information. It occurs when api_application.setStateful(in_stateful_yn=>'Y'); and at the end of procedure which finishes correctly.

Any idea how to get more info ?

Tomas

(23 Oct '15, 17:14) Tomeo

Actually this error starts to occur when a paging navigation button (in toolbar) is pressed and grid row changes. This error stops to display when in other form (screen) a different grid row data are refreshed.

(23 Oct '15, 17:23) Tomeo

A problem is that it occurs across whole application. Please see this short video example, when once a datasource paging is being used an error occurs until changing row in different datasource:

http://firma.agtransport.cz:8484/agftp/2015-10-23_2316.swf

(23 Oct '15, 17:34) Tomeo

And one more info, when I change application status to api_application.setStateful(in_stateful_yn=>'N'); then all works fine.

Please suggest what could be incorrectly set?

(23 Oct '15, 17:37) Tomeo

Hello folks,

any idea regarding this issue?

Removing pagination is not an option in this case.

Thanks, Tomas

link

answered 29 Oct '15, 05:12

Tomeo's gravatar image

Tomeo
162353
accept rate: 3%

Hi Tomas,

No, nothing new on this issue yet.

Kind Regards,
Yalim

(30 Oct '15, 05:02) Yalim Gerger ♦♦

Hi Yalim,

Were you able to simulate this issue?

Is there any workout?

Thanks, Tomas

(30 Oct '15, 08:42) Tomeo

I'm having the same issue with pagination. Please advise.

Thanks, Ilia

link

answered 05 Nov '15, 17:16

Ilia%20Sazonov's gravatar image

Ilia Sazonov
120512
accept rate: 0%

Maybe this information from the trace log will help?

----- Current SQL Statement for this session (sql_id=0c0hsv4awnczs) -----
UPDATE T_BDF_PANELDTLINS SET SELECTEDRECORDS_TX = BDF_SUPPORT.CHECKNULL(:B2 ) WHERE BDF_PANELDTLINS_OID =     :B1
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x721e3830       514  package body FORMSPIDER.BDF_PANELDTLINS_API
0x721e3830       521  package body FORMSPIDER.BDF_PANELDTLINS_API
0x721e3830       526  package body FORMSPIDER.BDF_PANELDTLINS_API
0x7bc4cde0       136  package body FORMSPIDER.BDF_PANELDTL_MNG
0x7c838728       475  package body FORMSPIDER.BDF_RESPONSE_MNG
0x7c838728      2673  package body FORMSPIDER.BDF_RESPONSE_MNG
0x7d931798      1760  package body FORMSPIDER.BDF_ENGINE
0x7d931798      2164  package body FORMSPIDER.BDF_ENGINE
0x7d931798      2448  package body FORMSPIDER.BDF_ENGINE
0x801c23e0         1  anonymous block
==================================================

Thanks, Ilia

link

answered 05 Nov '15, 21:39

Ilia%20Sazonov's gravatar image

Ilia Sazonov
120512
accept rate: 0%

Hi Illia,

Thanks for your posts, as I thought that I'm the only one with this issue. So far no fix :(

(06 Nov '15, 00:49) Tomeo

Hi Everyone,

There seems to be two threads on the Q&A site about this topic. Please, see my answer for this issue on this link: http://osqa.theformspider.com/questions/2081/getting-a-deadlock-while-using-api_datasourceexecutequery?page=1&focusedAnswerId=4776#4776

Kind Regards,
Yalim

link

answered 10 Nov '15, 09:37

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

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:

×3

Asked: 05 Oct '15, 04:35

Seen: 1,260 times

Last updated: 10 Nov '15, 09:37


© Copyright Gerger 2017