Web service integration question

A forum for discussing new installs or conversions from other software.
bking
Posts: 28
Joined: Thu Jan 13, 2011 9:40 am
Brief Company Description: http://www.gspnet.com - Full service Architect and Engineering firm
Deltek Vision Version: 6.1
Number of Employees: 700
Company Position: Manager of Information Systems
Number of Offices: 12
Year Vision Installed: 1999

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

User avatar
Gerald Cox
Site Admin
Posts: 549
Joined: Fri May 23, 2008 10:45 am
Company: Hurt & Proffitt, Inc.
Brief Company Description: We are primarily a Civil Engineering and Surveying firm that offers a few other supporting services. We upgraded to Vision from Advantage in 2005.
Deltek Vision Version: 5.1
Number of Employees: 70
Company Position: IT Director
Vision Modules: Accounting / Billing / Time & Expense / Payroll / CRM / Proposals / Planning
Number of Offices: 3
Year Vision Installed: 2005
Vision User Group: Richmond, VA

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.

bking
Posts: 28
Joined: Thu Jan 13, 2011 9:40 am
Brief Company Description: http://www.gspnet.com - Full service Architect and Engineering firm
Deltek Vision Version: 6.1
Number of Employees: 700
Company Position: Manager of Information Systems
Number of Offices: 12
Year Vision Installed: 1999

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

User avatar
Gerald Cox
Site Admin
Posts: 549
Joined: Fri May 23, 2008 10:45 am
Company: Hurt & Proffitt, Inc.
Brief Company Description: We are primarily a Civil Engineering and Surveying firm that offers a few other supporting services. We upgraded to Vision from Advantage in 2005.
Deltek Vision Version: 5.1
Number of Employees: 70
Company Position: IT Director
Vision Modules: Accounting / Billing / Time & Expense / Payroll / CRM / Proposals / Planning
Number of Offices: 3
Year Vision Installed: 2005
Vision User Group: Richmond, VA

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?

adil.naeem
Posts: 3
Joined: Thu Oct 06, 2011 6:47 am
Deltek Vision Version: 6.1
Number of Employees: 350
Company Position: System Analyst
Number of Offices: 0
Year Vision Installed: 2011

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

bking
Posts: 28
Joined: Thu Jan 13, 2011 9:40 am
Brief Company Description: http://www.gspnet.com - Full service Architect and Engineering firm
Deltek Vision Version: 6.1
Number of Employees: 700
Company Position: Manager of Information Systems
Number of Offices: 12
Year Vision Installed: 1999

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

adil.naeem
Posts: 3
Joined: Thu Oct 06, 2011 6:47 am
Deltek Vision Version: 6.1
Number of Employees: 350
Company Position: System Analyst
Number of Offices: 0
Year Vision Installed: 2011

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


Return to “Vision Implementation & Integration”

Who is online

Users browsing this forum: No registered users and 2 guests