Java Script AJAX call to JDE AIS Server.

KSK

KSK

Well Known Member
Hi ,

We are making a REST call to JDE AIS Server(Port:7050) from Chrome(Via Java Script Code-AJAX call).

REST calls are hitting the JDE AIS Server successfully but response is not coming back to chrome .getting the exceptions as share in the attachment.


Also capture the JAS log from AIS , Found Broken Pipe Exception for the REST calls sent by Chrome. Not getting the Root cause for this issue …Please share your inputs.


Tool Relase :9.1.5.7
Application Release : E91.



Exceptions from Chrome after making a REST call (Java Script -AJAX)

Failed to load http://uxnlsage032.eu.XXXX.com:7050/jderest/orchestrator/JDE_ORCH_EASYIMPORT: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://localhost:9999' is therefore not allowed access.



Exceptions captured from JAS log.

occured in the SQLPhysicalConnection.select():Auto: | Table or View Name = F9860 - Data Source[0] = Object Librarian - 910 java.sql.SQLRecoverableException: IO Error: Broken pipe

25 Jun 2018 12:44:35,766[SEVERE][BASE]com.jdedwards.database.base.JDBException:
[SQL_EXCEPTION_OCCURRED] An SQL exception occurred: IO Error: Broken pipe. java.sql.SQLRecoverableException: IO Error: Broken pipe

25 Jun 2018 12:44:35,766[SEVERE][BASE]com.jdedwards.database.base.JDBException:
[SQL_EXCEPTION_OCCURRED] An SQL exception occurred: IO Error: Broken pipe. com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: IO Error: Broken pipe.

25 Jun 2018 12:44:35,767[SEVERE][JAS]JDBCProxy.jdbcProxy():
JDBj database operation failed | UserName : S549266, Environment : JTL910, User Role : *ALL com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: IO Error: Broken pipe.

25 Jun 2018 12:44:35,767[SEVERE][RUNTIME]Failed
to get report description from F9860 -Errors on JAS: Error Message: <Errors on JAS: >, Error list:





Thanks,
Siva Kumar K
 

Attachments

  • REST call Exceptions.zip
    22.9 KB · Views: 21
HI

I got the following infomation from Oracle for my issue .


---------------------------------------------------------------------------------


If we are working below 9.2.0.2 tool release and calling the JDE AIS Server from browser then we need to do below changes .


Chrome
We need to Turn off the CORS using -disble-web-security command.


IE
We need to enable “Access data sources across domains” in the Internet Options.



https://www.thegeekstuff.com/2016/09/disable-same-origin-policy/


------------------------------------------------------------------------------------

I have tried the above solution in IE and it's working good.
 
Back
Top