PI vision error when viewing the screens

Hello, I am having a problem with pi vision, it has happened several times that I open pi vision and the screens are not visible, the solution is to restart the services of the IIS app pools and the SQL express service. This happens approximately once a month. I checked the logs in the AF and I got the following.Hello, I am having a problem with pi vision, it has happened several times that I open pi vision and the screens are not visible, the solution is to restart the services of the IIS app pools and the SQL express service. This happens approximately once a month. I checked the AF and I got the following.

 

 

 

 

 

 

 

Function Int64 RPCEntry(OSIsoft.AF.Service.AFService, Boolean, OSIsoft.AF.Service.dcServerError ByRef) at line: 0 in file System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at OSIsoft.AF.Service.AFService.Initialize() at OSIsoft.AF.Service.AFService.RPCEntry(AFService service, Boolean logWithTime, dcServerError& err) ClientConnectionId:00000000-0000-0000-0000-000000000000 Error Number:-1,State:0,Class:20 dcServerError state: Operation = 0 ErrorNumber = 53 Message = A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Procedure = .Net SqlClient Data Provider ObjectType = 0 ID = 00000000-0000-0000-0000-000000000000 ObjectName = Unknown SubObjectType = 0 User = Unknown LockedByUser = at OSIsoft.AF.Service.AFService.Initialize() at OSIsoft.AF.Service.AFService.RPCEntry(AFService service, Boolean logWithTime, dcServerError& err) OtherObjectType = 0 OtherObjectName = Unknown OtherObjectID = 00000000-0000-0000-0000-000000000000

Parents
  • Looks like there is a disconnection between AF and SQL Server. PI Vision inherits security from AF identities and if AF is not accessible then security for PI Vision display fails. As mentioned, if issue happens once a month then check if AF server is patched during that time and AF&SQL is online after patching/restart. Please note AF retries to connect to SQL server in case of any connection issue for a period of time and if SQL server is not online then AF Service has to be restarted.

Reply
  • Looks like there is a disconnection between AF and SQL Server. PI Vision inherits security from AF identities and if AF is not accessible then security for PI Vision display fails. As mentioned, if issue happens once a month then check if AF server is patched during that time and AF&SQL is online after patching/restart. Please note AF retries to connect to SQL server in case of any connection issue for a period of time and if SQL server is not online then AF Service has to be restarted.

Children
No Data