cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ERP Order Status App : Http 400 Bad Request Error

Former Member
0 Kudos

Hello Experts,

Currently i am installing sap erp order status app.

When i search for sales order or customers,I get HTTP 400 code bad request.

Please find the sup server log below.

2013-01-28 19:45:09.757 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response code is HTTP/1.1 400 Bad Request

2013-01-28 19:45:09.757 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP:Recieved the response from the gateway

2013-01-28 19:45:09.757 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Finished firing the request to GW-----------

2013-01-28 19:45:09.757 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Leaving FireRequest Method-----------

2013-01-28 19:45:09.756 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Finished Execute-----------

2013-01-28 19:45:09.547 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Before Execute-----------

2013-01-28 19:45:09.546 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP: Firing the request to the Gateway

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----Host request header set is ----ntbomsap24.corp.capgemini.com:8010

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept    value=application/xml

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Content-Type    value=application/atom+xml

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept-Encoding    value=gzip

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=X-Requested-With    value=XMLHttpRequest

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Authorization    value= Not printed for security reasons

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept-Language    value=en

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----------In GWProxy fireRequest()----------

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------About to fire the request to the GW-----------

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-----Leaving getConnection() of GWCConnectionPoolManager-- Found in cache first time----

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Flag value is (1)true

2013-01-28 19:45:09.546 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Address to which connection object has to be assigned is:http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/SalesOrderCollection?$filter=OrderNo+eq+'5187*'+AND+MAXSEL+EQ+50

2013-01-28 19:45:09.545 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Inside getConnection() of GWCConnectionPoolManager

2013-01-28 19:45:09.545 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]Pm is not null

2013-01-28 19:45:09.545 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]---------In getconnection() method of Connection Factory--------

2013-01-28 19:45:09.545 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----Application Id sent from client is--------com.sap.bsuite.erp.ops.orderstatus

2013-01-28 19:45:09.543 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----------In GWProxy handle()----------

2013-01-28 19:45:09.543 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]----------Leaving GWCRequestAdapter constructor()----------

2013-01-28 19:45:09.543 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]AppId got is POCDevelopment_com.sap.bsuite.erp.ops.orderstatus_POCDevelopment_HttpAuth_proxy

2013-01-28 19:45:09.542 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]Json Request header : [{"X-SAP-applicationId":"com.sap.bsuite.erp.ops.orderstatus"},{"request":"GET"},{"url":"http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/SalesOrderCollection?$filter=OrderNo+eq+'5187*'+AND+MAXSEL+EQ+50"},{"Accept-Encoding":"gzip"},{"X-Requested-With":"XMLHttpRequest"},{"Content-Type":"application/atom+xml"},{"Accept":"application/xml"},{"Accept-Language":"en"}]

2013-01-28 19:45:09.541 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]context.getDeviceUserName() is saperporder

2013-01-28 19:45:09.541 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]Request header : [{"X-SAP-applicationId":"com.sap.bsuite.erp.ops.orderstatus"},{"request":"GET"},{"url":"http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/SalesOrderCollection?$filter=OrderNo+eq+'5187*'+AND+MAXSEL+EQ+50"},{"Accept-Encoding":"gzip"},{"X-Requested-With":"XMLHttpRequest"},{"Content-Type":"application/atom+xml"},{"Accept":"application/xml"},{"Accept-Language":"en"}]

2013-01-28 19:45:09.541 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]Request body Read :

2013-01-28 19:45:09.541 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]ODP: Read the Request information

2013-01-28 19:45:09.541 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]UsrName/Pwd is extracted from context:

2013-01-28 19:45:09.541 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]----------In GWCRequestAdapter constructor()----------

2013-01-28 19:45:09.537 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GatewayConnectorHandler]ODP :Recieved a request to fire to Gateway

2013-01-28 19:45:08.977 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GatewayConnectorHandler]ODP:Returning Response from Gateway Back to Message Channel

2013-01-28 19:45:08.976 DEBUG PROXY Thread-290 [com.sybase.suplite.gwc.req.util.domainReqRespLogHandler]Inside Domain Logger for ReqResp

2013-01-28 19:45:08.975 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Connection released

2013-01-28 19:45:08.975 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-----Inside releaseConnection() of GWCConnectionPoolManager------

2013-01-28 19:45:08.975 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]---------In releaseconnection() method of Connection Factory--------

2013-01-28 19:45:08.973 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response Body is written into OutputStream

2013-01-28 19:45:08.973 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]------In writing response method-----

2013-01-28 19:45:08.973 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response body is obtained from BackEnd

2013-01-28 19:45:08.973 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP:Read response body from Gateway

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]------------content encoding is ZIP ----------gzip

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]------------content type|encoding|length--------application/xml----gzip----1467----

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keyset-cookie          Response header valueMYSAPSSO2=AjQxMDMBABhBAFcAQQBKAEcARQAgACAAIAAgACAAIAACAAY0ADAAMAADABBHADEAMAAgACAAIAAgACAABAAYMgAwADEAMwAwADEAMgA4ADEANAAxADUABQAEAAAACAYAAlgACQACRQD%2fAPowgfcGCSqGSIb3DQEHAqCB6TCB5gIBATELMAkGBSsOAwIaBQAwCwYJKoZIhvcNAQcBMYHGMIHDAgEBMBkwDjEMMAoGA1UEAxMDRzEwAgcgEgcJFgI3MAkGBSsOAwIaBQCgXTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xMzAxMjgxNDE1MDhaMCMGCSqGSIb3DQEJBDEWBBS3ObzaNWdrChtgUAc%21D1o5s7gr%2fDAJBgcqhkjOOAQDBC4wLAIUBikt3FbMSoVn5hUSJwiGRq1plGsCFF%2fcR3vQbF2l1nbgm0lYHMr2Evwa; path=/; domain=.corp.capgemini.com

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keycontent-type          Response header valueapplication/xml

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keycontent-encoding          Response header valuegzip

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keycontent-length          Response header value1467

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keydataserviceversion          Response header value2.0

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keyserver          Response header valueSAP NetWeaver Application Server / ABAP 702

2013-01-28 19:45:08.971 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response code is HTTP/1.1 200 OK

2013-01-28 19:45:08.971 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP:Recieved the response from the gateway

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Finished firing the request to GW-----------

2013-01-28 19:45:08.971 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Leaving FireRequest Method-----------

2013-01-28 19:45:08.970 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Finished Execute-----------

2013-01-28 19:45:08.837 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Before Execute-----------

2013-01-28 19:45:08.837 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP: Firing the request to the Gateway

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----Host request header set is ----<host>:8010

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept    value=application/xml

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Content-Type    value=application/atom+xml

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept-Encoding    value=gzip

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=X-Requested-With    value=XMLHttpRequest

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Authorization    value= Not printed for security reasons

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept-Language    value=en

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----------In GWProxy fireRequest()----------

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------About to fire the request to the GW-----------

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-----Leaving getConnection() of GWCConnectionPoolManager-- Found in cache first time----

2013-01-28 19:45:08.836 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Flag value is (1)true

2013-01-28 19:45:08.835 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Address to which connection object has to be assigned is:http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/$metadata

2013-01-28 19:45:08.835 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Inside getConnection() of GWCConnectionPoolManager

2013-01-28 19:45:08.835 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]Pm is not null

2013-01-28 19:45:08.835 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]---------In getconnection() method of Connection Factory--------

2013-01-28 19:45:08.835 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----Application Id sent from client is--------com.sap.bsuite.erp.ops.orderstatus

2013-01-28 19:45:08.834 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----------In GWProxy handle()----------

2013-01-28 19:45:08.834 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]----------Leaving GWCRequestAdapter constructor()----------

2013-01-28 19:45:08.833 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]AppId got is POCDevelopment_com.sap.bsuite.erp.ops.orderstatus_POCDevelopment_HttpAuth_proxy

2013-01-28 19:45:08.833 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]Json Request header : [{"X-SAP-applicationId":"com.sap.bsuite.erp.ops.orderstatus"},{"request":"GET"},{"url":"http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/$metadata"},{"Accept-Encoding":"gzip"},{"X-Requested-With":"XMLHttpRequest"},{"Content-Type":"application/atom+xml"},{"Accept":"application/xml"},{"Accept-Language":"en"}]

2013-01-28 19:45:08.832 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]context.getDeviceUserName() is saperporder

2013-01-28 19:45:08.832 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]Request header : [{"X-SAP-applicationId":"com.sap.bsuite.erp.ops.orderstatus"},{"request":"GET"},{"url":"http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/$metadata"},{"Accept-Encoding":"gzip"},{"X-Requested-With":"XMLHttpRequest"},{"Content-Type":"application/atom+xml"},{"Accept":"application/xml"},{"Accept-Language":"en"}]

2013-01-28 19:45:08.832 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]Request body Read :

2013-01-28 19:45:08.832 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]ODP: Read the Request information

2013-01-28 19:45:08.832 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]UsrName/Pwd is extracted from context:

2013-01-28 19:45:08.832 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCRequestAdapter]----------In GWCRequestAdapter constructor()----------

2013-01-28 19:45:08.828 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GatewayConnectorHandler]ODP :Recieved a request to fire to Gateway

2013-01-28 19:45:08.282 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GatewayConnectorHandler]ODP:Returning Response from Gateway Back to Message Channel

2013-01-28 19:45:08.280 DEBUG PROXY Thread-288 [com.sybase.suplite.gwc.req.util.domainReqRespLogHandler]Inside Domain Logger for ReqResp

2013-01-28 19:45:08.279 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Connection released

2013-01-28 19:45:08.279 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-----Inside releaseConnection() of GWCConnectionPoolManager------

2013-01-28 19:45:08.279 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]---------In releaseconnection() method of Connection Factory--------

2013-01-28 19:45:08.275 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response Body is written into OutputStream

2013-01-28 19:45:08.274 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]------In writing response method-----

2013-01-28 19:45:08.274 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response body is obtained from BackEnd

2013-01-28 19:45:08.274 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP:Read response body from Gateway

2013-01-28 19:45:08.272 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]------------content encoding is ZIP ----------gzip

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]------------content type|encoding|length--------application/xml----gzip----435----

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keyset-cookie          Response header valueMYSAPSSO2=AjQxMDMBABhBAFcAQQBKAEcARQAgACAAIAAgACAAIAACAAY0ADAAMAADABBHADEAMAAgACAAIAAgACAABAAYMgAwADEAMwAwADEAMgA4ADEANAAxADUABQAEAAAACAYAAlgACQACRQD%2fAPswgfgGCSqGSIb3DQEHAqCB6jCB5wIBATELMAkGBSsOAwIaBQAwCwYJKoZIhvcNAQcBMYHHMIHEAgEBMBkwDjEMMAoGA1UEAxMDRzEwAgcgEgcJFgI3MAkGBSsOAwIaBQCgXTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0xMzAxMjgxNDE1MDdaMCMGCSqGSIb3DQEJBDEWBBS3ObzaNWdrChtgUAc%21D1o5s7gr%2fDAJBgcqhkjOOAQDBC8wLQIVAJ66%21ASbyinmGUhNmXntZcNQouCeAhQqBx8vq8JQifiet2QxNBvhGsRwMQ%3d%3d; path=/; domain=.corp.capgemini.com

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keycontent-type          Response header valueapplication/xml

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keycontent-encoding          Response header valuegzip

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keycontent-length          Response header value435

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keydataserviceversion          Response header value2.0

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response header keyserver          Response header valueSAP NetWeaver Application Server / ABAP 702

2013-01-28 19:45:08.271 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]Response code is HTTP/1.1 200 OK

2013-01-28 19:45:08.271 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP:Recieved the response from the gateway

2013-01-28 19:45:08.271 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Finished firing the request to GW-----------

2013-01-28 19:45:08.270 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Leaving FireRequest Method-----------

2013-01-28 19:45:08.270 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Finished Execute-----------

2013-01-28 19:45:08.162 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------Before Execute-----------

2013-01-28 19:45:08.161 INFO PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]ODP: Firing the request to the Gateway

2013-01-28 19:45:08.161 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----Host request header set is ----<host>:8010

2013-01-28 19:45:08.161 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept    value=application/xml

2013-01-28 19:45:08.161 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Content-Type    value=application/atom+xml

2013-01-28 19:45:08.161 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept-Encoding    value=gzip

2013-01-28 19:45:08.161 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=X-Requested-With    value=XMLHttpRequest

2013-01-28 19:45:08.161 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Authorization    value= Not printed for security reasons

2013-01-28 19:45:08.161 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]header: key=Accept-Language    value=en

2013-01-28 19:45:08.150 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]----------In GWProxy fireRequest()----------

2013-01-28 19:45:08.149 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWProxy]--------------About to fire the request to the GW-----------

2013-01-28 19:45:08.083 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-----Leaving getConnection() of GWCConnectionPoolManager-- Found in cache first time----

2013-01-28 19:45:08.051 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Flag value is (1)true

2013-01-28 19:45:08.051 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Address to which connection object has to be assigned is:http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/

2013-01-28 19:45:08.051 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]Inside getConnection() of GWCConnectionPoolManager

2013-01-28 19:45:08.051 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]Pm is not null

2013-01-28 19:45:08.051 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.ConnectionFactory]---------In getconnection() method of Connection Factory--------

2013-01-28 19:45:08.048 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-------Exiting static block of GWCConnectionPoolManager-----------

2013-01-28 19:45:08.047 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]------Initialised everything-------

2013-01-28 19:45:08.041 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-------created a new instance of GWCConnectionPoolManager()--------

2013-01-28 19:45:08.012 DEBUG PROXY MessageChannel Thread-304 [com.sybase.suplite.gwc.req.handler.GWCConnectionPoolManager]-------Preparing the cache for pooling config--------

Url which is giving 400 bad request is :

http://<host>:8010/sap/opu/odata/sap/LWMSD_ORDERSTATUS/SalesOrderCollection?$filter=OrderNo+eq+'5187*'+AND+MAXSEL+EQ+50.

When i run the same url from rest client,It gives the same error(400 bad request) with description saying "Property OrderNo and MAXSEL not found in type SalesOrder".

Now the problem is in metadata under SalesOrder there is no property with name "OrderNo" instead of that it has "SalesOrderNo" Also MAXSEL property is not exist in metadata file.

Its really a weird problem and seems to be a bug kind of thing.

Can anyone guide me on this.

Any help would be appreciated.

Regards,

Abhishek Wajge

Accepted Solutions (0)

Answers (1)

Answers (1)

rohith_deraje
Advisor
Advisor
0 Kudos

Hi Abhishek,

May be you can post this query at gateway forum http://scn.sap.com/community/netweaver-gateway.

Since this is more of a gateway issue, you can get attention of gateway experts.

Regards

Rohith

Former Member
0 Kudos

Hi Rohith,

I don't find any problem in gateway services.

I checked all the services and all r working fine.

Formation of URL from sup side itself is not proper.Service document and metadata URL gives 200 success code but when i search for sales order Number from device,sup forms a URL to search that particular sales-order and that is not a valid URL.

I think have to raise oss for this issue.

Regards,

Abhishek Wajge

rohith_deraje
Advisor
Advisor
0 Kudos

Hi Abhishek,

Since you are using a standard application, the URL constructed from application should be the right one. However gateway is not able to interpret the filter parameters passed in this URL. So I suggested you to post this query in gateway forum.

By the way, you did not reply to my previous question in thread http://scn.sap.com/thread/3294359. I am curious to know how did you solve this problem.

Regards

Rohith

Former Member
0 Kudos

Hi Rohith,

I replied to Arfan's question in thread http://scn.sap.com/thread/3294359 and answer is also there.

.

Please check once if you still not get it,I will post again.

Regards,

Abhishek Wajge