SUP 2.1.3 & Web Service Basic Authentication Issue

[former_member220236]

Hi All,

I keep getting an error when try to get data from an Enterprise Webservice via SUP

The Web Service uses Basic Authentication

I have tested with SoapUI on my SUp server and i can

send requests and get responses back with no issues.

I have also tested using a standalone java applicat

ion and this also succeeds.

Here is the error I get from the "mlsrv_err.log" fi

le

E. 2012-12-05 13:55:13. <167672> [-10158] Exception thrown in method: 'public java.lang.String com.sybase.djc.mobilink.EventHandler.beginDownloadConnection(java.sql.Timestamp,java.lang.String)'. Error description: 'com.sybase.djc.SystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*'.
                        Stack trace: 'com.sybase.djc.SystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

                         at com.sybase.djc.mobilink.DownloadHandler.beginDownloadConnection(DownloadHandler.java:205)

                         at com.sybase.djc.mobilink.DownloadHandler_DJC.access$001(DownloadHandler_DJC.java:4)

                         at com.sybase.djc.mobilink.DownloadHandler_DJC$1.invoke(DownloadHandler_DJC.java:29)

                         at com.sybase.djc.transaction.TransactionManager.invokeNotSupported1(TransactionManager.java:670)

                         at com.sybase.djc.transaction.TransactionManager.invokeNotSupported(TransactionManager.java:632)

                         at com.sybase.djc.mobilink.DownloadHandler_DJC.beginDownloadConnection(DownloadHandler_DJC.java:43)

                         at com.sybase.djc.mobilink.EventHandler.beginDownloadConnection(EventHandler.java:721)

                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                         at java.lang.reflect.Method.invoke(Method.java:597)

                         at ianywhere.ml.script.MethodInfo.invoke(MethodInfo.java:11382)

                        Caused by: com.sybase.djc.SystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

                         at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:110)

                         at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:127)

                         at com.sybase.djc.mobilink.DownloadHandler.beginDownloadConnection(DownloadHandler.java:197)

                         ... 11 more

                        Caused by: com.sybase.djc.transaction.TransactionRolledbackSystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

                         at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:1011)

                         at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:747)

                         at com.sybase.djc.transaction.TransactionManager.invokeRequired(TransactionManager.java:1078)

                         at com.sybase.sup.server.mbs.SUPPackageUtil.invokeStatic(SUPPackageUtil.java:278)

                         at com.sybase.sup.server.mbs.SUPPackageUtil.invokeDBClassStaticMethod(SUPPackageUtil.java:102)

                         ... 13 more

                        Caused by: com.sybase.djc.SystemException: java.lang.reflect.InvocationTargetException

                         at com.sybase.sup.server.mbs.SUPPackageUtil$1.invoke(SUPPackageUtil.java:265)

                         at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:845)

                         ... 17 more

                        Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException

                         at com.sybase.vader.cache.CacheUtil.invokeWithDeadlockRetry(CacheUtil.java:613)

                         at com.sybase.vader.cache.SimpleRefreshManager.invokeWithDeadlockRetry(SimpleRefreshManager.java:1315)

                         at com.sybase.vader.cache.SimpleRefreshManager.refreshAsNeeded(SimpleRefreshManager.java:378)

                         at com.sybase.vader.cache.SimpleRefreshManager.refreshAsNeeded(SimpleRefreshManager.java:1242)

                         at com.sybase.vader.cache.CacheStatisticsRefreshManager.refreshAsNeeded(CacheStatisticsRefreshManager.java:204)

                         at com.sybase.vader.cache.CompositeRefreshManager.refreshAsNeeded(CompositeRefreshManager.java:138)

                         at com.sybase.vader.mms.DataServiceImpl.beforeDownload(DataServiceImpl.java:523)

                         at Airbus2.server.Airbus2DB.refreshCache(Airbus2DB.java:313)

                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                         at java.lang.reflect.Method.invoke(Method.java:597)

                         at com.sybase.sup.server.mbs.SUPPackageUtil$1.invoke(SUPPackageUtil.java:261)

                         ... 18 more

                        Caused by: java.lang.reflect.InvocationTargetException

                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                         at java.lang.reflect.Method.invoke(Method.java:597)

                         at com.sybase.vader.cache.CacheUtil.invokeWithDeadlockRetry(CacheUtil.java:557)

                         ... 30 more

                        Caused by: com.sybase.djc.transaction.TransactionRolledbackSystemException: com.sybase.djc.transaction.TransactionContext.*AnonymousTransaction*

                         at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:1011)

                         at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:747)

                         at com.sybase.vader.djc.environment.MmsDjcTransactionManager.invokeRequiresNew(MmsDjcTransactionManager.java:31)

                         at com.sybase.vader.cache.SimpleRefreshManager.internalRefreshAsNeeded(SimpleRefreshManager.java:495)

                         ... 35 more

                        Caused by: com.sybase.dataservices.DSException: org.apache.axis2.AxisFault: Transport error: 503 Error: Service Unavailable

                         at com.sybase.vader.da.ws.soap.SoapDSExceptionBuilder.newDSException(SoapDSExceptionBuilder.java:29)

                         at com.sybase.vader.da.ws.soap.SoapInteractionOperation.execute(SoapInteractionOperation.java:584)

                         at com.sybase.vader.statistics.MonitoringOperation.execute(MonitoringOperation.java:72)

                         at com.sybase.vader.service.interaction.BranchingInteractionOperation.getRootRecord(BranchingInteractionOperation.java:65)

                         at com.sybase.vader.service.interaction.BranchingInteractionOperation.execute(BranchingInteractionOperation.java:41)

                         at com.sybase.vader.core.vdb.interaction.InteractionQueryOperation.executeQuery(InteractionQueryOperation.java:53)

                         at com.sybase.vader.cache.VTFindAllQueryOperation.executeQuery(VTFindAllQueryOperation.java:20)

                         at com.sybase.vader.cache.PKMergeProcessor.executeCurrentQuery(PKMergeProcessor.java:308)

                         at com.sybase.vader.cache.PKMergeProcessor.actualAccumulateDeltas(PKMergeProcessor.java:385)

                         at com.sybase.vader.cache.PKMergeProcessor.accumulateDeltas(PKMergeProcessor.java:445)

                         at com.sybase.vader.cache.PKMergeProcessor.accumulateDeltas(PKMergeProcessor.java:738)

                         at com.sybase.vader.cache.MonitoringMergeProcessor.accumulateDeltas(MonitoringMergeProcessor.java:90)

                         at com.sybase.vader.cache.SimpleRefreshManager.accumulateDeltas(SimpleRefreshManager.java:1114)

                         at com.sybase.vader.cache.SimpleRefreshManager.refreshLoadGroup(SimpleRefreshManager.java:926)

                         at com.sybase.vader.cache.SimpleRefreshManager.refreshLoadGroups(SimpleRefreshManager.java:894)

                         at com.sybase.vader.cache.SimpleRefreshManager.access$600(SimpleRefreshManager.java:32)

                         at com.sybase.vader.cache.SimpleRefreshManager$2.invoke(SimpleRefreshManager.java:454)

                         at com.sybase.vader.djc.environment.MmsDjcTransactionManager.internalInvoke(MmsDjcTransactionManager.java:52)

                         at com.sybase.vader.djc.environment.MmsDjcTransactionManager.access$000(MmsDjcTransactionManager.java:13)

                         at com.sybase.vader.djc.environment.MmsDjcTransactionManager$1.invoke(MmsDjcTransactionManager.java:28)

                         at com.sybase.djc.transaction.TransactionManager.invokeRequiresNew(TransactionManager.java:845)

                         ... 38 more

                        Caused by: org.apache.axis2.AxisFault: Transport error: 503 Error: Service Unavailable

                         at org.apache.axis2.transport.http.HTTPSender.handleResponse(HTTPSender.java:310)

                         at org.apache.axis2.transport.http.HTTPSender.sendViaPost(HTTPSender.java:200)

                         at org.apache.axis2.transport.http.HTTPSender.send(HTTPSender.java:76)

                         at org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWithCommons(CommonsHTTPTransportSender.java:400)

                         at org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsHTTPTransportSender.java:225)

                         at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:435)

                         at org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperation.java:402)

                         at org.apache.axis2.description.OutInAxisOperationClient.executeImpl(OutInAxisOperation.java:229)

                         at org.apache.axis2.client.OperationClient.execute(OperationClient.java:165)

                         at com.sybase.vader.da.ws.soap.SoapInteractionOperation.execute(SoapInteractionOperation.java:523)

                         ... 57 more

Thanks in advance

Damien

[former_member220236 · Accepted solution]

Hi All,

So I finally resolved the issue by changing the user that the Sybase Unwired Services were running under.

The issue was realted to the user who installed SUP on the machine as it had a proxy set even tho I did not in my user account or on the SUP instance iteself. (ie. without a proxy set the system proxy for that user was being used)

By changing the user the service runs under, to my own the server can now send requests to the backend.

Thanks for everyone who chipped in with this one..

Regards

Damien

[Former Member · Accepted solution]

Damien, did you try looking at the Troubleshooting documentation at all during this problem? If you did, what were you hoping to find? Just trying to track this and see where we might refine the documentation based on this experience.

Any thoughts you can share would be great.

Cheers,

Annette

SUP Knowledge Management

[former_member220236]

Hi All,

Thanks for your help with this.

I managed to get some more information about why the request is failing from the logs

When I use the xml from the xxx-server.log

2012-12-10 12:55:38.321 DEBUG   DataServices Thread-284 [com.sybase.vader.da.ws.soap.SoapInteractionOperation] 54296810-42c0-11e2-8000-286abaec6739 supAdmin d1_airbus2.1_6_4 (Thread-284) com.sybase.vader.da.ws.soap.SoapInteractionOperation::execute:358 - Executing SOAP operation - service address [http://xxxxxxxxxxxxxxx/sap/bc/srt/xip/sap/ecc_maintreq003qr/716/ecc_maintreq003qr/elogbook_querynoti...], ...

...

com.sybase.vader.da.ws.soap.SoapInteractionOperation::execute:513 - Calling Web Service with SOAPEnvelope [<?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><MaintenanceRequestERPSimpleByElementsQuery_sync xmlns="http://sap.com/xi/EA-APPL/SE/Global" xmlns:ns1="http://sap.com/xi/EA-APPL/SE/Global"><MaintenanceRequestSimpleSelectionByElements xmlns=""><MaterialInternalID schemeID="" schemeAgencyID="" /><InstallationPointID schemeID="" schemeAgencyID="">N992AV</InstallationPointID><IndividualMaterialID schemeID="" schemeAgencyID="" /><ReporterInternalID schemeID="" schemeAgencyID="" /><TypeCode listID="" listAgencySchemeAgencyID="" listVersionID="" listAgencyID="" listAgencySchemeID="" /><RequestedProcessingPeriod /></MaintenanceRequestSimpleSelectionByElements><ProcessingConditions xmlns=""><LastProvidedMaintenanceRequestID schemeAgencyID="" /></ProcessingConditions></MaintenanceRequestERPSimpleByElementsQuery_sync></soapenv:Body></soapenv:Envelope>]

...

com.sybase.vader.da.ws.soap.SoapInteractionOperation::execute:582 - Fault Transport error: 503 Error: Service Unavailable

I get this response back from the server

<soap-env:Envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">

   <soap-env:Header>

      <soap-env:Upgrade>

         <soap-env:SupportedEnvelope qname="ns1:Envelope" xmlns:ns1="http://www.w3.org/2003/05/soap-envelope"/>

      </soap-env:Upgrade>

   </soap-env:Header>

   <soap-env:Body>

      <soap-env:Fault>

         <faultcode>soap-env:VersionMismatch</faultcode>

         <faultstring xml:lang="en">Wrong SOAP Version</faultstring>

         <detail/>

      </soap-env:Fault>

   </soap-env:Body>

</soap-env:Envelope>

It sounds like the backend web service is using an older Soap version which SUP does not support.

Does anyone know what version of Soap SUP uses?

I can see jar files for Axis 1.4 and Axis2.

I am in the process of finding out what version the backend uses also and will update accordingly.

Regards

Damien

[former_member10452]

Hi Damien,

From the log provided by you it looks like it's using Axis2.

Did you checked your web service properties mentioned at http://infocenter.sybase.com/help/index.jsp?docset=/com.sybase.infocenter.pubs.docset-SUP-2.1.3/doc/...

Regards,

Abhishek Joshi

[former_member220236]

Although the xml from the logs did not work once the proxy issue was sorted the requests worked fine so the above issue with Soap versions way a bit of a red herring..

[former_member10452]

Hi Damien,

I hope you configured HTTPAuthenticationLoginModule Authentication module for your security profile used for your webservice correctly under security? It would be nice if you can provide a snap of it for deeper look.

OR please let me know which security module you configured for your webservice.

Regards,

Abhishek Joshi

[sujith_prathap]

Hi Damien,

                  What are the headers that you pass in the request to get your data ?

Best Regards,

Sujith