This discussion is archived
1 Reply Latest reply: Feb 19, 2012 10:45 PM by 914616 RSS

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

718309 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points