Skip to Main Content
AVEVA™ Products Feedback Portal

Welcome to our new feedback site!


We created this site to hear your enhancement ideas, suggestions and feedback about AVEVA products and services. All of the feedback you share here is monitored and reviewed by the AVEVA product managers.

To start, select the product of your interest in the left column. Then take a look at the ideas in the list below and VOTE for your favorite ideas submitted by other users. POST your own idea if it hasn’t been suggested yet. Include COMMENTS and share relevant business case details that will help our product team get more information on the suggestion. Please note that your ideas will first be moderated before they are made visible to other users of this portal.

This page is for feedback for specific AVEVA solutions, excluding PI Systems and Data Hub. For links to these other feedback portals, please see the tab RESOURCES below.

Status Already exists
Created by Nina NICHOLLS
Created on Jul 12, 2021

Add support for units in CLR stored procedures


[Problem Summary]
when GetDataByLocationV200806 SP is executed with the fields source units ,Destination units and units below error comes.

EXEC @return_value = [dbo].[GetDataByLocationV200806]
@module = N'Inventory',
@location = 'EnterpriseFolder.SiteFolder.Pit.Pit',
--@samplePeriod = NULL,
--@startDateLocalTime = NULL,
--@endDateLocalTime = NULL,
@viewName = 'Movement Events',
@fields ='[Source Lot],[Source Lot Group],[Sample Period],[Movement Type],[Destination Units]',
--@modelFields = NULL,
---@filters = NULL,
--@inclusiveDataRange = NULL,
--@session = NULL,
@username = 'Administrator',
@password = 'a',
@serverName = 'http://localhost:8889/'
---@resolveIdentifiers = NULL,
--@pivotResults = NULL,
--@language = NULL

SELECT 'Return Value' = @return_value

GO

Error details:

Msg 6522, Level 16, State 1, Procedure GetDataByLocationV200806, Line 0 [Batch Start Line 18]

A .NET Framework error occurred during execution of user-defined routine or aggregate "GetDataByLocationV200806":

System.Web.Services.Protocols.SoapException: The multi-part identifier "DestinationMaterial.Units" could not be bound.

System.Web.Services.Protocols.SoapException:

at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)

at Citect.Ampla.Public.MSSQL.Data.V200806.DataWebServiceV200806.DataWebService.GetData(GetDataRequest GetDataRequest)

at Citect.Ampla.Public.MSSQL.Data.V200806.DataStoredProcedure.GetDataByLocationV200806(String module, String location, String samplePeriod, DateTime startDateLocalTime, DateTime endDateLocalTime, String viewName, String fields, String modelFields, String filters, Int32 inclusiveDataRange, String session, String username, String password, String serverName, Boolean resolveIdentifiers, Boolean pivotResults, String language)

[Reproduced in-house (Sydney GSC)] Yes

[Steps to Reproduce]
Please check the provided SP.

[Possible Cause]Bug

[What is the impact to Customer/s]Customer is not able to execute the SP with adding these fields for the fields parameter.

[Workaround] N/A

[Checklist] N/A

  • Attach files
  • Admin
    Nina NICHOLLS
    Reply
    |
    Oct 17, 2023

    Units can be returned by the stored procedure; the material needs to be included in the request as well for this to work.
    E.g.
    EXEC [dbo].[GetDataByLocationV200806]

    @module = N'Inventory',

    @location = 'ACME with children',

    --@samplePeriod = NULL,

    --@startDateLocalTime = NULL,

    --@endDateLocalTime = NULL,

    @viewName = 'Movement Events',

    @fields ='[Source Lot],[Source Lot Group],[Sample Period],[Movement Type],[Destination Material],[Destination Units]',

    --@modelFields = NULL,

    ---@filters = NULL,

    --@inclusiveDataRange = NULL,

    --@session = NULL,


    @serverName = 'http://localhost:8889/'

    ---@resolveIdentifiers = NULL,

    --@pivotResults = NULL,

    --@language = NULL


    GO