Category: Microsoft
Category Archives: Microsoft
Issue with Importing Custom App into Developer Portal
The app in question is the same package that I previously submitted for validation and which was successfully published to the Microsoft Teams store. However, I have noticed that the app has been deleted from my developer portal.
When attempting to import the app package again, I am encountering the following error message:
Failed to upload App (Tracking info: 4a6d5384-2ef7-4d64-82c6-02a6c248ba36_265 Thu, 09 May 2024 23:06:14 GMT | Status code: 422)
How can I upload the app to my developer portal?
The app in question is the same package that I previously submitted for validation and which was successfully published to the Microsoft Teams store. However, I have noticed that the app has been deleted from my developer portal. When attempting to import the app package again, I am encountering the following error message:Failed to upload App (Tracking info: 4a6d5384-2ef7-4d64-82c6-02a6c248ba36_265 Thu, 09 May 2024 23:06:14 GMT | Status code: 422) How can I upload the app to my developer portal? Read More
Access team meeting chat before the meeting starts when created using API
Hi, I am creating an event using Event API – https://learn.microsoft.com/en-us/graph/api/user-post-events?view=graph-rest-1.0&tabs=http and creating a teams meeting using online meeting API – https://learn.microsoft.com/en-us/graph/api/resources/onlinemeeting?view=graph-rest-1.0#onlinemeetingpresenters-values. But the participants are unable to start the chat in teams before the meeting is started. Participants can start the chat if I manually create a meeting from the team’s calendar. Please guide me on how I can enable the participants to start the chat before the meeting is started. I have the following flags set when create the online meeting –
shareMeetingChatHistoryDefault: “all”,
allowedPresenters: “everyone”,
Participants are seeing this error –
Hi, I am creating an event using Event API – https://learn.microsoft.com/en-us/graph/api/user-post-events?view=graph-rest-1.0&tabs=http and creating a teams meeting using online meeting API – https://learn.microsoft.com/en-us/graph/api/resources/onlinemeeting?view=graph-rest-1.0#onlinemeetingpresenters-values. But the participants are unable to start the chat in teams before the meeting is started. Participants can start the chat if I manually create a meeting from the team’s calendar. Please guide me on how I can enable the participants to start the chat before the meeting is started. I have the following flags set when create the online meeting – allowMeetingChat: “enabled”,shareMeetingChatHistoryDefault: “all”,allowedPresenters: “everyone”, Participants are seeing this error – Read More
Formula help please
I have a sheet with a year of (365) dates in Row 1 starting in cell B1
Under that is a list types of incidents in column A
The requirement is to look through each day per incident type to find the Max number of incidents and the date of that ‘peak’. I can find the maximum number in the row with a formula. But what do I need to add to give me the (Vector?) of the corresponding date that will be above in Row 1?
I have a sheet with a year of (365) dates in Row 1 starting in cell B1Under that is a list types of incidents in column AThe requirement is to look through each day per incident type to find the Max number of incidents and the date of that ‘peak’. I can find the maximum number in the row with a formula. But what do I need to add to give me the (Vector?) of the corresponding date that will be above in Row 1? Read More
Tracking changes Options in Excel
I would like to know how can I block the Tracking changes option for nobody can deactivate it? because I activated it, but I don’t want anyone to be able to deactivate it. Is it possible?
I would like to know how can I block the Tracking changes option for nobody can deactivate it? because I activated it, but I don’t want anyone to be able to deactivate it. Is it possible? Read More
Finding the best combination of values using solver
Question: How do I use Excel built in solver to get the correct combination?
Objective: To purchase parts at lowest cost.
Constraints: Divvy up among 3 suppliers/out of 5 suppliers ; a total of 19 parts in some combination.
A solution could look like this:
Sup1–>P1,P4,P7,P19,P16Sup2–>P2,P5,P8,P15,P13,P17,P18Sup3–>P3,P6,P9,P10,P11,P12,P14
Input data as follows:
SupplierPart numberCostSup1P1$10.00Sup1P2$9.00Sup1P3$5.00Sup1P4$6.00Sup1P5$6.00Sup1P6$15.00Sup1P7$11.00Sup1P8$8.00Sup1P9$71.00Sup1P10$11.00Sup1P11$12.00Sup1P12$21.00Sup1P13$22.00Sup1P14$6.00Sup1P15$31.00Sup1P16$6.00Sup1P17$4.00Sup1P18$17.00Sup1P19$8.00Sup2P1$6.00Sup2P2$8.00Sup2P3$11.00Sup2P4$4.00Sup2P5$8.00Sup2P6$34.00Sup2P7$12.00Sup2P8$8.00Sup2P9$55.00Sup2P10$77.00Sup2P11$13.00Sup2P12$25.00Sup2P13$23.00Sup2P14$2.00Sup2P15$34.00Sup2P16$12.00Sup2P17$3.00Sup2P18$13.00Sup2P19$7.00Sup3P1$9.00Sup3P2$11.00Sup3P3$4.00Sup3P4$3.00Sup3P5$2.00Sup3P6$23.00Sup3P7$13.00Sup3P8$8.00Sup3P9$45.00Sup3P10$29.00Sup3P11$14.00Sup3P12$23.00Sup3P13$24.00Sup3P14$3.00Sup3P15$49.00Sup3P16$16.00Sup3P17$1.00Sup3P18$12.00Sup3P19$6.00Sup4P1$8.00Sup4P2$13.00Sup4P3$2.00Sup4P4$7.00Sup4P5$8.00Sup4P6$55.00Sup4P7$14.00Sup4P8$8.00Sup4P9$48.00Sup4P10$34.00Sup4P11$15.00Sup4P12$22.00Sup4P13$25.00Sup4P14$8.00Sup4P15$32.00Sup4P16$13.00Sup4P17$2.00Sup4P18$11.00Sup4P19$5.00Sup5P1$9.00Sup5P2$12.00Sup5P3$1.00Sup5P4$16.00Sup5P5$1.00Sup5P6$41.00Sup5P7$15.00Sup5P8$8.00Sup5P9$26.00Sup5P10$67.00Sup5P11$16.00Sup5P12$17.00Sup5P13$26.00Sup5P14$7.00Sup5P15$22.00Sup5P16$12.00Sup5P17$5.00Sup5P18$19.00Sup5P19$4.00
Question: How do I use Excel built in solver to get the correct combination?Objective: To purchase parts at lowest cost.Constraints: Divvy up among 3 suppliers/out of 5 suppliers ; a total of 19 parts in some combination.A solution could look like this:Sup1–>P1,P4,P7,P19,P16Sup2–>P2,P5,P8,P15,P13,P17,P18Sup3–>P3,P6,P9,P10,P11,P12,P14 Input data as follows:SupplierPart numberCostSup1P1$10.00Sup1P2$9.00Sup1P3$5.00Sup1P4$6.00Sup1P5$6.00Sup1P6$15.00Sup1P7$11.00Sup1P8$8.00Sup1P9$71.00Sup1P10$11.00Sup1P11$12.00Sup1P12$21.00Sup1P13$22.00Sup1P14$6.00Sup1P15$31.00Sup1P16$6.00Sup1P17$4.00Sup1P18$17.00Sup1P19$8.00Sup2P1$6.00Sup2P2$8.00Sup2P3$11.00Sup2P4$4.00Sup2P5$8.00Sup2P6$34.00Sup2P7$12.00Sup2P8$8.00Sup2P9$55.00Sup2P10$77.00Sup2P11$13.00Sup2P12$25.00Sup2P13$23.00Sup2P14$2.00Sup2P15$34.00Sup2P16$12.00Sup2P17$3.00Sup2P18$13.00Sup2P19$7.00Sup3P1$9.00Sup3P2$11.00Sup3P3$4.00Sup3P4$3.00Sup3P5$2.00Sup3P6$23.00Sup3P7$13.00Sup3P8$8.00Sup3P9$45.00Sup3P10$29.00Sup3P11$14.00Sup3P12$23.00Sup3P13$24.00Sup3P14$3.00Sup3P15$49.00Sup3P16$16.00Sup3P17$1.00Sup3P18$12.00Sup3P19$6.00Sup4P1$8.00Sup4P2$13.00Sup4P3$2.00Sup4P4$7.00Sup4P5$8.00Sup4P6$55.00Sup4P7$14.00Sup4P8$8.00Sup4P9$48.00Sup4P10$34.00Sup4P11$15.00Sup4P12$22.00Sup4P13$25.00Sup4P14$8.00Sup4P15$32.00Sup4P16$13.00Sup4P17$2.00Sup4P18$11.00Sup4P19$5.00Sup5P1$9.00Sup5P2$12.00Sup5P3$1.00Sup5P4$16.00Sup5P5$1.00Sup5P6$41.00Sup5P7$15.00Sup5P8$8.00Sup5P9$26.00Sup5P10$67.00Sup5P11$16.00Sup5P12$17.00Sup5P13$26.00Sup5P14$7.00Sup5P15$22.00Sup5P16$12.00Sup5P17$5.00Sup5P18$19.00Sup5P19$4.00 Read More
NL to SQL Architecture Alternatives
Table of Contents
Architecture 1: Few Shot SQL Generation. 3
Architecture 2: Few Shot SQL Generation with RAG.. 4
Architecture 3: Fine Tuning SQL Generation with GPT 3.5T. 5
Introduction
The recent advances in LLMs have created opportunities for businesses to gain leverage and insight into their unstructured text data. A classic example of this has been using the popular Retrieval Augmented Generation (RAG) pattern in which company documents are used as context to answer user questions. These implementations are reducing the time spent reading through lengthy documentation by offloading this task to the LLMs.
But what about using LLMs to extract insights from structured relational data such as SQL databases? Many enterprises possess enormous quantities of SQL data that currently require technical users to query or build business dashboards to make this data accessible to end users. However, it is costly to build these dashboards, and they are limited in their scope.
With LLMs, there is a new potential to enable non-technical users to extract information from SQL databases by using an LLM to generate SQL queries dynamically to answer their Natural Language Questions. This use case has potential to enhance understanding of business data and reduce time and money spent on extracting data from SQL databases.
Overview
This guide will show multiple approaches to building a chat application that leverages SQL data as context. We will start with the simplest architecture and work progressively with more sophisticated methods to address limitations.
Note: Truncated prompts will be provided in the examples below, but more complete and comprehensive prompts will be included in the final section.
Architecture 1: Few Shot SQL Generation
In this first implementation of an NL to SQL chat app, the LLM builds a SQL query based on the user’s question and a fixed SQL schema that is included in the system prompt.
Figure 1 – Few Shot SQL Generation
User asks a question: for example, “What was the product line with the highest revenue in 2022?”
App makes a request to the LLM: prompt might look like the following,
“You are an expert at providing facts from a SQL Database. Given the user question, produce a PostgresSQL query which, when executed provides the correct answer to the question. Only use the tables and schema given below to answer the question. SQL Schema: {Schema}
User Question: {Question}”
LLM responds with a SQL query: response might look like, “SELECT p.product_line, SUM(s.revenue) AS total_revenue … “. This string gets stored as a variable, to be used in the next step.
SQL Query string is executed, result is saved: the previous string that was generated is sent to the SQL query to be executed. (Note: this poses a potential risk of SQL injection, ensure you are limiting permissions, and see final section regarding Security and Safety). The result of the SQL query will be saved as a text string (e.g. “Home Appliances, $12,500,000”)
Final LLM call performed: Another request is made to the LLM, this time with the user’s original question, and the result of SQL Query. The prompt might look like:
“Given the original question, the corresponding PostgreSQL query, and the execution results, produce a truthful and accurate natural language response to the original question.
Question: {question}”
Final Response: The LLM responds with the answer to the user’s question.
Benefits / Limitations: This architecture is quite simple and benefits in terms of latency by having only two LLM calls. However, this setup is limited because the LLM does not have any examples of valid SQL queries to reference.
Architecture 2: Few Shot SQL Generation with RAG
This implementation is similar to the previous architecture, but rather than having a fixed set of few-shot examples, we create a data preparation step in which we embed examples into a vector database, and then retrieve the examples that are most relevant to the user’s question.
Figure 2 – Few Shot SQL Generation with RAG
Below, we discuss the new steps that differentiate Architecture 2 from Architecture 1:
Offline Data Prep: In order to best leverage the few shot examples framework, a set of NL SQL Questions and corresponding SQL Queries (50-100 samples) should be collected and stored in JSON or CSV format. Then, each of these pairs should be embedded in a vector database such as Azure AI Search (Search over JSON blobs – Azure AI Search | Microsoft Learn).
e.g. {
“question”: “Which product line had the highest profit margin in 2020?”,
“sql_query”: “SELECT value FROM table_1…”,
}
Embed user’s question: Make a request to a text embeddings model, such as text-ada-002, to convert the user’s question to a vector.
Retrieve few shot examples: Then retrieve the top 5 examples with the closest similarity (using Azure AI Search cosine similarity algorithm) and include them in the SQL Generation request to GPT-4.
Benefits / Limitations: This architecture is quite simple and benefits in terms of latency by having only two LLM calls. However, this setup is limited because the LLM does not have any examples of valid SQL queries to reference.
Architecture 3: Fine Tuning SQL Generation with GPT 3.5T
One of the central challenges in building an NL to SQL based chat application is handling latency. One method to reduce latency is by opting to fine tune a smaller model, such as GPT 3.5T for the SQL generation step.
Figure 3 – Fine Tuning SQL Generation with GPT 3.5T
This architecture follows roughly the same pattern as architecture 1, but with a preparatory fine tuning step.
Offline Fine Tuning – Collect 50-100 NL questions and corresponding SQL Queries. Use Azure OpenAI’s fine tuning capability to fine tune your GPT 3.5 deployment (Customize a model with Azure OpenAI Service – Azure OpenAI | Microsoft Learn)
Steps 2-7 – Same as architecture 1, but directed toward the fine tuned instance of GPT 3.5T.
Note: If sufficient NL / SQL samples are available, fine tuning could be used with RAG to include few shot examples in addition to the fine tuning. Customers should experiment with the exact number of samples to include to get best results and ensure to test with unseen samples.
Evaluation
In order to evaluate an NL to SQL project you will need to evaluate the accuracy of the generated SQL query, the final response, and latency for each step. Below, we outline some of the key metrics to capture during the evaluation stage.
Manual Metrics:
The simplest way of evaluating the application is to have a human evaluator look at the final response and determine if it answer’s the user’s original question correctly. An example of this is End to End Accuracy.
End to End Accuracy – does the final response correctly answer the user’s question?
How to implement: Output all question and answers to a spreadsheet, and have a human validator enter 1 or 0 in each row to indicate whether the answer was correct or incorrect. Correct Answers / Total Answers = Accuracy.
The limitations with this method is that it requires a person to look at each response which can be a lengthy process. Additionally, if the answer is marked incorrect, it may not be clear which part of the process failed. For this reason, we also introduce a set of automated metrics to evaluate each step of the process.
Automated Metrics:
Validity of SQL Query – Is the generated SQL query valid?
How to Implement: This can be scored using a python library like sqlvalidator, or by implementing logic into the code to log each instance in which the SQL query fails.
SQL Critic Score – Does the SQL Query and result correctly translate the original question?
How to implement: Use the LLM to evaluate itself by sending a prompt with instructions to validate the accuracy of the SQL Query and include the original question, SQL query, and result in the request (see Appendix B Example 5)
End to End Relevance – Is the generated NL response relevant to the user’s initial question?
How to implement: Send a prompt to the LLM with instructions to compare the NL response to the user’s initial question and evaluate its relevance (see Appendix B Example 6)
End to End Groundedness – Does the generated NL response logically follow from the context provided to it (i.e. the SQL Query)?
How to implement: Send a prompt to the LLM with instructions to compare the NL response to the SQL query and results and determine if the response logically follows (see Appendix B Example 7)
Figure 4 – NL to SQL Evaluation Metrics
Safety / Security
LLMs introduce new risks to a web application. In this case, the LLM is generating SQL code that will be executed. This introduces a attack surface, and the appropriate boundaries should be introduced prior to releasing to public.
NL to SQL systems require various safety precautions to ensure accurate, secure, and unbiased results. Here are some key aspects to consider.
SQL Injection
Handling ambiguity and vagueness
Mitigating bias
Unintentionally writing to database
Granular permissions and proper authorization – refine access based on roles and groups.
Ensure access to known users.
Implement parameterized queries that separate data from the query itself.
Ensure read-only and only execute permissions.
Implement strict input validation and sanitization procedures with whitelisting, regular expressions, data type checks, escaping.
Implement logging and monitoring.
Explainability and transparency
Additional resources
How to use Semantic Kernel to execute natural language to SQL queries
Dataherald: An open-source project to query your structured data in natural language.
https://techcommunity.microsoft.com/t5/security-compliance-and-identity/best-practices-to-architect-secure-generative-ai-applications/ba-p/4116661
https://learn.microsoft.com/en-us/sql/relational-databases/security/sql-server-security-best-practices?view=sql-server-ver16
Appendix A: Prompt Examples
Example 1: NL to SQL System Prompt
“You are an expert in providing facts from an SQL database. Given the user question, produce a PostgreSQL query which, when executed, provides the correct answer to the question. Only use the tables and schema given below to answer the questions. Learn query patterns from the similar question-answer pairs provided as examples below. Directly start your response with the executable query. Do not start with ”’sql. Do not make up new table and column names. Only use the ones available in the schema below.
SQL Schema:
{schema}
Examples:
{examples}”
Example 2: SQL to NL System Prompt
“Given the original question, the corresponding PostgreSQL query, and the execution results, produce a truthful and accurate natural language response to the original question, that is only based on the execution results. Your answer should be detailed and accurate, for numerical responses make sure you infer the appropriate units. If the question is complex, you can provide a multi-sentence response. Make sure that you provide a response that is easy to understand.”
Example 3: NL to SQL User Prompt
“Your response should be an executable query, do not start with ”’sql Provide detailed reasoning behind the PostgreSQL query, please provide it as a comment using — at the beginning of the line. Formatting example:
SELECT some_name, val FROM some_table WHERE a = number AND b = another_number — This query selects some_name and val from some_table where a = number and b = another_number. Queries should return a minimal amount of rows, and should not return more rows than necessary.
User question: {query}
PostgreSQL query:”
Example 4: SQL to NL User Prompt
“Question: {question} SQL Query: {sql_query} SQL Query Results: {sql_query_results}”
Appendix B: Evaluation Prompt Examples
Example 5: SQL Critic Score Prompt
“Your job is to evaluate the nl-to-sql engine of the USA-Facts app.
The app goes through several steps:
The user question is sent to a Natural Language to SQL converter along with information about the database schema.
The generated SQL query is executed and the output is logged.
Your job is to determine if the generated SQL correctly translates the original question.
User question: {question}
Generated PostgreSQL: {generated_query}
Executed PostgreSQL result: {query_execution_result}
Given the information above, give a numeric score of 0 to the Generated SQL if it doesn’t correctly handle the User question, and give a numeric score of 1 if the Generated SQL query correctly handles the User question.
If the SQL query yields an error, give a numeric score of 0.
If the SQL query doesn’t error out, but doesn’t correctly handle the User question, give a numeric score of 0.
If the SQL execution results are empty, most likely it didn’t handle the User’s question. Think hard if you want to give it a 1 or a 0.
Score: “
Example 6: End to End Relevance
“You are an AI assistant. You will be given the definition of an evaluation metric for assessing the quality of an answer in a government stats question-answering task. Your job is to compute an accurate evaluation score using the provided evaluation metric.
You will be presented with a CONTEXT and an ANSWER about that CONTEXT. You need to decide whether the ANSWER is entailed by the CONTEXT by choosing one of the following rating:
10: The ANSWER follows logically from the information contained in the CONTEXT.
0: The ANSWER is logically false from the information contained in the CONTEXT.
an integer score between 0 and 10 and if such integer score does not exists, use 0: It is not possible to determine whether the ANSWER is true or false without further information.
Read the passage of information thoroughly and select the correct answer from the three answer labels. Read the CONTEXT thoroughly to ensure you know what the CONTEXT entails.
Note the ANSWER is generated by a computer system, it can contain certain symbols, which should not be a negative factor in the evaluation.
Independent Examples:
Example Task #1 Input:
“CONTEXT”:
Query: {Sample SQL Query}
Query results: {Sample SQL Query Result}
“ANSWER”: “{Valid Answer}”
Example Task #1 Output:
10
Example Task #2 Input:
“CONTEXT”:
Query: “SELECT area_name, MAX(value) – MIN(value) as increase_in_unemployment_rate
FROM bls_local_area_unemployment_statistics
WHERE year >= 2010 AND measure = ‘unemployment rate’ AND area_type = ‘cities and towns above 25,000 population’
GROUP BY area_name
ORDER BY increase_in_unemployment_rate DESC
LIMIT 5″;
Query results: San Luis City, AZ; Atlantic City city, NJ; Flint city, MI; Mount Morris township, MI; and Detroit city, MI
“ANSWER”: “The 5 cities where the unemployment rate has increased the most since 2010 are San Luis city, AZ; Atlantic City city, NJ; Flint city, MI; Mount Morris township, MI; and Detroit city, MI.”
Example Task #2 Output:
10
Example Task #3 Input:
“CONTEXT”:
Query: SELECT SUM(value) AS total_job_openings
FROM bls_job_turnover
WHERE state = ‘Washington’ AND year = 2020
LIMIT 10;
Query results: 15773441, 18150000
“ANSWER”: “The GDP of Washington state in 2020 was approximately $9,773,441,000,000.0 and the number of job openings was approximately 18,150,000.”
Example Task #3 Output:
0
“””
Example 7: End to End groundedness
“Is the answer relevant and related to the question?
If the answer is yes, output 1.
Respond 0 otherwise.
Question: {question}
Answer: {answer}
Score:”
Microsoft Tech Community – Latest Blogs –Read More
Multiplying values
Evening all,
I want to figure out a function to use to calculate a value using a value given and multiply that dependant on the ‘zone’ so zone 1 needs to be multiplied by 14.8 zone 2 by 14.8 zone 3 by 19.2 etc etc. I have tried to use product and if functions but it says I’m using too many variables. Any help appreciated!
Evening all, I want to figure out a function to use to calculate a value using a value given and multiply that dependant on the ‘zone’ so zone 1 needs to be multiplied by 14.8 zone 2 by 14.8 zone 3 by 19.2 etc etc. I have tried to use product and if functions but it says I’m using too many variables. Any help appreciated! Read More
Number fields rounding off in Cosmos Db from Azure Portal
Hi Azure Cosmos Db Team,
We are seeing an issue from Portal in Cosmos Db. When we enter a numeric field in cosmos db from portal for eg
Hi Azure Cosmos Db Team, We are seeing an issue from Portal in Cosmos Db. When we enter a numeric field in cosmos db from portal for eg “digittest”: 123456789123456789 it is rounding of to “digittest”: 123456789123456780 Saw this behavior after 16 characters. Thought the issue is with portal ( related to java script).So tried using the sdk. When using JAVA SDK we saw we were able to retrieve the same value we created with sdk. However when we update another attribute in document in the portal and then retrieve the same document from sdk we are seeing the portal saved value for the number even though we didn’t update the LONG number field . Can you please confirm for LONG fields and INT fields we can save and see the same way in portal and from sdk irrespective of length? This can be very misleading. With Regards,Nitin Rahim Read More
Server 2025 Hyper-V deduplication corruption is still there
I can still reproduce this with 100% confidence on two VERY different machines and hosts with my “easy to reproduce” package:
– AMD Ryzen 5950 with Windows 11 23H2 (self built)
– Dual Xeon 6226R with Server 2019 (HP Proliant DL 380).
As I posted quite often now: If you use deduplication for Hyper-V, i.e. where the virtual machines reside, you will get data corruptions, your virtual machines will crash, and you may even get a filesystem corruption on the drive hosting the machines.
For more details see here: 26063 deduplication data corruption is still there. – Microsoft Community Hub
As for now: If you used deduplication in Hyper-V scenario, like you used it with Server 2012 up to server 2019, don’t bother with Server 2022 and Server 2025 until that bug is fixed.
My offer still stands for a live demonstration how I reproduce and talk about the differences how Microsoft tried to reproduce this and how I reproduce this.
This is the result for “right about now” albeit without “funk soul brother”…
I can still reproduce this with 100% confidence on two VERY different machines and hosts with my “easy to reproduce” package: – AMD Ryzen 5950 with Windows 11 23H2 (self built) – Dual Xeon 6226R with Server 2019 (HP Proliant DL 380).As I posted quite often now: If you use deduplication for Hyper-V, i.e. where the virtual machines reside, you will get data corruptions, your virtual machines will crash, and you may even get a filesystem corruption on the drive hosting the machines.For more details see here: 26063 deduplication data corruption is still there. – Microsoft Community Hub As for now: If you used deduplication in Hyper-V scenario, like you used it with Server 2012 up to server 2019, don’t bother with Server 2022 and Server 2025 until that bug is fixed. My offer still stands for a live demonstration how I reproduce and talk about the differences how Microsoft tried to reproduce this and how I reproduce this. This is the result for “right about now” albeit without “funk soul brother”… Read More
GitHub integration with Loop
Hi Microsoft 365 Insiders!
Your voice drives our innovation! We’re thrilled to unveil the GitHub integration with Microsoft Loop! This latest integration empowers teams to manage their development projects with unprecedented ease.
Special thanks to Dimple, a Product Manager, and the rest of the Microsoft Loop team for bringing this vision to life!
Explore our blog to see how this integration can help your team’s efficiency and foster a more connected workspace: GitHub integration with Loop
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi Microsoft 365 Insiders!
Your voice drives our innovation! We’re thrilled to unveil the GitHub integration with Microsoft Loop! This latest integration empowers teams to manage their development projects with unprecedented ease.
Special thanks to Dimple, a Product Manager, and the rest of the Microsoft Loop team for bringing this vision to life!
Explore our blog to see how this integration can help your team’s efficiency and foster a more connected workspace: GitHub integration with Loop
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Stream video existence status – recorder leaves company
I have two questions:
1. If a person leaves the company, will stream video (set as no expiration) removed automatically?
2. If a person leaves the company, will a copy (not original video) of a stream video removed? We have a habit of keeping videos in one consolidated area with custom label that is understood by team
members.
I have two questions:1. If a person leaves the company, will stream video (set as no expiration) removed automatically?2. If a person leaves the company, will a copy (not original video) of a stream video removed? We have a habit of keeping videos in one consolidated area with custom label that is understood by teammembers. Read More
SQL Server Networking troubleshooting documentation expanded
The SQL Server CSS (technical support) and Content teams have been publishing documentation on troubleshooting SQL Server networking issues.
Here is a list of articles that have been produced over the past few months.
Much of the content for these articles was the work of Malcolm Stewart – a tenured SQL Networking Escalation Engineer who has left a large legacy of documentation and troubleshooting tools in the SQL networking domain. Also, the following individuals contributed many hours of reviews, ideas, improvements, and content creation and organization: Pradeep Madheshiya, Padma Jayaraman, Seven Dong, Haiying Yu, and Joseph Pilov.
Hope you find these useful. Please share with others and don’t hesitate to provide feedback at the bottom of each article page by clicking on “Was this page helpful?”. Also be on the look-out for more as we are not finished yet.
You can’t use Kerberos unconstrained delegation in certain versions of Windows – SQL Server | Microsoft Learn
Certificate validation failure – SQL Server | Microsoft Learn
Determine the authentication type – SQL Server | Microsoft Learn
Troubleshooting Windows user profile issue in SQL Server – SQL Server | Microsoft Learn
Troubleshooting the explicit misplaced SPN issue in SQL Server – SQL Server | Microsoft Learn
Troubleshooting the Kerberos tickets issue in SQL Server – SQL Server | Microsoft Learn
Troubleshoot LSASS errors with SQL Server authentication – SQL Server | Microsoft Learn
Troubleshooting linked server connectivity errors in SQL Server – SQL Server | Microsoft Learn
Troubleshooting Named Pipes connection error in SQL Server – SQL Server | Microsoft Learn
TLS 1.2 upgrade workflow – SQL Server | Microsoft Learn
Consistent SQL Server network connectivity issues – SQL Server | Microsoft Learn
Intermittent or periodic authentication issues – SQL Server | Microsoft Learn
MSSQLSERVER_18456 – SQL Server | Microsoft Learn (updated)
Windows user profile can’t be loaded in SQL Server – SQL Server | Microsoft Learn
Local SQL Server can’t connect to a linked server when RSA encryption is used – SQL Server | Microsoft Learn
Connection to the linked server fails – SQL Server | Microsoft Learn
Connectivity issues occur when SQL Server Integration Services packages fail to run – SQL Server | Microsoft Learn
SQL Server Agent fails to start while connecting to SQL Server due to misconfigured TLS protocol – SQL Server | Microsoft Learn
Intermittent connection errors occur in SQL Server – SQL Server | Microsoft Learn
Linked server couldn’t be created after moving on-premises SQL Server to Azure – SQL Server | Microsoft Learn
Client is unable to connect after implementing cipher suite policies on a SQL Server – SQL Server | Microsoft Learn
Troubleshooting the SSL_PE_NO_CIPHER error – SQL Server | Microsoft Learn
Troubleshooting intermittent connection errors using SQLCMD – SQL Server | Microsoft Learn
Explicit misplaced SPN error in SQL Server – SQL Server | Microsoft Learn
Kerberos tickets – KRB_AP_ERR_TKT_EXPIRED error in SQL Server – SQL Server | Microsoft Learn
Intermittent or periodic issues with connecting to SQL Server – SQL Server | Microsoft Learn
JDBC configuration and troubleshooting – SQL Server | Microsoft Learn
Troubleshooting network login issues in SQL Server – SQL Server | Microsoft Learn
Errors in the local security subsystem in SQL Server – SQL Server | Microsoft Learn
Linked server connectivity errors in SQL Server – SQL Server | Microsoft Learn
Named Pipes connection failure to SQL Server – SQL Server | Microsoft Learn
The certificate chain was issued by an authority that isn’t trusted – SQL Server | Microsoft Learn
Timeout expired messages when connecting to SQL Server – SQL Server | Microsoft Learn
Thank you!
Microsoft Tech Community – Latest Blogs –Read More
What to Do When Getting QuickBooks Unexpected Error Code C=184
QuickBooks is a powerful accounting software used by businesses worldwide to streamline financial management tasks. However, like any software, QuickBooks is susceptible to errors that can disrupt your workflow. One such error is QuickBooks Error 184. In this article, we’ll delve into what QuickBooks Error 184 is, its potential causes, and provide comprehensive solutions to help you resolve it efficiently.
Understanding QuickBooks Error 184
QuickBooks Error 184 typically occurs when there’s an issue with the user’s bank account or when QuickBooks encounters difficulty processing a bank transaction. This error is usually accompanied by a message stating, “There is a problem with your account or you are using a type of account that QuickBooks Online does not support.”
Possible Causes of QuickBooks Error 184
Incorrect Bank Account Information: If the bank account details entered in QuickBooks are incorrect or outdated, it can lead to Error 184 when attempting to connect to the bank’s servers for transaction processing.
Bank Server Issues: Sometimes, the bank’s servers may experience downtime or connectivity issues, preventing QuickBooks from establishing a connection and resulting in Error 184.
Unsupported Account Type: Certain types of bank accounts may not be compatible with QuickBooks Online, leading to Error 184 when trying to sync transactions or access account information.
Security Settings: Security settings on the bank’s end or within QuickBooks Online may block the connection between the two platforms, triggering Error 184.
Solutions to Fix QuickBooks Unexpected Error Code C=184
Now that we’ve identified potential causes, let’s explore effective solutions to resolve QuickBooks Error 184:
Update Bank Account Information:
Log in to QuickBooks Online and navigate to the Banking tab.Select the affected bank account and click on the Edit ✎ icon.Verify that the bank account details, including account number, routing number, and account type, are correct and up to date.If any information is incorrect, update it accordingly and save the changes.
Check Bank Server Status:
Visit the website of the bank associated with the affected account and check for any announcements regarding server maintenance or outages.If the bank’s servers are experiencing downtime or issues, you may need to wait until they are resolved before attempting to connect QuickBooks Online.
Contact Bank Support:
If you suspect that the issue lies with the bank account itself, contact your bank’s customer support for assistance.Verify with the bank that the account is in good standing and that there are no restrictions or issues affecting its accessibility.
Try a Different Account Type:
If you’re using an account type that QuickBooks Online does not support, consider switching to a supported account type.Check QuickBooks Online’s list of supported banks and account types to ensure compatibility.
Disable Security Settings:
Temporarily disable any security settings or features on the bank’s website that may be blocking QuickBooks Online from accessing your account.Similarly, review the security settings within QuickBooks Online and adjust them if necessary to allow connections to the bank’s servers.
Reconnect Bank Account:
In QuickBooks Online, navigate to the Banking tab and select the affected bank account.Click on the Edit ✎ icon and choose “Disconnect this account on save.”After disconnecting the account, reconnect it by following the prompts and providing the necessary information.Once the account is reconnected, attempt to sync transactions again to see if Error 184 persists.
By following these solutions, you can effectively troubleshoot and resolve QuickBooks Error 184, ensuring seamless integration and synchronization of your bank accounts with QuickBooks Online. If the error persists despite attempting these solutions, consider reaching out to QuickBooks support or your bank’s customer service for further assistance. With the right approach, you can overcome Error 184 and continue utilizing QuickBooks for your accounting needs without interruptions.
Related Searches:
QuickBooks C=184 error fix
Troubleshoot QuickBooks Unexpected Error Code C=184
Resolve QuickBooks Error C=184
QuickBooks C=184 error message
QuickBooks desktop C=184 error
QuickBooks error code C=184 solution
QuickBooks C=184 error support
QuickBooks C=184 error troubleshooting
QuickBooks C=184 error help
QuickBooks C=184 error causes
How to fix QuickBooks Unexpected Error Code C=184?
QuickBooks Unexpected Error Code C=184 solutions
QuickBooks C=184 error troubleshooting guide
What causes QuickBooks Unexpected Error Code C=184?
QuickBooks Unexpected Error Code C=184 support
QuickBooks is a powerful accounting software used by businesses worldwide to streamline financial management tasks. However, like any software, QuickBooks is susceptible to errors that can disrupt your workflow. One such error is QuickBooks Error 184. In this article, we’ll delve into what QuickBooks Error 184 is, its potential causes, and provide comprehensive solutions to help you resolve it efficiently. Understanding QuickBooks Error 184 QuickBooks Error 184 typically occurs when there’s an issue with the user’s bank account or when QuickBooks encounters difficulty processing a bank transaction. This error is usually accompanied by a message stating, “There is a problem with your account or you are using a type of account that QuickBooks Online does not support.” Possible Causes of QuickBooks Error 184 Incorrect Bank Account Information: If the bank account details entered in QuickBooks are incorrect or outdated, it can lead to Error 184 when attempting to connect to the bank’s servers for transaction processing.Bank Server Issues: Sometimes, the bank’s servers may experience downtime or connectivity issues, preventing QuickBooks from establishing a connection and resulting in Error 184.Unsupported Account Type: Certain types of bank accounts may not be compatible with QuickBooks Online, leading to Error 184 when trying to sync transactions or access account information.Security Settings: Security settings on the bank’s end or within QuickBooks Online may block the connection between the two platforms, triggering Error 184. Solutions to Fix QuickBooks Unexpected Error Code C=184 Now that we’ve identified potential causes, let’s explore effective solutions to resolve QuickBooks Error 184:Update Bank Account Information:Log in to QuickBooks Online and navigate to the Banking tab.Select the affected bank account and click on the Edit ✎ icon.Verify that the bank account details, including account number, routing number, and account type, are correct and up to date.If any information is incorrect, update it accordingly and save the changes.Check Bank Server Status:Visit the website of the bank associated with the affected account and check for any announcements regarding server maintenance or outages.If the bank’s servers are experiencing downtime or issues, you may need to wait until they are resolved before attempting to connect QuickBooks Online.Contact Bank Support:If you suspect that the issue lies with the bank account itself, contact your bank’s customer support for assistance.Verify with the bank that the account is in good standing and that there are no restrictions or issues affecting its accessibility.Try a Different Account Type:If you’re using an account type that QuickBooks Online does not support, consider switching to a supported account type.Check QuickBooks Online’s list of supported banks and account types to ensure compatibility.Disable Security Settings:Temporarily disable any security settings or features on the bank’s website that may be blocking QuickBooks Online from accessing your account.Similarly, review the security settings within QuickBooks Online and adjust them if necessary to allow connections to the bank’s servers.Reconnect Bank Account:In QuickBooks Online, navigate to the Banking tab and select the affected bank account.Click on the Edit ✎ icon and choose “Disconnect this account on save.”After disconnecting the account, reconnect it by following the prompts and providing the necessary information.Once the account is reconnected, attempt to sync transactions again to see if Error 184 persists.By following these solutions, you can effectively troubleshoot and resolve QuickBooks Error 184, ensuring seamless integration and synchronization of your bank accounts with QuickBooks Online. If the error persists despite attempting these solutions, consider reaching out to QuickBooks support or your bank’s customer service for further assistance. With the right approach, you can overcome Error 184 and continue utilizing QuickBooks for your accounting needs without interruptions.Related Searches: QuickBooks C=184 error fixTroubleshoot QuickBooks Unexpected Error Code C=184Resolve QuickBooks Error C=184QuickBooks C=184 error messageQuickBooks desktop C=184 errorQuickBooks error code C=184 solutionQuickBooks C=184 error supportQuickBooks C=184 error troubleshootingQuickBooks C=184 error helpQuickBooks C=184 error causesHow to fix QuickBooks Unexpected Error Code C=184?QuickBooks Unexpected Error Code C=184 solutionsQuickBooks C=184 error troubleshooting guideWhat causes QuickBooks Unexpected Error Code C=184?QuickBooks Unexpected Error Code C=184 support Read More
why is this SO hard ……
Hi,
I’ve inherited a few docs from a person who left and I’m no MS WORD guru. (grin)
All I’m trying to do is pull out pages from a bigger doc and extract some forms from it.
There are these “Section Break (next page) things all over this place and I have no clue how to deal with them, when I go to delete an extra page, the formatting of the previous page goes nuts.
I tried to read a article about saving the formatting and then deleting a page but I couldn’t get it to work for the life of me.
I’ve attached an example, and I have about 5 of these forms I need to get from a two page document down to a one page document, because the next page break thing is blank and I don’t need it, its just this formatting saving stuff and page breaks.
It’s got a header and footer in it but there’s nothing the footer, so I have everything I need the entire document to be, but there is another blank page two that shows up with the same header.
If I try in any way to delete that second blank page, the previous page one screws up, I’m saying that because its child-proof and I’m dumb. (sigh)
PLEASE – could anyone just explain, exactly, step by step how to save the formatting in the document (whatever that is) and then let me delete the entire second page without wrecking the first page?
You can do it for me but I’d rather learn how! Thankings …….
Cheers’
Dave
Hi,I’ve inherited a few docs from a person who left and I’m no MS WORD guru. (grin) All I’m trying to do is pull out pages from a bigger doc and extract some forms from it.There are these “Section Break (next page) things all over this place and I have no clue how to deal with them, when I go to delete an extra page, the formatting of the previous page goes nuts. I tried to read a article about saving the formatting and then deleting a page but I couldn’t get it to work for the life of me. I’ve attached an example, and I have about 5 of these forms I need to get from a two page document down to a one page document, because the next page break thing is blank and I don’t need it, its just this formatting saving stuff and page breaks. It’s got a header and footer in it but there’s nothing the footer, so I have everything I need the entire document to be, but there is another blank page two that shows up with the same header. If I try in any way to delete that second blank page, the previous page one screws up, I’m saying that because its child-proof and I’m dumb. (sigh)PLEASE – could anyone just explain, exactly, step by step how to save the formatting in the document (whatever that is) and then let me delete the entire second page without wrecking the first page? You can do it for me but I’d rather learn how! Thankings ……. Cheers’Dave Read More
Trello Integration with Loop
Hi Microsoft 365 Insiders!
Exciting news! Trello is now integrated with Microsoft Loop. Your data can now stay in sync, across both platforms automatically, making teamwork a breeze. Learn how this works in our latest blog by Dimple, Product Manager on the Loop team > > Trello Integration with Loop
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi Microsoft 365 Insiders!
Exciting news! Trello is now integrated with Microsoft Loop. Your data can now stay in sync, across both platforms automatically, making teamwork a breeze. Learn how this works in our latest blog by Dimple, Product Manager on the Loop team > > Trello Integration with Loop
Thanks!
Perry Sjogren
Microsoft 365 Insider Social Media Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
T-2 Weeks! Marketplace at Microsoft Build 2024
Register for marketplace-specific sessions to learn how the marketplace can keep you and customers ahead in the era of AI:
“Launch AI applications and get to market faster with marketplace” – in-person and online
“AI-powered commerce with the Microsoft commercial marketplace” – on-demand
“Maximize cloud investments with the Microsoft commercial marketplace” – on-demand
Exclusive evening social on May 22 for partners selling through the marketplace. Partners can engage with Microsoft leadership, meet other partners, and get insights into how to unlock benefits. Capacity is limited so complete this interest form to request passes. *Note, this does not include passes for Microsoft Build.
Connect with marketplace experts at our Community space at Microsoft Build. Marketplace experts will be staffed throughout all three days of the event, so stop by the Microsoft Cloud Platform Community space near Expert Meet-ups on the 5th floor to get your marketplace questions answered.
Marketplace at Microsoft Build 2024
Marketplace will be integrated as a core component at Microsoft Build for the first time with content for partners, developers, and customers. If you or your colleagues are attending Microsoft Build in-person this year, we encourage you to take part in these activities:
Register for marketplace-specific sessions to learn how the marketplace can keep you and customers ahead in the era of AI:
“Launch AI applications and get to market faster with marketplace” – in-person and online
“AI-powered commerce with the Microsoft commercial marketplace” – on-demand
“Maximize cloud investments with the Microsoft commercial marketplace” – on-demand
Exclusive evening social on May 22 for partners selling through the marketplace. Partners can engage with Microsoft leadership, meet other partners, and get insights into how to unlock benefits. Capacity is limited so complete this interest form to request passes. *Note, this does not include passes for Microsoft Build.
Connect with marketplace experts at our Community space at Microsoft Build. Marketplace experts will be staffed throughout all three days of the event, so stop by the Microsoft Cloud Platform Community space near Expert Meet-ups on the 5th floor to get your marketplace questions answered. Read More
Feature request: multiple windows share pinned tabs.
Edge enables us to pin tabs that frequently used. After closing and reopening Edge, the pinned tabs still exist. That’s great! However, I opened window 1 and pinned some tabs, and then I opened window 2. The window 2 did not share the pinned tabs, which was inconvenient. Even worse, if I close window 1 before window 2, all pinned tabs will lost! The reason is that Edge only saves the pinned tabs before exiting. So I hope that multiple windows share pinned tabs.
Edge enables us to pin tabs that frequently used. After closing and reopening Edge, the pinned tabs still exist. That’s great! However, I opened window 1 and pinned some tabs, and then I opened window 2. The window 2 did not share the pinned tabs, which was inconvenient. Even worse, if I close window 1 before window 2, all pinned tabs will lost! The reason is that Edge only saves the pinned tabs before exiting. So I hope that multiple windows share pinned tabs. Read More
Deploying Open OnDemand Portal with Azure CycleCloud
Dr. Wolfgang De Salvador – EMEA GBB HPC/AI Infrastructure Senior Specialist
Dr. Darko Mocelj – EMEA GBB HPC/AI Infrastructure Senior Specialist
Resources and references used in this article:
Repository of the Azure CycleCloud OnDemand project
Open OnDemand Portal
Open OnDemand Portal Documentation
OnDemand Job template for OpenFOAM
Visit us at ISC24 – Microsoft Booth #F30 for a live demo of this integration on Wednesday, the 15th | 9 AM – 12.30 PM
Introduction
As of today, several tools, frameworks and automations allow the deployment of HPC infrastructures in a cloud environment.
Azure CycleCloud enables users and IT administrators to run cloud-only or hybrid (bursting) clusters leveraging traditional HPC schedulers like OpenPBS, SGE, Altair PBS Professional and Slurm.
Azure CycleCloud provides the possibility to preserve standard submission interfaces from on-premises HPC systems, without the need to re-architect or alter by any means the standard simulation workflows. In this way, end users can keep running and using their standard applications without any disruption.
Azure CycleCloud provides out of the box the possibility for interaction and cluster operations only using a standard SSH connection for the end users or scheduler default APIs (e.g. Slurm APIs).
This blog post presents an Azure CycleCloud project allowing to deploy an Open OnDemand portal, an efficient open-source web portal for job submission, job monitoring, file management and remote desktop/application sessions.
This project allows to deploy an Open OnDemand Portal like az-hop, but allowing the user to just deploy a single VM with a portal to be attached to an already existing and configured Azure CycleCloud cluster.
What is required as prerequisites
The project requires a working installation of Azure CycleCloud.
At the same time, Open OnDemand portal is meant to be attached to an existing Slurm or OpenPBS cluster deployed in Azure CycleCloud. Support for additional schedulers is planned to be available in future releases.
The deployment relies on an Azure Key Vault and a Managed Identity for secret access during the deployment. The following elements need to be uploaded depending on the selected SSL and authentication mechanism need in the Azure Key Vault:
SSL certificate
Required to avoid using self-signed certificate.
Secret for the OIDC Client
This is required in case the authentication mechanism is OIDC. This will require an Entra ID app registration
LDAPS CA Certificate
This is required only in case of OIDC Dex LDAP if the LDAPS server requires a dedicated certification authority for SSL connections
LDAP Service Account BIND password
This is required only in case of OIDC Dex LDAP among with a read only account
Basic authentication option and self-signed SSL certificates should be considered only for test/development purpose, away from production systems because of the security concerns
How to deploy
The project can be deployed following the step-by-step guide provided in the README of the GitHub repository.
The steps involved in getting the project accessible inside Azure CycleCloud are:
Definition of a custom cluster-init project source in Azure CycleCloud
Import of the OnDemand Portal template in Azure CycleCloud
What the project will deliver
The project will deploy a single sever hosting an Open OnDemand portal allowing the users to specify:
The general server configuration in terms of Azure VM Size, Virtual Network, IP Address and server name.
The cluster to which the OnDemand Portal should be attached in terms of scheduler type (OpenPBS/Slurm) and scheduler version
The shared NFS file system to be attached in /shared and /sched as common shared file systems for users and file management
The OnDemand Portal configuration in terms of:
Authentication
OIDC
OIDC Dex LDAP
Basic PAM (insecure)
SSL termination
Bring-your-own certificate
Self-signed (insecure)
All the secrets and certificates involved in the configuration are safely stored inside an Azure Key Vault which is accessed by the Azure CycleCloud nodes through a Managed Identity.
After the cluster is successfully deployed, the user will be able to have a basic interface to access the main OnDemand functionality:
In-browser SSH connection
Ability to upload/download files
Possibility to customize the OnDemand portal configuration with dedicated Interactive Apps templates.
Additional considerations
Open OnDemand portal must be able to map the username provided by an external authentication mechanism like OIDC or OIDC Dex LDAP to a local Linux user account. This will be the Linux account that will be impersonating the user and interacting with the cluster through Open OnDemand.
This is something that remains responsibility of the user following the Open OnDemand documentation.
An easy way to realize this is to enable Azure CycleCloud EntraID and using the following additional configuration in Open OnDemand Portal:
user_map_match: ‘^([^@]+)@example.com$’
oidc_remote_user_claim: “email”
This will map the users authenticated from EntraID directly to a local user in the system. The configuration above can be inputted directly from Azure CycleCloud UI and respectively:
the user map match in the additional configuration
the OIDC Remote user claim in the authentication section
Creation of Interactive Desktop Sessions with auto-scaling in Azure CycleCloud
As already extensively implemented and developed in az-hop, Open OnDemand allows to create on-demand interactive Desktop Session or Interactive App session with nodes dynamically allocated by Azure CycleCloud.
The underlying concept is that a Desktop session will be submitted as a job to the scheduler and Azure CycleCloud will allocate the required nodes for the session duration.
In order to get this up in OnDemand, the steps are:
Defining a dedicated nodearray in Azure CycleCloud for the purpose. There is an example of a Slurm cluster template based on 3.0.6 version of the CycleCloud project inside the repository.
Building a dedicated OS image on Azure with the required Desktop environment. An example script for non-accelerated GPU environments is available in the repository. For GPU accelerated environment it is possible to install also the dedicated driver and VirtualGL.
Configuring Open OnDemand portal Desktop form attributes and enabling reverse proxy.
There is the plan in a future project release to integrate this configuration also in an automation.
Creation of a submission batch application
In a similar way of interactive session, Open OnDemand allows to define submission forms for specific batch submission logics.
For example, here an example of integrating OpenFOAM submission in the OpenOnDemand portal:
Once the job is finished, it can be visualized using a Desktop session GPU accelerated:
Visit us at ISC24 – Microsoft Booth #F30 for a live demo of this integration on Wednesday, the 15th | 9 AM – 12.30 PM
Microsoft Tech Community – Latest Blogs –Read More
Resolving QuickBooks Error 503: Causes and Solutions
QuickBooks is a versatile accounting software that helps businesses manage their finances efficiently. However, encountering errors like QuickBooks Error 503 can disrupt your workflow and hinder productivity. In this article, we’ll explore what QuickBooks Error 503 is, its potential causes, and provide detailed solutions to help you resolve it effectively.
Understanding QuickBooks Error 503
QuickBooks Error 503 typically occurs when users try to access the QuickBooks company file remotely, and the server is unable to handle the request. This error indicates that the QuickBooks server is temporarily unavailable or overloaded, preventing users from accessing the company file.
Possible Causes of QuickBooks Error 503
Server Overload: If the QuickBooks server is experiencing a high volume of requests or is overloaded due to heavy usage, it may result in Error 503.
Internet Connectivity Issues: Poor or unstable internet connection on the user’s end can also trigger Error 503 when trying to access QuickBooks remotely.
Firewall or Security Software: Sometimes, firewall or security software settings may block the connection to the QuickBooks server, leading to Error 503.
Corrupted QuickBooks Company File: If the QuickBooks company file is damaged or corrupted, it may cause issues when attempting to access it remotely, resulting in Error 503.
Solutions to Fix QuickBooks Error 503
Now that we’ve identified potential causes, let’s explore effective solutions to resolve QuickBooks Error 503:
Check QuickBooks Server Status:
Visit the Intuit QuickBooks status page or check the Intuit website for any announcements regarding server maintenance or outages.If the QuickBooks server is experiencing downtime or maintenance, you may need to wait until it’s back online before attempting to access your company file.
Verify Internet Connectivity:
Ensure that your internet connection is stable and functioning properly.If using a wireless connection, consider switching to a wired connection for a more stable connection.Test your internet connection by accessing other websites or services to confirm that it’s not a general connectivity issue.
Disable Firewall or Security Software:
Temporarily disable any firewall or security software on your computer.After disabling the firewall, try accessing QuickBooks again to see if Error 503 persists.If disabling the firewall resolves the issue, you may need to adjust the settings to allow QuickBooks access through the firewall.
Clear Browser Cache and Cookies:
If you’re accessing QuickBooks through a web browser, try clearing your browser’s cache and cookies.Cache and cookies can sometimes cause issues with website access, including QuickBooks, so clearing them may resolve Error 503.
Restart QuickBooks Server and Workstation:
Restart the QuickBooks server where the company file is stored.Restart the workstation or computer from which you’re trying to access QuickBooks.After restarting both the server and workstation, try accessing QuickBooks again to check if Error 503 persists.
Repair QuickBooks Installation:
Close QuickBooks and navigate to the Control Panel on your computer.Select “Programs and Features” or “Add/Remove Programs,” then locate QuickBooks in the list of installed programs.Right-click on QuickBooks and choose “Repair” to initiate the repair process.Once the repair is complete, restart your computer and attempt to access QuickBooks again.
By following these solutions, you can effectively troubleshoot and resolve QuickBooks Error 503, ensuring uninterrupted access to your company file. If the error persists despite attempting these solutions, consider reaching out to QuickBooks support for further assistance. With the right approach, you can overcome Error 503 and resume your accounting tasks with ease.
Related Searches:
How to fix QuickBooks Error 503?
QuickBooks Error 503 service unavailable solutions
QuickBooks Error 503 troubleshooting guide
What causes QuickBooks Error 503?
QuickBooks Error 503 support
QuickBooks is a versatile accounting software that helps businesses manage their finances efficiently. However, encountering errors like QuickBooks Error 503 can disrupt your workflow and hinder productivity. In this article, we’ll explore what QuickBooks Error 503 is, its potential causes, and provide detailed solutions to help you resolve it effectively. Understanding QuickBooks Error 503 QuickBooks Error 503 typically occurs when users try to access the QuickBooks company file remotely, and the server is unable to handle the request. This error indicates that the QuickBooks server is temporarily unavailable or overloaded, preventing users from accessing the company file. Possible Causes of QuickBooks Error 503 Server Overload: If the QuickBooks server is experiencing a high volume of requests or is overloaded due to heavy usage, it may result in Error 503.Internet Connectivity Issues: Poor or unstable internet connection on the user’s end can also trigger Error 503 when trying to access QuickBooks remotely.Firewall or Security Software: Sometimes, firewall or security software settings may block the connection to the QuickBooks server, leading to Error 503.Corrupted QuickBooks Company File: If the QuickBooks company file is damaged or corrupted, it may cause issues when attempting to access it remotely, resulting in Error 503. Solutions to Fix QuickBooks Error 503 Now that we’ve identified potential causes, let’s explore effective solutions to resolve QuickBooks Error 503:Check QuickBooks Server Status:Visit the Intuit QuickBooks status page or check the Intuit website for any announcements regarding server maintenance or outages.If the QuickBooks server is experiencing downtime or maintenance, you may need to wait until it’s back online before attempting to access your company file.Verify Internet Connectivity:Ensure that your internet connection is stable and functioning properly.If using a wireless connection, consider switching to a wired connection for a more stable connection.Test your internet connection by accessing other websites or services to confirm that it’s not a general connectivity issue.Disable Firewall or Security Software:Temporarily disable any firewall or security software on your computer.After disabling the firewall, try accessing QuickBooks again to see if Error 503 persists.If disabling the firewall resolves the issue, you may need to adjust the settings to allow QuickBooks access through the firewall.Clear Browser Cache and Cookies:If you’re accessing QuickBooks through a web browser, try clearing your browser’s cache and cookies.Cache and cookies can sometimes cause issues with website access, including QuickBooks, so clearing them may resolve Error 503.Restart QuickBooks Server and Workstation:Restart the QuickBooks server where the company file is stored.Restart the workstation or computer from which you’re trying to access QuickBooks.After restarting both the server and workstation, try accessing QuickBooks again to check if Error 503 persists.Repair QuickBooks Installation:Close QuickBooks and navigate to the Control Panel on your computer.Select “Programs and Features” or “Add/Remove Programs,” then locate QuickBooks in the list of installed programs.Right-click on QuickBooks and choose “Repair” to initiate the repair process.Once the repair is complete, restart your computer and attempt to access QuickBooks again.By following these solutions, you can effectively troubleshoot and resolve QuickBooks Error 503, ensuring uninterrupted access to your company file. If the error persists despite attempting these solutions, consider reaching out to QuickBooks support for further assistance. With the right approach, you can overcome Error 503 and resume your accounting tasks with ease. Related Searches: How to fix QuickBooks Error 503?QuickBooks Error 503 service unavailable solutionsQuickBooks Error 503 troubleshooting guideWhat causes QuickBooks Error 503?QuickBooks Error 503 support Read More
What to Do When Getting QuickBooks Error 50004
QuickBooks is a powerful accounting software trusted by millions of businesses worldwide for its comprehensive features and ease of use. However, encountering errors like QuickBooks Error 50004 can be frustrating and disruptive to your workflow. In this article, we’ll explore what QuickBooks Error 50004 is, its potential causes, and provide detailed solutions to help you resolve it effectively.
Understanding QuickBooks Error 50004
QuickBooks Error 50004 is a runtime error that typically occurs when users attempt to open or work with their company file. This error indicates an issue with the QuickBooks software or the company file itself, preventing users from accessing their financial data.
Possible Causes of QuickBooks Error 50004
Corrupted Company File: One of the most common reasons for QuickBooks Error 50004 is a corrupted company file. This can happen due to various factors such as improper shutdowns, power outages, or file system errors.
Outdated QuickBooks Version: Using an outdated version of QuickBooks can lead to compatibility issues and errors like Error 50004. It’s essential to keep your QuickBooks software up to date with the latest updates and patches released by Intuit.
Damaged QuickBooks Components: If certain components of the QuickBooks software are damaged or missing, it can result in runtime errors like Error 50004 when trying to access the company file.
Conflicting Software: Sometimes, other software installed on your computer may conflict with QuickBooks, leading to runtime errors. This could include antivirus programs, firewall settings, or other third-party applications.
Solutions to Fix QuickBooks Error 50004
Now that we’ve identified potential causes, let’s explore effective solutions to resolve QuickBooks Error 50004:
Run QuickBooks File Doctor:
QuickBooks File Doctor is a diagnostic tool provided by Intuit to troubleshoot and fix common QuickBooks issues, including company file errors.Download and install QuickBooks File Doctor from the Intuit website.Run the tool and follow the on-screen instructions to scan and repair your company file.Once the repair process is complete, attempt to open the company file again to see if Error 50004 persists.
Update QuickBooks Software:
Ensure that you’re using the latest version of QuickBooks by checking for updates within the software.Open QuickBooks and go to the “Help” menu, then select “Update QuickBooks Desktop.”Follow the on-screen instructions to download and install any available updates.After updating QuickBooks, try opening the company file again to see if the error is resolved.
Restore a Backup of the Company File:
If the company file is corrupted beyond repair, you can restore a backup copy of the file to resolve Error 50004.Locate a recent backup of the company file and restore it using the QuickBooks Backup and Restore feature.Ensure that the backup file is not corrupted and that it contains the most up-to-date financial data.
Reinstall QuickBooks Software:
If QuickBooks Error 50004 persists after trying the above solutions, consider reinstalling the QuickBooks software.Uninstall QuickBooks from your computer through the Control Panel or Applications folder.Download the latest version of QuickBooks from the Intuit website and reinstall it on your computer.After reinstalling QuickBooks, try opening the company file again to check if the error is resolved.
Check for Conflicting Software:
Review the list of installed programs on your computer and identify any software that may conflict with QuickBooks.Temporarily disable or uninstall conflicting software and then try opening the company file again to see if Error 50004 persists.
By following these solutions, you can effectively troubleshoot and resolve QuickBooks Error 50004, ensuring smooth access to your financial data. If the error persists despite attempting these solutions, consider reaching out to QuickBooks support for further assistance. With the right approach, you can overcome Error 50004 and continue utilizing QuickBooks’ powerful accounting features without interruption.
QuickBooks is a powerful accounting software trusted by millions of businesses worldwide for its comprehensive features and ease of use. However, encountering errors like QuickBooks Error 50004 can be frustrating and disruptive to your workflow. In this article, we’ll explore what QuickBooks Error 50004 is, its potential causes, and provide detailed solutions to help you resolve it effectively. Understanding QuickBooks Error 50004 QuickBooks Error 50004 is a runtime error that typically occurs when users attempt to open or work with their company file. This error indicates an issue with the QuickBooks software or the company file itself, preventing users from accessing their financial data. Possible Causes of QuickBooks Error 50004 Corrupted Company File: One of the most common reasons for QuickBooks Error 50004 is a corrupted company file. This can happen due to various factors such as improper shutdowns, power outages, or file system errors.Outdated QuickBooks Version: Using an outdated version of QuickBooks can lead to compatibility issues and errors like Error 50004. It’s essential to keep your QuickBooks software up to date with the latest updates and patches released by Intuit.Damaged QuickBooks Components: If certain components of the QuickBooks software are damaged or missing, it can result in runtime errors like Error 50004 when trying to access the company file.Conflicting Software: Sometimes, other software installed on your computer may conflict with QuickBooks, leading to runtime errors. This could include antivirus programs, firewall settings, or other third-party applications. Solutions to Fix QuickBooks Error 50004 Now that we’ve identified potential causes, let’s explore effective solutions to resolve QuickBooks Error 50004:Run QuickBooks File Doctor:QuickBooks File Doctor is a diagnostic tool provided by Intuit to troubleshoot and fix common QuickBooks issues, including company file errors.Download and install QuickBooks File Doctor from the Intuit website.Run the tool and follow the on-screen instructions to scan and repair your company file.Once the repair process is complete, attempt to open the company file again to see if Error 50004 persists.Update QuickBooks Software:Ensure that you’re using the latest version of QuickBooks by checking for updates within the software.Open QuickBooks and go to the “Help” menu, then select “Update QuickBooks Desktop.”Follow the on-screen instructions to download and install any available updates.After updating QuickBooks, try opening the company file again to see if the error is resolved.Restore a Backup of the Company File:If the company file is corrupted beyond repair, you can restore a backup copy of the file to resolve Error 50004.Locate a recent backup of the company file and restore it using the QuickBooks Backup and Restore feature.Ensure that the backup file is not corrupted and that it contains the most up-to-date financial data.Reinstall QuickBooks Software:If QuickBooks Error 50004 persists after trying the above solutions, consider reinstalling the QuickBooks software.Uninstall QuickBooks from your computer through the Control Panel or Applications folder.Download the latest version of QuickBooks from the Intuit website and reinstall it on your computer.After reinstalling QuickBooks, try opening the company file again to check if the error is resolved.Check for Conflicting Software:Review the list of installed programs on your computer and identify any software that may conflict with QuickBooks.Temporarily disable or uninstall conflicting software and then try opening the company file again to see if Error 50004 persists.By following these solutions, you can effectively troubleshoot and resolve QuickBooks Error 50004, ensuring smooth access to your financial data. If the error persists despite attempting these solutions, consider reaching out to QuickBooks support for further assistance. With the right approach, you can overcome Error 50004 and continue utilizing QuickBooks’ powerful accounting features without interruption. Read More