Web service integration question

A forum for discussing new installs or conversions from other software.

Web service integration question

Postby bking » Mon Sep 19, 2011 11:29 am

We have some custom web service inegration setup between our HR package and Vision under 5.1 .. I have recently upgrade to 6.1 and trying to setup the integration again. and the HR server is reporting unauthorized access when attempting to access the Vision Web service.


Code: Select all
The web service, http://visionserver/vision/VisionWS.asmx encountered an error: (The request failed with HTTP status 401: Unauthorized.).
ConnectionInfo=<VisionConnInfo><databaseDescription>GSP</databaseDescription><userName>********</userName><userPassword>*********</userPassword><integratedSecurity>N</integratedSecurity></VisionConnInfo>



However, if I take the connection string in the error log and go to the vision service and paste the same string in it will authenticate and return results via here:
http://localhost/Vision/VisionWS.asmx?op=GetSystemInfo

Am i missing something that allows the web services to communicate ?
Gresham, Smith, and Partners
Manager of Information Systems
http://www.gspnet.com
bking
 
Posts: 27
Joined: Thu Jan 13, 2011 9:40 am

Re: Web service integration question

Postby Gerald Cox » Mon Sep 19, 2011 11:38 am

It sounds like Anonymous access is disabled in IIS for the web service and that the account used to access the web service doesn't have permissions. Make sure that your services are running under the same account credentials as your 5.1 install and that IIS is setup with the same permissions as well.
User avatar
Gerald Cox
Site Admin
 
Posts: 549
Joined: Fri May 23, 2008 10:45 am

Re: Web service integration question

Postby bking » Mon Sep 19, 2011 12:30 pm

Thanks gerald you are correct! I created a new application in IIS and enabled Anonymous and disbaled integrated and now it calls the web service.

However I have a new error now that they are actually on speaking terms. I am trying to get a capture of what the HR app is actually posting to the service to see if it is coordinance with 6.1 web services.

Code: Select all
_________________________________
System.Web.Services.Protocols.SoapException: The request element <SendDataToDeltekVision xmlns='http://tempuri.org/Deltek.Vision.WebServiceAPI/Service1'> was not recognized.
   at System.Web.Services.Protocols.Soap11ServerProtocolHelper.RouteRequest()
   at System.Web.Services.Protocols.SoapServerProtocol.RouteRequest(SoapServerMessage message)
   at System.Web.Services.Protocols.SoapServerProtocol.Initialize()
   at System.Web.Services.Protocols.ServerProtocol.SetContext(Type type, HttpContext context, HttpRequest request, HttpResponse response)
   at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)
_________________________________
   at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
   at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
   at DeltekVisionEmpHandler.DeltekVisionEmpWebService.DeltekVisionOpenAPIWebService.SendDataToDeltekVision(String InfoCenter, String ConnInfoXML, String DataXML)
   at DeltekVisionEmpHandler.DeltekVisionEmp.ExportData(String personGuid, String action, XmlDocument dataDoc, XmlDocument authDoc, String webServiceURL, Int32 maxResponseTime)
   at IVantageWebServiceClient.WSECWorker.handleExport(String exportType, String personGuid, String action, XmlDocument dataDoc, XmlDocument authdoc, String webServiceURL, Int32 maxResponseTime)
   at IVantageWebServiceClient.WSECWorker.processExports()
   at IVantageWebServiceClient.WSECWorker.Startup()
_________________________________
Gresham, Smith, and Partners
Manager of Information Systems
http://www.gspnet.com
bking
 
Posts: 27
Joined: Thu Jan 13, 2011 9:40 am

Re: Web service integration question

Postby Gerald Cox » Mon Sep 19, 2011 12:57 pm

I'm not sure. We're about at the ceiling of my web service knowledge. Does it have anything to do with the tempuri.org URL in that error message?
User avatar
Gerald Cox
Site Admin
 
Posts: 549
Joined: Fri May 23, 2008 10:45 am

Re: Web service integration question

Postby adil.naeem » Thu Oct 13, 2011 5:32 am

bking wrote:We have some custom web service inegration setup between our HR package and Vision under 5.1 .. I have recently upgrade to 6.1 and trying to setup the integration again. and the HR server is reporting unauthorized access when attempting to access the Vision Web service.


Code: Select all
The web service, http://visionserver/vision/VisionWS.asmx encountered an error: (The request failed with HTTP status 401: Unauthorized.).
ConnectionInfo=<VisionConnInfo><databaseDescription>GSP</databaseDescription><userName>********</userName><userPassword>*********</userPassword><integratedSecurity>N</integratedSecurity></VisionConnInfo>



However, if I take the connection string in the error log and go to the vision service and paste the same string in it will authenticate and return results via here:
http://localhost/Vision/VisionWS.asmx?op=GetSystemInfo

Am i missing something that allows the web services to communicate ?


Hi
can you please share with me how you have integrated your deltek system with your HR system?
Actualy I am also working in this but am getting problem how to create employee through webservice in vision? can you please share with the code and other stuff

Regards
adil.naeem
 
Posts: 3
Joined: Thu Oct 06, 2011 6:47 am

Re: Web service integration question

Postby bking » Fri Oct 14, 2011 9:15 am

What part are you having trouble with ?

Out setup is an event handler on our HR system ( iVantage ) works in conjunction with a trigger on the employee table in the ivantage DB. The trigger creates the XML string that gets submitted to the Vision INPUT web service.

The documentation on from Deltek is pretty good on how to craft the XML to submit to the web service.

The big gotcha for me when I forst started using INPUT was in the Authentication string I would always try to use an AD account. Once i realized it was looking for an actual Vision user account and password things went smoother :)
Gresham, Smith, and Partners
Manager of Information Systems
http://www.gspnet.com
bking
 
Posts: 27
Joined: Thu Jan 13, 2011 9:40 am

Re: Web service integration question

Postby adil.naeem » Thu Jan 19, 2012 6:08 am

Hi

I am having trouble in generating employee XML. I need to sync my employee infocenter with our hr

Regards
Adil
adil.naeem
 
Posts: 3
Joined: Thu Oct 06, 2011 6:47 am


Return to Vision Implementation & Integration

Who is online

Users browsing this forum: No registered users and 1 guest