« previous next »
Pages: [1]

Author Topic: MOHON BANTUAN, OTO EROR  (Read 2675 times)

DQCELL RELOAD

  • User OtomaX
  • Newbie
  • *
  • Posts: 35
  • PULSA STANDAR BERKUALITAS
MOHON BANTUAN, OTO EROR
« 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()
Logged
kantor pusat : Jl. Raya Situbondo-Bondowoso, Depan KUA Tenggarang, Bondowoso
TELEGRAM: @cs2_dqcell, TELEGRAM OWNER: @owner_dqcell
Soft : OTOMAX Ultimate (CihR$lKBvw_nTfbP8iLvH3TVF@tKVoUGIzKkcs)+IRS
MOTTO: KEPUASAN PELANGGAN ADALAH PRIORITAS KAMI

Andr

  • User OtomaX
  • Full Member
  • ***
  • Posts: 566
Re: MOHON BANTUAN, OTO EROR
« Reply #1 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
« Last Edit: January 25, 2016, 06:58:20 PM by Andr »
Logged
cs @telegram:sdmg_cell

Budi Santoso

  • Dealer OtomaX
  • Sr. Member
  • ****
  • Posts: 1,996
  • Budi Santoso
Re: MOHON BANTUAN, OTO EROR
« Reply #2 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
Logged
SAFANA Corporation
IT Solution - Online Payment - General Payment


Jam Kerja Fix 07:00 - 22:00 Setiap Hari, Kecuali Hari Minggu (jika hari Minggu urgent bisa kontak via SMS)
Telegram:
@budi_s4n2s0, @owner_safana
WhatsApp:628112886854
Site : http://one.safana.co.id/

Muslim Supian

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 106
Re: MOHON BANTUAN, OTO EROR
« Reply #3 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
Logged
Pages: [1]
« previous next »