A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_URI::$config is deprecated
Filename: core/URI.php
Line Number: 101
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Router::$uri is deprecated
Filename: core/Router.php
Line Number: 127
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$benchmark is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$hooks is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$config is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$log is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$utf8 is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$uri is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$exceptions is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$router is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$output is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$security is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$input is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$lang is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$db is deprecated
Filename: core/Loader.php
Line Number: 396
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_DB_mysqli_driver::$failover is deprecated
Filename: database/DB_driver.php
Line Number: 371
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: Trying to access array offset on true
Filename: libraries/Email.php
Line Number: 978
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$email is deprecated
Filename: core/Loader.php
Line Number: 1283
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::close() should either be compatible with SessionHandlerInterface::close(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 295
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::read($session_id) should either be compatible with SessionHandlerInterface::read(string $id): string|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 169
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::write($session_id, $session_data) should either be compatible with SessionHandlerInterface::write(string $id, string $data): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 238
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::destroy($session_id) should either be compatible with SessionHandlerInterface::destroy(string $id): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 318
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::gc($maxlifetime) should either be compatible with SessionHandlerInterface::gc(int $max_lifetime): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 359
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 282
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_set_cookie_params(): Session cookie parameters cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 289
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 304
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 314
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 315
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 316
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 317
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 375
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_set_save_handler(): Session save handler cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 110
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_start(): Session cannot be started after headers have already been sent
Filename: Session/Session.php
Line Number: 143
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$session is deprecated
Filename: core/Loader.php
Line Number: 1283
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$user_model is deprecated
Filename: core/Loader.php
Line Number: 358
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$load is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$benchmark is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$hooks is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$config is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$log is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$utf8 is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$uri is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$exceptions is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$router is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$output is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$security is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$input is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$lang is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$db is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$email is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$session is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$user_model is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. | Forum Topic - SKML Home Tuitions
When I am calling a stored procedure from asp.net core the following error is coming.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Here is the parameter value is being passed for the execute
'242'
{01/01/2020 00:00:00}
{31/12/2020 00:00:00}
'NA,HO,DO,SI,MA,FU,TI,DE,EX,CO'
But when I execute the same procedure from sqlserver , it is coming very fast. Any idea why it is being showed slow here in asp.net core ? Please any help would be very appreciated.
SqlParameter parEmpID = new SqlParameter("@Employee", employeeIds);
SqlParameter paryearFrom = new SqlParameter("@FromDate", fromDate);
SqlParameter paryearTo= new SqlParameter("@ToDate", toDate);
SqlParameter parType = new SqlParameter("@Attendancetype", attType);
data = _db.AttendanceOverViewModel.FromSql("dbo.goGetEmployeeAttendanceReport @Employee,@FromDate,@ToDate, @Attendancetype",
parEmpID , paryearFrom , paryearTo, parType).ToList();
Not sure whare to join tuition right for you?
Choose the right one for you.
Let`s Connect
PARTH
Looks like you have a query that is taking longer than it should. From your stack trace and your code you should be able to determine exactly what query that is.
This type of timeout can have three causes:
-There's a deadlock somewhere
-The database's statistics and/or query plan cache are incorrect
-The query is too complex and needs to be tuned
A deadlock can be difficult to fix, but it's easy to determine whether that is the case. Connect to your database with Sql Server Management Studio. In the left pane right-click on the server node and select Activity Monitor. Take a look at the running processes. Normally most will be idle or running. When the problem occurs you can identify any blocked process by the process state. If you right-click on the process and select details it'll show you the last query executed by the process.
The second issue will cause the database to use a sub-optimal query plan. It can be resolved by clearing the statistics:
exec sp_updatestats
If that doesn't work you could also try
dbcc freeproccache
You should not do this when your server is under heavy load because it will temporarily incur a big performace hit as all stored procs and queries are recompiled when first executed. However, since you state the issue occurs sometimes, and the stack trace indicates your application is starting up, I think you're running a query that is only run on occasionally. You may be better off by forcing SQL Server not to reuse a previous query plan
For the third issue, you can easily determine whether the query needs tuning by executing the query manually, for example using Sql Server Management Studio. If the query takes too long to complete, even after resetting the statistics you'll probably need to tune it.
PADMAKEECHU
building a dataset is slower then then the display in sql devops. with devops you need to wait to the query has completed (not just when the first screen is filled) to know how long it takes.
you ca also check if the ado version is using the same query plan.