• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

ASp and MSSQl timeout error

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
isaackhazi
Asked:
isaackhazi
  • 2
  • 2
2 Solutions
 
Obadiah ChristopherCommented:
Have u created any identity column? Is the maximum size of the identity column reached?
0
 
isaackhaziAuthor Commented:
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
 
isaackhaziAuthor Commented:
Yes i did have a look at that but didnt help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now