Skip to main content
Participant
October 13, 2011
Question

CFSTOREDPROC Timeout in base.cfc

  • October 13, 2011
  • 1 reply
  • 752 views

Has anyone ever come across the error seen in the attached screenshot?

The error is happening inside base.cfc. The error only happens sometimes, usually it takes a really long time to load but then sometimes it works fine.

Here is the code that is in item.cfc:

11     <cfscript> 

12

13          local.spService = Application.db.sp("spGetItem"); // Custom code to create a stored procedure

14          local.spService.addParam(cfsqltype="cf_sql_integer", value=arguments.ID);

15          local.spService.addParam(cfsqltype="cf_sql_integer", value=arguments.ContactID);

16 

17          local.spService.addProcResult(name="qResult1",resultSet="1");

18          local.spService.addProcResult(name="qResult2",resultSet="2");

19          local.spService.addProcResult(name="qResult3",resultSet="3");

20          local.spService.addProcResult(name="qResul4",resultSet="4");

21          local.result = local.spService.execute();

22          local.returnValue = local.result.GETPROCRESULTSETS();

23 

24     </cfscript>

Any help would be appreciated.

This topic has been closed for replies.

1 reply

Owainnorth
Inspiring
October 13, 2011

I've never seen a cfquery/proc timeout that hasn't just been a basic lock on the database coming from somewhere else. What's your timeout set to in CFAdmin?

Participant
October 13, 2011

60 Seconds.