Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

Posted on by Microsoft Employee

Hello,

When I am trying to add Price List on my Product form I am getting an error "Invalid Argument" and when open the Log file I am getting this error Message

Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead. 

Please help me resolve this issue.

Its Urgent.

Thanks in Advance!!

*This post is locked for comments

  • Temmy Wahyu Raharjo Profile Picture
    Temmy Wahyu Raharjo 2,914 on at
    RE: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

    Please do check again for detail. Maybe there is workflow or plugin behind it? Seems there are query run after you save. Because of the value is null but the query is equal to null (should be use operator 'not-null').

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

    It is already having value still the same error

  • Suggested answer
    Jagannath Profile Picture
    Jagannath 545 on at
    RE: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

    Hi Neha,

    While adding price list don't  leave "product" field blank.

    Try it once and check.

    Thanks,

    Jagannath

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

    When I am trying to add Price List to the Field I am getting the error invalid argument.

    More detail of the error message -

    Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.Detail:

    <OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance&quot; xmlns="schemas.microsoft.com/.../Contracts&quot;>

     <ActivityId>eafa3697-c1d0-4f33-86d0-c4afab2205cd</ActivityId>

     <ErrorCode>-2147220989</ErrorCode>

     <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic&quot;>

       <KeyValuePairOfstringanyType>

         <d2p1:key>ApiExceptionSourceKey</d2p1:key>

         <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema&quot; i:type="d4p1:string">Plugin/Microsoft.Crm.ObjectModel.QueryService</d2p1:value>

       </KeyValuePairOfstringanyType>

       <KeyValuePairOfstringanyType>

         <d2p1:key>ApiOriginalExceptionKey</d2p1:key>

         <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema&quot; i:type="d4p1:string">Microsoft.Crm.CrmArgumentException: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead. ---> Microsoft.Crm.CrmArgumentException: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead. ---> System.ArgumentException: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

      --- End of inner exception stack trace ---

      at Microsoft.Crm.Query.ConditionExpression.ThrowIfNull(Object value)

      at Microsoft.Crm.Query.ConditionExpression..ctor(AttributeMetadata attribute, ConditionOperator conditionOperator, Array values, Boolean isCustom, IUserAndOrganizationContext userAndOrganizationContext, DynamicMetadataCache cache)

      at Microsoft.Crm.Query.ConditionExpression..ctor(AttributeMetadata attribute, ConditionOperator conditionOperator, Array values, IUserAndOrganizationContext userAndOrganizationContext)

      at Microsoft.Crm.Query.EntityExpression.FromSdkQueryVisitor.Visit(ConditionExpression condition)

      at Microsoft.Crm.Query.EntityExpression.FromSdkQueryVisitor.Visit(FilterExpression filter)

      at Microsoft.Crm.Query.EntityExpression.FromSdkQueryVisitor.Visit(LinkEntity linkEntity)

      at Microsoft.Crm.Query.EntityExpression.FromSdkQueryVisitor.Visit(QueryExpression query)

      at Microsoft.Crm.Query.EntityExpression.InitializeFromQuery(QueryBase query)

      at Microsoft.Crm.Query.EntityExpression.Converter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)

      at Microsoft.Crm.BusinessEntities.ConversionHelpers.Convert(ICrmConversionContext conversionContext, Object source, Type destinationType)

      at Microsoft.Crm.Extensibility.DictionaryMapper.Map(ParameterCollection inputs, ICrmConversionContext context)

      at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IServiceProvider serviceProvider)

      at Microsoft.Crm.Extensibility.V5PluginProxyStep.ExecuteInternal(PipelineExecutionContext context)

      at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)

      --- End of inner exception stack trace ---

      at Microsoft.Crm.Extensibility.VersionedPluginProxyStepBase.Execute(PipelineExecutionContext context)

      at Microsoft.Crm.Extensibility.PipelineInstrumentationHelper.Execute(Boolean instrumentationEnabled, String stopwatchName, ExecuteWithInstrumentation action, PipelineExecutionContext context)

      at Microsoft.Crm.Extensibility.Pipeline.Execute(PipelineExecutionContext context)</d2p1:value>

       </KeyValuePairOfstringanyType>

       <KeyValuePairOfstringanyType>

         <d2p1:key>ApiStepKey</d2p1:key>

         <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema&quot; i:type="d4p1:string">d3cabb1b-ea3e-db11-86a7-000a3a5473e8</d2p1:value>

       </KeyValuePairOfstringanyType>

       <KeyValuePairOfstringanyType>

         <d2p1:key>ApiDepthKey</d2p1:key>

         <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema&quot; i:type="d4p1:string">1</d2p1:value>

       </KeyValuePairOfstringanyType>

       <KeyValuePairOfstringanyType>

         <d2p1:key>ApiActivityIdKey</d2p1:key>

         <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema&quot; i:type="d4p1:string">eafa3697-c1d0-4f33-86d0-c4afab2205cd</d2p1:value>

       </KeyValuePairOfstringanyType>

       <KeyValuePairOfstringanyType>

         <d2p1:key>ApiPluginSolutionNameKey</d2p1:key>

         <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema&quot; i:type="d4p1:string">System</d2p1:value>

       </KeyValuePairOfstringanyType>

       <KeyValuePairOfstringanyType>

         <d2p1:key>ApiStepSolutionNameKey</d2p1:key>

         <d2p1:value xmlns:d4p1="www.w3.org/.../XMLSchema&quot; i:type="d4p1:string">System</d2p1:value>

       </KeyValuePairOfstringanyType>

     </ErrorDetails>

     <Message>Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.</Message>

     <Timestamp>2018-01-22T17:51:03.7459653Z</Timestamp>

     <ExceptionRetriable>false</ExceptionRetriable>

     <ExceptionSource i:nil="true" />

     <InnerFault i:nil="true" />

     <OriginalException i:nil="true" />

     <TraceText i:nil="true" />

    </OrganizationServiceFault>

    There is no code written behind it.

    I am just trying to add the Price List on the form

  • Jagannath Profile Picture
    Jagannath 545 on at
    RE: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

    Hi Neha,

    It will better if u will share ur code. so that we can help you.

    Thanks ,

    Jagannath

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Condition for attribute 'productpricelevel.productid': null is not a valid value for an attribute. Use 'Null' or 'NotNull' conditions instead.

    Can someone please help me with this

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans