After applying OCI ELK stack, when importing a file into Elasticsearch it fails at Data upload step

Error in the browser console - 'There are no ingest nodes in this cluster, unable to forward request to an ingest node'. 

This got fixed after following the node config changes suggested in blog.

Updated the OCI ELK stack terraform. In ESBootStrap.sh, modified the line 78 from 

echo "node.roles: [data]" >>/etc/elasticsearch/elasticsearch.yml

to 

echo "node.roles: [data,ingest,ml,transform]" >>/etc/elasticsearch/elasticsearch.yml

JDeveloper 12.2.1.4. - Doesn't shut down Integrated WebLogic Server

Uncomment the following line from ORACLE_HOME/wlserver/common/derby/derbyServer.policy file:

permission java.net.SocketPermission "*", "connect,resolve";

Aggregate/Sum of child attribute in ADF View Link using Groovy - ADF 12c

Create a new transient attribute in master VO to hold Sum value. Choose below properties

For expression value (yourColumnName is from child VO)

For refresh expression value

how to restore dropped table and data after commit.

 FLASHBACK TABLE <table_name> TO BEFORE DROP;

Find more at link below

https://docs.oracle.com/database/121/ADMQS/GUID-1DE547D1-3AF0-4269-8BAA-4C298EC05905.htm

Cannot find matching method oracle.jbo.server.SequenceImpl

 Error(10,1): [Static type checking] - Cannot find matching method oracle.jbo.server.SequenceImpl#<init>(java.lang.String, java.lang.Object). 

Please check if the declared type is right and if the method exists.

Solution 1:

Check if there is residue in meta data for groovy that was recently removed in VO/EO

Eg: VOOperations.xml in my case (12c)

Solution 2:

In VO source code check for trustMode. If any expression has untrusted, set it to default(trusted).

<TransientExpression

      Name="ExpressionScript"

      trustMode="untrusted"

      CodeSourceName="VORow"/>

If that doesn't work follow the below steps

a) Add import in .bcs file 

import groovy.transform.TypeChecked;

import groovy.transform.TypeCheckingMode;

b) add this annotation before def ...expression()

@TypeChecked(TypeCheckingMode.SKIP)

Subquery in ADF ViewCriteria using IsSqlFragment

 In the ViewCriteriaItem we have a property IsSqlFragment which is used to substitute literal value as query.

For Eg: To create a view criteria for below query

https://docs.oracle.com/middleware/1213/adf/api-reference-model/oracle/jbo/ViewCriteriaItem.html

select * from Dept where deptSal > (select avg(sal) from Emp)

<ViewCriteria Name="DeptSalCriteria"

 <ViewCriteriaRow

      Name="VOCriteria_row_0"

      UpperColumns="1"

      Conjunction="OR">

  <ViewCriteriaItem

        Name="DeptSalary"

        ViewAttribute="DeptSal"

        Operator=">"

        Conjunction="AND"

        Value="(select avg(sal) from Emp)"

        Required="Optional" IsSqlFragment="true"/>

  </ViewCriteriaRow>

</ViewCriteria>

Assisted By: Jagadeesh Bandaru