SQL Error: Invalid Column name "Owning Business Unit"

(0) Share

Report

Posted on by Community Member Microsoft Employee

Can you help me what is the solution on the error that I am getting below. It was working until yesterday but this morning it already getting this problem when I am trying to close the case by clicking resolve case as shown below.

after clicking the Resolve case we are getting the below error

Thanks

Categories:

Knowledge Management

All responses (11)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

Thanks to all of you, so I need to revert it back the original settings and follow the instructions above? Thanks. It's good that I saved the original configuration for Queries
Mduduzi on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

Agreed, I'm hoping that Microsoft gets better at introducing bug-free software updates; especially since their new update policy no longer allows us to postpone buggy software updates.
sustepav 5 on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

Well, this solves the error quote, but it is a security issue now, because other business units can see queues of different business unites. That shouldn't be possible. I believe it is still an issue, that should be raised to MS.
Mduduzi on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

My pleasure, glad I could help :)
Community Member Microsoft Employee on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

@Mduduzi, thanks a lot. It's working fine now.
Mduduzi on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

The Queue entity is on the Core Records tab as per the screenshot below.
Community Member Microsoft Employee on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

It's already set to Organizational level as shown below.
Suggested answer

Mduduzi on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

Good Day Noside,

Try setting the Read Privilege on the Queue Entity to Organization level.
LeoAlt 16,331 on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

Hi partner,

You could follow the below steps.

1.Login Office 365 and click "Admin" to enter admin center.

2.Click on "Support" in the left list and fill in "Dynamics 365" in text box then the system will return a link and open it.

3.Select your issue information and click "See solutions", then the system will show you some solutions about customizations, find "Create a new support" on the bottom of the page.

4.Complete your issues description here, you could also add attachment like imgs and click "Next".

5.Finally, fill in your region and contact, then the Microsoft engineer will contact you through the information you provided.

Hope it helps.

Best Regards,

Leo
Community Member Microsoft Employee on at

Like (0)

Report

RE: SQL Error: Invalid Column name "Owning Business Unit"

Thanks LeoAlt. Yes, it has permission already. Kindly help me on how will i raise it to Microsoft? I don’t have the right email address and contact number . Thanks