Forum Orisinil

Kategori Umum => Diskusi Umum => Topic started by: DQCELL RELOAD on January 25, 2016, 04:45:29 PM

Title: MOHON BANTUAN, OTO EROR
Post by: DQCELL RELOAD on January 25, 2016, 04:45:29 PM

MUNGKIN ADA SESEPUH USER OTOMAX YANG BISA BANTU, OTO SAYA ADA KENDALA, SERING KAYAK INI... SEBELUMNYA TRIMS



!21854 SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at   .(DbCommand )
   at   .(String , Object[] )
   at   . ()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

Title: Re: MOHON BANTUAN, OTO EROR
Post by: Andr on January 25, 2016, 06:52:16 PM

Quote from: DQCELL RELOAD on January 25, 2016, 04:45:29 PM

MUNGKIN ADA SESEPUH USER OTOMAX YANG BISA BANTU, OTO SAYA ADA KENDALA, SERING KAYAK INI... SEBELUMNYA TRIMS



!21854 SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.:    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at   .(DbCommand )
   at   .(String , Object[] )
   at   . ()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

masuk SQL run as> database>otomax>tabel> dbo reseler klik kanan open tabel blok data reseler copy ke notpad >seve
dbo pengirim klik kanan open tabel blok data reseler copy ke notpad >seve
dbo komisi  dbo reseler klik kanan open tabel blok data reseler copy ke notpad >seve
setelah itu aman hasil copy 3 notpad tadi ke driver lain /flasdis
mangsudnya instal ulang aja dari awal lagi kembalikan datanya sama seperti mengcopy tadi pastekan ke dbo masing2 semoga membantu ;D insyaalloh seger lagi

Title: Re: MOHON BANTUAN, OTO EROR
Post by: Budi Santoso on January 25, 2016, 06:56:33 PM

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

perlu di ketahui infonya.. itu dikarenakan databasenya berat, sampai time out..

yang perlu dicek
- coba cek resource PC nya
- berapa besar size database, cek fisik filenya
- coba di reindex
- coba di shrink
- applikasi apa aja yang baca database otomax itu

Title: Re: MOHON BANTUAN, OTO EROR
Post by: Muslim Supian on January 25, 2016, 08:03:01 PM

Quote from: Andr on January 25, 2016, 06:52:16 PM

masuk SQL run as> database>otomax>tabel> dbo reseler klik kanan open tabel blok data reseler copy ke notpad >seve
dbo pengirim klik kanan open tabel blok data reseler copy ke notpad >seve
dbo komisi  dbo reseler klik kanan open tabel blok data reseler copy ke notpad >seve
setelah itu aman hasil copy 3 notpad tadi ke driver lain /flasdis
mangsudnya instal ulang aja dari awal lagi kembalikan datanya sama seperti mengcopy tadi pastekan ke dbo masing2 semoga membantu ;D insyaalloh seger lagi

Owhhh... begitu ternyata cara lain nyelamatkan DB yg mau diinstall ulang...
nanti di coba kalau mau sudah ERROR kalau sekarang masih aman2 saja disini..

Thanks Infonya