I wanna use Web service via MSSQL2005 Stored Procedure on VC7.1 But I can't

[Former Member]

I want to use Web service in VC.

Stored Procedure (MS SQL 2005) was wrapped Web service.

WSDL URL : http://*******************************/Service1.asmx?wsdl

Procedure:

1. epportalURL/nwa -> SOA Management -> Destination Template Management -> Create destination!

2.

Destination Type : WSDL

Destination name : ****

URL : http://*******************************/Service1.asmx?wsdl

3.

Authentication : HTTP Authentication

User ID/PW(Basic)

Details - OK!

But I can' t call Web service in VC 7.1

Error Message : Error in search : Result is of type string.

Please Help Me!!

Edited by: Kang Min Shim on Jun 25, 2008 7:11 AM

Edited by: Kang Min Shim on Jun 25, 2008 7:12 AM

[richard_hirsch]

Hi,

What is the exact exception in the trace file? There are some types of web-services that can't be called from VC.

Dick

[Former Member]

Thanks For your reply^^;;

You say :

What is the exact exception in the trace file? There are some types of web-services that can't be called from VC.

And.

How exact exception in the trace file? I don't know.

And What types of webservice that can't be called from VC?

Thank you.

[richard_hirsch]

Hi,

Look at the logging using the NWA under "Problem Resolution tab".

Look at note SAP Note 1004108 for restrictions in the use of CE.

Dick

[Former Member]

Oh. Thank you.

I'm sorry But I don't know where my log..^^

Finally Stored Procedure was wrapped Web service, this uses not possible???

[richard_hirsch]

Go to http:[servername]:[port]/nwa. That is the NetWeaver Administrator. You will find the logs there

[Former Member]

Thank you^^ I find log.

Log 1.

Message: [VC-DevServer][error in search WebServicesProvider/kmshim_webservice_test]<Localization failed: ResourceBundle='com.sap.ds.core.exceptions.DevserverMessages', ID='SystemHandler#search: Could not find the functions metadata', Arguments: []> : Can't find resource for bundle java.util.PropertyResourceBundle, key SystemHandler#search: Could not find the functions metadata

Date: 2008-06-25

Time: 15:47:24:559

Category: com.sap.search.SearchService

Location: com.sap.search.SearchService

Application: sap.com/VisualComposerServerEar05

Thread: HTTP Worker [1]

Data Source: j2ee\cluster\server0\log\defaultTrace_00.trc

Correlator ID: 240496500000034258

Argument Objects:

Arguments:

DSR Component: n.a.

DSR Transaction: 43f0a6e0427311dda99c001e4f3b8fcb

DSR User:

Message Code:

Session: 8175

Transaction:

User: IT2

Host: EPP

System: CEP

Instance: J02

Node: server0

Log2

Message: SystemHandler: search in system: kmshim_webservice_test ,function expression : * ,object expression: null failed. Reason: 메타데이터를 검색할 수 없습니다.

Date: 2008-06-25

Time: 15:47:24:559

Category: com.sap.vc.bcksrv

Location: com.sap.vc.bcksrv

Application: sap.com/VisualComposerServerEar05

Thread: HTTP Worker [1]

Data Source: j2ee\cluster\server0\log\defaultTrace_00.trc

Correlator ID: 240496500000034258

Argument Objects:

Arguments:

DSR Component: n.a.

DSR Transaction: 43f0a6e0427311dda99c001e4f3b8fcb

DSR User:

Message Code:

Session: 8175

Transaction:

User: IT2

Host: EPP

System: CEP

Instance: J02

Node: server0

I don't know why Error Occured Plz help me^^

[Former Member]

Hi Kang,

Does your web service work with other Web service testing tools like Strike Iron or SOAP UI (both are free for download)?

Best regards,

Dharmi

p.s. I never got WSDL working from VC and it did work with other tools but not in the tabular / normal format ....