Orchard - SQL Server Timeout

Topics: General, Writing modules
Nov 22, 2013 at 5:41 AM
Edited Nov 22, 2013 at 5:49 AM
Hello all ,

I am using orchard 1.7 and building website using Bootstrap theme. I have integrated it very well and created custom module for my requirement.

What that module does is , it is taking data from user and enter those data in database.
FYI : I am using MSSQL server 2012 ....

But when I enter data from admin panel , it gives me error

{"could not execute query\r\n[ SELECT TOP (@p0) this_.Id as Id40_2_, this_.Number as Number40_2_, this_.Published as Published40_2_, this_.Latest as Latest40_2_, this_.Data as Data40_2_, this_.ContentItemRecord_id as ContentI6_40_2_, contentite1_.Id as Id39_0_, contentite1_.Data as Data39_0_, contentite1_.ContentType_id as ContentT3_39_0_, contenttyp4_.Id as Id41_1_, contenttyp4_.Name as Name41_1_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp4_ on contentite1_.ContentType_id=contenttyp4_.Id WHERE contentite1_.Id = @p1 and this_.Latest = @p2 ]\r\n Name:cp0 - Value:65 Name:cp1 - Value:True\r\n[SQL: SELECT TOP (@p0) this_.Id as Id40_2_, this_.Number as Number40_2_, this_.Published as Published40_2_, this_.Latest as Latest40_2_, this_.Data as Data40_2_, this_.ContentItemRecord_id as ContentI6_40_2_, contentite1_.Id as Id39_0_, contentite1_.Data as Data39_0_, contentite1_.ContentType_id as ContentT3_39_0_, contenttyp4_.Id as Id41_1_, contenttyp4_.Name as Name41_1_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id left outer join Orchard_Framework_ContentTypeRecord contenttyp4_ on contentite1_.ContentType_id=contenttyp4_.Id WHERE contentite1_.Id = @p1 and this_.Latest = @p2]"}

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

I am not getting where to debug for it to find where I am going wrong. Let me know if someone has idea regarding it.


Thank You,
Sohil Shah
Coordinator
Nov 25, 2013 at 9:12 AM
Your SQL Server is timing out. First thing to check is that the database server is communicating fast enough with the web server.
Nov 27, 2013 at 8:54 AM
Hello ,

Yes database server is communicating good enough with web server.

Thank you.