api_datasource set page ora-00060 deadlock

Question

Using this option api_datasource.setpage I have a deadlock. The deadlock is because design.

session 141: DID 0001-002B-000000A3 session 141: DID 0001-002B-000000A3

Rows waited on: Session 141: obj - rowid = 0000B256 - AAALJWAAEAAARjmAAH (dictionary objn - 45654, file - 4, block - 71910, slot - 7)

----- Information for the OTHER waiting sessions ----- ----- End of information for the OTHER waiting sessions -----

Information for THIS session:

----- Current SQL Statement for this session (sql_id=1k6mf097cza2n) ----- UPDATE T_BDF_PANELDTLINS SET LABEL_TX = BDF_SUPPORT.CHECKNULL(:B2 ) WHERE BDF_PANELDTLINS_OID = :B1 ----- PL/SQL Stack ----- ----- PL/SQL Call Stack ----- object line object handle number name 0x9817b8d8 318 package body FORMSPIDER.BDF_PANELDTLINS_API 0x98389b48 372 package body FORMSPIDER.BDF_DBOBJECTACCESS_MNG 0x98389b48 4171 package body FORMSPIDER.BDF_DBOBJECTACCESS_MNG 0x9814dea0 2173 package body FORMSPIDER.API_DATASOURCE 31,1 0%

Answer 1

it follow with those lines

x8fa84308 181 package body GESTION.REPFORM --That is the package where I do the call 0x8fa84308 156 package body GESTION.REPFORM 0x93f7a510 1 anonymous block 0x960acd58 25 package body GESTION.BDF_SCRIPTEXECUTER 0x960b1b00 2 anonymous block 0x9836bf08 140 package body FORMSPIDER.BDF_SCRIPTUTIL 0x9836bf08 152 package body FORMSPIDER.BDF_SCRIPTUTIL 0x983dd168 54 package body FORMSPIDER.BDF_ENGINE 0x983dd168 163 package body FORMSPIDER.BDF_ENGINE 0x983dd168 655 package body FORMSPIDER.BDF_ENGINE 0x983dd168 1785 package body FORMSPIDER.BDF_ENGINE 0x983dd168 2156 package body FORMSPIDER.BDF_ENGINE 0x983dd168 2438 package

Answer 2

0

Hi Jose,

We fixed this issue in a public release last year with Formspider 1.10.1. Please see the change log at: http://theformspider.com/changeLog.php

So I recommend you to use the latest version of Formspider to avoid this bug.

Kind Regards,
Yalim

link

answered 22 Sep '17, 18:23

Yalim ♦♦
2.8k●5
accept rate: 20%

Answer 3

0	Yalim, I read about this issue before send the post and I know you fixed it. But I'm using 1.11.0, so it must to have this fix resolved. And it don't have the fix resolved so. Waiting your answer regards. link answered 22 Sep '17, 18:31 JoseBenitez 41●2●4 accept rate: 16%

Answer 4

By the way here I add the PLSQL that call the api

-- api_application.showpopupmessage(' Nuevo paginacion'); datasource1 := panel.dsource;

    x1v := panel.paginpanel || '.gopagina';
  --  api_application.showpopupmessage(x1v);

    dpage := api_component.getvaluenr(x1v);
    if (dpage is null) or (dpage = 0) then
            dpage := panel.prevpanelpage; end if;

    if (dpage is null) or (dpage = 0) then dpage := 1; end if;
   -- api_application.showpopupmessage('Antes');

    null;
    api_datasource.setpage(datasource1,dpage);

Maybe, there is a wrong use from me.

Answer 5

0	in the first line datasource1 := panel.dsource it is in a normal line, not a comment line like is show in the post link answered 22 Sep '17, 18:44 JoseBenitez 41●2●4 accept rate: 16%

Answer 6

0	Yalim if I follow the link it pick up me to domwload the Formspider 1.11.0 I have this installed, version 1.11.0 (build 43). What must I do, download and reinstall? Regards. link answered 22 Sep '17, 20:30 JoseBenitez 41●2●4 accept rate: 16%

Answer 7

0

Hi Jose,

Sorry for the late reply. It's a busy week. I'll have to take a look at this more closely and find out if this API indeed causes a deadlock. This was an issue before and we fixed in FS 1.10.1. But maybe there has been a regression.

I'll get back to you. Next week is Open World, so my time will be again limited but I'll get to this ASAP.

Kind Regards,
Yalim

link

answered 27 Sep '17, 16:21

Yalim ♦♦
2.8k●5
accept rate: 20%