8 Replies Latest reply on Aug 13, 2013 8:10 AM by Gregor

    Access PI throught PI DataLink gives us the error "key not found in service directory"

    IPCOSRumaila

      Hi,

       

      we have a strange problem over here, We have a PI server and a PI/AF server. We can access PI-points from the PI/AF server. We can access PI-points through PI CoreSight.  But when we want to access these PI-Points through the PI DataLink plugin. We get the following error:  "key not found in service directory:  <server>". If we access the PI-point through PI/AF, or directly from PI, it does not make much difference, we get the same error.  This error is not mentioned in the PI Datalink Manual, so it comes from another level?

       

      Any clue on what this means, or a hint on where to look at for investing the problem will be much appreciated!

       

      Regards,

       

      Denis

        • Re: Access PI throught PI DataLink gives us the error "key not found in service directory"

          Hello Denis,

           

          My guess is a limitation with the privileges you are connecting with. If I am not mistaken, you should see "No read access secure object" in the PI Server's PI Message Log.

           

          Please look at PI Network Manager statistics (PI SMT -> Operation -> Network Manager Statistics) to see the credentials for your client machine connection (you need to scroll to the right hand site of the table). I assume further that PI Identity showing with the connection doesn't have read access to the Points table (see also PI SMT -> Security - Database Security -> PIPOINT). There may also be other privileges missing.

            • Re: Access PI throught PI DataLink gives us the error "key not found in service directory"
              IPCOSRumaila

              Hi,

               

              thanks for the quick reply! I looked at the logs and access statistics and now I'm even more puzzled! From the PI -Server side it looks like all access is perfectly OK! But unfortunately the data does not show up at the Excel-side! Instead we get the error mentioned above.

               

              In the Message log I get:

               

              09/08/2013 15:53:59.604, 7039, Information, Connection accepted:     Process name:  EXCEL.EXE(9700):remote(9700) ID: 762, pinetmgr, , , , , , , , , , ,

               

              09/08/2013 15:53:13.80602, 7080, Information, New Connection ID: 762 ; Process name: EXCEL.EXE(9700):remote(9700) ; User: piadmins | piusers | PIWorld ; OS User: IPCOSRUMAILA\Denis Gauder ; Hostname: ; IP: 10.0.0.113 ; AppID: 18 ; AppName: DataLink, pinetmgr, , , , , , , , , , ,

               

              09/08/2013 15:53:13.80602, 7082, Debug, Successful login  ID: 762. Address: 10.0.0.113. Name: EXCEL.EXE(9700):remote. Identity List: piadmins | piusers | PIWorld. Environment Username : IPCOSRUMAILA\Denis Gauder. Method: Windows Login (SSPI,Kerberos), pinetmgr, , , , , , , , , , ,

               

              09/08/2013 15:53:13.791, 7039, Information, Connection accepted:     Process name:  EXCEL.EXE(9700):remote(9700) ID: 762, pinetmgr, , , , , , , , , , ,

               

              For a connection from Pi-Explorer there are very similar messages except that the AppID is 18 in case of Data Link  and AppID is 635/737 in case of PI Explorer.

               

              In SMT-> Operation->Network Manager Statistics I get:

               

              For similar data requests the DataLink connection  has successfully sent 54584 bytes in 16 packaged and received  3620 bytes in 20 messages

               

              And for the PI Explorer connection is has sent 50466 bytes in 12 messages and received 3081 bytes in 15 messages.

               

              In DataLink we can successfully interrogate data stored in Linked tables and access via a Custom Data Reference.

               

              Maybe some incompatibility between DataLink and the PI-server ?

               

              Version of PI Server is 2012

               

              Versioning of PI DataLink is:

               

              Version 5.0.0

               

                   mscorlib     4.0.0.0     4.0.30319.1008 (RTMGDR.030319-1000)

               

                   Microsoft.VisualStudio.Tools.Office.Runtime     10.0.0.0     10.0.40305.0

               

                   System.Core     4.0.0.0     4.0.30319.233 built by: RTMGDR

               

                   System     4.0.0.0     4.0.30319.1001 built by: RTMGDR

               

                   System.Configuration     4.0.0.0     4.0.30319.1009 (RTMGDR.030319-1000)

               

                   System.Xml     4.0.0.0     4.0.30319.1009 built by: RTMGDR

               

                   Microsoft.VisualStudio.Tools.Applications.Hosting     10.0.0.0     10.0.40305.0

               

                   Microsoft.VisualStudio.Tools.Applications.Runtime     10.0.0.0     10.0.40305.0

               

                   System.Deployment     4.0.0.0     4.0.30319.1 (RTMRel.030319-0100)

               

                   System.Security     4.0.0.0     4.0.30319.1004 (RTMGDR.030319-1000)

               

                   Microsoft.VisualStudio.Tools.Applications.ServerDocument     10.0.0.0     10.0.40305.0

               

                   System.Windows.Forms     4.0.0.0     4.0.30319.1002 built by: RTMGDR

               

                   System.Drawing     4.0.0.0     4.0.30319.1001 built by: RTMGDR

               

                   System.Xml.Linq     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   Microsoft.Office.Tools     10.0.0.0     10.0.40305.0

               

                   Microsoft.Office.Tools.Excel.Implementation     10.0.0.0     10.0.40305.0

               

                   Microsoft.Office.Tools.Common.Implementation     10.0.0.0     10.0.40305.0

               

                   Microsoft.Office.Tools.Common     10.0.0.0     10.0.40305.0

               

                   Microsoft.Office.Tools.Excel     10.0.0.0     10.0.40305.0

               

                   OSIsoft.PIDataLink.UI     4.0.3.0     5.0.0.0

               

                   Microsoft.Office.Tools.Common.v4.0.Utilities     10.0.0.0     10.0.30319.1

               

                   OSIsoft.PIDataLink.Resources     4.2.0.0     5.0.0.0

               

                   y4ilms51     4.0.3.0     4.0.30319.1001 built by: RTMGDR

               

                   OSIsoft.PIDataLink.AFData     5.0.0.0     5.0.0.0

               

                   OSIsoft.AFSDK     4.0.0.0     2.5.1.5159

               

                   qhlu321t     4.0.3.0     4.0.30319.1001 built by: RTMGDR

               

                   OSIsoft.PI.Configuration     1.0.1.0     1.2.1.71

               

                   OSIsoft.PI.Net     1.0.1.0     1.2.1.71

               

                   b2edogsx     4.0.3.0     4.0.30319.1001 built by: RTMGDR

               

                   Microsoft.CSharp     4.0.0.0     4.0.30319.1

               

                   System.Dynamic     4.0.0.0     4.0.30319.1

               

                   Anonymously Hosted DynamicMethods Assembly     0.0.0.0     

               

                   CustomMarshalers     4.0.0.0     4.0.30319.1 (RTMRel.030319-0100)

               

                   System.Runtime.Serialization     4.0.0.0     4.0.30319.1 (RTMRel.030319-0100)

               

                   System.ServiceProcess     4.0.0.0     4.0.30319.1 (RTMRel.030319-0100)

               

                   OSIsoft.PI.Configuration.PISDKRegDirectoryProvider     1.0.1.0     1.2.1.71

               

                   Accessibility     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   OSIsoft.Search     1.0.0.0     1.2.0.0

               

                   OSIsoft.PIDataServices.Common     3.4.0.0     3.4.0.107

               

                   OSIsoft.PIDataServices.DataAccess     3.4.0.0     3.4.0.107

               

                   OSIsoft.PIDataServices.DataService     3.4.0.0     3.4.0.107

               

                   OSIsoft.PIInstrumentation     3.4.0.0     3.4.0.107

               

                   3p5e3irt     3.4.0.0     4.0.30319.1001 built by: RTMGDR

               

                   OSIsoft.PIInstrumentation.Listeners     3.4.0.0     3.4.0.107

               

                   OSIsoft.PISDK     1.4.0.0     1.4.0.416

               

                   OSIsoft.PISDKCommon     1.4.0.0     1.4.0.416

               

                   OSIsoft.PITimeServer     1.4.0.0     1.4.0.416

               

                   System.ServiceModel     4.0.0.0     4.0.30319.1001 built by: RTMGDR

               

                   SMDiagnostics     4.0.0.0     4.0.30319.1 (RTMRel.030319-0100)

               

                   System.IdentityModel     4.0.0.0     4.0.30319.1001 (RTMGDR.030319-1000)

               

                   System.Runtime.DurableInstancing     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   System.WorkflowServices     4.0.0.0     4.0.30319.1 (RTMRel.030319-0100)

               

                   System.ServiceModel.Web     4.0.0.0     4.0.30319.233 (RTMGDR.030319-2300)

               

                   System.ServiceModel.Discovery     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   System.ServiceModel.Activities     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   System.ServiceModel.Routing     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   Microsoft.VisualStudio.Diagnostics.ServiceModelSink     4.0.0.0     10.0.30319.1

               

                   System.ServiceModel.Channels     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   System.Web     4.0.0.0     4.0.30319.272 built by: RTMGDR

               

                   System.Data     4.0.0.0     4.0.30319.237 (RTMGDR.030319-2300)

               

                   OSIsoft.AF.UI     4.0.0.0     2.5.1.5159

               

                   OSIsoft.AF.Asset.DataReference.PIPoint     2.0.0.0     2.5.1.5159

               

                   System.Xaml     4.0.0.0     4.0.30319.298 built by: RTMGDR

               

                   System.Transactions     4.0.0.0     4.0.30319.1 (RTMRel.030319-0100)

               

                   OSIsoft.AF.Asset.DataReference.TableLookup     2.0.0.0     2.5.1.5159

               

                   System.Numerics     4.0.0.0     4.0.30319.1 built by: RTMRel

               

                   MDBTree.ocx          1.06.0365

               

                   PIDAArc.dll          3.1.9.0

               

                   PIDAEXTTREND.dll          3.1.9.0

               

                   PIDAXL.dll          3.1.8.0

               

                   PIDO.dll          3.1.9.0

               

                   PIPC32.xll          5.0.0.0

               

                   PISDK.dll          1.4.0.416

               

                   PISDKCommon.dll          1.4.0.416

               

                   PISDKCtl.ocx          1.06.0400

               

                   PISDKDlg.dll          1.08.0412

               

                   PITimeServer.dll          

               

                   PITrend.dll          3.1.9.0

               

                   PIXLTWIZ.dll          3.1.8.0

               

                   OSIsoft.PIDataLink.Notifications.Common.dll     5.0.0.0     5.0.0.0

               

                   OSIsoft.PIDataLink.Notifications2007.UDF.dll     5.0.0.0     5.0.0.0

               

                   OSIsoft.PIDataLink.Notifications2007.UI.dll     5.0.0.0     5.0.0.0

               

              Copyright (c) 2013, OSIsoft, LLC

               

              Regards,

               

              Denis