SharePoint Cannot see Folder under Upload button

This short post shows you one of the reasons you cannot see Folder under the Upload button in SharePoint, like the picture below.

The reason here is because you use Internet Explorer. Internet Explorer has become helpless now a day. I need to open your SharePoint Document Library using Microsoft Edge or Google Chrome.

Posted in .Net, Cloud, Community, Computers and Internet, Office 365 | Tagged | Leave a comment

System.InvalidOperationException: Connector: M365xxxxx.onmicrosoft.com – AAD is busy.

This post shows you how to get rid of the below error.

“System.InvalidOperationException: Connector: M365xxxxx.onmicrosoft.com – AAD is busy.”

When you issue the below command in PowerShell.

Start-ADSyncSyncCycle -PolicyType Delta

You need to do this to run the command.

Enter-PSSession -ComputerName TypeInYourComputerName

Start-ADSyncSyncCycle -PolicyType Delta

Exit-PSSession

Posted in .Net, Cloud, Community, Computers and Internet, Office 365, sharepoint | Tagged , | Leave a comment

Office 365 You cannot turn off Active Directory synchronization

This post shows one of the possible solutions

Set-MsolDirSyncEnabled : You cannot turn off Active Directory synchronization.”

When you run the following PowerShell command.

“Set-MsolDirSyncEnabled -EnableDirSync $true”

For me I start my Azure AD Connect. Choose Configure then choose Next.

Once it is done rerun the Set-MsolDirSyncEnabled -EnableDirSync $true. This works for me.

Reference: https://jaapwesselius.com/2018/03/22/set-msoldirsyncenabled-not-available/

Posted in .Net, Cloud, Community, Computers and Internet, Office 365 | Tagged | Leave a comment

Microsoft Forms Pro

This post guide you to Microsoft Forms Pro in the way I understand. When I reach https://formspro.microsoft.com/en-us/ then start to worry how much I need to pay for this because in order to create your Form with question with Italic font in it then you need Microsoft Forms Pro. Somehow I can get an evaluate without paying. When you reach the landing page, do not click the Sign n. Click Get started then put in your email address.

You will then get the feature of Forms Pro when you are creating a Form.

The end result is like the one below.

Posted in .Net, Cloud, Community, Computers and Internet, Microsoft Office, Office 365 | Tagged , | Leave a comment

SSIS Parallel Data Source using OFFSET…FETCH NEXT

This post shows you how to divide huge single table data extracting in SSIS to multiple parallel data source using the T-SQL offset and fetch next feature.

The pre-requisite is you need to have a knowledge on SSIS and T-SQL. In this sample I will use northwind database Products tables and load the data parallelly into Products2 table. First you need to have a Control Flow as below. Create 2 SSIS variable name them varRows and varReminder.


The total rows will divide equally by 5. I will use Data Flow Task to Data Flow Task 4 to run them. The reminding rows will run in Data Flow 5. Assign the result divided by 5 into varRows, for example if the total rows is 78 then varRows will get 15. So Data Flow Task to Data Flow Task 4 will run 15 rows each. Data Flow Task 5 will run the reminding 3 rows. Inside the code into the Script Task as below.

public void Main()

{

    string strCon = “data source=.;initial catalog=NorthWind;user id=sa; password=”password”;

    string strSql = “SELECT COUNT(ProductId) as RowsCount FROM Products”;

    SqlConnection conn = new SqlConnection(strCon);

    conn.Open();

    SqlCommand cmd = new SqlCommand(strSql, conn);

    SqlDataReader dr = cmd.ExecuteReader();

    while (dr.Read())

    {

        Dts.Variables[“User::varRows”].Value = long.Parse(dr[0].ToString()) / 5;

        Dts.Variables[“User::varRemainer”].Value = long.Parse(dr[0].ToString()) % 5;

    }

    Dts.TaskResult = (int)ScriptResults.Success;

}

In the Data Flow Task OLE DB Source put the following SQL statement.


The task will start from row 0. It will take 15 rows.

SELECT * FROM Products

order by ProductId

OFFSET 0 ROWS

FETCH NEXT ? ROWS ONLY

In the Data Flow Task 1 OLE DB Source put the following SQL statement This task will start from row 16. You realized both parameters are also varRows.


SELECT * FROM Products

order by ProductId

OFFSET ? ROWS

FETCH NEXT ? ROWS ONLY

In the Data Flow Task 2 OLE DB Source put the following SQL statement This task will start from row 31 because Offset 15×2=30.

SELECT * FROM Products

order by ProductId

OFFSET (? * 2) ROWS

FETCH NEXT ? ROWS ONLY

In data Flow Task 5 the second parameter is the varReminder, the reminding rows to fetch.


SELECT * FROM Products

order by ProductId

OFFSET (? * 5) ROWS

FETCH NEXT ? ROWS ONLY

Theoretically, this should run faster than you run all the rows in one data source.

Source code: https://github.com/chanmmn/SSISOFFSETFETCHNEXT

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged | Leave a comment

Hadoop installation in Windows 2016 Server

This post shows you the installation of Hadoop in Windows 2016 Server but you might face the warning like I do. If you follow the step of https://muhammadbilalyar.github.io/blogs/How-to-install-Hadoop-on-Window-10/ then you can be successfully setup Hadoop in a Windows Server. Few things you need to watch out.

1. You need to download Hadoop 2.8.0 because you are not able to find 2.10.0 hadoop.dll.

2. I am using latest Java jdk 12, means the path in the article may not be the same as yours as well.

3. Don’t miss hdfs namenode –format else your http://localhost:50070 will not work.

After the installation normally you will to use the Hadoop fs command. I got the warning below that I cannot get rid of.

WARNING: An illegal reflective access operation has occurred

WARNING: Illegal reflective access by org.apache.hadoop.security.authentication.util.KerberosUtil (file:/C:/hadoop-2.8.0/share/hadoop/common/lib/hadoop-auth-2.8.0.jar) to method sun.security.krb5.Config.getInstance()

WARNING: Please consider reporting this to the maintainers of org.apache.hadoop.security.authentication.util.KerberosUtil

WARNING: Use –illegal-access=warn to enable warnings of further illegal reflective access operations

WARNING: All illegal access operations will be denied in a future release

This is not the end. Pig has no update after 2017. You might try Hive. MapReduce is the Java code. So, I am yet to find a way to do the analysis part of it.

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment

Migrate to Microsoft SQL Server

This post shows you the tools you can use when migrating your data to Microsoft SQL Server.

Compatibility Certification

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/compatibility-certification?view=sql-server-ver15?WT.mc_id=DP-MVP-36769

What is Azure Database Migration Service?

https://docs.microsoft.com/en-us/azure/dms/dms-overview?WT.mc_id=DP-MVP-36769

Overview of Data Migration Assistant

https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15?WT.mc_id=DP-MVP-36769

Overview of Database Experimentation Assistant

https://docs.microsoft.com/en-us/sql/dea/database-experimentation-assistant-overview?view=sql-server-ver15?WT.mc_id=DP-MVP-36769

SQL Server Migration Assistant

https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15?WT.mc_id=DP-MVP-36769

SQL Server Migration Assistant for MySQL (MySQLToSQL)

https://docs.microsoft.com/en-us/sql/ssma/mysql/sql-server-migration-assistant-for-mysql-mysqltosql?view=sql-server-ver15?WT.mc_id=DP-MVP-36769

Posted in .Net, Cloud, Community, Computers and Internet, Data Platform | Tagged , | Leave a comment