Error occurred when opening the software

Question

Error occurred when opening the software

pooo zz 80

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

Answer 1

Erland Sommarskog 72,891 MVP

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.

pooo zz 80 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 72,891 Reputation points MVP

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 80 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 72,891 Reputation points MVP

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 80 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！！

Answer 2

Olaf Helper 27,301

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.

pooo zz 80 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.

Answer 3

Seeya Xi-MSFT 15,196 Microsoft Vendor

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".

pooo zz 80 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 15,196 Reputation points Microsoft Vendor

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 80 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.

Error occurred when opening the software

2 additional answers

Activity