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% |
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 |
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, 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. |
By the way here I add the PLSQL that call the api -- api_application.showpopupmessage(' Nuevo paginacion'); datasource1 := panel.dsource;
Maybe, there is a wrong use from me. |
in the first line datasource1 := panel.dsource it is in a normal line, not a comment line like is show in the post |
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. |
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, |