Error occurred when opening the software

pooo zz 100

Hello experts,

I encountered this problem when opening the sanling software. sanling is the software used by our company to process the sql server. When I execute the sql code, I occasionally log in to sanling for the next operation. I am very distressed. The frequency is about once a week. Please help me.

Thanks！！

User's image

Accepted answer

Erland Sommarskog 107.2K Reputation points

2023-03-07T22:40:41.4733333+00:00

By default most client APIs waits 30 seconds for SQL Server to complete, and if it doesn't the raise this error and at the same time tells SQL Server to cancel the operation.

It appears that this occurs with a software package you are using. You need to talk to the vendor of that package. It could be a query that is too slow. Or they should just simply change the timeout.
Please sign in to rate this answer.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

pooo zz 100 Reputation points

2023-03-09T07:45:45.8933333+00:00

Hello expert, the local execution of sql statements is very fast. I didn't find the reason for the timeout caused by the slow execution. Whether the link time setting of the software I used is too short, and whether it is necessary for me to contact the supplier, because I can't see it in the background. I only use this software. I don't know other information.

Erland Sommarskog 107.2K Reputation points

2023-03-09T21:55:06.7933333+00:00

Hello expert, the local execution of sql statements is very fast

What statements? The same statements that the application submits? Or some completely different statements?

Please bear in mind that we only know as much about your problem as you tell us, and our answers will be accordingly.

pooo zz 100 Reputation points

2023-03-10T08:24:12.84+00:00

Good afternoon, erland. Maybe I didn't express it clearly. The statement here refers to the sql code provided by sanling. I used SET STATISTICS on and off to try to find out whether the error is caused by these statements not being optimized, but it executes quickly, so I ruled it out. I don't know if you know anything about the application log, because someone recommended me to see what caused it in this way. If you have any suggestions, please comment. I am also contacting the crm supplier now.

Thanks in advance!

pooo

Erland Sommarskog 107.2K Reputation points

2023-03-10T15:54:08.1333333+00:00

I have no idea what "sanling" is.

Here is one thing to try. Before you run the statement from Sanling, run this command: SET ARITHABORT OFF. Does this change things?

Any chance you can share the problematic statement with us?

pooo zz 100 Reputation points

2023-03-13T01:24:36.07+00:00

Thank you erland for your reply, I contacted the manufacturer and finally got the answer that the delay of their link to the database is 15ms, so when my computer freezes suddenly prompts the login failure, thank you again for your free time to help me！！
Sign in to comment

2 additional answers

Olaf Helper 43,246 Reputation points

2023-03-07T11:00:47.48+00:00

Sorry, but for me it's unclear, what your issue is.

Deafult for "Execution timeout" aare 30 seconds. Optimize your query or increase the timeout period.
Please sign in to rate this answer.
pooo zz 100 Reputation points

2023-03-09T07:42:24.16+00:00

Thank you for your reply. The problem I'm facing now is that there is no problem with my code running locally on the sql server. I also used the command to check the execution time and execution plan. When I link to a piece of software of sanling, it has a problem. When I occasionally prompt the hyperlink, I have changed the execution time of the statement in the database, but this has not solved my problem. Do you have any other ideas about this.
Sign in to comment
Seeya Xi-MSFT 16,461 Reputation points

2023-03-08T02:08:40.82+00:00

Hi @pooo zz ,

This error message indicates that the SQL Server was not able to complete the operation within the specified time limit, and the execution has timed out. There are several possible causes for this error:

Server performance: The SQL Server might be overloaded or experiencing performance issues, causing it to take longer than expected to complete the query.

Query complexity: The query being executed might be too complex or involve too much data, making it take longer to execute than the timeout period allows.

Network issues: There might be issues with the network connection between the client and the SQL Server, causing delays in data transmission.

Server configuration: The SQL Server configuration settings might be set to a low timeout value.

To resolve this error, you can try the following steps:

Check the SQL Server logs to see if there are any performance or connectivity issues that need to be addressed.

Increase the timeout value in the SQL Server configuration settings to allow the query more time to complete.

Best regards,

Seeya

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Please sign in to rate this answer.
pooo zz 100 Reputation points

2023-03-09T07:47:41.0233333+00:00

Thank you for your reply. Can you give me some suggestions for my reference? The above words are too complex for me to understand.

Seeya Xi-MSFT 16,461 Reputation points

2023-03-09T07:57:50.8033333+00:00

Hi,

Server performance: You can try running just one query.

Query complexity：You can try to run a simple query.

Both of these are performance checks.

Network issues: Maybe your network is unstable. You can try a few more times.

Server configuration: This is something they also mentioned.

Check the SQL Server logs to see if there are any performance or connectivity issues that need to be addressed.

pooo zz 100 Reputation points

2023-03-10T08:25:31.6366667+00:00

No, you don't understand what I mean. What I need is the reason that may cause the application link database timeout.

Joana Arez 0 Reputation points

2023-07-03T07:45:39.9+00:00

Hello, I have the same problem as this person. I was trying to reset the computer to factory settings, when this same warning appeared. I've tried to follow the instructions but it just repeats, it tries to reset the computer but this warning appears again and again and again. I would appreciate a lot if you could help me 🙏:)

Erland Sommarskog 107.2K Reputation points

2023-07-03T14:51:17.8766667+00:00

House rules: don't piggyback on old threads, but ask a new question, describing your problem from start to end. With the information you have shared, we know far too little to be able to help you.
Sign in to comment

Share via

Error occurred when opening the software

2 additional answers