Home » Developer & Programmer » Forms » ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i
ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #420562] Mon, 31 August 2009 06:21 Go to next message
gmaz
Messages: 8
Registered: August 2009
Junior Member
Hi all;
The following message :
"ORA 24757 :Duplicate transaction identifier
ORA-02063:preceding line from S0300001
FROM ==> TRANSACT@S0300001"

is appearing when I try to run a report from a form ;

In fact I have two kind of reports the one is working fine(case of report R0102.rep) with no such messages when called ,while the 2nd type of reports is showing the error(case of report R0102_300) ;

In the 2nd reports type I am reading a remote database(TRANSACT@S0300001) in the main select of the report
while the form and the report are both connected to a local database(S0218001);

the call is as follows :
(....parameters....)
(.................)
IF :Branch = 300 then
Run_Product(Reports ,:Global.Path_Name||'R0102_300.rep' ,Synchronous ,Runtime ,Filesystem ,P1_id ) ;
ELSE
Run_Product(Reports ,:Global.Path_Name||'R0102.rep' ,Synchronous ,Runtime ,Filesystem ,P1_id ) ;
END IF ;

While :Global.path_name is the root ;
P1_id is the parameter list ;
:branch is the value of the field which I am positioned
in the main data block ;

Now if I run only the report R0102_300 (Not from the form but from reports builder) which is connected to database(S0218001) and I enter the parameters the result is showed correctly;

I have searched all forums and all oracle related blogs and did not find any clue that will resolve my issue especially the Error ORA 24757 which is not detailed ;

What should I do not to have such duplicate in the transaction Id' ,Note that I am not doing any Update, or insert but only a select to get the information in the report?


Thanks for your reply ;






Re: ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #420753 is a reply to message #420562] Wed, 02 September 2009 01:10 Go to previous messageGo to next message
gmaz
Messages: 8
Registered: August 2009
Junior Member
Hi Again ;
Well I did not receive any answer yet ;
I will resume again my problem :

I have a form which is calling a report ;
the form has a block that is querying a table on a local database(S0218001) + remote database(S0300001) ;
the report is querying a table on a remote database(S0300001) in the main select ; when running the form and calling the report
I am receiving the following message :

"ORA 24757 :Duplicate transaction identifier
ORA-02063:preceding line from S0300001
FROM ==> TRANSACT@S0300001" ;

Any reference to "database links" or a link concerning this error ?


Re: ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #421286 is a reply to message #420753] Mon, 07 September 2009 05:35 Go to previous messageGo to next message
gyanny
Messages: 2
Registered: September 2009
Location: Beirut Lebanon
Junior Member
Cancel your connect order "TRANSACT@S0300001" in the main select of the report and before calling RUN_PRODUCT from your form, try connect at the desired DB following instruction LOGON(),

IF :Branch = 300 then
LOGON(Username , Password||'@S0300001') ;
Run_Product(.......);
ELSE
---------------------
END IF ;
Re: ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #421417 is a reply to message #421286] Tue, 08 September 2009 03:50 Go to previous messageGo to next message
gmaz
Messages: 8
Registered: August 2009
Junior Member
Well Thanks yanny for your answer but it has not yet solved the problem;
Please Note the following :

1) Some reports I am calling needs to read from the two databases simultaneously (I mean by UNION in the main Select of the report )the local one (S0218001) and the remote database(S0300001) ;

1) When Logging in from the form to the database(S0300001)as you said and before calling the report (RUN_PRODUCT) ,I am loosing the local connection (S0218001) which means that in case the report runs in the screen and then I close it I won't be able to run the form correctly (I mean the buttons will made errors because the query in the local form is a UNION between S0218 and S0300)

Regards ;
Re: ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #421430 is a reply to message #421417] Tue, 08 September 2009 05:01 Go to previous messageGo to next message
gyanny
Messages: 2
Registered: September 2009
Location: Beirut Lebanon
Junior Member
So your problem due to the UNION between S0218 and S0300.
Solutions:

1. Manage your DB Link (Tunnel btw the 2 DBs)
2. Keep one DB and insert into a temporery table your necessary data then clear it before calling RUN_PRODUCT or even during the call procedure.
Re: ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #423184 is a reply to message #420562] Tue, 22 September 2009 08:10 Go to previous messageGo to next message
gmaz
Messages: 8
Registered: August 2009
Junior Member
Thanks Yanny;
But 1st - How to manage the DB link (what do you mean by Tunnel) ?

2Nd I am supposed not to change in the main select of the report
That's why I can't create one table and fill in by data .
By the way the idea of creating a new view and read it in the report was successful but it was rejected ;

3rd The (LOGON / LOGOUT) was not the ideal way since there are many users who connect into this program , I don't want to put something specific especially that I don't know the password of the user ;
Regards ;
Re: ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #423584 is a reply to message #423184] Fri, 25 September 2009 07:36 Go to previous message
gmaz
Messages: 8
Registered: August 2009
Junior Member
Well , things seems to come to a happy ending in this post ;

After trying to Re-Build the report provoking the error ORA 24757 I managed to diminish the number of remote connections
@S0300001 (which seems to me unuseful or that can be re-formulate in a way not to be linked to the remotely connection in question) in the formulas created in the report
which makes the call of the report from the form possible
even if there is a UNION between the 2 DB's S0218 and S0300 ;

Regards;
Previous Topic: Problem using webutil functionality in 10g forms
Next Topic: how to enter into a form via login form
Goto Forum:
  


Current Time: Sat Dec 10 08:42:08 CST 2016

Total time taken to generate the page: 0.12672 seconds