Thursday, July 19, 2012

Oracle SOA/BPM- Business Rule - Error(53): The role named "IDecisionService_Role" on this partnerLinkType uses portType "null" which is not defined anywhere.

When you add or remove rule set from the decision service you will get following type of error and warning during compilation

Error(53): The role named "IDecisionService_Role" on this partnerLinkType uses portType "null" which is not defined anywhere
Warning(126): The activity <bpel:invoke> refers to a bpel:partnerLink (via the attribute "partnerLink") - this bpel:partnerLink needs to be defined correctly.


This compilation error comes due to change in namespace in Rule's wsdl file(e.g xyzRule_DecisionService_1.wsdl)  by the JDeveloper. Its a bug in JDeveloper.

It changed from
 xmlns:plnk="http://docs.oasis-open.org/wsbpel/2.0/plnktype"
to
xmlns:plnk="http://schemas.xmlsoap.org/ws/2003/05/partner-link/"

Just revert it to

xmlns:plnk="http://docs.oasis-open.org/wsbpel/2.0/plnktype"

 back after add or remove rule set from the decision service.


Tuesday, July 3, 2012

Oracle AIA installation error : java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection


BUILD FAILED
C:\Oracle\AIAHOME\Infrastructure\Install\AID\AIAExecuteDriver.xml:222: The following error occurred while executing this line:
C:\Oracle\AIAHOME\Infrastructure\Install\AID\AIAExecuteDriver.xml:65: The following error occurred while executing this line:
C:\Oracle\AIAHOME\aia_instances\AIAINST\tmp\AIDExecuteDP_temp_1008901005.xml:50: The following error occurred while executing this line:
C:\Oracle\AIAHOME\Infrastructure\Install\AID\lib\AIDConfigurationLibraryTasks.xml:298: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Total time: 1 minute 27 seconds
'choice' is not recognized as an internal or external command,
operable program or batch file.


This happens due to less number of DB processes defined on the database. You can run following command to verify number of db processes on the DB.

SQL> show parameter process


NAME                                 TYPE        VALUE
------------------------------------ ----------- -----
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
job_queue_processes                 integer     4
log_archive_max_processes        integer     2
processes                                       integer    45

Increase this value to 200 by running following command

SQL> alter system set processes = 200 scope=spfile;

Now again rerun AIA installer.This time you will not get this issue.