Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://host.domain:8065/webservices/SOAProvider/EbizAuth?Generate= 3527
I have cloned our production environment (EBS version 12.1.3, DB 11.2.0.2) and then I have upgraded the database from 11.2.0.2 to 12.1.0.2.
and later We have requirement to enable integrate SOA gateway. So We were applied all the applicable patches at Production environment and enabled SOA also. So I thinking I have to enable asadmin and then I can able to generate wsdl through SOA. But When I tried , I am getting below error
“Service Provider Access resulted in exception ‘oracle.apps.fnd.soa.util.SOAException: SystemError: Error while sending message to server. http://xxxxxxx:8065/webservices/SOAProvider/EbizAuth?Generate=3527&soa_ticket=..’ when attempting to perform ‘GENERATE’. Please view Service Provider logs for more details”
and
http://xxxxxxxx:8065/webservices/SOAProvider/?testquery also return http 404 error.
Usually If we will get the above error If asadmin inactive or apps schema role are not defined for asadmin, So change the asadmin password and then we added the asadmin password in $ORA_CONFIG_HOME/10.1.3/j2ee/oafm/config/system-jazn-data.xml and then restarted service, It will work.
But My case I did all the steps but Still I am getting error.
Solution :
When i upgraded the database 12c R2, I was missed to add the below parameter in sqlnet.ora and sqlnet_ifile.ora file.
If sec_case_sensitive_logon to False
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
If sec_case_sensitive_logon to True
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
After I have added the parameter in both files and restarted the application and database.
Its working fine
DBA 