REP-0180: Report has been cancelled from the Report Server.

When calling reports from Forms in Oracle 10g Application server (Forms and Report server), we got

REP-0180: Report has been cancelled from the Report Server.

The issue was with the Report server configuration file. The Report server has been authenticated through the Portal. We have not configured portal.

Just commented the security block in the configuration file (report server Path: (FORMS_SERVER_PATH\report\conf\rep-hostname.conf)

Original block was:

security id="rwSec" class="oracle.reports.server.RWSecurity"

!--property name="securityUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/-->

property name="oidEntity" value="reportsApp_chainsysindia_85C49001C04D11DE8F660BF187F8822B"/>

/security>

destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">

!--property name="portalUserid" value="%PORTAL_DB_USERNAME%/%PORTAL_DB_PASSWORD%@%PORTAL_DB_TNSNAME%" confidential="yes" encrypted="no"/-->

/destination>

Changed Block:

!--security id="rwSec" class="oracle.reports.server.RWSecurity">

/security-->

!--destination destype="oraclePortal" class="oracle.reports.server.DesOraclePortal">

/destination-->

Bounce the report server.

It should work!!! Cheers!!!

The requested url /em is not found on the server

During the navingation of Application Server enterprise manager in the SOA Suite, i received a message that ' The requested url /em is not found on the server'

The Cause is that:
During installation of SOA Suite, mistakenly i forgot to check the "Configure this as an Administration OC4J instance".

So the Enterprise Manager control is not enabled in our SOA Suite,
Everything is turned off after this, i had the fix from here
Fix:
The two files you need to touch:
ORACLE_HOME/j2ee/oc4j_soa/config/server.xml
ORACLE_HOME/j2ee/oc4j_soa/config/default-web-site.xml

The values you need to change from the files:
In server.xml find ascontrol and set start="true"
in default-web-site.xml find ascontrol and set ohs-routing="true"
Restart SOA
$ORACLE_HOME/opmn/bin/opmnctl stopall
$ORACLE_HOME/opmn/bin/opmnctl startall

The requested web page should appear now.

Cheers!!!

[ons-connect] Passive connection 127.0.0.1,6100 missing connect

Today i need to blog out my experience with SOA installation. I received an error stating in opmn.log during configuration of BPEL process manager

09/07/07 09:40:39 [ons-connect] Passive connection 127.0.0.1,6100 missing connect
09/07/07 09:40:39 [ons-connect] Passive connection 127.0.0.1,6100 missing connect

We can try a fix like this:
go to DATABASE oracle home /opmn/conf directory

vi ons.config
there you can find some entries like
localport=6100
remoteport=6200
loglevel=3

Change them safely to (add+1000)
localport=7100
remoteport=7200
loglevel=3

bounce the database listener.
Reason for local connect missing is:
Application server opmn.xml will be having the entry like

notification-server interface="ipv4"
port local="6100" remote="6200" request="6003"/

This port value gets conflict with the database ons process. So the issue arises.

Retry the operation that failed.

FRM-92101

1.The file "ldflags" in
$ORACLE_HOME/lib32 is missing or pointing to a wrong location,
recreate the symbolic link
$ rm $ORACLE_HOME/lib32/ldflags
create lib32 in apps oracle home (mkdir $ORACLE_HOME/lib32)
after this please do the necessary as follows.

$ ln -s $ORACLE_HOME/lib/ldflags $ORACLE_HOME/lib32/ldflags
go to .
/apps/tech_st/10.1.2/forms/lib/make -f ins_forms.mk install
2.Relink forms executables.
Please follow the next below steps:
2.1. Source the Applications environment file
2.2. Run the following command to relink the forms from 10.1.2 home/lib folder
make -f ins_forms.mk installOr make -if ins_forms.mk install

The Issue should be resolved.