AnsweredAssumed Answered

Why i am getting "IsSQLDatabaseCompatible=false" to connect  PIAF 2.7.5.7166  to SQL Server 2014 ?

Question asked by Lowreno on Apr 11, 2016
Latest reply on Apr 13, 2016 by Lowreno

I am getting the following message when I try to connect  a box of PI AF Server (AFService.exe version 2.7.5.7166 ) to another box of a dedicated instance of SQL Server 2014 w/ PIFD installed manually.

 

2016-04-11 16:56:12.287 [9276:7116]: Add New EventItem: EventArgs='Action='Change'', Sender='PI AF Server 'PWNPO-BHEPIAPP1''

2016-04-11 16:56:12.294 [9276:7116]:     SENDING CHANGED EVENT: Count=3

            [0] Target='OSIsoft.AF.UI.PISystemPicker'

            [1] Target='OSIsoft.AF.UI.PropertyPage.AFGeneralSystemPage'

            [2] Target='OSIsoft.AF.UI.AFPropertySheet, Text: PI AF Server Properties'

2016-04-11 16:56:12.306 [9276:7116]: Start Raising 1 Top-Level EventItems

        1. RaiseEventItem: EventArgs='Action='Change'', Sender='PI AF Server 'PWNPO-BHEPIAPP1''

    Finished Raising 1 Total EventItems

2016-04-11 16:56:12.309 [9276:7116]: Add New EventItem: EventArgs='Action='Change'', Sender='PI AF Server 'PWNPO-BHEPIAPP1''

2016-04-11 16:56:12.309 [9276:7116]:     SENDING CHANGED EVENT: Count=3

            [0] Target='OSIsoft.AF.UI.PISystemPicker'

            [1] Target='OSIsoft.AF.UI.PropertyPage.AFGeneralSystemPage'

            [2] Target='OSIsoft.AF.UI.AFPropertySheet, Text: PI AF Server Properties'

2016-04-11 16:56:12.309 [9276:7116]: Start Raising 1 Top-Level EventItems

        1. RaiseEventItem: EventArgs='Action='Change'', Sender='PI AF Server 'PWNPO-BHEPIAPP1''

    Finished Raising 1 Total EventItems

2016-04-11 16:56:12.310 [9276:7116]: GET PROXY: Serial Pool Count=0, MaxCount=1

2016-04-11 16:56:12.310 [9276:7116]: Attempting Connection(FirstAttempt=True, Member='<null>', Preference=PreferPrimary): WasFound=True, SelectedMember='<null>', Protocol=Tcp, Host='PWNPO-BHEPIAPP1', Port=5457, StreamedPort=5459, AccountName='netcemig\adm-srvpi', Timeout=00:05:00

2016-04-11 16:56:22.675 [9276:7116]: Proxy GetSystemVersions Returned: IsSQLDatabaseCompatible=False, ErrNumber=-2

2016-04-11 16:56:22.678 [9276:7116]:    CONNECT ERROR(-2) Unexpected

        Cannot connect to PI AF Server.

2016-04-11 16:56:22.679 [9276:7116]: Cannot connect to host 'PWNPO-BHEPIAPP1' on first attempt but will retry.

        >> Cannot connect to PI AF Server.

           at OSIsoft.AF.PISystem.CheckServerConnectError(PISystem system, Int32 errNumber)

       at OSIsoft.AF.Support.AFProxy.CheckGetSystemVersions(Boolean isSQLDatabaseCompatible, Int32 errNumber, Int32[] compatibilityNumbers, String[] versionStrings)

       at OSIsoft.AF.Support.AFSerialProxy.GetSystemVersions(Int32[]& compatibilityNumbers, String[]& versionStrings)

       at OSIsoft.AF.Support.AFProxy.Reconnect(Boolean autoPrompt, Boolean raiseEvents, AFConnectionProtocol protocol, String host, Int32 port, String accountName, TimeSpan timeout)

2016-04-11 16:56:22.679 [9276:7116]: Attempting Connection(FirstAttempt=False, Member='<null>', Preference=PreferPrimary): WasFound=False, SelectedMember='<null>', Protocol=Tcp, Host='', Port=5457, StreamedPort=5459, AccountName='', Timeout=00:05:00

2016-04-11 16:56:22.679 [9276:7116]: RETURN PROXY: Serial Pool Count=1, MaxCount=1

 

Does anyone have any idea what is happening ? I cannot find  WHAT is the reason of isSQLDatabaseCompatible is setting FALSE once the instance of database is an SQL Server 2014 (which is supported by PI AF)...

 

BTW: I am using the following "string connection" at  "C:\Program Files\PIPC\AF\AFService.exe.config" :   <add key="connectString" value="Persist Security Info=False;Integrated Security=SSPI;server=sa-corp-sql0\d;database=PIFD;Application Name=AF Application Server;"/>

 

Thanks in advance,

 

Lowreno.

Outcomes