SharePoint - Error Message: Object Reference not set to an instance of an object.
Action:
We started getting an error from a component which copies a file to an Office 365 SharePoint site. This upload has been working fine for months and no deployments have been made to it. The error is happening both on the deployed version and when run locally in Visual Studio. We've recreated the issue on several SharePoint sites, using several different sets of credentials. When we go into the SharePoint Connection Manager and hit Test Connection, we get the following error message.
Error Message:
'Object Reference not set to an instance of an object '
Solution:
Two possible solutions:
1. After COZYROC assessed customer Fiddler Trace files against a SharePoint server that was not failing and 2nd trace file against Sharepoint server that was failing, customer was urged to contact Microsoft with problem on Sharepoint side, not COZYROC SharePoint connection. Customer reported the following feedback:
Was a problem in Office 365, as per your assessment.
Just FYI, Microsoft helped fixing the problem in the environment. It turned to be an Office 365 setting that had been wrongly applied.According to Microsoft, someone would have had to run a PowerShell command to change this tenant setting LegacyAuthProtocolsEnabled to False.
Reference here: https://docs.microsoft.com/en-us/powershell/module/sharepoint-online/set-spotenant?view=sharepoint-ps
2. It is possible your user account has enabled Multi-Factor Authentication(MFA) and this is the reason for the error.
In version 2.0 COZYROC release a way of connecting with MFA enabled SharePoint service. Please see this KB article:
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access
Action: When running a package that includes a Dynamics CRM connection, I get the following error: Error Message: AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use ...If our SharePoint service is MFA-enabled, does this mean we can't use the SharePoint components?
We have recently posted a way to connect to MFA-enabled service. You have to upgrade to latest 2.0 version of COZYROC in order to use this new connection for MFA-enabled service. You can see the "Quick Start" article by clicking here: ...How to pass a multiple choices to a MULTI-CHOICE SharePoint Column?
Scenario: You have a package with a SharePoint Destination Component and you are trying to map multi-select option set to a multi-choice SharePoint column. Solution: You should use SharePoint Source component to retrieve multi-choice fields from ...Error Message: 'The remote server returned an error (429)' when using Sharepoint Online.
Summary: The error 429 is related to throttled or blocked in Sharepoint Online when sending too many requests as mentioned here Avoid getting throttled or blocked in Sharepoint Online. SharePoint Online API requests occasionally return a 429 error, ...Error Message: "Could not initialize component for use in the designer."
Action: While creating a new CRM destination, the following error is encountered. Error Message: TITLE: Microsoft Visual Studio ------------------------------ The component could not be added to the Data Flow task. Verify that this component is ...