AIS Testing using SoapUI

Soumen

Soumen

Reputable Poster
I am trying to perform a testing using SoapUI for my AIS installation. This is a simple test for tokenrequest as outlined in this doc (probably written by Jon)
http://www.jdesource.com/enterpriseone/jd-edwards-application-interface-services-ais-server/

However my test is failing with this message:

"message": "Authorization Failure Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest",
"exception": "com.oracle.e1.rest.session.E1LoginException",
"timeStamp": "2016-01-29:11.17.26"

The AIS logs show this error:

29 Jan 2016 10:46:44,093[SEVERE][AIS]JAS ERROR OUTPUT: inputParams INPUT PARAMS: aichs-JDV910-ALL-http://txhdcwbs08.svc.ssss.com:8094 Exception Occurred Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest java.io.IOException: Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest
29 Jan 2016 10:46:54,577[SEVERE][AIS]JAS ERROR OUTPUT: inputParams INPUT PARAMS: aichs-JDV910-ALL-http://txhdcwbs08.svc.ssss.com:8094 Exception Occurred Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest java.io.IOException: Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest



Interestingly though my TEST connection works for AIS, also I am able to open the Apps from my iPAD using this AIS URL so I know the AIS installation works. Moreover I have verified that the Allowed host entry is set to "*" on the JAS server.

I bumped into this Doc id on MOS:
E1: MOB: AIS Server Connection Error <JAS ERROR OUTPUT: http://[machine_name]:9999/jde/FormServiceRequest> (Doc ID 1929480.1)

But I have checked the environment names and they are correct.

Has anybody got this error, seems like I am missing something..not sure what.

Meanwhile this is E9.1 on TR 9.1.5.5 with WebSphere 8.5.5.5 installation.

As mentioned before the AIS works great form the Apps but I needed to test this from SoapUI.

Thanks,
Soumen
 
I am trying to perform a testing using SoapUI for my AIS installation. This is a simple test for tokenrequest as outlined in this doc (probably written by Jon)
http://www.jdesource.com/enterpriseone/jd-edwards-application-interface-services-ais-server/

However my test is failing with this message:

"message": "Authorization Failure Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest",
"exception": "com.oracle.e1.rest.session.E1LoginException",
"timeStamp": "2016-01-29:11.17.26"

The AIS logs show this error:

29 Jan 2016 10:46:44,093[SEVERE][AIS]JAS ERROR OUTPUT: inputParams INPUT PARAMS: aichs-JDV910-ALL-http://txhdcwbs08.svc.ssss.com:8094 Exception Occurred Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest java.io.IOException: Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest
29 Jan 2016 10:46:54,577[SEVERE][AIS]JAS ERROR OUTPUT: inputParams INPUT PARAMS: aichs-JDV910-ALL-http://txhdcwbs08.svc.ssss.com:8094 Exception Occurred Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest java.io.IOException: Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest



Interestingly though my TEST connection works for AIS, also I am able to open the Apps from my iPAD using this AIS URL so I know the AIS installation works. Moreover I have verified that the Allowed host entry is set to "*" on the JAS server.

I bumped into this Doc id on MOS:
E1: MOB: AIS Server Connection Error <JAS ERROR OUTPUT: http://[machine_name]:9999/jde/FormServiceRequest> (Doc ID 1929480.1)

But I have checked the environment names and they are correct.

Has anybody got this error, seems like I am missing something..not sure what.

Meanwhile this is E9.1 on TR 9.1.5.5 with WebSphere 8.5.5.5 installation.

As mentioned before the AIS works great form the Apps but I needed to test this from SoapUI.

Thanks,
Soumen

Dear Soumen,

We have successfully tested AIS server using Soap UI. We are able to get security token from the Enterprise server via JAS Server.

We have made this article to help everyone easily configure AIS Sever for JD Edwards Mobile and IOT.

We have created this article "In collaboration with JDESource" and published the article on both the website.

JDEE1Tips : http://www.jdee1tips.com/#!JD-Edwar...ces-AIS-Server/esfmi/56aa0b670cf2e43ac04f8ff0

JDESource : http://www.jdesource.com/enterpriseone/jd-edwards-application-interface-services-ais-server/

This issue can happened because of the in correct value of allowed hosts in JAS Server. However you already verified the value.

Its Interesting, How your mobile apps works when soap UI test fails. Lets troubleshoot the issue!!!

Let us know the below information to understand and troubleshoot the issue

Whether you synchronized the JAS Instance with SM configuration, after changing the allowed hosts value to * using Server Manager? Check the actual jas.ini whether Server Manager changed the allowed hosts value to * or not?

Whether you restarted the JAS instance after changing the allowed hosts value to *?

Can you check the e1root.log of JAS Instance? Let us know if you found any error message in e1root.log, we will try to help you.
 
Last edited:
Let us know the below information to understand and troubleshoot the issue

Whether you synchronized the JAS Instance with SM configuration, after changing the allowed hosts value to * using Server Manager? Check the actual jas.ini whether Server Manager changed the allowed hosts value to * or not?

Whether you restarted the JAS instance after changing the allowed hosts value to *?

Can you check the e1root.log of JAS Instance? Let us know if you found any error message in e1root.log, we will try to help you.

Yes synchronization was done and we have restarted both the AIS and HTML instances multiple time since then.

I also checked the jas.ini and it shows me this entry...

[FORMSERVICE]
ALLOWEDHOSTS=*

I do not see any error message in the e1root logs however when I increased the logging on the HTML instances I see these entries every time I send a response from the SoapUI.
these are not errors though just regular SQL statements.

01 Feb 2016 10:31:07,191[APP][JDBJ]SQL statement parameter marker values are :
01 Feb 2016 10:31:07,191[APP][JDBJ]Param1 : AICHS_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]SELECT T0.RLFRROLE,T0.RLFUROLE1,T1.AUROLEDESC,T0.RLEXPIRDATE,T1.AUSEQNO,T1.AULNGP,T1.AUUSER FROM SY910.F95921 T0, SY910.F00926 T1 WHERE ((T0.RLTOROLE = ? AND EXISTS( SELECT T0.LLLL FROM (SY910.F0093 T0 INNER JOIN SY910.F00941 T1 ON T0.LLLL = T1.LMLL ) WHERE ((T1.LMENHV01 = ? AND T1.LMPATHCD IN ( ? ) AND T0.LLUSER = RLFRROLE)) ) AND (T1.AULNGP = ? OR T1.AULNGP = ? ) AND T0.RLEFFDATE <= ? AND (T0.RLEXPIRDATE = ? OR T0.RLEXPIRDATE > ? ))) AND (T0.RLFRROLE = T1.AUUSER) ORDER BY T1.AUSEQNO DESC
01 Feb 2016 10:31:07,207[APP][JDBJ]SQL statement parameter marker values are :
01 Feb 2016 10:31:07,207[APP][JDBJ]Param1 : AICHS_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param2 : 1_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param3 : DV910_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param4 : _Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param5 : _Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param6 : 116032_Types.INTEGER,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param7 : 0_Types.INTEGER,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param8 : 116032_Types.INTEGER,


As noted earlier the AIS logs do show these errors right at the same time:

01 Feb 2016 10:28:46,828[SEVERE][AIS]JAS ERROR OUTPUT: inputParams INPUT PARAMS: aichs-JDV910-ALL-http://txhdcwbs08.svc.ssss.com:8094 Exception Occurred Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest java.io.IOException: Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest


So it does look like the SoapUI is able to connect to the HTML server but then it does not know what to do with the request. I notices that the test you conducted is on 9.2, I am on release 9.1 (TR 9.1.5.5) could it be because of the release level?

Thank you for your help with this. I really appreciate your inputs.

Many Thanks,
Soumen
 
Can you see the JSON payload that is being returned or just the 403 error?

By the way, there is an error in JSON payload for the website you referenced. They show the role as being "ALL" but this should be "*ALL" so if you are following this then I would check that you have the role correct.
 
Yes synchronization was done and we have restarted both the AIS and HTML instances multiple time since then.

I also checked the jas.ini and it shows me this entry...

[FORMSERVICE]
ALLOWEDHOSTS=*

I do not see any error message in the e1root logs however when I increased the logging on the HTML instances I see these entries every time I send a response from the SoapUI.
these are not errors though just regular SQL statements.

01 Feb 2016 10:31:07,191[APP][JDBJ]SQL statement parameter marker values are :
01 Feb 2016 10:31:07,191[APP][JDBJ]Param1 : AICHS_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]SELECT T0.RLFRROLE,T0.RLFUROLE1,T1.AUROLEDESC,T0.RLEXPIRDATE,T1.AUSEQNO,T1.AULNGP,T1.AUUSER FROM SY910.F95921 T0, SY910.F00926 T1 WHERE ((T0.RLTOROLE = ? AND EXISTS( SELECT T0.LLLL FROM (SY910.F0093 T0 INNER JOIN SY910.F00941 T1 ON T0.LLLL = T1.LMLL ) WHERE ((T1.LMENHV01 = ? AND T1.LMPATHCD IN ( ? ) AND T0.LLUSER = RLFRROLE)) ) AND (T1.AULNGP = ? OR T1.AULNGP = ? ) AND T0.RLEFFDATE <= ? AND (T0.RLEXPIRDATE = ? OR T0.RLEXPIRDATE > ? ))) AND (T0.RLFRROLE = T1.AUUSER) ORDER BY T1.AUSEQNO DESC
01 Feb 2016 10:31:07,207[APP][JDBJ]SQL statement parameter marker values are :
01 Feb 2016 10:31:07,207[APP][JDBJ]Param1 : AICHS_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param2 : 1_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param3 : DV910_Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param4 : _Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param5 : _Types.VARCHAR,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param6 : 116032_Types.INTEGER,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param7 : 0_Types.INTEGER,
01 Feb 2016 10:31:07,207[APP][JDBJ]Param8 : 116032_Types.INTEGER,


As noted earlier the AIS logs do show these errors right at the same time:

01 Feb 2016 10:28:46,828[SEVERE][AIS]JAS ERROR OUTPUT: inputParams INPUT PARAMS: aichs-JDV910-ALL-http://txhdcwbs08.svc.ssss.com:8094 Exception Occurred Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest java.io.IOException: Server returned HTTP response code: 403 for URL: http://txhdcwbs08.svc.ssss.com:8094/jde/FormServiceRequest


So it does look like the SoapUI is able to connect to the HTML server but then it does not know what to do with the request. I notices that the test you conducted is on 9.2, I am on release 9.1 (TR 9.1.5.5) could it be because of the release level?

Thank you for your help with this. I really appreciate your inputs.

Many Thanks,
Soumen

Dear Soumen,

Your Release level is fine. No problem in that.

We also suspect the same what RussellCodlin found out. Because you have error message related to Role relationship F95921 & F00926.

Please try the below values

{
"username":"JDE",
"password":"JDE",
"enviornment":"JDV910",
"role":"*ALL",
"devicename":"SoapUI"
}
 
Russell,

You are right, the role needed to be *ALL instead of ALL.
Dang! I should have known this. I feel stu*** now! :)

Thanks for your help!
Soumen
 
Back
Top