Hi All
I am developing a SAPUI5 application hosted on a local installation (localhost) of Tomcat server, trying to display all the sales order from the SAP ES Workplace ERP system using the SAP Demo Gateway services provided...
I am using the following REST service to fetch all Sales Order - http://gw.esworkplace.sap.com/sap/opu/odata/sap/SALESORDERS/SOHeaders
My HTML5 application is running on the local host..But when I try to run this on IE8, gives me a Access denied
But the sap-ui-core.js is indeed placed under the location mentioned above..If I write a simple application which only display some text, the same code works.
Here is the HTML code I have written
<!DOCTYPE html>
<html>
<head>
<meta http-equiv='X-UA-Compatible' content='IE=edge' />
<title>Fetch Sales Order via Gateway - SAPUI5</title>
<script id="sap-ui-bootstrap"
type="text/javascript"
src="../sapui5/resources/sap-ui-core.js"
data-sap-ui-theme="sap_goldreflection"
data-sap-ui-libs="sap.ui.commons, sap.ui.table">
document.domain = '*.sap.com'
</script>
<script src="scripts/fetchsalesorder_new.js"></script>
</head>
<body class="sapUiBody">
<div id="salesorders"></div>
<div id="lineitems"></div>
</body>
</html>
And the snippet of the script file
//supress the Same Origin Policy on IE8 & Chrome
var domainString = "document.domain";
domainstring = "*.com"
'Access-Control-Allow-Origin: *.sap.com'
'Access-Control-Allow-Headers: X-KEY'
var ODataModel = sap.ui.model.odata.ODataModel
var salesOrderService =
"http://gw.esworkplace.sap.com/sap/opu/odata/sap/SALESORDERS/SOHeaders",
username = "GW@ESW",
password = "ESW4GW",
oModel = new sap.ui.model.odata.ODataModel("http://gw.esworkplace.sap.com/sap/opu/odata/sap/SALESORDERS/SOHeaders")
asJson = false,
salesOrderCollection = "SOHeader";
var salesDetailsTable = new sap.ui.table.DataTable({
title : "Available Sales Order",
width : "100%",
visibleRowCount : 5,
ExpandedVisibleRowCount : 20,
selectionMode : sap.ui.table.SelectionMode.Single,
editable : false
});
// connect the data table to the SalesOrder service
salesDetailsTable.setModel(oModel);
salesDetailsTable.bindRows("SOHeader");
//place table at the div element
salesDetailsTable.placeAt("salesorders");
What could be the issue here??
Appreciate any help.
Regards
Sandip
- SAP Managed Tags:
Accepted Solutions (1)
Answers (3)
No data is returned by the service. The error in IE console is 2013-01-04 09:39:38 The following problem occurred: HTTP request failed500
Abhilash, Simon
Thanks for your inputs
@Abhilash - I tried disabling SOP in chrome, but still it does not work. Interestingly, in chrome it does not even show some of the text/images which are placed in the HTML along with the code for Table.
In IE I can at least get the banner..
I tried debugging in Chrome using the developer tools, it points out to some syntax error bu its written in Chinese
Here is a screen shot
Simon - Tried accessing the tomcat using FQDN, but still the same problem. Added the following line in the Hosts file
# Local Tomcat Server
127.0.0.1 tomcat.local.com localhost
Still no luck..
Regards
Sandip
Hi Sandip,
So I had a bit of a play around and did some reading too: https://developer.mozilla.org/en/http_access_control I think what you are trying to do is not possible unless you have control over the gw.esworkplace.sap.com server - it is up to the server to decide what domains it will accept these type of requests from - you would have to configure the server to send back a
Access-Control-Allow-Origin: http://tomact.local.com
or something similar (* also works to all all). But you don't have access to so that. If your JS was being hosted in the same origin as the gw.esworkplace.sap.com server it would also work.
However I did get around it as Abhilash suggests. You can turn off the Same Origin Policy in chrome with the following command:
chrome.exe --disable-web-security
When I did that it gets around that problem (and move onto another!). It should work for you too. Make sure you close all other sessions of Chrome, navigate to the folder where Chrome.exe is located and run that command as above.
The next error I get is related to the format of the URL you use to get the list of sales orders:
Looks like it doesn't like that /SOHeaders isn't the last segment in the URL:
if you just get rid of the /SOHeader at the end it works:
Anyway over to you mate! Hope this helps you.
Cheers,
Simon
Ok..so finally I could make it to work ...
Interestingly the application works in IE only, but not Chrome or Firefox (And I dnt know why)...I did disable the SOP in Chrome but still....
Here are the screenshot of the UI5 app running in IE
Here are few things which I changed in the HTMl and JS
1) Added Suppress SOP script
//supress the Same Origin Policy on IE8 & Chrome
var domainString = "document.domain";
domainstring = "*.com"
'Access-Control-Allow-Origin: *.local.com'
'Access-Control-Allow-Headers: X-KEY'
2) Truncated the Gateway Service URL -
http://gw.esworkplace.sap.com/sap/opu/odata/sap/SALESORDERS
3) Tomcat Server is accessed using a FQDN ...
e.g. - http://tomcat.local.com:8080/sample_apps/fetchsalesorder.html
@Simon Kemp - Thanks for your inputs
@ Abhilash - Thanks for your help..The code snippet is inspired from your blog..
And the last, I still do not know why the same app does not work in Chrome and Firefox
Regards
Sandip
App completed..Some of the screen shots
| User | Count |
|---|---|
| 95 | |
| 13 | |
| 13 | |
| 11 | |
| 11 | |
| 7 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.