Finding List Name Using List ID in SharePoint

Sometimes you just have the ID of the list. For example, if you have code that calls an API and the software developer who wrote that code directly used the ID of the list. In this case, it may take some time to find out which list on your site has this ID.

If you only have the ID of the list and you are wondering which SharePoint list this ID corresponds to, a PowerShell Snippet like the one below can work.

Check If Active Directory Account is Locked out

If you want to find out if the active directory user is locked out, I would like to mention two ways to do this.

POWERSHELL

C#

Problem: Chrome – Mark cross-site cookies as Secure to allow setting them in cross-site contexts

Cookies are one of the methods available for adding persistent state to web sites. Over the years their capabilities have grown and evolved, but left the platform with some problematic legacy issues. To address this, browsers (including Chrome, Firefox, and Edge) are changing their behavior to enforce more privacy-preserving defaults. If you want to read an excellent article on this topic, you can click this link.

If you see the warning message in the console section of your browser and you have lost some functionality on your site, I will suggest a short but risky workaround. In the example I came across, the login part of my site was not working on the server where IIS is located. But I could login different clients without any problems. I did not experience this problem in browsers other than Chrome.

What is causing the problem is actually a security measure in Chrome. You can access the details of this measure from the links below.

You can completely disable this feature by going to “chrome://flags” and disabling “Cookies without SameSite must be secure”.  This will disable it for all sites, so it will be less secure when you aren’t developing too.

How To Fix a Degraded Search Index Partition in a SharePoint Farm

If you are working with SharePoint 2013, 2016 or 2019, you may encounter an error like the following when you want to search for a keyword on the site.

When you want to check the status of the Search Service Application to diagnose the probem, you can see a screen like the one below. A warning icon on Index Partition!

To understand the problem in more detail you can open up a PowerShell window (used the option “Run As Administrator” to ensure proper permissions) and executed the following commands:

After execution or the command, the result confirmed a problem with the Index Partition. Showing the Index component with the Degraded state.

Solution 1

  1. Reset the Search Index
  2. Perform a Full Crawl on Search Content Source

For resetting the search index, you should go to the Central Administration page. Open up Search Service Application management page and click “Reset Index” link on left hand side. To confirm the Index Reset, click “OK” in the popup message.

And then you should re-index all content sources. For this operation, you should go to the Central Administration Console. Then open Search Service Application Management Page and go to “Content Sources” link. Click any of the content source you already configured earlier, and start full crawl.

Solution 2

You can open up a PowerShell window (used the option “Run As Administrator” to ensure proper permissions) and execute the following commands:

 

Searching in SharePoint Recycle Bin

SharePoint’s trash mechanism is a commonly known concept. However, sometimes there are too many items in the trash can.

Since you cannot filter it, it is very difficult to see if the item you are looking for is in the trash can. In this case, you can tell if the item you are looking for has been deleted with a PowerShell script as follows.

 

Errors in SQL Server while importing CSV file despite varchar(MAX)

You can use CSV or TEXT files for data transfers with Sql Server Management Studio. If the nvarchar fields in the table you will import are defined as MAX, you may see an error message.

You go through the Import Wizard and finally try to import the file you get the following error report:

Executing (Error) Messages
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column “”Detail”” returned status value 4 and status text “Text was truncated or one or more characters had no match in the target code page.”.

(SQL Server Import and Export Wizard)

Error 0xc020902a: Data Flow Task 1: The “Source – Sample_csv.Outputs[Flat File Source Output].Columns[“Detail”]” failed because truncation occurred, and the truncation row disposition on “Source – Sample_csv.Outputs[Flat File Source Output].Columns[“Detail”]” specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

(SQL Server Import and Export Wizard)

Error 0xc0202092: Data Flow Task 1: An error occurred while processing file “C:\Sample.csv” on data row 2.

(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Source – Sample_csv returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.

(SQL Server Import and Export Wizard)

To solve the problem, go to the “Advanced” tab on the source screen where you have selected FLAT File, select “DT_TEXT” instead of “DT_STR” and continue the process.

Slow Internet Connection – Pulse Secure

If you need to use Pulse Secure for VPN, you are likely to have experienced a problem. Your internet connection is slower than ever and you will find that resources cannot be downloaded on many websites. The problem can be experienced due to the wireless hardware used in Windows 10 Redstone 3 and above versions and some Dell and HP model computers. When you want to test your internet speed, you can see that your download speed is even below your upload speed.

The solution

Solution 1

Go to your network adapter settings and navigate to the properties with a right click. You can type Start> Run> ncpa.cpl for this. Make sure that the checkbox next to “Juniper Network Service”, among the adapter features on the screen that opens, is not selected and save the settings. Then, when you make VPN again, you will be able to use your internet speed correctly.

Solution 2

It is necessary to disable the RSC service. You can do a similar operation with PowerShell. Run the following command in a PowerShell console opened in run as administrator mode.

“Wifi 2” is your adapter name. You can run the command below to get this name.

 

Deleting RBS (Remote Blob Storage) Data on Disk (SharePoint)

There are two options to store your content data of your applications on your Microsoft SharePoint environment.

Default

This option stores the files uploaded to the site as binary content in content database tables. With this option active, default settings of SharePoint recycle bin will be in use when deleting content. These settings — described in details below — keeps the deleted content in content database and enables you to restore it even after 60 days (default value is 30 + 30 days).

RBS (Remote Blob Storage)

Remote Blob Storage is a whole other subject and we will focus on some of the problems we face on this subject. To learn more about RBS, I recommend reading this article: https://docs.microsoft.com/en-us/sharepoint/administration/rbs-overview

If I have to briefly explain, it is about storing binary BLOB data which is stored in content database by default outside of content database. In the case where RBS is used, default recycle bin in SharePoint works the same way, however in addition to the default setting of 30 + 30 days, garbage collection process of RBS must be performed. Otherwise, deleted SharePoint content will continue to take up space on the disk.

Workflow Manager Migration

Workflow Manager Server is a technology that is used to host high-scale, high-density workflows. It allows you to develop workflows as declarative model. In other words, there is no code in the workflows to be developed, only their declarations. It is aimed to apply business logic to the flow by communicating with the background systems over the services. It is built on Microsoft .Net Framework 4.5 and Windows Workflow Foundation.

The general use of Workflow Manager is running SharePoint Workflows on Microsoft SharePoint Server. Although Workflow Manager is not a technology created for SharePoint, it is mainly used with SharePoint product.

It works in Farm topology. So, just like SharePoint or Exchange Server farms, you perform a farm configuration after the initial server setup. Then, you can add servers to this farm that you created by installing applications on new servers. If we talk about SharePoint specific, you can also install directly on servers that have SharePoint Server installed without a separate server. (Not recommended, however)

After a brief summary about Workflow Manager, I would like to come to the main issue I want to address in this article. As with all server applications, you may want to move Workflow Manager to a different environment over the server that it is currently configured. Your reasons may be one of the following;

  • After the difficulties experienced in the current environment, you could not be able to make in-place corrections and you want to re-install.
  • After an architectural decision, you may want to install Workflow Manager as a separate farm.
  • After a disaster scenario, you may only have up-to-date Workflow Manager databases and want to continue your work with a new configuration.
  • You may want to renew the configuration due to infrastructure operations such as Windows upgrade, domain upgrade / change etc. in the installed environment.

It is possible to increase these reasons. Basically, re-installing and configuring an application does not seem like a serious problem. However, when it comes to a structure like Workflow Manager, one of the important issue is business continuity. You can have dozens of workflows that have been deployed on their existing setup, and thousands of instances of these workflows associated with SharePoint lists and libraries. Of course, you will not want to re-deploy all of your workflows, nor to lose the ongoing instances and restart them. At this point, it is significant to configure a healthy environment and to ensure that the existing farm works with ongoing instances of this environment.

To perform this process, we first need to define our prerequisites.