Tag Archives: microsoft
Cloning/duplicating sharePoint site
Hi there,
We have a SharePoint intranet site (using the modern communication template), there is talk of the site needing a redesign/changing on menu etc. Is there a way of cloning/creating a duplicate copy of the entire site, so the users can make/experiment with making changes/redesign etc and not affecting the main/actual site? There is no option for save template for modern communication template.
Thanks in advance
Hi there,We have a SharePoint intranet site (using the modern communication template), there is talk of the site needing a redesign/changing on menu etc. Is there a way of cloning/creating a duplicate copy of the entire site, so the users can make/experiment with making changes/redesign etc and not affecting the main/actual site? There is no option for save template for modern communication template.Thanks in advance Read More
URGENT HELP NEEDED! Microsoft To Do has deleted extremely important reminders
I really need help. Microsoft To Do has deleted so many very important reminders. Things relating to work, finances, paying bills, subscriptions, everything. I’m despairing and really hoping there is some way to retrieve them
I have Microsoft To Do installed on (1) My Chromebook and (2) My Samsung Galaxy A52s 5G
8 hours ago all the reminders were in 2 lists – “Important with deadline” and “Important”. Together there were around 300 reminders. On my Chromebook I selected all the reminders in one list and moved them all to “Tasks”. I did the same thing with the other lists. I could see that the number to the right of “Tasks” had gone up by 300, and that the reminders had copy pasted in successfully. I thus proceeded to delete the 2 lists
Now I’ve discovered that for some reason the number of “Tasks” has reduced by 300 and I can no longer find the reminders on either my Chromebook or Samsung. The 2 lists have not returned – they are still deleted as far as I can tell (unless they’re hiding somewhere?). I’ve logged into Microsoft Outlook and the reminders are not in “Deleted Items”
I really hope there’s some way for me to retrieve these numerous reminders because they were beyond important. Any help would be greatly appreciated guys. Is there some automatic backup that would have the reminders?
I really need help. Microsoft To Do has deleted so many very important reminders. Things relating to work, finances, paying bills, subscriptions, everything. I’m despairing and really hoping there is some way to retrieve them I have Microsoft To Do installed on (1) My Chromebook and (2) My Samsung Galaxy A52s 5G 8 hours ago all the reminders were in 2 lists – “Important with deadline” and “Important”. Together there were around 300 reminders. On my Chromebook I selected all the reminders in one list and moved them all to “Tasks”. I did the same thing with the other lists. I could see that the number to the right of “Tasks” had gone up by 300, and that the reminders had copy pasted in successfully. I thus proceeded to delete the 2 listsNow I’ve discovered that for some reason the number of “Tasks” has reduced by 300 and I can no longer find the reminders on either my Chromebook or Samsung. The 2 lists have not returned – they are still deleted as far as I can tell (unless they’re hiding somewhere?). I’ve logged into Microsoft Outlook and the reminders are not in “Deleted Items”I really hope there’s some way for me to retrieve these numerous reminders because they were beyond important. Any help would be greatly appreciated guys. Is there some automatic backup that would have the reminders? Read More
Why is my Quickbooks Payroll Tax Updates Not Working?
How can I encounter and resolve the issue of QuickBooks Payroll tax updates not functioning properly? Seeking guidance on resolving this problem efficiently. Appreciate any assistance.
How can I encounter and resolve the issue of QuickBooks Payroll tax updates not functioning properly? Seeking guidance on resolving this problem efficiently. Appreciate any assistance. Read More
How to Get Rid of Quickbooks Error 15103 Windows 10
I’m encountering QuickBooks Error 15103 on my Windows 10 system. It’s disrupting my workflow and I need a solution fast. What could be causing this error and how can I fix it to resume using QuickBooks smoothly
I’m encountering QuickBooks Error 15103 on my Windows 10 system. It’s disrupting my workflow and I need a solution fast. What could be causing this error and how can I fix it to resume using QuickBooks smoothly Read More
Powershell to find out if a user has blocked a phone number
Hello
Is there a powershell to run to find out if a user has blocked a phone number
Regards
JFM_12
HelloIs there a powershell to run to find out if a user has blocked a phone numberRegardsJFM_12 Read More
How to Fix QuickBooks Error 6129 in Windows 11
I encountered QuickBooks Error 6129 on Windows 11 while trying to access my company file. It’s frustrating and I need a solution fast. Can anyone help me understand why this error is happening on Windows 11 and what steps I can take to resolve it? I’m worried about data loss and the impact on my business. Any guidance would be greatly appreciated
I encountered QuickBooks Error 6129 on Windows 11 while trying to access my company file. It’s frustrating and I need a solution fast. Can anyone help me understand why this error is happening on Windows 11 and what steps I can take to resolve it? I’m worried about data loss and the impact on my business. Any guidance would be greatly appreciated Read More
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