Category: Microsoft
Category Archives: Microsoft
fill series
I want to fill series in a column and skip those cell which has some values (text). and start Again from 1 in the next cell after text
I want to fill series in a column and skip those cell which has some values (text). and start Again from 1 in the next cell after text Read More
Why I Am Getting QuickBooks unrecoverable error when opening company file
I’m encountering a QuickBooks unrecoverable error every time I try to open my company file. It’s frustrating because I can’t access my financial data. What could be causing this issue, and how can I fix it? I’m using QuickBooks Desktop on Windows 10.
I’m encountering a QuickBooks unrecoverable error every time I try to open my company file. It’s frustrating because I can’t access my financial data. What could be causing this issue, and how can I fix it? I’m using QuickBooks Desktop on Windows 10. Read More
How to Fix QuickBooks Won’t Open Company File?
I’m encountering a frustrating issue with QuickBooks Won’t Open Company File. Every time I try, it just freezes or crashes. I’ve tried restarting my computer and reinstalling QuickBooks, but nothing seems to work. What could be causing this problem, and how can I fix it?
I’m encountering a frustrating issue with QuickBooks Won’t Open Company File. Every time I try, it just freezes or crashes. I’ve tried restarting my computer and reinstalling QuickBooks, but nothing seems to work. What could be causing this problem, and how can I fix it? Read More
Opportunity Details and Summary not showing up in Outlook
Hi ,
I have configured the sales copilot add-in but the only feature is see is linking and creating contact in Dynamics 365.
Email drafting, opportunity summary and other features are not coming up in Outlook add-in
Hi , I have configured the sales copilot add-in but the only feature is see is linking and creating contact in Dynamics 365. Email drafting, opportunity summary and other features are not coming up in Outlook add-in Read More
Person or Group column not allowing me to select options
Hi,
I have a Person or Group column on SharePoint. When trying to select some of the items they are coming up when I search for them but when I select them, it comes up with the message saying “We couldn’t find an exact match”. Does anyone know why this might be occurring and how I can get round it? Any help would be really appreciated.
Thanks,
Lucy
Hi, I have a Person or Group column on SharePoint. When trying to select some of the items they are coming up when I search for them but when I select them, it comes up with the message saying “We couldn’t find an exact match”. Does anyone know why this might be occurring and how I can get round it? Any help would be really appreciated. Thanks,Lucy Read More
Bulk Checkin in Sharepoint
I want to create a manually triggered flow in Power Automate to check in all files checked out by me in SharePoint, which are located in different folders. Is it possible to have such a flow?
I want to create a manually triggered flow in Power Automate to check in all files checked out by me in SharePoint, which are located in different folders. Is it possible to have such a flow? Read More
Why is My QuickBooks desktop 2022 running slow After latest Update?
I’m experiencing significant slowdowns with QuickBooks Desktop 2022, making it difficult to manage my finances efficiently. It’s frustrating as it disrupts my workflow and impacts productivity. Could you provide guidance on troubleshooting steps to address this issue? I need solutions that can help optimize the performance of QuickBooks and restore its speed to ensure seamless operation.
I’m experiencing significant slowdowns with QuickBooks Desktop 2022, making it difficult to manage my finances efficiently. It’s frustrating as it disrupts my workflow and impacts productivity. Could you provide guidance on troubleshooting steps to address this issue? I need solutions that can help optimize the performance of QuickBooks and restore its speed to ensure seamless operation. Read More
Disable link preview image
When copy-paste a link into a Microsoft Teams Chat window an extra large thumbnail (image preview) is inserted too.
I can close this thumbnail (thumb).
But it is very annoying to close each Web Link Preview Image or Link Thumbnail.
I do work a lot with links and references to other documents, I do not need to Microsoft Team to show a generic thumb towards those sites.
Skype has this feature of: Disable link preview image, where is it in Teams?
When copy-paste a link into a Microsoft Teams Chat window an extra large thumbnail (image preview) is inserted too.I can close this thumbnail (thumb). But it is very annoying to close each Web Link Preview Image or Link Thumbnail. I do work a lot with links and references to other documents, I do not need to Microsoft Team to show a generic thumb towards those sites. Skype has this feature of: Disable link preview image, where is it in Teams? Read More
New to MS Project – Changing start dates not being picked up.
This might be an easy question – I am new to MS Project. In a recent training group when changing the Start Date for a project in Project Information, the new start date is not picked up on the task list and Gantt chart? In a group of four people, my system was the only one ignoring the new start dates.
Our training facilitator had never experienced this before and was unsure how to help….
This might be an easy question – I am new to MS Project. In a recent training group when changing the Start Date for a project in Project Information, the new start date is not picked up on the task list and Gantt chart? In a group of four people, my system was the only one ignoring the new start dates. Our training facilitator had never experienced this before and was unsure how to help…. Read More
What To Do When Stuck In QuickBooks Enterprise 2022 Running Slow Issue?
Help! My QuickBooks Enterprise 2022 is running painfully slow. It’s affecting my productivity and causing frustration. What could be causing this sluggishness, and how can I resolve it quickly?
Help! My QuickBooks Enterprise 2022 is running painfully slow. It’s affecting my productivity and causing frustration. What could be causing this sluggishness, and how can I resolve it quickly? Read More
Teams for VDI – Screenshots Meetings
Any details on when being able to screenshot meetings/shared screens will be available for Teams for VDI / Windows 365? Currently have to use local desktop which is beyond annoying
https://learn.microsoft.com/en-us/azure/virtual-desktop/troubleshoot-teams#calls-and-meetings
Any details on when being able to screenshot meetings/shared screens will be available for Teams for VDI / Windows 365? Currently have to use local desktop which is beyond annoyinghttps://learn.microsoft.com/en-us/azure/virtual-desktop/troubleshoot-teams#calls-and-meetings Read More
How to Fix QuickBooks Desktop has Stopped Working after latest updates?
I recently updated my QuickBooks Desktop software, but now it keeps crashing with a ‘QuickBooks Desktop has Stopped Working’ message. I’m unable to access my financial data or complete any tasks. What could be causing this issue, and how can I resolve it quickly?
I recently updated my QuickBooks Desktop software, but now it keeps crashing with a ‘QuickBooks Desktop has Stopped Working’ message. I’m unable to access my financial data or complete any tasks. What could be causing this issue, and how can I resolve it quickly? Read More
Teams Adds Slash Commands to the Message Compose Box
Teams has added the ability to use slash commands (shortcuts) to the message compose box. Although the feature seems useful, I wonder about its potential usage. The fact is that people are pretty accustomed to how they compose message text and other options are available to add Loop or code blocks or set their online status, so why would they use the slash commands in the message compose box?
https://office365itpros.com/2024/05/16/teams-slash-commands/
Teams has added the ability to use slash commands (shortcuts) to the message compose box. Although the feature seems useful, I wonder about its potential usage. The fact is that people are pretty accustomed to how they compose message text and other options are available to add Loop or code blocks or set their online status, so why would they use the slash commands in the message compose box?
https://office365itpros.com/2024/05/16/teams-slash-commands/ Read More
Lesson Learned #488: A severe error occurred on the current command. Operation cancelled by user.
Today, I worked on a service request that our customer got this error message: “A severe error occurred on the current command. The results, if any, should be discarded.rnOperation cancelled by user.“. This cancellation happens before the CommandTimeout duration is met in the SQL Client application, normally, asynchronous database operations that the CancellationToken setting is reached. Following I would like to share with you my lessons learned.
The customer application was running asynchronous database operations and two primary types of cancellations can occur:
A CommandTimeout cancellation typically indicates that the query is taking longer than expected, possibly due to database performance issues or query complexity. On the other hand, a cancellation triggered by a CancellationToken may be due to application logic deciding to abort the operation, often in response to user actions or to maintain application responsiveness.
Error Handling and Connection Resilience:
Errors during query execution, such as syntax errors or references to non-existent database objects, necessitate immediate attention and are not suitable for retry logic. The application must distinguish these errors from transient faults, where retry logic with exponential backoff can be beneficial. Moreover, connection resilience is paramount, and implementing a retry mechanism for establishing database connections ensures that transient network issues do not disrupt application functionality.
Measuring Query Execution Time:
Gauging the execution time of queries is instrumental in identifying performance bottlenecks and optimizing database interactions. The example code demonstrates using a Stopwatch to measure and log the duration of query execution, providing valuable insights for performance tuning.
Adaptive Timeout Strategy:
The code snippet illustrates an adaptive approach to handling query cancellations due to timeouts. By dynamically adjusting the CommandTimeout and CancellationToken timeout values upon encountering a timeout-related cancellation, the application attempts to afford the query additional time to complete in subsequent retries, where feasible.
Tests and Results:
I conducted a series of tests to understand the behavior under different scenarios and the corresponding exceptions thrown by the .NET application. Here are the findings:
Cancellation Prior to Query Execution:
Scenario: The cancellation occurs before the query gets a chance to execute, potentially due to reasons such as application overload or a preemptive cancellation policy.
Exception Thrown: TaskCanceledException
Internal Error Message: “A task was canceled.”
Explanation: This exception is thrown when the operation is canceled through a CancellationToken, indicating that the asynchronous task was canceled before it could begin executing the SQL command. It reflects the application’s decision to abort the operation, often to maintain responsiveness or manage workload.
Cancellation Due to CommandTimeout:
Scenario: The cancellation is triggered by reaching the CommandTimeout of SqlCommand, indicating that the query’s execution duration exceeded the specified timeout limit.
Exception Thrown: SqlException with an error number of -2
Internal Error Message: “Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”
Explanation: This exception occurs when the query execution time surpasses the CommandTimeout value, prompting SQL Server to halt the operation. It suggests that the query may be too complex, the server is under heavy load, or there are network latency issues.
Cancellation Before CommandTimeout is Reached:
Scenario: The cancellation happens before the CommandTimeout duration is met, not due to the CommandTimeout setting but possibly due to an explicit cancellation request or an unforeseen severe error during execution.
Exception Thrown: General Exception (or a more specific exception depending on the context)
Internal Error Message: “A severe error occurred on the current command. The results, if any, should be discarded.rnOperation cancelled by user.”
Explanation: This exception indicates an abrupt termination of the command, potentially due to an external cancellation signal or a critical error that necessitates aborting the command. Unlike the TaskCanceledException, this may not always originate from a CancellationToken and can indicate more severe issues with the command or the connection.
using System;
using System.Diagnostics;
using System.Data;
using System.Threading;
using System.Threading.Tasks;
using Microsoft.Data.SqlClient;
namespace CancellationToken
{
class Program
{
private static string ConnectionString = “Server=tcp:servername.database.windows.net,1433;User Id=username;Password=pwd!;Initial Catalog=dbname;Persist Security Info=False;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Pooling=true;Max Pool size=100;Min Pool Size=1;ConnectRetryCount=3;ConnectRetryInterval=10;Application Name=ConnTest”;
private static string Query = “waitfor delay ’00:00:20′”;
static async Task Main(string[] args)
{
SqlConnection connection = await EstablishConnectionWithRetriesAsync(3, 2000);
if (connection == null)
{
Console.WriteLine(“Failed to establish a database connection.”);
return;
}
await ExecuteQueryWithRetriesAsync(connection, 5, 1000, 10000,15);
connection.Close();
}
private static async Task<SqlConnection> EstablishConnectionWithRetriesAsync(int maxRetries, int initialDelay)
{
SqlConnection connection = null;
int retryDelay = initialDelay;
for (int attempt = 1; attempt <= maxRetries; attempt++)
{
try
{
connection = new SqlConnection(ConnectionString);
await connection.OpenAsync();
Console.WriteLine(“Connection established successfully.”);
return connection;
}
catch (SqlException ex)
{
Console.WriteLine($”Failed to establish connection: {ex.Message}. Attempt {attempt} of {maxRetries}.”);
if (attempt == maxRetries)
{
Console.WriteLine(“Maximum number of connection attempts reached. The application will terminate.”);
return null;
}
Console.WriteLine($”Waiting {retryDelay / 1000} seconds before the next connection attempt…”);
await Task.Delay(retryDelay);
retryDelay *= 2;
}
}
return null;
}
private static async Task ExecuteQueryWithRetriesAsync(SqlConnection connection, int maxRetries, int initialDelay, int CancellationTokenTimeout, int CommandSQLTimeout)
{
int retryDelay = initialDelay;
for (int attempt = 1; attempt <= maxRetries; attempt++)
{
using (var cts = new CancellationTokenSource())
{
cts.CancelAfter(CancellationTokenTimeout*attempt); // Set CancellationToken timeout to 10 seconds
try
{
using (SqlCommand command = new SqlCommand(Query, connection))
{
command.CommandTimeout = CommandSQLTimeout*attempt; // Set CommandTimeout to 15 seconds
Stopwatch stopwatch = Stopwatch.StartNew();
await command.ExecuteNonQueryAsync(cts.Token);
stopwatch.Stop();
Console.WriteLine($”Query executed successfully in {stopwatch.ElapsedMilliseconds} milliseconds.”);
return;
}
}
catch (TaskCanceledException)
{
Console.WriteLine($”Query execution was canceled by the CancellationToken. Attempt {attempt} of {maxRetries}.”);
}
catch (SqlException ex) when (ex.Number == -2)
{
Console.WriteLine($”Query execution was canceled due to CommandTimeout. Attempt {attempt} of {maxRetries}.”);
}
catch (SqlException ex) when (ex.Number == 207 || ex.Number == 208 || ex.Number == 2627)
{
Console.WriteLine($”SQL error preventing retries: {ex.Message}”);
return;
}
catch (Exception ex)
{
Console.WriteLine($”An exception occurred: {ex.Message}”);
return;
}
Console.WriteLine($”Waiting {retryDelay / 1000} seconds before the next query attempt…”);
await Task.Delay(retryDelay);
retryDelay *= 2;
}
}
}
}
}
Disclaimer:
The example code provided in this article is intended for educational and informational purposes only. It is strongly recommended to test this code in a controlled and secure environment before implementing it in any production system. The user assumes full responsibility for any risks, damages, or losses incurred by using the code. The author and the blog are not liable for any issues that may arise from the use or misuse of the provided code.
Microsoft Tech Community – Latest Blogs –Read More
How to enable paraent control in windows 11?
Does Windows 11 have the native feature for parent control or I have to download 3rd-party app for doing this?
Does Windows 11 have the native feature for parent control or I have to download 3rd-party app for doing this? Read More
How to fix unrecoverable error in quickbooks desktop
I’m facing an unrecoverable error in QuickBooks Desktop, disrupting my workflow. It’s frustrating not being able to access crucial financial data. How can I troubleshoot this issue effectively?
I’m facing an unrecoverable error in QuickBooks Desktop, disrupting my workflow. It’s frustrating not being able to access crucial financial data. How can I troubleshoot this issue effectively? Read More
Conditional Access Policy – Register security information
Hi,
As response to a security incident we’ve created a conditional access policy to block registration of MFA methodes from other countries based on the User Actions = Register security information.
We noticed that users who are working in other countries using VPN sometimes can’t log in because of this conditional access.
It seems like after a number of logins, over a period of time, there is a registration triggered which causes this conditional access policy to be hit.
Excluding the affected user from this policy solves the issue, and after removing the exclusion the user can keep on working for a period of time without issues.
Is it correct to assume that there is an automatic registering of security information is triggered? What are the conditions for this to happen?
kind Regards,
Ivan
Hi,As response to a security incident we’ve created a conditional access policy to block registration of MFA methodes from other countries based on the User Actions = Register security information.We noticed that users who are working in other countries using VPN sometimes can’t log in because of this conditional access.It seems like after a number of logins, over a period of time, there is a registration triggered which causes this conditional access policy to be hit.Excluding the affected user from this policy solves the issue, and after removing the exclusion the user can keep on working for a period of time without issues.Is it correct to assume that there is an automatic registering of security information is triggered? What are the conditions for this to happen?kind Regards,Ivan Read More
PIM Groups prevent permanent assignment
Hi,
I am designing a PIM implementation and was planning on leveraging PIM groups for most privileged access management scenarios. I created a group and PIM-enabled it and configured the settings to prevent permanent assignment.
However, I find I can still assign permanent members via the normal Entra ID Groups section where you add members to a normal group. Then when I check the PIM section I see a permanent assignment.
Is there a way of preventing this?
Cheers,
Jeremy.
Hi,I am designing a PIM implementation and was planning on leveraging PIM groups for most privileged access management scenarios. I created a group and PIM-enabled it and configured the settings to prevent permanent assignment.However, I find I can still assign permanent members via the normal Entra ID Groups section where you add members to a normal group. Then when I check the PIM section I see a permanent assignment.Is there a way of preventing this?Cheers,Jeremy. Read More
How to Resolve QuickBooks Payroll Error PS032?
I’m encountering QuickBooks Payroll Error PS032 when trying to download updates. How can I fix this issue and update my QuickBooks Payroll successfully?
I’m encountering QuickBooks Payroll Error PS032 when trying to download updates. How can I fix this issue and update my QuickBooks Payroll successfully? Read More
Why Does My QuickBooks Data Conversion Services?
I’m encountering difficulties with QuickBooks data conversion services. How can I efficiently convert my data to QuickBooks format without errors or data loss?
I’m encountering difficulties with QuickBooks data conversion services. How can I efficiently convert my data to QuickBooks format without errors or data loss? Read More