[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

ASp and MSSQl timeout error

Posted on 2009-02-12
4
Medium Priority
?
227 Views
Last Modified: 2012-06-22
I recently Migrated a Job Board website from an online server to a local server within the company as it was really slow. Once i migrated the website i set everything right .

THere is a login screen, I log in and the LOGIN works fine , which means that the databse is configured right.

Once i login when i try to View Candidates(Lots of records) I get the follwoing error.

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Error while processing your query, please retry your search !"

I changed the coonection string timeout property and all but nothing worked.

What im unable to understand that when the site was online it used to TIMEOUT ocassionally But when I migrated it to a local server It Timesout all the time.

On some suggestions i checked the SQL LOG and found this error:


A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is IFTS (id: 8); catalog name is MessageCatalog (id: 5); table name Messages (id: 2105058535). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.


I have enabled FDLHost etc....

I just dont seem to figure out whats happening
0
Comment
Question by:isaackhazi
  • 2
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
informaniac earned 1500 total points
ID: 23620187
Have u created any identity column? Is the maximum size of the identity column reached?
0
 
LVL 8

Author Comment

by:isaackhazi
ID: 23620201
What do you mean by ID column. Do you mean PK. Well, i didntr design the database . It was designed by another developer. But the whole problem is that it works OK when its online but in local host i get the errors i mentioned above.
0
 
LVL 20

Assisted Solution

by:informaniac
informaniac earned 1500 total points
ID: 23620280
0
 
LVL 8

Author Comment

by:isaackhazi
ID: 23620614
Yes i did have a look at that but didnt help.
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question