.NET Framework のコンソール アプリケーションで STA スレッドから XmlSerializer クラスを利用する場合の注意事項

こんにちは、Visual Studio サポート チームです。 今回は、.NET Framework のコンソール アプリケーションで STA 属性を指定したスレッドから、XmlSerializer クラスを利用するなどして直接、または間接的に COM コンポーネントが利用される場合の注意事項についてご案内します。   注意事項 STA に属する COM コンポーネントを作成した場合は、COM のガイドラインに則り、対象の STA スレッドでは定期的にメッセージ ポンプを動作させてウィンドウ メッセージを処理する必要があります。メッセージ ポンプの処理を実装していないと、対象 STA の外部からは COM コンポーネントにアクセスすることができません。このため、特に .NET Framework のコンソール アプリケーションでは、ファイナライザー スレッドが対象の STA スレッドと通信できずにハング アップしてしまい、メモリ リークなどの問題を引き起こす可能性があります。 STA スレッドがメッセージ ポンプを実装する必要がある点については以下のドキュメントに解説がありますのでご参照ください。 [OLE] OLE スレッド モデルの概要としくみ https://support.microsoft.com/ja-jp/help/150777/info-descriptions-and-workings-of-ole-threading-models   具体例 .NET Framework の XmlSerializer クラスでは、コンストラクタの特定のオーバーロード (*1) を利用すると、内部でアセンブリを生成してキャッシュする処理が行われます。この処理では内部的に…


IP Address Mapping in Power BI

I recently assisted in troubleshooting an issue where the error logs contained several unknown IP addresses. During this process, I created a quick dashboard in Power BI to display the location of these IP addresses on a map to get a better understanding of where the machines were located. I used a free service from…


CIMOL Goes to Seattle: Perjalanan ke Seattle

Sesuai rencana, tim CIMOL hari ini melakukan perjalanan ke Seattle dari Jakarta. Karena salah satu anggota tim (Tifani) harus mengikuti acara wisuda, maka rombongan kami dipecah menjadi 2 (dua): rombongan pertama terdiri dari Adi, Fery dan bu Ayu (mentor) berangkat tanggal 22 Juli, sedangkan Tifani berangkat tanggal 23 Juli. Hari ini, rombongan Adi, Fery dan…


Reset lost admin account password

Symptom: If you lost your admin account password, or you need to change the password for any reason follow this article to reset your admin account password. Resolution: Option 1: Using Azure Portal Using Azure Portal open your Azure SQL Server blade. Make sure you are in the Overview blade. Click on “Reset password” at…


Project Prague: What is it and why should you care?

Guest blog from Charlie Crisp, Microsoft Student Partner at the University of Cambridge This year at Build, Microsoft announced a ton of cool new stuff, including the new Cognitive Services Labs – a service which allows developers to get their hands on the newest and most experimental tools which are being developed by Microsoft. Particularly…


Microsoft Azure - Artificial Intelligence Data Science Stack

Microsoft now has an amazing offering for building and hosting your AI/Data Science solution. Infrastructure Azure Batch https://azure.microsoft.com/en-us/services/batch/ Docker Images for AI/Data Science  https://github.com/Azure/batch-shipyard/tree/master/recipes Data Platforms SQL Database/SQL Server https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017 Azure Datalake https://azure.microsoft.com/en-us/solutions/data-lake/ Azure Analysis Services https://azure.microsoft.com/en-us/services/analysis-services/ Azure Cosmos DB https://azure.microsoft.com/en-us/services/cosmos-db/ Hardware FPGA https://azure.microsoft.com/en-gb/resources/videos/build-2017-inside-the-microsoft-fpga-based-configurable-cloud/ GPU http://gpu.azure.com/ Processing Process data in Azure DataScience VM https://docs.microsoft.com/en-us/azure/machine-learning/machine-learning-data-science-virtual-machine-overview#whats-included-in-the-data-science-vm Azure…


Using Azure Functions, Cosmos DB and Powerapps to build, deploy and consume Serverless Apps

Azure Functions can be used to quickly build Application as Micro Services, complete with turnkey integration with other Azure Services like Cosmos DB, Queues, Blobs, etc , through the use of Input and output Bindings. Inbuilt tools can be used to generate Swagger definitions for these Services, publish them and consume them in Client side…


Rendering a large report in SharePoint mode fails with maximum message size quota exceeded error message

Recently, i was working on a scenario where reporting services 2012 was configured in SharePoint 2013 integrated mode. We were exporting a report that was ~240MB in size. When we do that, the reports fails with the following exception: 07/19/2017 13:37:57.46  w3wp.exe (0x2C80)                        0x0834 SQL Server Reporting Services  Service Application Proxy      00000 Monitorable Notified the…


Troubleshooting SQL Server Upgrade Issues

Recently, one of my partners, were facing issues upgrading SQL server 2008 from Service Pack 2 to Service Pack 3.  On checking the summary.txt in the setup bootstrap logs found the following error information : —————— Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log…


Installation of SSDT for BI on SQL 2014

A few days back, I was working with one of our partners who had a requirement of installing SQL Server Data Tools (SSDT) for Business Intelligence on their SQL server 2014 instance. When it comes to the same scenario in SQL 2012, the installation of SSDT is a straight forward procedure by selecting it on…