Category: News
Disabling Bits of Copilot for Microsoft 365
The Copilot for Microsoft 365 license has 8 service plans to govern feature availability. You can disable individual components, if you know what you’re doing. One thing that’s not possible is to disable Copilot for individual Office apps. A single service plan covers all the “productivity apps,” so they’re either all on or all off.
https://office365itpros.com/2024/04/30/copilot-for-microsoft-365-service-plans/
The Copilot for Microsoft 365 license has 8 service plans to govern feature availability. You can disable individual components, if you know what you’re doing. One thing that’s not possible is to disable Copilot for individual Office apps. A single service plan covers all the “productivity apps,” so they’re either all on or all off.
https://office365itpros.com/2024/04/30/copilot-for-microsoft-365-service-plans/ Read More
Export custom event fields Outlook desktop
Hello:
I have created a custom template with custom fields, which is used to make an appointment in certain calendar.
When I export data from that calendar to csv , custom fields are not exported.
Does anybody know the way to export this kind of data?
Is it possible?
Thank you very much.
Hello: I have created a custom template with custom fields, which is used to make an appointment in certain calendar.When I export data from that calendar to csv , custom fields are not exported.Does anybody know the way to export this kind of data?Is it possible? Thank you very much. Read More
PWA Tasks View for an individual and task usage view
We are currently using PWA as our project management tool. We have a task that runs from Mon 29/04/24 Fri 03/05/24 for 15 hours of work in total. The assigned resource can see the task and total work in their task view:
However, there are no planned hours in the current period.
When the view is changed to task usage in the plan the scheduled hours are shown for this period
We have tried changing the task to Auto-schedule, unassigning and reassigning the task to the same resource. None of which has worked.
We would be very grateful for any advice. Thank you
We are currently using PWA as our project management tool. We have a task that runs from Mon 29/04/24 Fri 03/05/24 for 15 hours of work in total. The assigned resource can see the task and total work in their task view:However, there are no planned hours in the current period.When the view is changed to task usage in the plan the scheduled hours are shown for this periodWe have tried changing the task to Auto-schedule, unassigning and reassigning the task to the same resource. None of which has worked. We would be very grateful for any advice. Thank you Read More
How fix QuickBooks Payroll Error PS032 after update windows 10/11?
Troubleshooting Solutions: QuickBooks Payroll Error PS032
QuickBooks Payroll Error PS032 typically occurs when there are issues with the QuickBooks software or the Payroll subscription. This error can prevent you from updating your payroll tax tables or processing payroll. Here are several troubleshooting steps to resolve this issue:
Update QuickBooks Desktop: Start by ensuring that your QuickBooks Desktop software is updated to the latest release. QuickBooks frequently releases updates and patches to fix bugs and errors. To update, go to the Help menu, select Update QuickBooks Desktop, and follow the prompts.Check Payroll Subscription Status: Verify that your Payroll subscription is active and up-to-date. If your subscription has expired or encountered issues, it can cause PS032 errors. Log in to your Intuit account to check your subscription status and renew if necessary.Download Payroll Updates: Ensure that you’ve downloaded the latest payroll tax table updates. These updates include the most recent tax rates and calculations required for accurate payroll processing. In QuickBooks, go to the Employees menu, select Get Payroll Updates, and then click Download Entire Update.Verify Billing Information: Confirm that your billing information in QuickBooks is accurate and up-to-date. Incorrect billing details can lead to subscription errors, including PS032. Update your billing information if necessary through the Account Management portal.Repair QuickBooks Desktop Installation: Sometimes, the QuickBooks installation itself might be corrupted, causing PS032 errors. You can repair the installation to fix any damaged files. Navigate to the Control Panel on your computer, select Programs and Features, locate QuickBooks in the list, and choose Repair.Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair common QuickBooks issues, including PS032 errors. Download and run the tool from the QuickBooks Tool Hub, which can be found on the Intuit website. Follow the on-screen instructions to scan and fix errors.Check for Windows Updates: Ensure that your Windows operating system is up-to-date with the latest patches and updates. Sometimes, system updates can resolve compatibility issues that lead to PS032 errors in QuickBooks.Disable User Account Control (UAC): User Account Control settings in Windows can sometimes interfere with QuickBooks operations. Temporarily disable UAC and then try updating your payroll tax tables again. Remember to re-enable UAC after troubleshooting.Consult QuickBooks Support: If you’ve exhausted these troubleshooting steps and are still encountering the PS032 error, it’s recommended to contact QuickBooks Support for further assistance. They can provide personalized guidance and help resolve complex issues.
By following these troubleshooting solutions, you should be able to resolve the QuickBooks Payroll Error PS032 and resume normal payroll processing without interruptions. Remember to keep your software and subscriptions updated regularly to prevent similar issues in the future.
Troubleshooting Solutions: QuickBooks Payroll Error PS032 QuickBooks Payroll Error PS032 typically occurs when there are issues with the QuickBooks software or the Payroll subscription. This error can prevent you from updating your payroll tax tables or processing payroll. Here are several troubleshooting steps to resolve this issue: Update QuickBooks Desktop: Start by ensuring that your QuickBooks Desktop software is updated to the latest release. QuickBooks frequently releases updates and patches to fix bugs and errors. To update, go to the Help menu, select Update QuickBooks Desktop, and follow the prompts.Check Payroll Subscription Status: Verify that your Payroll subscription is active and up-to-date. If your subscription has expired or encountered issues, it can cause PS032 errors. Log in to your Intuit account to check your subscription status and renew if necessary.Download Payroll Updates: Ensure that you’ve downloaded the latest payroll tax table updates. These updates include the most recent tax rates and calculations required for accurate payroll processing. In QuickBooks, go to the Employees menu, select Get Payroll Updates, and then click Download Entire Update.Verify Billing Information: Confirm that your billing information in QuickBooks is accurate and up-to-date. Incorrect billing details can lead to subscription errors, including PS032. Update your billing information if necessary through the Account Management portal.Repair QuickBooks Desktop Installation: Sometimes, the QuickBooks installation itself might be corrupted, causing PS032 errors. You can repair the installation to fix any damaged files. Navigate to the Control Panel on your computer, select Programs and Features, locate QuickBooks in the list, and choose Repair.Run QuickBooks File Doctor: Utilize the QuickBooks File Doctor tool to diagnose and repair common QuickBooks issues, including PS032 errors. Download and run the tool from the QuickBooks Tool Hub, which can be found on the Intuit website. Follow the on-screen instructions to scan and fix errors.Check for Windows Updates: Ensure that your Windows operating system is up-to-date with the latest patches and updates. Sometimes, system updates can resolve compatibility issues that lead to PS032 errors in QuickBooks.Disable User Account Control (UAC): User Account Control settings in Windows can sometimes interfere with QuickBooks operations. Temporarily disable UAC and then try updating your payroll tax tables again. Remember to re-enable UAC after troubleshooting.Consult QuickBooks Support: If you’ve exhausted these troubleshooting steps and are still encountering the PS032 error, it’s recommended to contact QuickBooks Support for further assistance. They can provide personalized guidance and help resolve complex issues.By following these troubleshooting solutions, you should be able to resolve the QuickBooks Payroll Error PS032 and resume normal payroll processing without interruptions. Remember to keep your software and subscriptions updated regularly to prevent similar issues in the future. Read More
Restricted SharePoint Search is The Legacy of Previous Microsoft Collaboration Strategies
Microsoft has been forced to introduce restricted SharePoint search to allow customers to deploy Copilot for Microsoft 365 projects without worrying that Copilot will find and reuse information from across the entire tenant. It’s a sad legacy of previous Microsoft collaboration strategies, notably the decision to allow users to create groups without hindrance.
https://practical365.com/restricted-sharepoint-search/
Microsoft has been forced to introduce restricted SharePoint search to allow customers to deploy Copilot for Microsoft 365 projects without worrying that Copilot will find and reuse information from across the entire tenant. It’s a sad legacy of previous Microsoft collaboration strategies, notably the decision to allow users to create groups without hindrance.
https://practical365.com/restricted-sharepoint-search/ Read More
Error while downloading pdf from Onedrive through get content api
Hello,
I am getting java Unknown host exception: my.microsoftpersonalcontent.com : Name does not found error.
My code was running fine but from last 10 days i was facing this issue , also i have not changed anything in my code or url given by Onedrive documentation.
Hello,I am getting java Unknown host exception: my.microsoftpersonalcontent.com : Name does not found error. My code was running fine but from last 10 days i was facing this issue , also i have not changed anything in my code or url given by Onedrive documentation. Read More
How can we get new SPO sites re-created for the existing teams
Hello
Please i need your help on this issue.
A couple of years ago, we setup a few Microsoft Teams (which had some files in the associated SharePoint sites). The vendor let the licensing lap, so the sites were deleted.
Unfortunately we could not restore the sites because it has pass the 93days default duration that Microsoft cloud stores data for deleted.
I would like to know how can we get new SPO sites re-created for the existing teams? Creating new teams isn’t an option.
Is it possible as we want to get a new SPO sites recreated for the existing teams.
Hello Please i need your help on this issue. A couple of years ago, we setup a few Microsoft Teams (which had some files in the associated SharePoint sites). The vendor let the licensing lap, so the sites were deleted. Unfortunately we could not restore the sites because it has pass the 93days default duration that Microsoft cloud stores data for deleted. I would like to know how can we get new SPO sites re-created for the existing teams? Creating new teams isn’t an option. Is it possible as we want to get a new SPO sites recreated for the existing teams. Read More
Exchange Cross-Forest migration and Autodiscover
We’re planning a cross-forest migration for a company splitting scenario.
At the moment there’s an exchange organization with several accepted domains which the two most important are domainA.com and DomainB.com
The migration will involve DomainB.com users.
During the migration we will have a coexistence period where domainB.com users are on both the AD domains.
The migration will be carried with ADMT tool.
My question is about the autodiscover URL which is now pointing to the current Exchange infrastructure.
When an user is migrated with his mailbox and PC his outlook client, and the next startup, will query the autodiscover pointing to the “old” exchange server and, I think, it will fail.
Can anyone share any experiences on how to carry this kind of migration with the least impact on the users ?
We’re planning a cross-forest migration for a company splitting scenario.At the moment there’s an exchange organization with several accepted domains which the two most important are domainA.com and DomainB.comThe migration will involve DomainB.com users.During the migration we will have a coexistence period where domainB.com users are on both the AD domains.The migration will be carried with ADMT tool.My question is about the autodiscover URL which is now pointing to the current Exchange infrastructure.When an user is migrated with his mailbox and PC his outlook client, and the next startup, will query the autodiscover pointing to the “old” exchange server and, I think, it will fail.Can anyone share any experiences on how to carry this kind of migration with the least impact on the users ? Read More
Preserve Disk space in ImageStore for Service Fabric Managed Clusters
As mentioned in this article: Service Fabric: Best Practices to preserve disk space in Image Store ImageStore keeps copied packages and provisioned packages.
In this article, we will discuss how can you configure cleaning up the copied application package for Service Fabric Managed Cluster ‘SFMC’.
The mitigation is to set “AllowRuntimeCleanupUnusedApplicationTypesPolicy“: “true“.
For properties, specify the following tags:
…
“applicationTypeVersionsCleanupPolicy”: {
“maxUnusedVersionsToKeep”: 3
}
Let me show you a step-by-step guide to automatically remove the unwanted application versions in your Service Fabric Managed cluster below:
Scenario:
– I have deployed 4 versions of my app (1 InUse – 3 UnUsed) to my managed cluster as the following:
Symptom:
I need Service Fabric to do automatic cleanup for the Application Unused Versions and keep only the last 3 so as not to fill the disk space.
Mitigation Steps:
From https://resources.azure.com/ open your managed cluster resource and open the read/write mode.
Add the tag “AllowRuntimeCleanupUnusedApplicationTypesPolicy“: “true“
Under fabricsettings, add the param “name”: “CleanupUnusedApplicationTypes”, “value”: “true” under fabricsettings and set the “maxUnusedVersionsToKeep”: 3
Click on PUT to save the changes, and I deployed the 5th version (1.0.4) to the cluster, which should make the cleaning happens for the oldest version (1.0.0)
Note: The automatic clean-up should be effective after 24 hours of making those changes.
Then I tried to deploy a new version, and I could see that the oldest version was also cleaned up.
For manual cleanup of the ImageStoreService:
You can use PowerShell commands to delete copied packages and unregister application types as needed.
This includes using Get-ServiceFabricImageStoreContent to retrieve content and Remove-ServiceFabricApplicationPackage to delete it, as well as Unregister-ServiceFabricApplicationType to remove application packages from the image store and image cache on nodes.
Microsoft Tech Community – Latest Blogs –Read More
How to use Taylor Series in stateflow?
I want to use Trigonometric function or Taylor Series in Stateflow, Not Simulink block.
How can I use it like that?I want to use Trigonometric function or Taylor Series in Stateflow, Not Simulink block.
How can I use it like that? I want to use Trigonometric function or Taylor Series in Stateflow, Not Simulink block.
How can I use it like that? simulink, electric_motor_control MATLAB Answers — New Questions
The function’s input parameter must be a vector or matrix, and the function must add 1 to each element of the input parameter.
In matlab i need to do the following operations. The function’s input parameter must be a vector or matrix, and the function must add 1 to each element of the input parameter.In matlab i need to do the following operations. The function’s input parameter must be a vector or matrix, and the function must add 1 to each element of the input parameter. In matlab i need to do the following operations. The function’s input parameter must be a vector or matrix, and the function must add 1 to each element of the input parameter. the function must add 1 to each element of the inp, homework, no attempt MATLAB Answers — New Questions
generate scenario on matlab
Can I make scenario file on matlab?
I’m trying to make vehicles on roadrunner using matlab but I can’t find any way.Can I make scenario file on matlab?
I’m trying to make vehicles on roadrunner using matlab but I can’t find any way. Can I make scenario file on matlab?
I’m trying to make vehicles on roadrunner using matlab but I can’t find any way. roadrunner, scenario MATLAB Answers — New Questions
Can I use matlab to write and execute 8051 assembly language programs?
ORG 0000H
MOV R2,#05H
MOV R0,#30H
MOV R1,#40H
REPEAT: MOV A,@R0
XCH A,@R1
MOV @R0,A
INC R0
INC R1
DJNZ R2,REPEAT
ENDORG 0000H
MOV R2,#05H
MOV R0,#30H
MOV R1,#40H
REPEAT: MOV A,@R0
XCH A,@R1
MOV @R0,A
INC R0
INC R1
DJNZ R2,REPEAT
END ORG 0000H
MOV R2,#05H
MOV R0,#30H
MOV R1,#40H
REPEAT: MOV A,@R0
XCH A,@R1
MOV @R0,A
INC R0
INC R1
DJNZ R2,REPEAT
END 8051 assembl language programs MATLAB Answers — New Questions
How to read multiple grb2 files on a webpage ?
Dear all,
I like to download all the grb2 files from the following website:
https://polar.ncep.noaa.gov/waves/hindcasts/multi_1/200502/gribs
The file link can be identified, for instance, the first one is:
https://polar.ncep.noaa.gov/waves/hindcasts/multi_1/200502/gribs/multi_1.ak_4m.dp.200502.grb2
Is there a way to automatically update the link to download these files?
Thanks for the help.Dear all,
I like to download all the grb2 files from the following website:
https://polar.ncep.noaa.gov/waves/hindcasts/multi_1/200502/gribs
The file link can be identified, for instance, the first one is:
https://polar.ncep.noaa.gov/waves/hindcasts/multi_1/200502/gribs/multi_1.ak_4m.dp.200502.grb2
Is there a way to automatically update the link to download these files?
Thanks for the help. Dear all,
I like to download all the grb2 files from the following website:
https://polar.ncep.noaa.gov/waves/hindcasts/multi_1/200502/gribs
The file link can be identified, for instance, the first one is:
https://polar.ncep.noaa.gov/waves/hindcasts/multi_1/200502/gribs/multi_1.ak_4m.dp.200502.grb2
Is there a way to automatically update the link to download these files?
Thanks for the help. webread, grb2 data, batch operation MATLAB Answers — New Questions
Treat a row as an array inside an array formulation
Hello there,
Running Excel 365. Attaching a sample document for better understanding.
I am trying to compute the final price of a product on each year of its project. The final price is based on an initial price and percentage discounts that are cumulative year over year. For this purpose, I use SCAN function and returns the desired output beautifully.
Now, I need a second consideration for the computation of the price. There are some price components that expire before the end of the whole project. That is, I need to substract some amount from the price at a given date, since that concept is no longer computing to the final price and it has already been amortized. For this other purpose, I use some references that allows the final user only to enter the value that is going to be substracted and during how many years is this particular value going to be amortized. Then, the formulation “drops” that amount once the years of amortization are completed.
These two functionalities (% discount and dropping price component) work when I formulate them apart. However, I need them to be together. The issue is that one of the ranges in the formulation for the latter functionality is not treated as an array and, therefore, it does not dynamically “move” within the range and everything breaks. How can I rearrange the formulation and make this range be a functional array (with minimum alteration of the concept behind this formualtion)?
Thank you so much for any kind support.
Martin
Hello there, Running Excel 365. Attaching a sample document for better understanding. I am trying to compute the final price of a product on each year of its project. The final price is based on an initial price and percentage discounts that are cumulative year over year. For this purpose, I use SCAN function and returns the desired output beautifully. Now, I need a second consideration for the computation of the price. There are some price components that expire before the end of the whole project. That is, I need to substract some amount from the price at a given date, since that concept is no longer computing to the final price and it has already been amortized. For this other purpose, I use some references that allows the final user only to enter the value that is going to be substracted and during how many years is this particular value going to be amortized. Then, the formulation “drops” that amount once the years of amortization are completed. These two functionalities (% discount and dropping price component) work when I formulate them apart. However, I need them to be together. The issue is that one of the ranges in the formulation for the latter functionality is not treated as an array and, therefore, it does not dynamically “move” within the range and everything breaks. How can I rearrange the formulation and make this range be a functional array (with minimum alteration of the concept behind this formualtion)? Thank you so much for any kind support. Martin Read More
Slow Table with lot of registers
Hello,
I have a database with a big table that I store sensor values, basically the structure is
ID, DataTime, SensorID, Value.
Each sensor sends data each minute, I have more than 100 sensors, so every day is a lot of records (more than 20.000.000 each month)…
2/3 months is not bad, but more than that is getting slow every time I want to do a graph, doing a
“select … where data>X and data<y and sensorid=z”
How can I speed up things and make this more efficient?
Thanks for any tip.
JS
Hello,I have a database with a big table that I store sensor values, basically the structure isID, DataTime, SensorID, Value.Each sensor sends data each minute, I have more than 100 sensors, so every day is a lot of records (more than 20.000.000 each month)…2/3 months is not bad, but more than that is getting slow every time I want to do a graph, doing a”select … where data>X and data<y and sensorid=z”How can I speed up things and make this more efficient?Thanks for any tip. JS Read More
Bing Chat service delay issue
Hello, I am an IT manager considering the introduction of Bing Chat services for businesses. After logging in and using it in protected mode, I am consistently unable to receive a response after a message that says ‘reconnecting’ appears following a maximum of 2 turns. I am curious if this is only happening today or if it is a recurring issue. I would also appreciate it if you could inform me about any available support within the license agreement.
Hello, I am an IT manager considering the introduction of Bing Chat services for businesses. After logging in and using it in protected mode, I am consistently unable to receive a response after a message that says ‘reconnecting’ appears following a maximum of 2 turns. I am curious if this is only happening today or if it is a recurring issue. I would also appreciate it if you could inform me about any available support within the license agreement. Read More
How do I fix QuickBooks Error 40001 while Activating Direct Deposit in QuickBooks Desktop?
Troubleshooting Solutions : QuickBooks Error 40001
Encountering “QuickBooks Error 40001” can disrupt workflow and cause frustration. This error typically indicates a communication problem between QuickBooks Desktop and the database server. Here’s how to troubleshoot and resolve it:
Restart QuickBooks Database Server Manager: Begin by restarting the QuickBooks Database Server Manager. Navigate to the Windows Start menu, type “Services” in the search bar, and press Enter. Locate the QuickBooksDBXX service (XX denotes the version of QuickBooks), right-click on it, and select Restart. Repeat this process for other related services like QuickBooksDBXX (QBDBXX) and QuickBooksDBXX (QBCFMonitorService).Check QuickBooks Hosting: Verify that QuickBooks Desktop is not set to host multi-user access. Open QuickBooks on the host computer, navigate to the File menu, select Utilities, and then select Stop Hosting Multi-User Access. Ensure that hosting multi-user access is enabled only on the computer designated as the server.Verify Network Connectivity: Confirm that all computers connected to the QuickBooks company file have proper network connectivity. Check network cables, routers, and switches for any signs of malfunction. Ensure that workstations have proper network access to the server hosting the company file.Update QuickBooks: Ensure that QuickBooks Desktop is updated to the latest version. Outdated software may encounter compatibility issues leading to Error 40001. Go to the Help menu, select Update QuickBooks, and follow the prompts to download and install any available updates.Check Firewall and Antivirus Settings: Adjust firewall and antivirus settings to allow QuickBooks Desktop to communicate with the database server. Add exceptions for QuickBooks and its associated processes in firewall and antivirus software settings to prevent them from blocking necessary connections.Run QuickBooks File Doctor: Intuit provides a tool called QuickBooks File Doctor, which can diagnose and repair various QuickBooks-related issues, including Error 40001. Download and run the tool from the Intuit website, and follow the on-screen instructions to scan and repair your company file.Reset Sync Manager: If you’re using QuickBooks Sync Manager, reset it to resolve Error 40001. Open QuickBooks, go to the Help menu, and select Manage Data Sync. Choose Reset Sync Manager and follow the prompts to reset the sync process.Recreate QuickBooks Network Data (.ND) File: If the issue persists, recreate the QuickBooks Network Data (.ND) file associated with the company file. Close QuickBooks on all workstations and navigate to the folder containing the company file. Locate the corresponding .ND file, rename it, and reopen QuickBooks. QuickBooks will automatically recreate the .ND file, potentially resolving any corruption issues causing the error.
By following these troubleshooting steps, users can effectively address QuickBooks Error 40001 and resume normal operations in QuickBooks Desktop without significant disruption. If the problem persists after attempting these solutions, it may be necessary to contact QuickBooks support for further assistance.
Troubleshooting Solutions : QuickBooks Error 40001 Encountering “QuickBooks Error 40001” can disrupt workflow and cause frustration. This error typically indicates a communication problem between QuickBooks Desktop and the database server. Here’s how to troubleshoot and resolve it: Restart QuickBooks Database Server Manager: Begin by restarting the QuickBooks Database Server Manager. Navigate to the Windows Start menu, type “Services” in the search bar, and press Enter. Locate the QuickBooksDBXX service (XX denotes the version of QuickBooks), right-click on it, and select Restart. Repeat this process for other related services like QuickBooksDBXX (QBDBXX) and QuickBooksDBXX (QBCFMonitorService).Check QuickBooks Hosting: Verify that QuickBooks Desktop is not set to host multi-user access. Open QuickBooks on the host computer, navigate to the File menu, select Utilities, and then select Stop Hosting Multi-User Access. Ensure that hosting multi-user access is enabled only on the computer designated as the server.Verify Network Connectivity: Confirm that all computers connected to the QuickBooks company file have proper network connectivity. Check network cables, routers, and switches for any signs of malfunction. Ensure that workstations have proper network access to the server hosting the company file.Update QuickBooks: Ensure that QuickBooks Desktop is updated to the latest version. Outdated software may encounter compatibility issues leading to Error 40001. Go to the Help menu, select Update QuickBooks, and follow the prompts to download and install any available updates.Check Firewall and Antivirus Settings: Adjust firewall and antivirus settings to allow QuickBooks Desktop to communicate with the database server. Add exceptions for QuickBooks and its associated processes in firewall and antivirus software settings to prevent them from blocking necessary connections.Run QuickBooks File Doctor: Intuit provides a tool called QuickBooks File Doctor, which can diagnose and repair various QuickBooks-related issues, including Error 40001. Download and run the tool from the Intuit website, and follow the on-screen instructions to scan and repair your company file.Reset Sync Manager: If you’re using QuickBooks Sync Manager, reset it to resolve Error 40001. Open QuickBooks, go to the Help menu, and select Manage Data Sync. Choose Reset Sync Manager and follow the prompts to reset the sync process.Recreate QuickBooks Network Data (.ND) File: If the issue persists, recreate the QuickBooks Network Data (.ND) file associated with the company file. Close QuickBooks on all workstations and navigate to the folder containing the company file. Locate the corresponding .ND file, rename it, and reopen QuickBooks. QuickBooks will automatically recreate the .ND file, potentially resolving any corruption issues causing the error.By following these troubleshooting steps, users can effectively address QuickBooks Error 40001 and resume normal operations in QuickBooks Desktop without significant disruption. If the problem persists after attempting these solutions, it may be necessary to contact QuickBooks support for further assistance. Read More
EXECUTE AS WITH COOKIE causing performance degradation
Hi,
We’re seeing an issue with SQL server where the performance of the server degrades over time when there are a large amount of EXECUTE AS USER statements.
We’re hosting a legacy system based on SharePoint which is generating these transactions so in the short term we are unable to obtain the source to refactor this code.
To minimally replicate the issue we can run the following code:
DECLARE @counter INT = 1;
DECLARE @cookie VARBINARY(100);
WHILE @counter <= 5000
BEGIN
EXECUTE AS USER = N’DataReader’ WITH COOKIE INTO @cookie;
REVERT WITH COOKIE = @cookie
SET @counter += 1;
END
The first run takes just over 2 seconds, and then subsequent runs take progressively longer to complete.
Run
Duration
1
00:02.343
2
00:03.437
3
00:04.984
4
00:07.094
5
00:09.875
6
00:13.578
Restarting the SQL server service restores performance back to the start.
From running the SQL Profiler, it seems as if the bottleneck is with the EXECUTE AS USER statement, and the REVERT statement takes approximately 0ms every time.
From running various numbers through this I’ve found that running batches of 30 per second doesn’t seem to degrade performance, but after a while, 60 per second does.
Furthermore, if we run just:
EXECUTE AS USER = N’DataReader’
REVERT
And we’re not storing the cookie, then I can run 50k in the loop, it takes 0.5 seconds, and doesn’t degrade performance with subsequent runs.
We’re running this test internally on SQL Server 2016, but we’ve also run the same test on Azure SQL, which I can only assume is running the latest version. It exhibits the same behaviour, so it would appear that simply upgrading versions wouldn’t solve the problem.
Does anyone know what’s going on here? Is the performance being degraded by storage of these cookies? If so, where are they even being stored and is there any way to mitigate this or periodically clear the cookie cache to get some of the lost performance back?
Any thoughts on the matter welcome!
Mat
Hi, We’re seeing an issue with SQL server where the performance of the server degrades over time when there are a large amount of EXECUTE AS USER statements. We’re hosting a legacy system based on SharePoint which is generating these transactions so in the short term we are unable to obtain the source to refactor this code.To minimally replicate the issue we can run the following code: DECLARE @counter INT = 1;
DECLARE @cookie VARBINARY(100);
WHILE @counter <= 5000
BEGIN
EXECUTE AS USER = N’DataReader’ WITH COOKIE INTO @cookie;
REVERT WITH COOKIE = @cookie
SET @counter += 1;
END The first run takes just over 2 seconds, and then subsequent runs take progressively longer to complete.RunDuration100:02.343200:03.437300:04.984400:07.094500:09.875600:13.578 Restarting the SQL server service restores performance back to the start.From running the SQL Profiler, it seems as if the bottleneck is with the EXECUTE AS USER statement, and the REVERT statement takes approximately 0ms every time. From running various numbers through this I’ve found that running batches of 30 per second doesn’t seem to degrade performance, but after a while, 60 per second does. Furthermore, if we run just: EXECUTE AS USER = N’DataReader’
REVERT And we’re not storing the cookie, then I can run 50k in the loop, it takes 0.5 seconds, and doesn’t degrade performance with subsequent runs. We’re running this test internally on SQL Server 2016, but we’ve also run the same test on Azure SQL, which I can only assume is running the latest version. It exhibits the same behaviour, so it would appear that simply upgrading versions wouldn’t solve the problem. Does anyone know what’s going on here? Is the performance being degraded by storage of these cookies? If so, where are they even being stored and is there any way to mitigate this or periodically clear the cookie cache to get some of the lost performance back? Any thoughts on the matter welcome!Mat Read More
How to fix QuickBooks desktop 2024 keeps crashing after update?
Troubleshooting Solutions : QuickBooks desktop 2024 keeps crashing
QuickBooks desktop 2024 keeps crashing can be frustrating, disrupting your workflow and potentially causing data loss. However, several troubleshooting steps can help resolve this issue and get your software running smoothly again.
1. Update QuickBooks Desktop: Ensure you have the latest version of QuickBooks Desktop installed. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.
2. Check System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Desktop 2024. Inadequate hardware or outdated software can cause performance issues and crashes. Visit the QuickBooks support website to review the system requirements for your version.
3. Run QuickBooks Diagnostic Tool: QuickBooks comes with a built-in diagnostic tool that can help identify and fix common issues. Run the QuickBooks Install Diagnostic Tool, which automatically scans and repairs problems related to installation, .NET Framework, MSXML, and C++. Download and run the tool from the Intuit website for best results.
4. Disable Compatibility Mode: If you’ve enabled compatibility mode for QuickBooks Desktop, it might conflict with the software and cause crashes. Right-click the QuickBooks Desktop shortcut icon, select Properties, and navigate to the Compatibility tab. Ensure that the “Run this program in compatibility mode for” option is unchecked.
5. Verify Company File: A corrupted company file can lead to frequent crashes in QuickBooks Desktop. Use the Verify Data utility to check for data integrity issues and resolve them. Go to the File menu, select Utilities, and then Verify Data. Follow the on-screen instructions to repair any detected issues.
6. Rebuild Data: If the Verify Data utility detects problems with your company file, use the Rebuild Data tool to fix them. This tool reconstructs the damaged data, resolving issues that could cause QuickBooks Desktop to crash. Go to the File menu, select Utilities, and then Rebuild Data. Follow the prompts to complete the process.
7. Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks Desktop and cause it to crash. Temporarily disable any add-ons or extensions and check if the crashing issue persists. If the software runs smoothly without them, consider updating or reinstalling the problematic add-ons.
8. Clean Install QuickBooks Desktop: If all else fails, perform a clean install of QuickBooks Desktop. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Make sure to backup your company file before proceeding with the reinstall.
By following these troubleshooting solutions, you can effectively address the QuickBooks desktop 2024 keeps crashing issue and restore stability to your accounting software. If the problem persists after attempting these steps, consider reaching out to QuickBooks support for further assistance.
Troubleshooting Solutions : QuickBooks desktop 2024 keeps crashing QuickBooks desktop 2024 keeps crashing can be frustrating, disrupting your workflow and potentially causing data loss. However, several troubleshooting steps can help resolve this issue and get your software running smoothly again. 1. Update QuickBooks Desktop: Ensure you have the latest version of QuickBooks Desktop installed. Developers often release updates to address bugs and improve stability. Go to the Help menu and select Update QuickBooks Desktop to download and install any available updates.2. Check System Requirements: Verify that your computer meets the minimum system requirements for running QuickBooks Desktop 2024. Inadequate hardware or outdated software can cause performance issues and crashes. Visit the QuickBooks support website to review the system requirements for your version.3. Run QuickBooks Diagnostic Tool: QuickBooks comes with a built-in diagnostic tool that can help identify and fix common issues. Run the QuickBooks Install Diagnostic Tool, which automatically scans and repairs problems related to installation, .NET Framework, MSXML, and C++. Download and run the tool from the Intuit website for best results.4. Disable Compatibility Mode: If you’ve enabled compatibility mode for QuickBooks Desktop, it might conflict with the software and cause crashes. Right-click the QuickBooks Desktop shortcut icon, select Properties, and navigate to the Compatibility tab. Ensure that the “Run this program in compatibility mode for” option is unchecked.5. Verify Company File: A corrupted company file can lead to frequent crashes in QuickBooks Desktop. Use the Verify Data utility to check for data integrity issues and resolve them. Go to the File menu, select Utilities, and then Verify Data. Follow the on-screen instructions to repair any detected issues.6. Rebuild Data: If the Verify Data utility detects problems with your company file, use the Rebuild Data tool to fix them. This tool reconstructs the damaged data, resolving issues that could cause QuickBooks Desktop to crash. Go to the File menu, select Utilities, and then Rebuild Data. Follow the prompts to complete the process.7. Disable Add-ons and Extensions: Third-party add-ons or extensions can sometimes conflict with QuickBooks Desktop and cause it to crash. Temporarily disable any add-ons or extensions and check if the crashing issue persists. If the software runs smoothly without them, consider updating or reinstalling the problematic add-ons.8. Clean Install QuickBooks Desktop: If all else fails, perform a clean install of QuickBooks Desktop. Uninstall the software completely from your computer, including all associated files and settings. Then, download the latest version from the Intuit website and reinstall it. Make sure to backup your company file before proceeding with the reinstall. By following these troubleshooting solutions, you can effectively address the QuickBooks desktop 2024 keeps crashing issue and restore stability to your accounting software. If the problem persists after attempting these steps, consider reaching out to QuickBooks support for further assistance. Read More