Emerson Exchange 365

• Not Answered

Deltav Live : SQL query not working after Feature pack 3 installed

Hello,

After the installation of 14.3 Feature pack 3 the SQL queries on DeltaV Live have stopped working.

All these queries were working fine before upgrade to FP3

In the SQL Datasource management, I have allowed unsecured SQL queries.

I am using a SI dongle and can create perform other configuration functions like creating Class based GEMS.

So, i am sure it is not a licensing issue.

Following is the script:

// ********************* Button12.Action.Script(X: number, Y: number): void ********************* //

 

 try

    {

        var id = Dsp.UnitID.Value

        Dsp.UnitName.Value = await SQL.TruBioDS.QueryAsync("SELECT TagName FROM [TruBio].[dbo].[UnitRecord] WHERE Id = " + id.toString());

    }

  catch(e)

    {

        DL.MessageBoxAsync(e.toString(), "Exception", Constants.MessageBoxButtonType.MB_OK, 30);   

    }

The query itself seems ok as it can be executed in SQL

 

Regards,

Navin Singh

Navin Singh

• 4 May 2022 10:07 AM
• Cancel

3 Replies

• Martin v. Bergeijk

  

  • 26 Jul 2024 9:10 AM

  Is this because they removed unsecured access?

  

  • Cancel
• Matt Stoner

  

  • 26 Jul 2024 1:08 PM

  In reply to Martin v. Bergeijk:

  Unsecured access hasn't been removed, may never and this highlighted text may get removed from BOL.
  
  You should log a call on the issue but did anything in the SQL database configuration change (Users, network config, etc)?

  • Cancel
• Andre Dicaire

  

  • 6 Aug 2024 5:22 PM

  Small comment on SI Dongle. The SI dongle disable license validation to allow configuration of unlicensed system. But it can also allow Un-licensable configurations that work with this dongle, cut cannot be commissioned into a licensed system. Be careful assuming there is no license issue just because you have an SI dongle attached.

  Andre Dicaire

  • Cancel