Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tracefile not getting created

Apoorva S-OracleJan 23 2018 — edited Jan 24 2018

Hi,

I have enabled SQL trace for orclpdb and I have the following code in a SQL script:

set echo on
connect trace/trace@orclpdb
alter session set tracefile_identifier='mytraceP3';
update sales set amount_sold=20000 where prod_id=13 and cust_id=987;
commit;
create index sales_prod_cust_indx on sales(prod_id,cust_id);
connect trace/trace@orclpdb
alter session set tracefile_identifier='mytraceS3';
update sales set amount_sold=30000 where prod_id=13 and cust_id=987;
commit;
connect trace/trace
drop index sales_prod_cust_indx;
exit;

The tracefile for mytraceP3 gets generated but mytraceS3 does not get generated.

Could somebody please help me?

- Apoorva
This post has been answered by AJ on Jan 23 2018
Jump to Answer

Comments

Timo Hahn

InvokeAction?
Aren't they deprecated?
From the description, the flow is hard to understand.
Can you provide some images?
A reproducible test case might help as well.

Timo

dvohra21

The migration path is supported. How was the application migrated?
Just open ADF 12.2.1.3 app in JDev 12.2.1.4. Issues, if any, shall get listed.

DebWilliams

Thank you, Timo. Yes, I realize the invokeAction is deprecated. The application was originally migrated from ADF 10.1.3.5 to ADF 12.2.1.0, 12.2.1.3, and then 12.2.1.4. The invokeAction functionality, although deprecated, still worked. I will have to update the code to replace the functionality for the invokeAction at some point.

The web application was successfully migrated to each version of ADF, deployed to WebLogic, and working. The last Version 12.2.1.3 was deployed successfully.
The issues I am having were all introduced after migrating from 12.2.1.3 to 12.2.1.4.

I believe I have found the cause for the New Row not being displayed in the Add page.
In JDev 11.1.2, the changeEventPolicy was updated to default to "ppr" instead of "none".
The changeEventPolicy did not impact our application for version 12.2.1.0 or 12.2.1.3.
However, version 12.2.1.4 is refreshing the Iterator several times. The end result is the Iterator is refreshed again after the New Row is created and before the Page is displayed - which is removing the New Row, after it is created.
After setting the changeEventPolicy to "none", the Add page is initialized as expected, the New Row is created, and now displayed as the Current Row.

I am still having trouble with the default values not displaying on the Add page, but the New Row is now displayed.

Thank you for your time!
-Deb

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 21 2018
Added on Jan 23 2018
#database, #general-database-discussions, #performance
10 comments
293 views