5 Replies Latest reply on Oct 12, 2017 12:05 PM by vint.maggs@srs.gov

    PI ICU "Locked"

    vint.maggs@srs.gov

      Hello All. I am running PI Data Archive 2017 SP1 Hotfix on W2K12R2. My interface node is W2K8R2 running the GSE D/3 DBA interface, 4.33.7.147. When I start the Interface Configuration Utility, it shows the PI Data Server Connection State is Read-Only with a lock icon. It was a green check.

       

      I have been dinking around trying to implement the seven best practices and fear I may have broken something, but for the life of me I do not know what may be misconfigured. The message logs look ok, I don't see a missing trust issue. I checked the permissions on the PIDBSEC, PIDS, and PIPOINT tables. I also checked the permissions on the MODULE Database.

       

      What can I do?

       

      Thanks,

      Vint

        • Re: PI ICU "Locked"
          sraposo

          Hi Vint,

           

          The times I've seen this, the user authenticated on the PI Data Archive didn't have write access to the module database. If you open PI SDK > Connection Manager, I would verify which user(s) you are authenticating as and then double check the permissions in the security database for PI Modules.

           

          Hope this helps,

          Sebastien

            • Re: PI ICU "Locked"
              vint.maggs@srs.gov

              UPDATED: I mapped the Identity to a domain account and added RW permissions to the PIMODULES table. This made the ICU "Writeable" and the green check mark reappeared.

               

              Unfortunately my data is still not getting to the data archive server. On the client I see messages like Initial connection to <server> buffered and Error -10401 posting to point id 408 (event time: 11-Oct-17 16:29:16, value 7.22, mode: precomp_snap).

               

              Could this be a time issue and how do I recover? The client is not domain joined while the data archive server is. They are getting there time from two different sources.

               

              Thanks,

              Vint