UnableToWriteToAadException For Mailbox Stored in Cloud but Managed On-Prem

Question

UnableToWriteToAadException For Mailbox Stored in Cloud but Managed On-Prem

Ryan Broman 21

Hello,

I'd like to add an email address to a user like so:

Set-Mailbox RBroman -EmailAddresses @{add="TestRBroman@xyz.com"}

However, when running it while connected to Exchange Online I get the following error:

An Azure Active Directory call was made to keep object in sync between Azure Active Directory and Exchange Online. However, it failed. Detailed error message:  
        Unable to update the specified properties for on-premises mastered Directory Sync objects or objects currently undergoing migration. DualWrite (Graph) RequestId:

We are a hybrid environment and recently moved our mailboxes to the cloud. So I opened Exchange Management Shell on-prem to try it and received a Not Found Error:

The operation couldn't be performed because object 'rbroman' couldn't be found on ''.

So if I can't edit mailboxes in the cloud AND I can't edit them on-prem, what do I do?

It should be noted that I am able to edit the mailbox using the on-prem EAC but am trying to automate processes via PowerShell.

Answer 1

Andy David - MVP 121K MVP

on-prem its a remote mailbox

Set-RemoteMailbox RBroman -EmailAddresses @{add="TestRBroman@xyz.com"}

Ryan Broman 21

[PS] C:\Windows\system32>Set-RemoteMailbox RBroman -EmailAddresses @{add="RBromanTesting@asdfghjkl.ca.gov"}  
[PS] C:\Windows\system32>

Perfect, thank you Andy!

Mary Sachet 41 Reputation points

2022-11-08T03:56:31.85+00:00
hi AndyDavid, would you be able to help me please. I am also trying to fix my issue, These are the three that I am trying to solve

INSERT INTO Public_Housing_Building
(Public_Housing_Number, Names_of_the_building, Street_Address, Suburb, State, Postcode,Building_Year, Heightinstories_Levels)
VALUES
(109, 'APT 1','16 Spook Street','Glen Iness', 'NSW', 2017,2022, 30),
(110, 'APT 2','26 Sava Avenue','Square', 'NSW', 1070, 2022, 45),
(111, 'APT 3','86 Chisholm Parade', 'Broad', 'NSW', 2906, 2019, 10),
(112,'APT 4','76 Sylvan Road','DeerBush', 'NSW', 2621,2020,20),
(113,'APT 5','55 Ireland Road','Discovery','NSW', 3017,2022, 50),
(114,' APT 6','22 Budget Place','Grove', 'NSW', 4018, 2018, 60),
(115,' APT 7','9 Parklands Street','Hill', 'NSW', 2211,2017, 10),
(116,' APT 8','2 Wonga Avenue','Bare', 'NSW', 2421, 2022, 22),
(117,' APT 9','19 Monic Cresent','Kotlash', 'NSW', 6021, 2021, 65),
(118,' APT 10','25 Sunset Close','Gabo', 'NSW', 2554, 2021, 15);

Failed to execute the query. Error: Violation of PRIMARY KEY constraint 'PK__Public_H__B43318E961C9E79D'. Cannot insert duplicate key in object 'dbo.Public_Housing_Building'. The duplicate key value is (109).
The statement has been terminated.
Mary Sachet 41 Reputation points

2022-11-08T03:58:07.01+00:00
2
INSERT INTO Unit_Building (Unit_Building_Number, Public_Housing_Number, Number_of_bedrooms,Number_of_Kitchens,Number_of_livingrooms, Unit_area
VALUES
(200,109,3,1,1, tinyint(110)),
(201,111,1,2,1,tinyint(125)),
(202,112,2,3,1,tinyint(130)),
(203,113,3,1,1,tinyint(140)),
(204,114,4,1,1,tinyint(150)),
(204,114,4,1,1,tinyint(150)),
(204,114,4,1,1,tinyint(150)),
(205,115,2,3,1,tinyint(120)),
(206,116,1,1,1,tinyint(180)),
(207,117,4,2,1,tinyint(190)),
(208,118,3,1,1,tinyint(175)),
(209,119,3,2,1,tinyint(200));

Failed to execute query. Error: Incorrect syntax near the keyword 'VALUES'.
Query failed

CREATE TABLE TRACK_OF_MOVING_IN_OUT(
Building_ID int,
Unit_ID int,
Member_ID int,
PRIMARY KEY (Building_ID, Unit_ID, Member_ID),
FOREIGN KEY (Building_ID) REFERENCES BUILDING (Building_ID),
FOREIGN KEY (Unit_ID) REFERENCES UNIT (Unit_ID),
FOREIGN KEY (Member_ID) REFERENCES MEMBER (Member_ID)
ON UPDATE CASCADE ON DELETE CASCADE,
Date_of_Moving_In date,
Date_of_Moving_Out date,
);

Failed to execute query. Error: Foreign key 'FK__TRACK_OF___Build__797309D9' references invalid table 'BUILDING'.
Could not create constraint or index. See previous errors.
Query failed

UnableToWriteToAadException For Mailbox Stored in Cloud but Managed On-Prem

0 additional answers

Activity