Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

CRM Dynamics 365 online sql error when qualify a lead after update service 42

Posted on by 32


Hello, when I qualify a lead with a user who does not have an administrator role, the 'Sql error: 'Invalid column name 'OwnerId'.'","stacktrace..' error is generated, does it occurs after the update of service 42 (18-april-2019), any solution? I have Microsoft Dynamics 365 online version 1710 (9.1.0.4425) online

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: CRM Dynamics 365 online sql error when qualify a lead after update service 42

    In my scenarios, users are facing issue while converting to case from email activity after the shared time stamp. I tried this but no luck in this issue.

    also, getting same error on disqualify.

    I have given the organization level rights on queue to the particular user.

  • Alice R Profile Picture
    Alice R 32 on at
    RE: CRM Dynamics 365 online sql error when qualify a lead after update service 42

    Hello, thank you very much, I applied your recommendation and it worked correctly

  • Verified answer
    Pau1977 Profile Picture
    Pau1977 on at
    RE: CRM Dynamics 365 online sql error when qualify a lead after update service 42

    We solved it giving permissions to all organization on queue entity.

    Meanwhile we are waiting for fix this:

    Users may receive a SQL error when saving or modifying cases.
    Title: SQL errors

    User Impact: Users may receive a SQL error when saving or modifying cases.

    More Info: Users may receive the SQL error “Invalid column name” when attempting to access case records.

    Current Status: The code fix has been developed and we are validating and testing the code to ensure the problem is resolved.

    Incident Start Time: Monday, April 22, 2019, 5:12 PM UTC

    Next Update: Tuesday, April 23, 2019, 4:00 PM UTC, to allow time for the code fix to be tested and validated.
  • Ciaran Reynolds Profile Picture
    Ciaran Reynolds 230 on at
    RE: CRM Dynamics 365 online sql error when qualify a lead after update service 42

    I'm having the same problem. I have noticed that as a system admin I am able to qualify leads but other users are unable, which leads me to believe it is an error within the security roles but I haven't been able to identify the issue yet.

  • Pau1977 Profile Picture
    Pau1977 on at
    RE: CRM Dynamics 365 online sql error when qualify a lead after update service 42

    I am having same issue when trying to close an incident since an update ocurred last weekend.

  • Roland Pot Profile Picture
    Roland Pot 35 on at
    RE: CRM Dynamics 365 online sql error when qualify a lead after update service 42

    Same issue here, only for 2 users for one department. This weekend we got updated to the April update, no issues before that and no changes have been made in security roles...

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

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