1 Reply Latest reply: Feb 20, 2012 12:45 AM by 914616 RSS

    ProSight 8.0 Bridge to P6 Connection Problem - Update 1- Update2 - SOLVED

    718309
      SOLVED: The problem was that despite the deprecation in web services documentation  of "cookies for session management" authentication mode, the bridge to P6 needs this authentication mode in the web services sides to work!


      Hi,
      I am testing the new ProSight 8.0 and I am experiencing problems with the connection to P6 7.0.

      The short log is: Primavera P6 Server 'http://h103sv02:8380/p6ws/services' could not be accessed with username 'admin'. Please verify the username and password configured are correct

      The long log is below. The webservices demo connect properly to the same server.

      Is there some suggestion?

      The log in the web services reports a problem in the ws security header:


      Caused by: org.apache.ws.security.WSSecurityException: An error was discovered processing the <wsse:Security> header
           at org.apache.cxf.ws.security.wss4j.WSS4JInInterceptor.handleMessage(WSS4JInInterceptor.java:200)
           ... 30 more
      22:16:35,251 ERROR [STDERR] Mar 5, 2010 10:16:35 PM org.apache.cxf.interceptor.LoggingOutInterceptor$LoggingCallback onClose
      INFO: Outbound Message
      ---------------------------
      ID: 7
      Encoding: UTF-8
      Content-Type: text/xml
      Headers: {}
      Payload: <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><soap:Fault><faultcode xmlns:ns1="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">ns1:InvalidSecurity</faultcode><faultstring>An error was discovered processing the &lt;wsse:Security> header</faultstring></soap:Fault></soap:Body></soap:Envelope>
      --------------------------------------
      22:16:35,861 ERROR [STDERR] Mar 5, 2010 10:16:35 PM org.apache.cxf.interceptor.LoggingInInterceptor logging
      INFO: Inbound Message
      ----------------------------
      ID: 8
      Address: /p6ws/services/EPSService
      Encoding: UTF-8
      Content-Type: text/xml; charset=utf-8
      Headers: {expect=[100-continue], content-type=[text/xml; charset=utf-8], host=[h103sv02:8380], content-length=[379], SOAPAction=["ReadEPS"], user-agent=[Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.3603)], Content-Type=[text/xml; charset=utf-8]}
      Payload: <?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><ReadEPS xmlns="http://xmlns.oracle.com/Primavera/P6/V7/WS/EPS"><Field>ObjectId</Field><Field>Name</Field><Field>Id</Field></ReadEPS></soap:Body></soap:Envelope>
      --------------------------------------
      22:16:35,908 ERROR [STDERR] Mar 5, 2010 10:16:35 PM org.apache.cxf.ws.security.wss4j.WSS4JInInterceptor handleMessage
      WARNING: Request does not contain required Security header


      Thanks
      Fabio D'Alfonso

      UPDATE: I saw many other messages in the logs of this type so the problem was not only with the bridge. So I uninstalled the prosight (that test was based on a distributed setup with database on Oracle 10.2.0.4 on windows 2003 Sp2 and Prosight on a different windows 2003 (with all prerequisites, it seemed to me satisfied).
      I reinstallled PS8 on a single 2003 server with sql server 2005 (so with no interaction with OracleMTS ) and this standalone setup does not show the described behaviour, also if the bridge still have problems.

      Found this in readme.htm
      Integration with project management systems (Optional):
      =====================================================

      Primavera P6 Enterprise Project Portfolio management
           

      Primavera P6 Version 7.0 components:
      Project and methodology management applications

      Job service

      Web services

      So 7.0 is not only supported but required.



      Version: 8.0.8374
      File name: /ProSight/msProject/p6Wizard.aspx
      Stack trace: at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.handleException(Exception iEx, String iAddionalMsg)
      at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean, Boolean iDisableTransaction)
      at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTransactionalScenarioInterface.invokeTS(String className, String methodName, Object[] parameters, Int32 maxRetries, Int32 minRetryWait, psResultContainer containerToClean)
      at ProSight.Portfolios.BusinessLogic.TS.TransactionalScenarioInterface.psTSIMSPBridge.updateServer(Int32 iUserID, Int32 iServerID, String iName, String iDescription, String iURL, String iMSPLogin, String iMSPPassword, Int32 iAuthenticationType, String iRDBServerName, String iRDBName, String iInterfaceURL)
      at ProSight.Portfolios.BusinessLogic.Flows.MSPBridge.psMSPBridgeFlows.editServer(Int32 iUserID, Int32 iServerID, String iName, String iDescription, String iURL, String iMSPLogin, String iMSPPassword, Int32 iAuthenticationType, String iRDBServerName, String iRDBName, String iInterfaceURL)
      at ProSight.Portfolios.Server.Presentation.Logic.Bridge.BridgeGUIFacade.SaveChanges(Boolean FullSave)
      at ProSight.Portfolios.Server.Presentation.Logic.Bridge.GeneralStepState.SaveConnectionDetails()
      at ProSight.Portfolios.Server.Presentation.Logic.Bridge.GeneralStepState.TestServerConnection(Object sender, EventArgs e)
      at ProSight.Portfolios.Server.Presentation.Controls.psClientFakeButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
      at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
      at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
      Error code: -1