ADF, ADF Application Module, ADF Exceptions

JBO-25058: Definition vc_temp_1 of type Variable is not found in …

“JBO-25058: Definition vc_temp_1 of type Variable is not found in …”.What can be the reason?ADF creates/reuses application module (AM) instance for each user request. It is passivated (saved) after each HTTP request (if configured accordingly). When in application there are used some queries with view criteria, filter variables are passivated  for according AM as well. During the next HTTP request…

Continue Reading
Database, XML

How to create XMLIndex? When its worth to use it?

How to create XML index? Very general way with all default applied as follows: create index index_name on table_name (xmltype_column) indextype is xdb.xmlindex; Check the name of PATH table select path_table_name from user_xml_indexes  where table_name = ‘table_name’ and index_name = ‘index_name’;  Check what secondary indexes are used select c.index_name, c.column_name, c.column_position, e.column_expression  from user_ind_columns c left outer join user_ind_expressions e…

Continue Reading
Database, Logging, PL/SQL, SQL

How to enable tracing in Oracle DB? How to read trace files?

There are many ways to enable tracing in Oracle DB, some are legacy and deprecated. One of latest and recommended method for 11gR2 – use of DBMS_MONITOR (find out more about it in Oracle reference) package. To enable whole instance tracing: execute dbms_monitor.database_trace_enable(waits => true, binds => true,  instance_name => ‘instance_name’); To disable whole instance tracing:  execute dbms_monitor.database_trace_disable(instance_name => ‘instance_name’);…

Continue Reading
ADF

ADF “Select many shuttle” (af:selectManyShuttle) component does not show all items in the leading list

   ADF “Select many shuttle” does not populate all items available in binded iterator. I don’t know whether this is a bug or some other reason, but af:selectManyShuttle in the leading list populates just no more items then defined in the “RangeSize” property of iterator.   To my mind it supposed to fetch all items in iterator in bunches of %RangeSize%…

Continue Reading
ADF, ADF Task Flows

Problem with navigation using task flow actions – action is not executed after first button click

I experienced such strange ADF behavior regarding navigation using task-flow actions. Navigation doesn’t work after single button press. After second press – works fine. Preconditions: Application “MyApp” with two pages – main.jspx and popup.jspx (You can download sample app) popup.jspx belongs to bounded task-flow main.jspx belongs to unbounded task-flow Action “open” is defined in unbouded task-flow (see picture below) CommandButton…

Continue Reading
ADF

How to implement contextual events between parent page and region?

   Contextual events are necessary when need to communicate between separate regions or between parent page and region in ADF application. Here I’ll describe one approach to implement this. It is a little improvement of classic approach, because of event handling java interface is created and event consumer is implementing it. It is convenient, when need to separate data control…

Continue Reading
ADF, ADF Desktop Integration (ADFdi), ADF Exceptions

ADF Desktop Integration Excel worksheet exception on upload operation: ArgumentException: invalid area string: N5:Q5,S5

Full exception stack: ArgumentException: invalid area string: N5:Q5,S5 Source: adfdi-excel-om-api Stack: at oracle.adf.client.windows.excel.om.api.ExcelRangeAreas.ParseRangeAddress() at oracle.adf.client.windows.excel.om.api.cache.ExcelRangeCache.get_RangeAreas() at oracle.adf.client.windows.excel.om.api.ExcelRangeReader..ctor(ExcelRange range, Int32 maxRows) at oracle.adf.client.windows.excel.runtime.uicomponent.table.DEGUploadHelper.InitDataRangeIterator() at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.ProcessRows(Boolean abortOnFail) at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.Run(RTColumn rtColumnFlaggedOrChanged, Int32 cRowsFlaggedOrChanged, Boolean abortOnFail) at oracle.adf.client.windows.excel.runtime.uicomponent.table.DEGUploadHelper.Upload(Boolean haveOptions, Boolean abortOnFail, Boolean downloadAfterUpload) at oracle.adf.client.windows.excel.runtime.uicomponent.RTDataEntryGrid.Invoke(RTComponentAction rtAction) at oracle.adf.client.windows.excel.runtime.uicomponent.RTActionCollection.DoInvoke(RTColumnCollection parent) This exception is thrown when data upload to server is requested. Range N5:Q5,S5 specifies cells…

Continue Reading
ADF Desktop Integration (ADFdi)

ADF dekstop integration (ADFdi) plugin with macro enabled file doesn’t work when opened from MS Internet Explorer. File is opened but nothing is loaded. Why?

Actually this is not an issue or bug, it is not even directly related to ADFdi. Everything work as supposed to 🙂 ADFdi plugin can’t function properly, because Excel opens file in a protected view. This happens because AES (Attachment Execution Services) marks file as downloaded from internet (only MS IE and Outlook can do this). Before showing file contents…

Continue Reading