SOA Gateway Issues and Resolution

1. While modifying the PL\SQL specs make sure that the param names, Object name is correct. 
2. While creating the ildt file if an error is thrown related to appearance of “;” and “,” make sure the PL\SQL script doesn’t have any extra ‘/’.
3. While creating the ildt file if an error is thrown as ”Unknown command END” then check for empty spaces and tabs in the pls file. 
4. For deploying the SOA Gateway Service if permission denied error is shown for the following commands:

soagenerate.sh and soadeploy.sh

Contact people with ADMIN privileges to run this command.

 5.      Once the WSDL is created and accessible, if while invoking the same results in the following issue:

                                 User not authorized to execute service

Then check the grants provided for the service in Integration Repository. Sometimes even if the grants are given this error is shown. In that case, delete the grants and give the grants again.

  

6.      If there are changes in PL/SQL scripts then make sure to regenerate and redeploy the WSDL. Also the grants have to be given again. Only regeneration of WSDL will not result in modified WSDL.