Forum Orisinil

Kategori Umum => Diskusi Umum => Topic started by: IRG SM@RT on July 16, 2013, 04:38:05 PM

Title: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: IRG SM@RT on July 16, 2013, 04:38:05 PM

Unable to find index entry in index ID 2, of table 341576255, in database 'otomax'. The indicated index is corrupt or there is aproblem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact produk support.
A server error occured on the current on the command. The result, if any, should be discarded

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: aviva arifin on July 16, 2013, 04:56:26 PM

Quote from: pulsa126 on July 16, 2013, 04:38:05 PM

Unable to find index entry in index ID 2, of table 341576255, in database 'otomax'. The indicated index is corrupt or there is aproblem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact produk support.
A server error occured on the current on the command. The result, if any, should be discarded

Terjemahan:
Tidak dapat menemukan entri indeks dalam indeks ID 2, tabel 341.576.255, dalam database 'otomax'. menunjukkan indeks rusak atau ada problem dengan rencana pembaharuan entry terbaru. Jalankan DBCC CHECKDB atau DBCC CHECKTABLE. Jika masalah berlanjut, hubungi dukungan Produk.
Terjadi galat server pada perintah teranyar. Hasilnya, jika ada, harus dibuang

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: arieftheluffy on July 16, 2013, 05:07:07 PM

Quote from: aviva arifin on July 16, 2013, 04:56:26 PM

Terjemahan:
Tidak dapat menemukan entri indeks dalam indeks ID 2, tabel 341.576.255, dalam database 'otomax'. menunjukkan indeks rusak atau ada problem dengan rencana pembaharuan entry terbaru. Jalankan DBCC CHECKDB atau DBCC CHECKTABLE. Jika masalah berlanjut, hubungi dukungan Produk.
Terjadi galat server pada perintah teranyar. Hasilnya, jika ada, harus dibuang

kaya nya harus di re-index nih

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: Ryra Multipay on July 16, 2013, 06:21:14 PM

posting dengan topik sama cukup 1 tempat gan,, ini kok smpe 3 lahan di boikot smua...  ;D

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: IRG SM@RT on July 16, 2013, 10:25:07 PM

TUTORIAL RE-INDEX nya donk????
 :( maklum ane pemula

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: arieftheluffy on July 16, 2013, 10:40:14 PM

Quote from: pulsa126 on July 16, 2013, 10:25:07 PM

TUTORIAL RE-INDEX nya donk????
 :( maklum ane pemula

sya blm pernah re-index DB.
tp tutor nya pernah sya baca di forum ini.   ;D

tanya om busan

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: GR on July 16, 2013, 10:44:02 PM

USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: server_kecil on July 17, 2013, 12:16:15 AM

Copy perintah ini

Quote from: GR on July 16, 2013, 10:44:02 PM

USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

buka Sql server studio
- connect
- kalo udah ter connect klik New Query
- database nya pilih otomax
- paste perintah tadi yang udah di copy ke page sebelah kanan
- lalu klik Execute
- tunggu proses, selesai

CMIIW

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: abe on July 17, 2013, 12:16:33 AM

coba sini >  http://forum.orisinil.com/index.php/topic,4797.0.html

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: 1510Cell on July 17, 2013, 04:49:16 PM

Quote from: GR on July 16, 2013, 10:44:02 PM

USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

Quote from: server_kecil on July 17, 2013, 12:16:15 AM

Copy perintah inibuka Sql server studio
- connect
- kalo udah ter connect klik New Query
- database nya pilih otomax
- paste perintah tadi yang udah di copy ke page sebelah kanan
- lalu klik Execute
- tunggu proses, selesai

CMIIW

lengkap niih tutorialnya  8) 8)

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: Doa_Ibuku on July 18, 2013, 02:07:43 AM

klo msh blm paham, coba pakai yg demo dlu, baru yg resmi, kalo misalnya salah langkah nanti bsa berimbas di lainnya utk defaultnya harus install ulang, karena data recovery msh tersimpan extension .sql berbentuk tabung, bahasa gaulnya fragmentasi.   ;D

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: 1510Cell on July 18, 2013, 03:25:39 PM

betul mas,sebelum pakai yg asli baiknya pahamin dulu gimana kinerja software yg free dan langkah2 seperti apa jika ada problem.. jadi disaat server sudah berjalan setidaknya kita sudah punya bekal jika ada bugs/problem diserver kita..
mudah2an saya gak salah kata mas

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: IRG SM@RT on July 26, 2013, 05:54:12 AM

ten kiyu ya mas bro .... SDH FIX

Title: Re: ERROR === DATA RESELLER TDK DAPAT DIUBAH
Post by: 1510Cell on July 26, 2013, 12:50:00 PM

Quote from: pulsa126 on July 26, 2013, 05:54:12 AM

ten kiyu ya mas bro .... SDH FIX

lanjut gan!!!