Does anyone knows how to fix the error 10102? there is a lot of record of this issue on the web but no solution.

Its the one when you try to open a project with the desktop client, pressing the checkout button doesn’t do anything and when trying to publish through the info->menu, the following message appears:

“this project is no longer checked out to you on the project web app, to save as different project…” blablabla.

I deleted the cash, but it didn’t help.

The problem suddenly appeared a couple months ago, and is getting worse by the weeks, and Me and my colleagues are affected which makes me think it’s not a local issue on my PC.

I am the admin of this PWA instance so I have all the rights.

<detail><ServerExecutionFault xmlns=”http://Microsoft.Office.Project.Interfaces/” xmlns:i=”http://www.w3.org/2001/XMLSchema-instance“><Actor i:nil=”true”/><LastError>10102</LastError><Message></Message><Source></Source><StackTrace></StackTrace><TargetSite i:nil=”true”/><ExceptionDetails><errinfo xmlns=””><general><class name=”CICONotCheckedOut”><error id=”10102″ name=”CICONotCheckedOut” uid=”89ec1f75-7521-ef11-8ae4-00155da89d0c”/></class></general></errinfo></ExceptionDetails></ServerExecutionFault></detail>

​Does anyone knows how to fix the error 10102? there is a lot of record of this issue on the web but no solution.Its the one when you try to open a project with the desktop client, pressing the checkout button doesn’t do anything and when trying to publish through the info->menu, the following message appears:”this project is no longer checked out to you on the project web app, to save as different project…” blablabla.I deleted the cash, but it didn’t help.The problem suddenly appeared a couple months ago, and is getting worse by the weeks, and Me and my colleagues are affected which makes me think it’s not a local issue on my PC.I am the admin of this PWA instance so I have all the rights. <detail><ServerExecutionFault xmlns=”http://Microsoft.Office.Project.Interfaces/” xmlns:i=”http://www.w3.org/2001/XMLSchema-instance”><Actor i:nil=”true”/><LastError>10102</LastError><Message></Message><Source></Source><StackTrace></StackTrace><TargetSite i:nil=”true”/><ExceptionDetails><errinfo xmlns=””><general><class name=”CICONotCheckedOut”><error id=”10102″ name=”CICONotCheckedOut” uid=”89ec1f75-7521-ef11-8ae4-00155da89d0c”/></class></general></errinfo></ExceptionDetails></ServerExecutionFault></detail>    Read More

​

In our previous blogs we introduced you to what is Azure Cosmos DB and Azure Cosmos DB APIs like Azure Cosmos DB for PostgreSQL, Azure Cosmos DB for Apache Gremlin, Azure Cosmos DB for MongoDB. In this blog we are going to introduce you Azure Cosmos DB Emulator which will help to run Azure Cosmos DB offline and do local development with ease. 

Benefits of Azure Cosmos DB Emulator 

Local Development Environment: The emulator provides a local environment that closely emulates the Azure Cosmos DB service. You can use it to develop and test your applications without needing an active Azure subscription or incurring any service costs. 
Cost-Free Testing: By using the emulator, you can write and test code that interacts with Azure Cosmos DB APIs even when you have no network connection. This allows you to avoid any costs associated with using the actual cloud service 
Automation Workflow Support: Incorporating the emulator into your automation workflows enables consistent testing across local development machines and remote continuous integration jobs. 

Prerequisites 

.NET 6 or later, Node.js LTS, or Python 3.7 or later 

Ensure that all required executables are available in your PATH. 

Windows emulator 

64-bit Windows Server 2016, 2019, Windows 10, or Windows 11. 
Minimum hardware requirements: 

2-GB RAM 
10-GB available hard disk space 

What will be covered 

Installation process of Azure Cosmos DB Emulator 
Using Explorer in Azure Cosmos DB Emulator 
Connecting Azure Cosmos DB Emulator with Azure Data Studio 
Consuming Azure Cosmos DB using Azure Cosmos DB client library for JavaScript/TypeScript 

Installation process of Azure Cosmos DB Emulator   

Visit this page  
Under choose an API, select your preferred API, I will go with NoSQL. 
You can run the emulator in docker(both linux & windows) or windows via local installation which we are going to do. 
Download the Azure Cosmos DB emulator. 
Run the installer on your local machine with administrative privileges. 
The emulator automatically installs the appropriate developer certificates and configures firewall rules on your local machine. 

Start the emulator 

Start the emulator by selecting the application in the Windows Start menu. 
Alternatively, you can start the emulator’s executable (Microsoft.Azure.Cosmos.Emulator.exe) at the %ProgramFiles%Azure Cosmos DB Emulator path. 
Also, you can start the emulator from the command-line. Use these parameters to configure the emulator ie you can specify the port to use for the API for NoSQL endpoint. More about emulator cli commands  

Microsoft.Azure.Cosmos.Emulator.exe /Port=65000

The emulator automatically opens the data explorer using the URL https://localhost:8081/_explorer/index.html 
If you’re using docker you must configure emulator’s TLS/SSL certificate but Windows local installation of the emulator automatically imports the TLS/SSL certificates. No further action is necessary. 
You should be welcomed by this familiar screen. 

Using Explorer in Azure Cosmos DB Emulator 

Create a database, container, select database throughput, database max RU/s and partition key. Then press okey 

 You can confirm that you have created the database and container by 

Let’s create an item in our container. Click on items then new item and paste below json object and save. 

{

“eventId”: “unique_event_id”,

“eventName”: “Marathon”,

“eventDate”: “2024-05-20”,

“participants”: [

{

“participantId”: “participant1”,

“name”: “Alice”,

“score”: 1200

},

{

“participantId”: “participant2”,
“name”: “Bob”,
“score”: 1100

}
]

}

 Run query to select all items in our container. Click on run query, write your query and execute the query. 

You can access the Query Stats like RUs usage. You can also export the stats. 

Connecting Azure Cosmos DB Emulator with Azure Data Studio 

Download Azure data studio here and install it in your machine. 

Go to Azure Cosmos DB Emulator quickstart page and copy the Primary Connection String 

Open Azure data studio. Under extensions search Azure Cosmos DB and install the extension. 

Click on connections, create new connection, then select Azure Cosmos DB for NoSQL, select connection string, the paste the Primary Connection String we copied in the emulator. Press connect. 

The connection is successful, and you can easily use Azure Data Studio if its your preferred tool and create databases, containers make queries etc. 

U can take advantage of the import sample data button to get sample data to get started. A new container will be created with data. 

Consuming Azure Cosmos DB using Azure Cosmos DB client library for JavaScript/TypeScript 

We are going to use Azure Cosmos DB client library for JavaScript/TypeScript which is an SDK intended for JavaScript/TypeScript applications to interact with Azure Cosmos DB APIs. With it we can  

Create Cosmos DB databases and modify their settings.
Create and modify containers to store collections of JSON documents.
Create, read, update, and delete the items (JSON documents) in your containers.
Query the documents in your database using SQL-like syntax 

You can read more about this SDK here. 
I have prepared a small workshop here, to help you interact with Azure Cosmos DB Emulator with a simple API starter code which you can hook up with hono or express or your favorite JavaScript / Typescript backend. 

In client.config.ts, we have just initialized our cosmosClient and passed in endpoint and key stored in .env file. NB: I have added agent property to allow us to use the “https:” from our emulator smoothly in our local development. 
I have imported client.config.ts into db.config.ts to help us create our database and container programtically. Lastly I’m using data.ts to store sample objects we can use to save in our container. 

In my index.ts, I have included several functions to help interact with our emulator. If you run pnpm run dev

 or npm run dev you will get [ ]  meaning our container is empty but it have been created together with the database. 

If you uncomment createFamilyMember(familyMember) and alsorun you code. You should get one family member create 

You can confirm this on the Emulators explorer. 

Read more 

Optimize development and testing cost in Azure Cosmos DB 
Understand your Azure Cosmos DB bill 
Optimize request cost in Azure Cosmos DB 
Estimate RU/s using the Azure Cosmos DB capacity planner – Azure Cosmos DB for NoSQL 

​Microsoft Tech Community – Latest Blogs –Read More 

Hi guys,

Can someone please help me with a formula for the following task?

I have over 40,000 rows of data in ‘Table 1′, I’ve extracted a sample.

I need to analyse only cells which contain identical values in both ‘Product‘ and ‘Decrement‘ in ‘Table 1’. I have manually created a dataset in ‘Table 2′ which highlits the output I need.

Thanks in advance!! 

​ Hi guys, Can someone please help me with a formula for the following task? I have over 40,000 rows of data in ‘Table 1’, I’ve extracted a sample. I need to analyse only cells which contain identical values in both ‘Product’ and ‘Decrement’ in ‘Table 1’. I have manually created a dataset in ‘Table 2’ which highlits the output I need. Thanks in advance!!       Read More

​

TOC

Why we use it
Architecture
How to use it
References

Why we use it

An increasing number of security vulnerabilities are caused by sensitive information in the source code being leaked or accidentally uploaded to open repositories GitHub, leading to the exposure of a large amount of user privacy. This information includes, but is not limited to, database credentials, app keys, etc. Traditional MySQL databases use usernames and passwords for login operations, naturally leading to the inclusion of these credentials in project configuration files. Even with proper safeguards, there remain unpredictable risks, such as hacking.

This tutorial will introduce how to integrate Microsoft Entra with Azure Database for MySQL to avoid using fixed usernames and passwords. By utilizing system-assigned managed identities and user-assigned managed identities as a programmatic bridge, it becomes easier for Azure-related PaaS services (such as Function App or App Services) to communicate with the database without storing connection information in plain text.

Architecture

I will introduce each service or component and their configurations in subsequent chapters according to the order of A-E:

A: The company’s account administrator needs to create or designate a user as the database administrator. This role can only be assigned to one person within the database and is responsible for basic configuration and the creation and maintenance of other database users. It is not intended for development or actual system operations.

B: The company’s development department needs to create a Function App (or other service) as the basic unit of the business system. Programmers within this unit will write business logic (e.g., accessing the database) and deploy it here.

C: The company’s development department needs to create and manage a system-assigned managed identity for the Function App. In the future, the Function App will issue access requests to the database under its own identity.

D: The company’s security department needs to create one or more user-assigned managed identities. In the future, the Function App will issue access requests to the database under different user identities.

E: The company’s data department needs to create or maintain a database and designate Microsoft Entra as the only login method, eliminating other fixed username/password combinations.

For steps C and D, you can choose to implement one method or both, depending on your business scenarios.

How to use it

A: As this article does not dive into the detailed configuration of Microsoft Entra, it will only outline the process. The company’s account administrator needs to create or designate a user as the database administrator. In this example, we will call this user “cch,” and the account, “cch@thexxxxxxxxxxxx” will be used in subsequent steps.

B-1: In this example, we can create a Function App with any SKU/region. For the development language (stack), we choose Python as a demonstration, though other languages also support the same functionality. Since this article does not cover the detailed network configuration or other specifics of the Function App, we will use the default values for other settings. Simply click on “Review + Create,” and then click on “Create” to complete the process.

C-1: Meanwhile, in the Function App, navigate to the “Identity” option. We need to enable its system-assigned managed identity and make a note of its Object ID for use in next steps.

C-2: To get the detailed information of this system-assigned managed identity, please navigate to Microsoft Entra. Click on “Enterprise Applications,” then search for the name of your Function App in the search bar, and make sure to disable the application type filter.

After selecting this application, you will be able to obtain the application ID of the system-assigned managed identity from its page. Please make a note of this ID, as it will be used in subsequent steps.

D-1: Please open Azure Cloud Shell in the PowerShell mode and enter a command similar to the one below to create a user-assigned managed identity. You will need to change the <text> to follow your company’s naming conventions. Once the creation is successful, please note the returned values for “clientid” and “id” as these will be used in subsequent steps.

az identity create –resource-group <YOUR_RG_NAME> –name <YOUR_IDENTITY_NAME>

D-2: Staying in PowerShell mode, you will then need to use the “id” obtained in step D-1 to construct a command that will bind this user-assigned managed identity to the Function App.

az functionapp identity assign –resource-group <YOUR_RG_NAME> –name <YOUR_FUNCTION_APP_NAME> –identities <ID_IN_STEP_D1>

E-1: Create a database. During this process, you need to specify the user created in Step A as the database administrator and specify the user-assigned managed identity created in Step D as the entity that will actually operate the database. Please note that the MySQL version needs to be at least 5.7 or higher, and for the authentication method, select “Microsoft Entra authentication only.” In this mode, the username/password will no longer be used. Then, click on “Next: Networking.”

Since this article does not cover the detailed network configuration of the database, temporarily allow public access during the tutorial. Use the default values for other settings, click on “Review + Create,” and then click “Create” to finish the setup.

E-2: After the database is created, you can log in using the identity “cch@thexxxxxxxxxxxx” you’ve get from Step A which is the database administrator. Log in to the Azure portal using the “cch” account, open an Azure Cloud Shell, and switch to Bash mode. Then, enter the following command to log in to MySQL. You will need to change the <text> to follow your company’s naming conventions.

mysql -h <YOUR_DB_NAME>.mysql.database.azure.com –user <YOUR_FULL_USER_EMAIL> –enable-cleartext-plugin –password=`az account get-access-token –resource-type oss-rdbms –output tsv –query accessToken`

Here, we additionally introduce the method for logging in using a GUI-related MySQL client. In the previous command, you may notice a nested command enclosed within backticks “. This is used to get an access token for database access as the “cch” user. This token can be used as the password when logging into MySQL clients (e.g., DataGrip, HeidiSQL).

az account get-access-token –resource-type oss-rdbms –output tsv –query accessToken

Returning to the MySQL console, we will now create user accounts in MySQL for the managed identities setup from Step C and Step D. First, we will introduce the method for the user-assigned managed identity. Please enter the following command.

SET aad_auth_validate_oids_in_tenant = OFF;
CREATE AADUSER ‘<SPECIFY_A_PROPER_NAME>’ IDENTIFIED BY ‘<YOUR_CLIENT_ID_FROM_D1>’;

The purpose of these two commands is to create a MySQL user account specifically for the managed identity. You can freely name the account; in this example, I have named it “miuser”.

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON *.* TO ‘<SPECIFY_A_PROPER_NAME>’@’%’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

The purpose of the next two commands is to grant database-related operational permissions to the newly created user. This is just an example. In actual scenarios, you should follow your company’s security policies and make the necessary adjustments accordingly.

Once you are familiar with the method, you can proceed to perform the same operations for the system-assigned managed identity.

SET aad_auth_validate_oids_in_tenant = OFF;
CREATE AADUSER ‘<SPECIFY_A_PROPER_NAME>’ IDENTIFIED BY ‘<YOUR_APP_ID_FROM_C2>’;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON *.* TO ‘<SPECIFY_A_PROPER_NAME>’@’%’ WITH GRANT OPTION;
FLUSH PRIVILEGES;

For testing purposes in later steps, we will create a test database, a test table, and insert some data. Please put this data schema in the mysql console.

CREATE DATABASE test;
USE test;
CREATE TABLE test.welcome_test(
id int AUTO_INCREMENT PRIMARY KEY,
test VARCHAR(4) NOT NULL
) ENGINE=InnoDB;
INSERT INTO test.welcome_test(test) VALUES (‘asdf’);

B-2: Programmer can now deploy the code to the Function App. In this tutorial, we use Python to complete the example and utilize “Programming Model v2”. Other languages also have their respective MySQL connectors and follow the same principles.

In requirements.txt, in addition to the existing azure-functions, please add the following two packages: azure-identity and mysql-connector-python.

azure-functions
azure-identity
mysql-connector-python

In function_app.py, include the following example content:

import azure.functions as func
import logging
import mysql.connector
from mysql.connector import errorcode
import azure.identity
from azure.identity import DefaultAzureCredential
from azure.identity import ManagedIdentityCredential
app = func.FunctionApp(http_auth_level=func.AuthLevel.ANONYMOUS)
@app.route(route=”mysqltest”)
def mysqltest(req: func.HttpRequest) -> func.HttpResponse:
ret = “”
# —————————-
logging.info(‘Get token from system assigned identity’)
smi = DefaultAzureCredential()
stoken = smi.get_token(“https://ossrdbms-aad.database.windows.net”).token
stoken = str(stoken).strip()
sconn = mysql.connector.connect(**{
‘host’:’mimysql-db.mysql.database.azure.com’, # change to your server
‘user’:’smiuser’, # change to your username
‘password’:stoken,
‘auth_plugin’:’mysql_clear_password’,
‘client_flags’: [mysql.connector.ClientFlag.SSL],
‘database’:’test’ # change to your database
})
scursor = sconn.cursor()
scursor.execute(“SELECT * FROM welcome_test;”) # change to your table
srows = scursor.fetchall()
sret = “”
for srow in srows:
sret += str(srow[1])
sconn.commit()
scursor.close()
sconn.close()
# —————————-
logging.info(‘Get token from user assigned identity’)
umi = ManagedIdentityCredential(client_id=”1ddc2a7e-xxxx-xxxx-xxxx-xxxxxxxxxxxx”) # change to your client id from Step D1
utoken = umi.get_token(“https://ossrdbms-aad.database.windows.net”).token
utoken = str(utoken).strip()
uconn = mysql.connector.connect(**{
‘host’:’mimysql-db.mysql.database.azure.com’, # change to your server
‘user’:’miuser’, # change to your username
‘password’:utoken,
‘auth_plugin’:’mysql_clear_password’,
‘client_flags’: [mysql.connector.ClientFlag.SSL],
‘database’:’test’ # change to your database
})
ucursor = uconn.cursor()
ucursor.execute(“SELECT * FROM welcome_test;”) # change to your table
urows = ucursor.fetchall()
uret = “”
for urow in urows:
uret += str(urow[1])
uconn.commit()
ucursor.close()
uconn.close()
# —————————-
return func.HttpResponse(sret + uret)

Please note that the code I provided in this tutorial is only suitable for the testing phase. Its purpose is to verify usability and it is not intended for production use. Ultimately, please make the corresponding modifications based on the business functionality and security guidelines of your own environment.

Once the deployment is complete, you can proceed with testing. We can observe that the Function App will call the authentication endpoint in the background to get an access token. It will then use this token to interact with the database and subsequently print out the queried data.

An important thing in the code is the following snippet.

‘auth_plugin’:’mysql_clear_password’,

Referencing Step E-2, when “cch” used the MySQL console during the connection process, the –enable-cleartext-plugin parameter was used. This parameter means that the client can send the password to the server in clear text because the password is already in the form of an encrypted token. Unlike traditional plain-text passwords that need to be encrypted on the client side before transmission, it can be sent directly in plain text to the server. Different languages and different MySQL connectors may require similar configurations, so this should be noted carefully.

References

Active Directory authentication – Azure Database for MySQL | Microsoft Learn

Use Microsoft Entra ID – Azure Database for MySQL | Microsoft Learn

How to create users for Azure Database for MySQL | Microsoft Learn

Connect with Managed Identity – Azure Database for MySQL | Microsoft Learn

Set up Microsoft Entra authentication – Azure Database for MySQL – Flexible Server | Microsoft Learn

Use managed identities on a virtual machine to acquire access token – Managed identities for Azure resources | Microsoft Learn

Azure AD authentication for Azure MySQL! (microsoft.com)

How to connect to Azure Database for MySQL using Managed Identity of Function App – Microsoft Community Hub

​Microsoft Tech Community – Latest Blogs –Read More 

When compressing larger files with the new create archive options there will be no progress bar, until File Explorer really finished and writes the file to disk.

The dialogue will show “not responding” meanwhile. Only mouse cursor “busy” and taskmanager reveals that something is still going on.

https://aka.ms/AAqogye

​When compressing larger files with the new create archive options there will be no progress bar, until File Explorer really finished and writes the file to disk.
The dialogue will show “not responding” meanwhile. Only mouse cursor “busy” and taskmanager reveals that something is still going on.
 
https://aka.ms/AAqogye  Read More

​