ORA - 24757 Duplicate transaction identifier (merged 2) - forms 6i [message #420562] |
Mon, 31 August 2009 06:21  |
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   |
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   |
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   |
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 #423184 is a reply to message #420562] |
Tue, 22 September 2009 08:10   |
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  |
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;
|
|
|