Index Server Error MSIDX 0x8004181d... HELP

Mar 13, 2008

p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
span.EmailStyle15
{font-family:'Calibri','sans-serif';color:#1F497D;}
.MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}



I had this query that was working fine before, but suddenly start giving me errors. Anyone can give me an idea where do I look for?

I get the error



p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri','sans-serif';}
.MsoChpDefault
{font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}



[OLE/DB provider returned message: There is no catalog. ]
OLE DB error trace [OLE/DB Provider 'MSIDXS' ICommandText::Execute returned 0x8004181d].
Msg 7320, Level 16, State 2, Line 1Could not execute query against OLE DB provider 'MSIDXS'.


this is the query where BookPDF is a link index server.




Code Snippet

select * from articles INNER JOIN




((SELECT Articles_id as XID,FTBL.Rank from Articles inner join
OpenQuery(BookPDF,'select rank,filename from scope('' "" '')
where contains(contents,'' legal '')') as FTBL on Articles.[book_pdf] like '%' + FTBL.[filename] ) Union (SELECT Articles_id as XID,Keytbl.rank from Articles inner join Containstable(Articles,*,'legal') as KEYTBL on Articles.Articles_id = KEYTBL.[Key] )) as XTBL on Articles.Articles_id = XTBL.XID where (newsletter_name NOT IN(select Newsletters_id from Newsletters where Product IN (23,24)) AND (dont_show_in_search = 0
))
order by issue_date desc

View 1 Replies


ADVERTISEMENT

SQL Server 2014 :: Error - Cannot Create More Than One Clustered Index On Table

Aug 18, 2015

i have created a fact table which has unique cluster index as below,

CREATE UNIQUE CLUSTERED INDEX [FactSales_SalesID] ON [dbo].[FactSales] (salesid ASC)
WITH (DATA_COMPRESSION = PAGE)
GO
however later when i add CLUSTERED COLUMNSTORE INDEXES :
CREATE CLUSTERED COLUMNSTORE INDEX CSI_FactSales
ON dbo.FactSales WITH (DATA_COMPRESSION = COLUMNSTORE)
GO

it prompts error.

Msg 35372, Level 16, State 3, Line 167 You cannot create more than one clustered index on table 'dbo.FactSales'. Consider creating a new clustered index using 'with (drop_existing = on)' option.

View 4 Replies View Related

SQL Server 2014 :: Error On Unique Index - Duplicate Key When Insert / Select

Aug 4, 2014

I have an issue where I am getting an error on an unique index.

I know why I am getting the error but not sure how to get around it.

The query does a check on whether a unique value exists in the Insert/Select. If I run it one record at a time (SELECT TOP 1...) it works fine and just won't update it if the record exists.

But if I do it in a batch, I get the error. I assume this is because it does the checking on the file before records are written out and then writes out the records one at a time from a temporary table.

It thinks all the records are unique because it compares the records one at a time to the original table (where there would be no duplicates). But it doesn't check the records against each other. Then when it actually writes out the record, the duplicate is there.

How do I do a batch where the Insert/Select would write out the records without the duplicates as it does when I do it one record at a time.

CREATE TABLE #TestTable
(
Name varchar(50),
Email varchar (40)
)
Insert #TestTable (Name,Email) Values('Tom', 'tom@aol.com')

[Code] .....

View 1 Replies View Related

Language Error When Creating FULLTEXT INDEX By Using SQL Server 2005 Management Express!

Apr 12, 2007

Hello..
When I used Microsoft SQL Server 2005 Management Studio Express to Create FULL TEXT INDEX by this code:

CREATE FULLTEXT INDEX ON txtfilestbl(txtfile) KEY INDEX PK_txtfilestbl ON ForumsArchiveLibCtlg WITH CHANGE_TRACKING AUTO

It returns this ERR MSG:

Informational: No full-text supported languages found.
Informational: No full-text supported languages found.
Msg 7680, Level 16, State 1, Line 1
Default full-text index language is not a language supported by full-text search.

I Use same this code to create FULL TEXT INDEX by using Microsoft SQL Server 2005 Management Studio, and it was working properly.
What I have to do?

View 2 Replies View Related

Difference Between Index Seek && Index Scan && Index Lookup Operations?

Oct 20, 2006

please explain the differences btween this logical & phisicall operations that we can see therir graphical icons in execution plan tab in Management Studio

thank you in advance

View 3 Replies View Related

SQL Server 2012 :: Failing On Update With Unique Index Error (Not Unique)

Jul 5, 2015

This index is not unique

ix_report_history_creative_id

Msg 2601, Level 14, State 1, Procedure DFP_report_load, Line 161
Cannot insert duplicate key row in object 'dbo.DFP_Reports_History' with unique index 'ix_report_history_creative_id'.

The duplicate key value is (40736326382, 1, 2015-07-03, 67618862, 355324).
Msg 3621, Level 0, State 0, Procedure DFP_report_load, Line 161

The statement has been terminated.

Exception in Task: Cannot insert duplicate key row in object 'dbo.DFP_Reports_History' with unique index 'ix_report_history_creative_id'. The duplicate key value is (40736326382, 1, 2015-07-03, 67618862, 355324).

The statement has been terminated.

View 6 Replies View Related

Error Message With Index

Feb 9, 2001

URGENT!!!!!
I am getting this error and cannot find out what is happening anywhere!!!

Server: Msg 7319, Level 16, State 1, Line 3
OLE DB provider 'SQLOLEDB' returned a 'NON-CLUSTERED and NOT INTEGRATED' index 'account_index' with bookmark ordinal 0.


This is a SQL7 with service pack 3.

Please help me on this issue.



Jim

View 3 Replies View Related

SQL Error When Deleting Index

Jan 6, 2004

Hi.

I have a SQL 2000 database. The table's primary key is set up as a "regular" index and another field is set up as a clustered index. When attempting to delete the index on this other field, I am receiving the following error message:

'tblQuestionAnswer' table
- Unable to delete index 'tblQuestionAnswer1'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]A column has been specified more than once in the order by list. Columns in the order by list must be unique.

I do not understand why I am receiving this message in relation to the deletion of an index. Any ideas?

View 4 Replies View Related

Help Me Please Error Index - Primary Key

Apr 9, 2008

'PXQ_2' table
- Unable to delete index 'PK_PXQ'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]I/O error (bad page ID) detected during read at offset 0x0000000102e000 in file 'D:MSSQL2000MSSQLxxx.mdf'.

I can't drop Primary Key. How to fix this problem?

Hardware(HDD) no error. I test oke?

Please help me.





-= MIB =-

View 7 Replies View Related

Index Fail Error 644

Jan 19, 2006

Guys,
We just got an Error 644 on our DB, the error was:

Could not find the index entry for RID '169bc61301c3950000209e1a0002000000030000' in index page (1:1683508), index ID 0, database 'TR'..

Error: 644, Severity: 21, State: 3

We run dbcc CheckDB on the TR DB with no error:

CHECKDB found 0 allocation errors and 0 consistency errors in database 'TR'.

I read JohnSharp post, and tried the script from Paul:

DBCC CHECKTABLE (sysindexes) WITH NO_INFOMSGS, ALL_ERRORMSGS

it return no erros as well, anyone got any more info on whats this error is?

At the time of this happen, its seems that a process is running, which run some stored proc which will create some temp tables, will that message be relating to some index that created on the tempdb (from the temp tables) rather then the index on the TR DB? Since we can't even tell which table its affected, is there any way to find out?

Thanks.

View 10 Replies View Related

Help, Index Out Of Bounds Error

Sep 7, 2007

Hi,

I really don't know why I'm getting this error! Index was outside the bounds of the array.

I am reading a comma-delimited flat file, line by line. This is part of my script component:


Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim rowValues As String()

rowValues = Row.Line.Split(columnDelimiter) 'parse rows by comma



Row.col1 = rowValues(0).Replace("""", String.Empty)

Row.col2 = rowValues(1).Replace("""", String.Empty)


I've done this quite a few times before in other packages. WHY is it telling me that rowValues(1) is out of bounds?? I've commented out EVERYTHING in my script, except for these 2 rows. If I comment out Row.col2, I don't get the out of bounds error. If I include Row.col2, I get the out of bounds error, so it doesn't like rowValues(1).

The file has 13 columns in it. A row looks like this:

"ATMC","004930202",529.000000,"L",11.380000,6020.020000,7210.270000,6072.920000,"BSZTX","MTPO",,"Equities","My Fund Appreciation","06/30/2006"

Thanks

View 6 Replies View Related

Reorganize Index Error

Jan 7, 2008

Any assistance with this issue would be greatly appreciated. TIA!

Server: DBServer-1
Task Detail: Reorganize index on Local server connection
Databases: dbA,dbB,dbC,dbD,dbE,master,model,msdb



Object: Tables and views
Compact large objects
Error No: -1073548784
Error Message: Executing the query "ALTER INDEX [PK_Residential] ON [dbo].[Residential] REORGANIZE WITH ( LOB_COMPACTION = ON )" failed with the following error: "A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


Windows Server 2003 Standard Edition w/ SP2
SQL Server 2005 Standard Edition (9.0.3054)

View 8 Replies View Related

Error While Droping Unique Index

Apr 4, 2002

Hi,

I get the following error message while droping unique index.

Server: Msg 3723, Level 16, State 5, Line 1
An explicit DROP INDEX is not allowed on index 'dbo.ALEG.IX_ALEG'. It is being used for UNIQUE KEY constraint enforcement.

Could you please how the index can be droped.

Thanks

View 1 Replies View Related

Create Unique Index Error

Jan 11, 2005

Does anybody know the significance of 3 in the following error message?

"CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 3. "

Thank you

View 3 Replies View Related

Index Tuning Wizard Error

May 9, 2006

Hi

When I try to run the ITW to increase performance I get this error in the event viewer. Earlier I have used the ITW with success but now I dont get any more index recommendations, just this error. Do you know what it means :


"The description for Event ID ( 4 ) in Source ( ITW ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event:
Error in Parsing Event:
execute sp_Sys'.

View 3 Replies View Related

SYSINDEXES Index Fail, Error 644

Jan 16, 2006

A few days ago a sproc stopped working, only noticed it this morning, when checking information to see what's up I get this:

Server: Msg 644, Level 21, State 1, Procedure uspV2InventoryFetch, Line 83
Could not find the index entry for RID '45574f44523738313834202020202020202020202020202020202020202020' in index page (1:11690152), index ID 2, database 'ASOS'.

Connection Broken

I've treid DBCC CHECKDBing all related tables and everything else. Even tried dbreindexing a couple of them too, everything reports as correct. When I looked further at the problem I spotted "index ID 2" in there, on checking this out in sysindexes it seems that the name field of sysindexes where id = 2 is SYSINDEXES and TSYSINDEXES.

I can't seem to do a DBB DBRECINDEX against a system table.

Any help appreciated.

John

View 3 Replies View Related

Full Text Index Error

Feb 11, 2008

Hi,

I build some t-sql code to check if full text is installed on the sql server. If not, some sql statements must be not executed. Here is my code:


if (select serverproperty('IsFullTextInstalled')) = 1

Begin


EXEC sp_fulltext_database 'enable'


CREATE FULLTEXT CATALOG [...] WITH ACCENT_SENSITIVITY = OFF AS DEFAULT




CREATE FULLTEXT INDEX ON dbo.Test (Name LANGUAGE 0, Description LANGUAGE 0) KEY INDEX IX_Test_1 ON [...] WITH CHANGE_TRACKING AUTO
ALTER FULLTEXT INDEX ON dbo.Test ENABLE


End


Statement 1 and 2 is not executed, but for statement 3 the server throws the following error:
Full-Text Search is not installed, or a full-text component cannot be loaded.


I don't know why the server tries to execute statement 3, because it is in an if statement.

Any help is welcome.

View 10 Replies View Related

Invalid Descriptor Index Error

Oct 2, 2006

I'm testing db to db transactional replication on a box ( all on the same box ) and the distribution agent fails with the above error. I know it's something to do with the physical server as this test works on other servers fine. SQL2k Ent sp4 on w2k3 ent sp1. ( clustered )

Server and Agent accounts are in local admins, tried push and pull, named and anonymous. Replication also fails if I use the default snapshot location. I suspect policy restrictions ( maybe on the sql service accounts ) Any pointers would be helpful - there are no errors other than above, sadly.

View 12 Replies View Related

SQL 2012 :: Error - Index Was Outside The Bounds Of The Array

Sep 2, 2014

Currently underway with migrating from SQL 2005 to SQL2012. I have loaded all of my SSRS reports into Visual Studio 2010 (SQL Server Data Tools) and they all appeared to upgrade fine. I have 150+ reports and I'm in the middle of recreating a tonne of Subscriptions.

However, I have 4 reports that run fine, execute nicely.... but as soon as I click on 'Subscriptions' I get the index bounds array error.

I could attempt to re-create them. It's only 4 reports after all. But it doesn't answer the question, why would the reports execute fine, but unable to create a subscription?

View 0 Replies View Related

Consistency Error On Merge Table Index

May 30, 2007

I'm getting the following error on our merge contents table in one of our DBs:


Msg 8952, Level 16, State 1, Line 1
Table error: Database 'ks241', index 'MSmerge_contents.nc3MSmerge_contents' (ID 1950682047) (index ID 3). Extra or invalid key for the keys:
Msg 8956, Level 16, State 1, Line 1
Index row (1:1893:42) with values (partchangegen = NULL and tablenick = 17665001 and rowguid = AEAE7256-F571-478E-B2B4-D142B47C38C1) points to the data row identified by ().
Msg 8952, Level 16, State 1, Line 1
Table error: Database 'ks241', index 'MSmerge_contents.nc3MSmerge_contents' (ID 1950682047) (index ID 3). Extra or invalid key for the keys:
Msg 8956, Level 16, State 1, Line 1
Index row (1:1893:66) with values (partchangegen = NULL and tablenick = 17665001 and rowguid = B94F1591-33B0-4625-A269-DB9B8B05BCCE) points to the data row identified by ().
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'MSmerge_contents' (object ID 1950682047).
repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (ks241.dbo.MSmerge_contents ).


There are no other corruption issues on the server that I can find. I do not believe there are any current hardware issues, though I am not on site.

What would be the best way to resolve this? Is recreating or defrag/rebuild the index an option, here? Or can I just run a repair on this? Since it's a merge table, I'm a little gun shy, having limited experience with replication.

Thanks.

____________________________________________________________________________________
"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide

View 4 Replies View Related

Table Error: Object ID XX, Index ID X. Keys

Jan 2, 2008

I have a problem with multiple databases on a server. I originally read another post that went into detail on this same error. After reading the post I decided to re-index the table to see if that would fix my issue. I started on Saturday by re-indexing a table on database 'a' - the process completed after that; I received another error on database 'b' on Monday i subsequently re-indexed all indexes on this database; today I have received the same message on database 'c' and 'd'. All post that I have read seem to point to an issue with only one database and not multiple databases. I have approximately 100 databases on this cluster - SQL 2000. The physical server logs only error shown is '000009ac.00001744::2007/12/29-15:12:58.848 ERR [CP] CppReadCheckpoint unable to copy file U:Disk12Partition1d61e68e-a60f-4ca6-b9ae-df3b893e4bb20000001.CPT to C:DOCUME~1mscsLOCALS~1TempCLS302F.tmp, error 3
000009ac.00001744::2007/12/29-15:12:58.848 ERR [CP] CppReadCheckpoint - Was that due to quorum resource not being up ???
' before corruption of database 'a'.

Here is the entire error if you think it will help. The error has been the same on all databases: 12/28/2007 6:23 AM A possible database consistency problem has been detected on database ‘ substituted_name'. DBCC CHECKDB and DBCC CHECKCATALOG should be run on database 'substituted_name'..

When I run the DBCC CHECKDB command I got these errors on Substite name database:
DBCC results for 'FVD_A'.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 165575628, Index ID 2. Keys out of order on page (1:12743984), slots 97 and 98.
There are 72920059 rows in 2281375 pages for object 'FVD_A'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'FVD_A' (object ID 165575628).
DBCC results for 'FVD_CVS322'.
Msg 2511, Level 16, State 1, Line 1
Table error: Object ID 181575685, Index ID 2. Keys out of order on page (1:7250519), slots 30 and 31.


I am at a loss. I believe we may have a bigger issue, but the SAN Administrator and Server Admin are saying there is nothing they can do. Do I have a true SQL Server issue or something else.

HELP!

View 2 Replies View Related

Merge Replication: Unique Index Error 1505

Mar 23, 2002

We are currently attempting to (Merge) replicate a database between 2 servers; distributor and subscriber. Apparently there are no Primary Keys in the database, and without the input of the developers, we can only assume that data integrity must be maintained by the application and the database is somewhat generic. In any case, what we are experiencing is that when we attempt to replicate, and you may know, you need PKs. Without any, SQL Server has utilized it's own (Row GUIDs). The Snapshot worked fine, but the merge agent reports error 1505.

The error is "CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID %d. Most significant primary key is '%S_KEY'."

The fix and workaround are SP2 and deselecting Unique in the index propoerties of the index raising the error. We already had SP2 on the system. Tried the other and still the same issue occurs.

Microsoft's Knowledgebase has nothing. Any suggestions or fixes would be greatly appreciated.

Regards,
Alex Cohen (MCSE, MCDBA, MCT)

View 1 Replies View Related

Fulltext Index Error With Query Word BARBE

Jul 30, 2007

For demonstration I created a fulltext index on table employee in Northwind database.

The following query gives an error:

SELECT * FROM employees
WHERE CONTAINS (FirstName, 'Barbe')

Replacing 'Barbe' by 'Barb' or other words it works fine.

The error message is (I have a french version of SQL installed, here the translation: "A clause in the query contains only ignored words"
Une clause de la requête ne contient que des mots ignorés)

Language for wordbreak in fulltext index is French and the error happens only with French, with English it works.

Is this a Microsoft bug?

View 1 Replies View Related

Package Migration Wizard Error -- Index Was Out Of Range

Nov 10, 2005

I am unable to migrate any DTS packages, from a SQL Server 2000 package, from a structured storage file, or from a DTS package imported into SQL2005 (Developer Edition, 32 bit).  Running the Package Migration Wizard, every time I get to the List Package screen, i get the error below.  I haven't found any other mention of this so far.  Anyone else seen this error or have suggestions?

View 20 Replies View Related

SQL 2005 Index Issue – General Network Error

Jan 2, 2007

Info: CE.Net 4.2
CF 2
SQL Server 2005

First of all, sorry for the cross post but i need a quick answer on this.

I am executing a CLR Stored Procedure from a Windows Mobile device and regularly get a general network error.

The stored procedure cycles through up to 70 tables, checking for any records between two dates. The LastUpdate field is in each one of the 70 tables and is indexed.

The mobile device regularly reports general network error, which is due to a timeout. Command timeout is now set to 10 minutes but the timeout still occurs.

The stored procedure appears to get stuck on a particular table. If I rebuild the index on this table, it will get past it but then get stuck on the next table.

I set up a maintenance plan to run every 5 minutes (extreme, I know!) but the indices would appear to corrupt (without any activity on the table) in less than this interval.

However, running the exact same query from SQL Server Management Studio works correctly every time and usually within 10 seconds.

I€™m sure that it has something to do with the indices but cannot seem to resolve the issue. It€™s even more confusing how only the mobile device is affected!

Any help or advice would be greatly appreciated.

View 3 Replies View Related

An Error Occurred During Local Report Processing. Index Was Outside The Bounds Of The Array.

Oct 29, 2007

I got rid of the .rdl.data files, which apparently has been a successful fix for this problem in the past. Everything worked fine Thursday when I left (I was off Friday - Saturday), but today I get this error for all but one of the reports in the solution when I try to preview the report. BTW, the published stuff works fine. Thanks in advance for any help.

View 6 Replies View Related

Error 644 - Index Error

Aug 4, 2006

We have encountered this error and we need help tp be resolved. Please view the following result after running DBCC CHECKDB :

DBCC results for 'KOTRA_App'.
DBCC results for 'sysobjects'.
There are 22423 rows in 349 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 5895 rows in 316 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 55026 rows in 1087 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 1357 rows in 22 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 32250 rows in 14096 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 50 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 12 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 813 rows in 9 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 127027 rows in 792 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 1426 rows in 10 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'unitcd3'.
There are 0 rows in 0 pages for object 'unitcd3'.
DBCC results for 'RESATTR000'.
There are 0 rows in 0 pages for object 'RESATTR000'.
DBCC results for 'site_compression'.
There are 0 rows in 0 pages for object 'site_compression'.
DBCC results for 'APPCFG'.
There are 1 rows in 1 pages for object 'APPCFG'.
DBCC results for 'org_cpny'.
There are 0 rows in 0 pages for object 'org_cpny'.
DBCC results for 'experience'.
There are 0 rows in 0 pages for object 'experience'.
DBCC results for 'commdue_all'.
There are 0 rows in 0 pages for object 'commdue_all'.
DBCC results for 'unitcd3_all'.
There are 0 rows in 0 pages for object 'unitcd3_all'.
DBCC results for 'RESLOAD000'.
There are 0 rows in 0 pages for object 'RESLOAD000'.
DBCC results for 'site_group'.
There are 1 rows in 1 pages for object 'site_group'.
DBCC results for 'APPSTRING'.
There are 0 rows in 0 pages for object 'APPSTRING'.
DBCC results for 'parms'.
There are 1 rows in 1 pages for object 'parms'.
DBCC results for 'export_aptrx'.
There are 0 rows in 0 pages for object 'export_aptrx'.
DBCC results for 'commodity'.
There are 0 rows in 0 pages for object 'commodity'.
DBCC results for 'unitcd4'.
There are 0 rows in 0 pages for object 'unitcd4'.
DBCC results for 'RESMNT000'.
There are 0 rows in 0 pages for object 'RESMNT000'.
DBCC results for 'site_hierarchy'.
There are 1 rows in 1 pages for object 'site_hierarchy'.
DBCC results for 'APPSTRLIST'.
There are 0 rows in 0 pages for object 'APPSTRLIST'.
DBCC results for 'parms_all'.
There are 1 rows in 1 pages for object 'parms_all'.
DBCC results for 'export_aptrxd'.
There are 0 rows in 0 pages for object 'export_aptrxd'.
DBCC results for 'commtab'.
There are 0 rows in 0 pages for object 'commtab'.
DBCC results for 'unitcd4_all'.
There are 0 rows in 0 pages for object 'unitcd4_all'.
DBCC results for 'RESPAIR000'.
There are 0 rows in 0 pages for object 'RESPAIR000'.
DBCC results for 'tmp_aps_sync'.
There are 16391 rows in 326 pages for object 'tmp_aps_sync'.
DBCC results for 'site_link_info'.
There are 0 rows in 0 pages for object 'site_link_info'.
DBCC results for 'APSSITE'.
There are 0 rows in 0 pages for object 'APSSITE'.
DBCC results for 'pck_hdr'.
There are 0 rows in 0 pages for object 'pck_hdr'.
DBCC results for 'export_arinv'.
There are 0 rows in 0 pages for object 'export_arinv'.
DBCC results for 'commtran'.
There are 0 rows in 0 pages for object 'commtran'.
DBCC results for 'user_class'.
There are 1 rows in 1 pages for object 'user_class'.
DBCC results for 'RESPLAN000'.
There are 0 rows in 0 pages for object 'RESPLAN000'.
DBCC results for 'site_live_link'.
There are 0 rows in 0 pages for object 'site_live_link'.
DBCC results for 'ATTRIB000'.
There are 0 rows in 0 pages for object 'ATTRIB000'.
DBCC results for 'pckitem'.
There are 0 rows in 0 pages for object 'pckitem'.
DBCC results for 'export_arinvd'.
There are 0 rows in 0 pages for object 'export_arinvd'.
DBCC results for 'con_inv_hdr'.
There are 0 rows in 0 pages for object 'con_inv_hdr'.
DBCC results for 'user_class_committed'.
There are 0 rows in 0 pages for object 'user_class_committed'.
DBCC results for 'RESQ000'.
There are 0 rows in 0 pages for object 'RESQ000'.
DBCC results for 'sitenet'.
There are 0 rows in 0 pages for object 'sitenet'.
DBCC results for 'AccountAuthorizations'.
There are 5893 rows in 138 pages for object 'AccountAuthorizations'.
DBCC results for 'per_sort'.
There are 0 rows in 0 pages for object 'per_sort'.
DBCC results for 'extfin_parms'.
There are 1 rows in 1 pages for object 'extfin_parms'.
DBCC results for 'con_inv_item'.
There are 0 rows in 0 pages for object 'con_inv_item'.
DBCC results for 'user_class_fld'.
There are 1 rows in 1 pages for object 'user_class_fld'.
DBCC results for 'RESRC000'.
There are 116 rows in 7 pages for object 'RESRC000'.
DBCC results for 'skill'.
There are 0 rows in 0 pages for object 'skill'.
DBCC results for 'ActiveBGTasks'.
There are 0 rows in 0 pages for object 'ActiveBGTasks'.
DBCC results for 'per_sort_all'.
There are 0 rows in 0 pages for object 'per_sort_all'.
DBCC results for 'fabonus'.
There are 0 rows in 0 pages for object 'fabonus'.
DBCC results for 'con_inv_line'.
There are 0 rows in 0 pages for object 'con_inv_line'.
DBCC results for 'user_class_fld_committed'.
There are 0 rows in 0 pages for object 'user_class_fld_committed'.
DBCC results for 'RESSCHD000'.
There are 0 rows in 0 pages for object 'RESSCHD000'.
DBCC results for 'slparms'.
There are 0 rows in 0 pages for object 'slparms'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (1:92560) allocated to object ID 133575514, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 133575514, index ID 1. Page (1:92560) was not seen in the scan although its parent (1:140572) and previous (1:92407) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 133575514, index ID 1. Page (1:92561) is missing a reference from previous page (1:92560). Possible chain linkage problem.
DBCC results for 'tmp_jobmatl_copy'.
There are 0 rows in 0 pages for object 'tmp_jobmatl_copy'.
DBCC results for 'ApplicationMessages'.
There are 4072 rows in 66 pages for object 'ApplicationMessages'.
DBCC results for 'per_unit'.
There are 0 rows in 0 pages for object 'per_unit'.
DBCC results for 'faclass'.
There are 13 rows in 1 pages for object 'faclass'.
DBCC results for 'coparms'.
There are 1 rows in 1 pages for object 'coparms'.
DBCC results for 'user_class_fld_impacted'.
There are 0 rows in 0 pages for object 'user_class_fld_impacted'.
DBCC results for 'RESSEND000'.
There are 0 rows in 0 pages for object 'RESSEND000'.
DBCC results for 'slsclass'.
There are 7 rows in 1 pages for object 'slsclass'.
DBCC results for 'AuditLog'.
There are 978910 rows in 24693 pages for object 'AuditLog'.
CHECKDB found 0 allocation errors and 3 consistency errors in table 'AuditLog' (object ID 133575514).
DBCC results for 'per_unit_all'.
There are 0 rows in 0 pages for object 'per_unit_all'.
DBCC results for 'facost'.
There are 224 rows in 4 pages for object 'facost'.
DBCC results for 'coparms_all'.
There are 1 rows in 1 pages for object 'coparms_all'.
DBCC results for 'user_class_impacted'.
There are 0 rows in 0 pages for object 'user_class_impacted'.
DBCC results for 'RESSUM000'.
There are 0 rows in 0 pages for object 'RESSUM000'.
DBCC results for 'slsman'.
There are 352 rows in 15 pages for object 'slsman'.
DBCC results for 'AuditLogTypes'.
There are 472 rows in 7 pages for object 'AuditLogTypes'.
DBCC results for 'periods'.
There are 10 rows in 1 pages for object 'periods'.
DBCC results for 'fadepr'.
There are 227 rows in 6 pages for object 'fadepr'.
DBCC results for 'costcode'.
There are 0 rows in 0 pages for object 'costcode'.
DBCC results for 'user_class_record_assoc'.
There are 0 rows in 0 pages for object 'user_class_record_assoc'.
DBCC results for 'RGATTR000'.
There are 0 rows in 0 pages for object 'RGATTR000'.
DBCC results for 'slsman_all'.
There are 352 rows in 6 pages for object 'slsman_all'.
DBCC results for 'BATCH000'.
There are 0 rows in 0 pages for object 'BATCH000'.
DBCC results for 'periods_all'.
There are 10 rows in 1 pages for object 'periods_all'.
DBCC results for 'fadeptab'.
There are 1 rows in 1 pages for object 'fadeptab'.
DBCC results for 'country'.
There are 25 rows in 1 pages for object 'country'.
DBCC results for 'user_fld'.
There are 1 rows in 1 pages for object 'user_fld'.
DBCC results for 'RGLOAD000'.
There are 0 rows in 0 pages for object 'RGLOAD000'.
DBCC results for 'ssd'.
There are 0 rows in 0 pages for object 'ssd'.
DBCC results for 'BATRL000'.
There are 0 rows in 0 pages for object 'BATRL000'.
DBCC results for 'periods_seq'.
There are 70 rows in 3 pages for object 'periods_seq'.
DBCC results for 'fadisp'.
There are 0 rows in 0 pages for object 'fadisp'.
DBCC results for 'country_all'.
There are 25 rows in 1 pages for object 'country_all'.
DBCC results for 'user_fld_committed'.
There are 0 rows in 0 pages for object 'user_fld_committed'.
DBCC results for 'RGRP000'.
There are 53 rows in 1 pages for object 'RGRP000'.
DBCC results for 'state'.
There are 16 rows in 1 pages for object 'state'.
DBCC results for 'BATSUM000'.
There are 0 rows in 0 pages for object 'BATSUM000'.
DBCC results for 'pertot'.
There are 0 rows in 0 pages for object 'pertot'.
DBCC results for 'fadist'.
There are 0 rows in 0 pages for object 'fadist'.
DBCC results for 'course'.
There are 0 rows in 0 pages for object 'course'.
DBCC results for 'user_fld_impacted'.
There are 0 rows in 0 pages for object 'user_fld_impacted'.
DBCC results for 'RGRPMBR000'.
There are 116 rows in 2 pages for object 'RGRPMBR000'.
DBCC results for 'sup_edi_parms'.
There are 0 rows in 0 pages for object 'sup_edi_parms'.
DBCC results for 'BATTIME000'.
There are 0 rows in 0 pages for object 'BATTIME000'.
DBCC results for 'pertot_all'.
There are 0 rows in 0 pages for object 'pertot_all'.
DBCC results for 'famaster'.
There are 224 rows in 10 pages for object 'famaster'.
DBCC results for 'ctc_log'.
There are 0 rows in 0 pages for object 'ctc_log'.
DBCC results for 'user_index'.
There are 1 rows in 1 pages for object 'user_index'.
DBCC results for 'RGRPSUM000'.
There are 0 rows in 0 pages for object 'RGRPSUM000'.
DBCC results for 'system_type'.
There are 11 rows in 1 pages for object 'system_type'.
DBCC results for 'artranTemp'.
There are 0 rows in 0 pages for object 'artranTemp'.
DBCC results for 'BATWAIT000'.
There are 0 rows in 0 pages for object 'BATWAIT000'.
DBCC results for 'phyinv'.
There are 0 rows in 0 pages for object 'phyinv'.
DBCC results for 'famcode'.
There are 0 rows in 0 pages for object 'famcode'.
DBCC results for 'curr_uk'.
There are 0 rows in 0 pages for object 'curr_uk'.
DBCC results for 'user_index_committed'.
There are 0 rows in 0 pages for object 'user_index_committed'.
DBCC results for 'ReplicatedRows3'.
There are 0 rows in 0 pages for object 'ReplicatedRows3'.
DBCC results for 'table_class'.
There are 374 rows in 21 pages for object 'table_class'.
DBCC results for 'BGTaskDefinitions'.
There are 536 rows in 20 pages for object 'BGTaskDefinitions'.
DBCC results for 'phytags'.
There are 5 rows in 1 pages for object 'phytags'.
DBCC results for 'faparms'.
There are 1 rows in 1 pages for object 'faparms'.
DBCC results for 'curr_uk_all'.
There are 0 rows in 0 pages for object 'curr_uk_all'.
DBCC results for 'user_index_fld'.
There are 1 rows in 1 pages for object 'user_index_fld'.
DBCC results for 'ReplicatedRowsErrors'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'BGTaskHistory' (ID 261575970). Missing or invalid key in index 'IX_BGTaskHistory_RowPointer' (ID 3) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:89662:11) identified by (RID = (1:89662:11) ) has index values (RowPointer = A41369EA-8888-493C-8B7A-F47922383FA6h¢¿).
There are 0 rows in 0 pages for object 'ReplicatedRowsErrors'.
DBCC results for 'table_class_committed'.
There are 0 rows in 0 pages for object 'table_class_committed'.
DBCC results for 'BGTaskHistory'.
There are 144344 rows in 19374 pages for object 'BGTaskHistory'.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'BGTaskHistory' (object ID 261575970).
DBCC results for 'pitemh'.
There are 934 rows in 77 pages for object 'pitemh'.
DBCC results for 'fatran'.
There are 0 rows in 0 pages for object 'fatran'.
DBCC results for 'curracct'.
There are 4 rows in 1 pages for object 'curracct'.
DBCC results for 'user_index_fld_committed'.
There are 0 rows in 0 pages for object 'user_index_fld_committed'.
DBCC results for 'ReplicationOperationCounter'.
There are 0 rows in 0 pages for object 'ReplicationOperationCounter'.
DBCC results for 'table_class_impacted'.
There are 0 rows in 0 pages for object 'table_class_impacted'.
DBCC results for 'BOM000'.
There are 1630 rows in 245 pages for object 'BOM000'.
DBCC results for 'plan_ra'.
There are 0 rows in 0 pages for object 'plan_ra'.
DBCC results for 'featqty'.
There are 0 rows in 0 pages for object 'featqty'.
DBCC results for 'curracct_all'.
There are 4 rows in 1 pages for object 'curracct_all'.
DBCC results for 'user_index_fld_impacted'.
There are 0 rows in 0 pages for object 'user_index_fld_impacted'.
DBCC results for 'ReportOptions'.
There are 106 rows in 2 pages for object 'ReportOptions'.
DBCC results for 'tax_item_jur'.
There are 0 rows in 0 pages for object 'tax_item_jur'.
DBCC results for 'CAL000'.
There are 10 rows in 1 pages for object 'CAL000'.
DBCC results for 'po'.
There are 6203 rows in 618 pages for object 'po'.
DBCC results for 'featqty_all'.
There are 0 rows in 0 pages for object 'featqty_all'.
DBCC results for 'currate'.
There are 219 rows in 4 pages for object 'currate'.
DBCC results for 'user_index_impacted'.
There are 0 rows in 0 pages for object 'user_index_impacted'.
DBCC results for 'ReusableNotesToSite'.
There are 0 rows in 0 pages for object 'ReusableNotesToSite'.
DBCC results for 'tax_item_jur_all'.
There are 0 rows in 0 pages for object 'tax_item_jur_all'.
DBCC results for 'ClassNotes'.
There are 0 rows in 0 pages for object 'ClassNotes'.
DBCC results for 'po_all'.
There are 6203 rows in 83 pages for object 'po_all'.
DBCC results for 'featrank'.
There are 0 rows in 0 pages for object 'featrank'.
DBCC results for 'currate_all'.
There are 219 rows in 4 pages for object 'currate_all'.
DBCC results for 'user_local'.
There are 53 rows in 1 pages for object 'user_local'.
DBCC results for 'SCHEDOP000'.
There are 0 rows in 0 pages for object 'SCHEDOP000'.
DBCC results for 'tax_jur'.
There are 1 rows in 1 pages for object 'tax_jur'.
DBCC results for 'ConnectionInformation'.
There are 5 rows in 4 pages for object 'ConnectionInformation'.
DBCC results for 'po_bln'.
There are 1 rows in 1 pages for object 'po_bln'.
DBCC results for 'featrank_all'.
There are 0 rows in 0 pages for object 'featrank_all'.
DBCC results for 'currency'.
There are 12 rows in 1 pages for object 'currency'.
DBCC results for 'vacation'.
There are 0 rows in 0 pages for object 'vacation'.
DBCC results for 'SHIFT000'.
There are 11 rows in 1 pages for object 'SHIFT000'.
DBCC results for 'tax_jur_all'.
There are 1 rows in 1 pages for object 'tax_jur_all'.
DBCC results for 'DOWN000'.
There are 0 rows in 0 pages for object 'DOWN000'.
DBCC results for 'po_bln_all'.
There are 1 rows in 1 pages for object 'po_bln_all'.
DBCC results for 'feature'.
There are 0 rows in 0 pages for object 'feature'.
DBCC results for 'currency_all'.
There are 12 rows in 1 pages for object 'currency_all'.
DBCC results for 'vacparms'.
There are 0 rows in 0 pages for object 'vacparms'.
DBCC results for 'SHIFTEXDI000'.
There are 0 rows in 0 pages for object 'SHIFTEXDI000'.
DBCC results for 'tax_system'.
There are 1 rows in 1 pages for object 'tax_system'.
DBCC results for 'DOWNPLAN000'.
There are 0 rows in 0 pages for object 'DOWNPLAN000'.
DBCC results for 'po_lang'.
There are 0 rows in 0 pages for object 'po_lang'.
DBCC results for 'feature_all'.
There are 0 rows in 0 pages for object 'feature_all'.
DBCC results for 'currparms'.
There are 1 rows in 1 pages for object 'currparms'.
DBCC results for 'vch_dist'.
There are 34807 rows in 776 pages for object 'vch_dist'.
DBCC results for 'SampleTable_1'.
There are 0 rows in 0 pages for object 'SampleTable_1'.
DBCC results for 'tax_system_all'.
There are 1 rows in 1 pages for object 'tax_system_all'.
DBCC results for 'DefaultTypes'.
There are 4 rows in 1 pages for object 'DefaultTypes'.
DBCC results for 'po_rcpt'.
There are 16536 rows in 550 pages for object 'po_rcpt'.
DBCC results for 'fingroup'.
There are 0 rows in 0 pages for object 'fingroup'.
DBCC results for 'currparms_all'.
There are 1 rows in 1 pages for object 'currparms_all'.
DBCC results for 'vch_hdr'.
There are 32755 rows in 1291 pages for object 'vch_hdr'.
DBCC results for 'SessionContextNames'.
There are 116 rows in 3 pages for object 'SessionContextNames'.
DBCC results for 'taxcode'.
There are 1 rows in 1 pages for object 'taxcode'.
DBCC results for 'DefineVariables'.
There are 61 rows in 6 pages for object 'DefineVariables'.
DBCC results for 'po_vch'.
There are 36187 rows in 889 pages for object 'po_vch'.
DBCC results for 'forecast'.
There are 0 rows in 1 pages for object 'forecast'.
DBCC results for 'cust_lcr'.
There are 0 rows in 0 pages for object 'cust_lcr'.
DBCC results for 'vch_hdr_all'.
There are 32755 rows in 718 pages for object 'vch_hdr_all'.
DBCC results for 'ShadowValues'.
There are 0 rows in 0 pages for object 'ShadowValues'.
DBCC results for 'taxcode_all'.
There are 1 rows in 1 pages for object 'taxcode_all'.
DBCC results for 'DocProfileCustomer'.
There are 0 rows in 0 pages for object 'DocProfileCustomer'.
DBCC results for 'poblnchg'.
There are 0 rows in 0 pages for object 'poblnchg'.
DBCC results for 'frzcost'.
There are 888 rows in 41 pages for object 'frzcost'.
DBCC results for 'cust_lcr_all'.
There are 0 rows in 0 pages for object 'cust_lcr_all'.
DBCC results for 'vch_item'.
There are 15979 rows in 418 pages for object 'vch_item'.
DBCC results for 'ShadowValuesErrors'.
There are 0 rows in 0 pages for object 'ShadowValuesErrors'.
DBCC results for 'taxparms'.
There are 1 rows in 1 pages for object 'taxparms'.
DBCC results for 'DocProfileVendor'.
There are 0 rows in 0 pages for object 'DocProfileVendor'.
DBCC results for 'poblnh'.
There are 0 rows in 0 pages for object 'poblnh'.
DBCC results for 'glbank'.
There are 9743 rows in 213 pages for object 'glbank'.
DBCC results for 'cust_tp'.
There are 0 rows in 0 pages for object 'cust_tp'.
DBCC results for 'vch_item_all'.
There are 15979 rows in 306 pages for object 'vch_item_all'.
DBCC results for 'SiteUserMap'.
There are 0 rows in 0 pages for object 'SiteUserMap'.
DBCC results for 'taxparms_all'.
There are 1 rows in 1 pages for object 'taxparms_all'.
DBCC results for 'EFFECT000'.
There are 5010 rows in 251 pages for object 'EFFECT000'.
DBCC results for 'pochange'.
There are 2906 rows in 57 pages for object 'pochange'.
DBCC results for 'glrpth'.
There are 0 rows in 1 pages for object 'glrpth'.
DBCC results for 'custaddr'.
There are 7094 rows in 524 pages for object 'custaddr'.
DBCC results for 'vch_pr'.
There are 0 rows in 0 pages for object 'vch_pr'.
DBCC results for 'SpecificNotes'.
There are 703271 rows in 8916 pages for object 'SpecificNotes'.
DBCC results for 'term_lang'.
There are 0 rows in 0 pages for object 'term_lang'.
DBCC results for 'ERDB'.
There are 0 rows in 0 pages for object 'ERDB'.
DBCC results for 'pochg'.
There are 130 rows in 14 pages for object 'pochg'.
DBCC results for 'glrpthc'.
There are 0 rows in 1 pages for object 'glrpthc'.
DBCC results for 'custdrft'.
There are 0 rows in 0 pages for object 'custdrft'.
DBCC results for 'vch_pr_all'.
There are 0 rows in 0 pages for object 'vch_pr_all'.
DBCC results for 'SystemNotes'.
There are 1 rows in 1 pages for object 'SystemNotes'.
DBCC results for 'termination'.
There are 0 rows in 0 pages for object 'termination'.
DBCC results for 'slsmanTemp'.
There are 252 rows in 6 pages for object 'slsmanTemp'.
DBCC results for 'ERDBGW'.
There are 0 rows in 0 pages for object 'ERDBGW'.
DBCC results for 'poh'.
There are 480 rows in 47 pages for object 'poh'.
DBCC results for 'glrptl'.
There are 0 rows in 1 pages for object 'glrptl'.
DBCC results for 'custdrft_all'.
There are 0 rows in 0 pages for object 'custdrft_all'.
DBCC results for 'vch_pr_stax'.
There are 0 rows in 0 pages for object 'vch_pr_stax'.
DBCC results for 'SystemProcessDefaults'.
There are 4 rows in 1 pages for object 'SystemProcessDefaults'.
DBCC results for 'terms'.
There are 17 rows in 1 pages for object 'terms'.
DBCC results for 'ERRORLOG'.
There are 0 rows in 0 pages for object 'ERRORLOG'.
DBCC results for 'poitem'.
There are 13098 rows in 1030 pages for object 'poitem'.
DBCC results for 'glrptl_all'.
There are 0 rows in 1 pages for object 'glrptl_all'.
DBCC results for 'custlog'.
There are 1 rows in 1 pages for object 'custlog'.
DBCC results for 'vch_pr_stax_all'.
There are 0 rows in 0 pages for object 'vch_pr_stax_all'.
DBCC results for 'TBLLIST000'.
There are 0 rows in 0 pages for object 'TBLLIST000'.
DBCC results for 'terms_all'.
There are 17 rows in 1 pages for object 'terms_all'.
DBCC results for 'FDBVER'.
There are 1 rows in 1 pages for object 'FDBVER'.
DBCC results for 'poitem_all'.
There are 13098 rows in 236 pages for object 'poitem_all'.
DBCC results for 'glrptlc'.
There are 0 rows in 1 pages for object 'glrptlc'.
DBCC results for 'customer'.
There are 7094 rows in 842 pages for object 'customer'.
DBCC results for 'vch_stax'.
There are 0 rows in 0 pages for object 'vch_stax'.
DBCC results for 'TODEMAND000'.
There are 0 rows in 0 pages for object 'TODEMAND000'.
DBCC results for 'tick_cal'.
There are 330 rows in 35 pages for object 'tick_cal'.
DBCC results for 'FIELDS'.
There are 1151 rows in 16 pages for object 'FIELDS'.
DBCC results for 'poitmchg'.
There are 10264 rows in 749 pages for object 'poitmchg'.
DBCC results for 'glrptls'.
There are 0 rows in 1 pages for object 'glrptls'.
DBCC results for 'customer_all'.
There are 7094 rows in 368 pages for object 'customer_all'.
DBCC results for 'vch_stax_all'.
There are 0 rows in 0 pages for object 'vch_stax_all'.
DBCC results for 'TOODP000'.
There are 0 rows in 0 pages for object 'TOODP000'.
DBCC results for 'time_zone'.
There are 88 rows in 2 pages for object 'time_zone'.
DBCC results for 'GNTHLCAT'.
There are 0 rows in 0 pages for object 'GNTHLCAT'.
DBCC results for 'poparms'.
There are 1 rows in 1 pages for object 'poparms'.
DBCC results for 'grn_hdr'.
There are 1 rows in 1 pages for object 'grn_hdr'.
DBCC results for 'custtype'.
There are 24 rows in 1 pages for object 'custtype'.
DBCC results for 'vend_lcr'.
There are 0 rows in 0 pages for object 'vend_lcr'.
DBCC results for 'TOSUPPLY000'.
There are 0 rows in 0 pages for object 'TOSUPPLY000'.
DBCC results for 'timeatt'.
There are 0 rows in 0 pages for object 'timeatt'.
DBCC results for 'GNTHLCRIT'.
There are 0 rows in 0 pages for object 'GNTHLCRIT'.
DBCC results for 'pos_chg'.
There are 0 rows in 0 pages for object 'pos_chg'.
DBCC results for 'grn_line'.
There are 1 rows in 1 pages for object 'grn_line'.
DBCC results for 'custtype_all'.
There are 24 rows in 1 pages for object 'custtype_all'.
DBCC results for 'vend_tp'.
There are 0 rows in 0 pages for object 'vend_tp'.
DBCC results for 'TRACELOG000'.
There are 0 rows in 0 pages for object 'TRACELOG000'.
DBCC results for 'tmp_MessageBuffer'.
There are 0 rows in 0 pages for object 'tmp_MessageBuffer'.
DBCC results for 'GNTSELCAT'.
There are 0 rows in 0 pages for object 'GNTSELCAT'.
DBCC results for 'pos_class'.
There are 0 rows in 0 pages for object 'pos_class'.
DBCC results for 'horizon'.
There are 0 rows in 0 pages for object 'horizon'.
DBCC results for 'cycle'.
There are 0 rows in 1 pages for object 'cycle'.
DBCC results for 'vendaddr'.
There are 814 rows in 56 pages for object 'vendaddr'.
DBCC results for 'TaskExclusion'.
There are 0 rows in 0 pages for object 'TaskExclusion'.
DBCC results for 'tmp_apdraftt'.
There are 0 rows in 0 pages for object 'tmp_apdraftt'.
DBCC results for 'GNTSELMBR'.
There are 0 rows in 0 pages for object 'GNTSELMBR'.
DBCC results for 'pos_det'.
There are 0 rows in 0 pages for object 'pos_det'.
DBCC results for 'hrparms'.
There are 1 rows in 1 pages for object 'hrparms'.
DBCC results for 'dcco'.
There are 0 rows in 0 pages for object 'dcco'.
DBCC results for 'vendcat'.
There are 19 rows in 1 pages for object 'vendcat'.
DBCC results for 'TaskTypes'.
There are 0 rows in 0 pages for object 'TaskTypes'.
DBCC results for 'tmp_appmt'.
There are 0 rows in 0 pages for object 'tmp_appmt'.
DBCC results for 'GroupNames'.
There are 109 rows in 2 pages for object 'GroupNames'.
DBCC results for 'pos_rqmt'.
There are 0 rows in 0 pages for object 'pos_rqmt'.
DBCC results for 'hrstep'.
There are 0 rows in 0 pages for object 'hrstep'.
DBCC results for 'dcco_serial'.
There are 0 rows in 0 pages for object 'dcco_serial'.
DBCC results for 'vendlog'.
There are 0 rows in 0 pages for object 'vendlog'.
DBCC results for 'TrackRows'.
There are 61 rows in 5 pages for object 'TrackRows'.
DBCC results for 'tmp_appmtd'.
There are 0 rows in 0 pages for object 'tmp_appmtd'.
DBCC results for 'INVPLAN000'.
There are 0 rows in 0 pages for object 'INVPLAN000'.
DBCC results for 'position'.
There are 0 rows in 0 pages for object 'position'.
DBCC results for 'i9doc'.
There are 0 rows in 0 pages for object 'i9doc'.
DBCC results for 'dcitem'.
There are 0 rows in 0 pages for object 'dcitem'.
DBCC results for 'vendor'.
There are 814 rows in 61 pages for object 'vendor'.
DBCC results for 'UserDefinedFields'.
There are 1329 rows in 667 pages for object 'UserDefinedFields'.
DBCC results for 'tmp_ardraftt'.
There are 0 rows in 0 pages for object 'tmp_ardraftt'.
DBCC results for 'JOB000'.
There are 0 rows in 0 pages for object 'JOB000'.
DBCC results for 'pr_comm'.
There are 0 rows in 0 pages for object 'pr_comm'.
DBCC results for 'indcode'.
There are 0 rows in 0 pages for object 'indcode'.
DBCC results for 'dcitem_serial'.
There are 0 rows in 0 pages for object 'dcitem_serial'.
DBCC results for 'vendor_all'.
There are 814 rows in 27 pages for object 'vendor_all'.
DBCC results for 'UserDefinedTypeValues'.
There are 0 rows in 0 pages for object 'UserDefinedTypeValues'.
DBCC results for 'tmp_arfin'.
There are 0 rows in 0 pages for object 'tmp_arfin'.
DBCC results for 'tmp_co_job'.
There are 0 rows in 0 pages for object 'tmp_co_job'.
DBCC results for 'JOBLNKS000'.
There are 0 rows in 0 pages for object 'JOBLNKS000'.
DBCC results for 'prbank'.
There are 0 rows in 0 pages for object 'prbank'.
DBCC results for 'ins_age'.
There are 0 rows in 0 pages for object 'ins_age'.
DBCC results for 'dcjit'.
There are 0 rows in 0 pages for object 'dcjit'.
DBCC results for 'vendtype'.
There are 0 rows in 0 pages for object 'vendtype'.
DBCC results for 'UserDefinedTypes'.
There are 0 rows in 0 pages for object 'UserDefinedTypes'.
DBCC results for 'tmp_arinv'.
There are 3381 rows in 162 pages for object 'tmp_arinv'.
DBCC results for 'JOBPLAN000'.
There are 0 rows in 0 pages for object 'JOBPLAN000'.
DBCC results for 'prdecd'.
There are 0 rows in 0 pages for object 'prdecd'.
DBCC results for 'ins_hc'.
There are 0 rows in 0 pages for object 'ins_hc'.
DBCC results for 'dcjit_serial'.
There are 0 rows in 0 pages for object 'dcjit_serial'.
DBCC results for 'wa_pos'.
There are 0 rows in 0 pages for object 'wa_pos'.
DBCC results for 'UserGroupMap'.
There are 350 rows in 6 pages for object 'UserGroupMap'.
DBCC results for 'tmp_arinvd'.
There are 3262 rows in 91 pages for object 'tmp_arinvd'.
DBCC results for 'JOBSTEP000'.
There are 10538 rows in 801 pages for object 'JOBSTEP000'.
DBCC results for 'preq'.
There are 4583 rows in 78 pages for object 'preq'.
DBCC results for 'jobroute_ii'.
There are 0 rows in 1 pages for object 'jobroute_ii'.
DBCC results for 'insurance'.
There are 0 rows in 0 pages for object 'insurance'.
DBCC results for 'dcjm'.
There are 0 rows in 0 pages for object 'dcjm'.
DBCC results for 'wa_usage'.
There are 0 rows in 0 pages for object 'wa_usage'.
DBCC results for 'UserModules'.
There are 3 rows in 4 pages for object 'UserModules'.
DBCC results for 'tmp_arpaypost'.
There are 1662 rows in 56 pages for object 'tmp_arpaypost'.
DBCC results for 'JS10VR000'.
There are 0 rows in 0 pages for object 'JS10VR000'.
DBCC results for 'preq_all'.
There are 4583 rows in 52 pages for object 'preq_all'.
DBCC results for 'intranet'.
There are 1 rows in 1 pages for object 'intranet'.
DBCC results for 'dcjm_serial'.
There are 0 rows in 0 pages for object 'dcjm_serial'.
DBCC results for 'want_ad'.
There are 0 rows in 0 pages for object 'want_ad'.
DBCC results for 'UserNames'.
There are 53 rows in 2 pages for object 'UserNames'.
DBCC results for 'tmp_arpmt'.
There are 1102 rows in 36 pages for object 'tmp_arpmt'.
DBCC results for 'tmp_co_jobroute'.
There are 0 rows in 0 pages for object 'tmp_co_jobroute'.
DBCC results for 'JS11VR000'.
There are 0 rows in 0 pages for object 'JS11VR000'.
DBCC results for 'preqcode'.
There are 3 rows in 1 pages for object 'preqcode'.
DBCC results for 'jobroute_dd'.
There are 0 rows in 1 pages for object 'jobroute_dd'.
DBCC results for 'inv_category'.
There are 1 rows in 1 pages for object 'inv_category'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_cust_curr' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:7) identified by (RID = (1:92505:7) inv_num = '0' and inv_seq = 38132) has index values (cust_num = 'APR0003' and curr_code = NULL and inv_num = '0' and inv_seq = 38132).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_cust_curr' (ID 4) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:9) identified by (RID = (1:92505:9) inv_num = '0' and inv_seq = 38134) has index values (cust_num = 'APW0001' and curr_code = NULL and inv_num = '0' and inv_seq = 38134).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_RowPointer' (ID 12) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:7) identified by (RID = (1:92505:7) inv_num = '0' and inv_seq = 38132) has index values (RowPointer = 2CFD6073-656E-4B7E-B276-FB59D14440ADh¢¿ and inv_num = '0' and inv_seq = 38132).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr' (ID 731149650). Missing or invalid key in index 'IX_inv_hdr_RowPointer' (ID 12) for the row:
DBCC results for 'dcmove'.
There are 0 rows in 0 pages for object 'dcmove'.
DBCC results for 'wbs_hdr'.
There are 0 rows in 0 pages for object 'wbs_hdr'.
DBCC results for 'UserNotes'.
There are 1 rows in 1 pages for object 'UserNotes'.
DBCC results for 'tmp_arpmtd'.
There are 1947 rows in 92 pages for object 'tmp_arpmtd'.
DBCC results for 'JS12VR000'.
There are 0 rows in 0 pages for object 'JS12VR000'.
DBCC results for 'preqitem'.
There are 9273 rows in 438 pages for object 'preqitem'.
DBCC results for 'inv_hdr'.
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92505:9) identified by (RID = (1:92505:9) inv_num = '0' and inv_seq = 38134) has index values (RowPointer = D531C719-87C7-4BA8-BEF3-213A772349D5h¢¿ and inv_num = '0' and inv_seq = 38134).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr_all' (ID 747149707). Missing or invalid key in index 'IX_inv_hdr_all_RowPointer' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92521:2) identified by (RID = (1:92521:2) site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38132) has index values (RowPointer = 2CFD6073-656E-4B7E-B276-FB59D14440ADh¢¿ and site_ref = 'KOTRA' and site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38132).
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'inv_hdr_all' (ID 747149707). Missing or invalid key in index 'IX_inv_hdr_all_RowPointer' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:92521:4) identified by (RID = (1:92521:4) site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38134) has index values (RowPointer = D531C719-87C7-4BA8-BEF3-213A772349D5h¢¿ and site_ref = 'KOTRA' and site_ref = 'KOTRA' and inv_num = '0' and inv_seq = 38134).
There are 212606 rows in 12941 pages for object 'inv_hdr'.
CHECKDB found 0 allocation errors and 4 consistency errors in table 'inv_hdr' (object ID 731149650).
DBCC results for 'dcmove_serial'.
There are 0 rows in 0 pages for object 'dcmove_serial'.
DBCC results for 'wbs_item'.
There are 0 rows in 0 pages for object 'wbs_item'.
DBCC results for 'UserProcessDefaults'.
There are 0 rows in 0 pages for object 'UserProcessDefaults'.
DBCC results for 'tmp_co_ship'.
There are 0 rows in 0 pages for object 'tmp_co_ship'.
DBCC results for 'JS13VR000'.
There are 0 rows in 0 pages for object 'JS13VR000'.
DBCC results for 'preqitem_all'.
There are 9273 rows in 137 pages for object 'preqitem_all'.
DBCC results for 'inv_hdr_all'.
There are 212606 rows in 7414 pages for object 'inv_hdr_all'.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'inv_hdr_all' (object ID 747149707).
DBCC results for 'dcparm'.
There are 1 rows in 1 pages for object 'dcparm'.
DBCC results for 'wc'.
There are 53 rows in 7 pages for object 'wc'.
DBCC results for 'WAIT000'.
There are 0 rows in 0 pages for object 'WAIT000'.
DBCC results for 'tmp_dcsfc_item'.
There are 0 rows in 0 pages for object 'tmp_dcsfc_item'.
DBCC results for 'JS14VR000'.
There are 0 rows in 0 pages for object 'JS14VR000'.
DBCC results for 'prhrs'.
There are 0 rows in 0 pages for object 'prhrs'.
DBCC results for 'inv_item'.
There are 691269 rows in 25037 pages for object 'inv_item'.
DBCC results for 'dcparm_all'.
There are 1 rows in 1 pages for object 'dcparm_all'.
DBCC results for 'wcresourcegroup'.
There are 53 rows in 1 pages for object 'wcresourcegroup'.
DBCC results for 'WorkflowTemplates'.
There are 0 rows in 0 pages for object 'WorkflowTemplates'.
DBCC results for 'tmp_edi_RSEQ_DTL'.
There are 0 rows in 0 pages for object 'tmp_edi_RSEQ_DTL'.
DBCC results for 'tmp_co_jrt_sch'.
There are 0 rows in 0 pages for object 'tmp_co_jrt_sch'.
DBCC results for 'JS15VR000'.
There are 0 rows in 0 pages for object 'JS15VR000'.
DBCC results for 'pricecode'.
There are 17 rows in 1 pages for object 'pricecode'.
DBCC results for 'inv_item_all'.
There are 691269 rows in 15557 pages for object 'inv_item_all'.
DBCC results for 'dcpo'.
There are 0 rows in 0 pages for object 'dcpo'.
DBCC results for 'wcseq'.
There are 0 rows in 0 pages for object 'wcseq'.
DBCC results for 'Workflows'.
There are 0 rows in 0 pages for object 'Workflows'.
DBCC results for 'tmp_edi_RSEQ_HDR'.
There are 0 rows in 0 pages for object 'tmp_edi_RSEQ_HDR'.
DBCC results for 'JS16VR000'.
There are 0 rows in 0 pages for object 'JS16VR000'.
DBCC results for 'pricecode_all'.
There are 17 rows in 1 pages for object 'pricecode_all'.
DBCC results for 'inv_map'.
There are 0 rows in 0 pages for object 'inv_map'.
DBCC results for 'dcpo_serial'.
There are 0 rows in 0 pages for object 'dcpo_serial'.
DBCC results for 'whse'.
There are 5 rows in 1 pages for object 'whse'.
DBCC results for 'absence'.
There are 0 rows in 0 pages for object 'absence'.
DBCC results for 'tmp_edi_co_100'.
There are 0 rows in 0 pages for object 'tmp_edi_co_100'.
DBCC results for 'JS17VR000'.
There are 0 rows in 0 pages for object 'JS17VR000'.
DBCC results for 'priceformula'.
There are 8 rows in 1 pages for object 'priceformula'.
DBCC results for 'inv_ms'.
There are 0 rows in 0 pages for object 'inv_ms'.
DBCC results for 'dcps'.
There are 0 rows in 0 pages for object 'dcps'.
DBCC results for 'whse_all'.
There are 5 rows in 1 pages for object 'whse_all'.
DBCC results for 'ack'.
There are 0 rows in 0 pages for object 'ack'.
DBCC results for 'tmp_edi_co_300'.
There are 0 rows in 0 pages for object 'tmp_edi_co_300'.
DBCC results for 'JS18VR000'.
There are 0 rows in 0 pages for object 'JS18VR000'.
DBCC results for 'priceformula_all'.
There are 8 rows in 1 pages for object 'priceformula_all'.
DBCC results for 'inv_ms_log'.
There are 0 rows in 0 pages for object 'inv_ms_log'.
DBCC results for 'dcps_serial'.
There are 0 rows in 0 pages for object 'dcps_serial'.
DBCC results for 'ack_bln'.
There are 0 rows in 0 pages for object 'ack_bln'.
DBCC results for 'tmp_edi_output'.
There are 0 rows in 0 pages for object 'tmp_edi_output'.
DBCC results for 'tmp_co_jobmatl'.
There are 0 rows in 0 pages for object 'tmp_co_jobmatl'.
DBCC results for 'JS19VR000'.
There are 10538 rows in 798 pages for object 'JS19VR000'.
DBCC results for 'pricematrix'.
There are 6 rows in 1 pages for object 'pricematrix'.
DBCC results for 'inv_ms_seq'.
There are 0 rows in 0 pages for object 'inv_ms_seq'.
DBCC results for 'dcsfc'.
There are 0 rows in 0 pages for object 'dcsfc'.
DBCC results for 'ackitem'.
There are 0 rows in 0 pages for object 'ackitem'.
DBCC results for 'tmp_edi_poack_100'.
There are 0 rows in 0 pages for object 'tmp_edi_poack_100'.
DBCC results for 'JS2VR000'.
There are 0 rows in 0 pages for object 'JS2VR000'.
DBCC results for 'pricematrix_all'.
There are 6 rows in 1 pages for object 'pricematrix_all'.
DBCC results for 'inv_pro'.
There are 0 rows in 0 pages for object 'inv_pro'.
DBCC results for 'dcsfc_item'.
There are 0 rows in 0 pages for object 'dcsfc_item'.
DBCC results for 'adp_parm'.
There are 0 rows in 0 pages for object 'adp_parm'.
DBCC results for 'tmp_edi_poack_200'.
There are 0 rows in 0 pages for object 'tmp_edi_poack_200'.
DBCC results for 'JS3VR000'.
There are 0 rows in 0 pages for object 'JS3VR000'.
DBCC results for 'prlog'.
There are 0 rows in 0 pages for object 'prlog'.
DBCC results for 'inv_sequence'.
There are 3 rows in 1 pages for object 'inv_sequence'.
DBCC results for 'dcsfc_serial'.
There are 0 rows in 0 pages for object 'dcsfc_serial'.
DBCC results for 'ana_ledger'.
There are 0 rows in 0 pages for object 'ana_ledger'.
DBCC results for 'tmp_edi_poack_300'.
There are 0 rows in 0 pages for object 'tmp_edi_poack_300'.
DBCC results for 'JS4VR000'.
There are 0 rows in 0 pages for object 'JS4VR000'.
DBCC results for 'probcode'.
There are 10 rows in 1 pages for object 'probcode'.
DBCC results for 'inv_stax'.
There are 0 rows in 0 pages for object 'inv_stax'.
DBCC results for 'dcta'.
There are 0 rows in 0 pages for object 'dcta'.
DBCC results for 'ana_ledger_all'.
There are 0 rows in 0 pages for object 'ana_ledger_all'.
DBCC results for 'tmp_edi_ship_dtl'.
There are 0 rows in 0 pages for object 'tmp_edi_ship_dtl'.
DBCC results for 'JS6VR000'.
There are 0 rows in 0 pages for object 'JS6VR000'.
DBCC results for 'prod_mix'.
There are 0 rows in 0 pages for object 'prod_mix'.
DBCC results for 'inv_stax_all'.
There are 0 rows in 0 pages for object 'inv_stax_all'.
DBCC results for 'dctrans'.
There are 0 rows in 0 pages for object 'dctrans'.
DBCC results for 'ana_pertot'.
There are 0 rows in 0 pages for object 'ana_pertot'.
DBCC results for 'tmp_edi_ship_hdr'.
There are 0 rows in 0 pages for object 'tmp_edi_ship_hdr'.
DBCC results for 'JS7VR000'.
There are 0 rows in 0 pages for object 'JS7VR000'.
DBCC results for 'prod_mix_irt'.
There are 0 rows in 0 pages for object 'prod_mix_irt'.
DBCC results for 'inv_void'.
There are 0 rows in 0 pages for object 'inv_void'.
DBCC results for 'dctrans_serial'.
There are 0 rows in 0 pages for object 'dctrans_serial'.
DBCC results for 'ana_pertot_all'.
There are 0 rows in 0 pages for object 'ana_pertot_all'.
DBCC results for 'tmp_edi_vinv_100'.
There are 0 rows in 0 pages for object 'tmp_edi_vinv_100'.
DBCC results for 'JS8VR000'.
There are 0 rows in 0 pages for object 'JS8VR000'.
DBCC results for 'prod_mix_item'.
There are 0 rows in 0 pages for object 'prod_mix_item'.
DBCC results for 'invc_lang'.
There are 0 rows in 0 pages for object 'invc_lang'.
DBCC results for 'dcwc'.
There are 0 rows in 0 pages for object 'dcwc'.
DBCC results for 'ap_batch_counter'.
There are 0 rows in 0 pages for object 'ap_batch_counter'.
DBCC results for 'tmp_edi_vinv_200'.
There are 0 rows in 0 pages for object 'tmp_edi_vinv_200'.
DBCC results for 'JS9VR000'.
There are 0 rows in 0 pages for object 'JS9VR000'.
DBCC results for 'prodcode'.
There are 101 rows in 7 pages for object 'prodcode'.
DBCC results for 'invparms'.
There are 1 rows in 1 pages for object 'invparms'.
DBCC results for 'dcwc_serial'.
There are 0 rows in 0 pages for object 'dcwc_serial'.
DBCC results for 'apdraftt'.
There are 0 rows in 0 pages for object 'apdraftt'.
DBCC results for 'tmp_edi_vsn_100'.
There are 0 rows in 0 pages for object 'tmp_edi_vsn_100'.
DBCC results for 'JSATTR000'.
There are 0 rows in 0 pages for object 'JSATTR000'.
DBCC results for 'prodcode_all'.
There are 101 rows in 2 pages for object 'prodcode_all'.
DBCC results for 'invparms_all'.
There are 1 rows in 1 pages for object 'invparms_all'.
DBCC results for 'del_term'.
There are 0 rows in 0 pages for object 'del_term'.
DBCC results for 'apdraftt_all'.
There are 0 rows in 0 pages for object 'apdraftt_all'.
DBCC results for 'tmp_edi_vsn_200'.
There are 0 rows in 0 pages for object 'tmp_edi_vsn_200'.
DBCC results for 'JSTYPE'.
There are 39 rows in 1 pages for object 'JSTYPE'.
DBCC results for 'prodvar'.
There are 101 rows in 6 pages for object 'prodvar'.
DBCC results for 'kotra_ETHProdGrp_Old_20052006'.
There are 1654 rows in 207 pages for object 'kotra_ETHProdGrp_Old_20052006'.
DBCC results for 'item'.
There are 2423 rows in 419 pages for object 'item'.
DBCC results for 'del_term_all'.
There are 0 rows in 0 pages for object 'del_term_all'.
DBCC results for 'app_int'.
There are 0 rows in 0 pages for object 'app_int'.
DBCC results for 'tmp_finstmt'.
There are 0 rows in 1 pages for object 'tmp_finstmt'.
DBCC results for 'kotra_ProdIncGrp-180406'.
There are 21 rows in 2 pages for object 'kotra_ProdIncGrp-180406'.
DBCC results for 'LOADPERF000'.
There are 0 rows in 0 pages for object 'LOADPERF000'.
DBCC results for 'progbill'.
There are 0 rows in 0 pages for object 'progbill'.
DBCC results for 'kotra_OTCProdGrp-260606'.
There are 361 rows in 46 pages for object 'kotra_OTCProdGrp-260606'.
DBCC results for 'item_all'.
There are 2423 rows in 286 pages for object 'item_all'.
DBCC results for 'dep_dtl'.
There are 0 rows in 0 pages for object 'dep_dtl'.
DBCC results for 'app_ref'.
There are 0 rows in 0 pages for object 'app_ref'.
DBCC results for 'tmp_inv'.
There are 1 rows in 1 pages for object 'tmp_inv'.
DBCC results for 'kotra_MgmtGrp_old'.
There are 29 rows in 1 pages for object 'kotra_MgmtGrp_old'.
DBCC results for 'LOADSUM000'.
There are 0 rows in 0 pages for object 'LOADSUM000'.
DBCC results for 'progh'.
There are 0 rows in 0 pages for object 'progh'.
DBCC results for 'kotra_OTCProdGrp-130706'.
There are 361 rows in 51 pages for object 'kotra_OTCProdGrp-130706'.
DBCC results for 'item_glbl'.
There are 2423 rows in 76 pages for object 'item_glbl'.
DBCC results for 'dept'.
There are 12 rows in 1 pages for object 'dept'.
DBCC results for 'app_source'.
There are 0 rows in 0 pages for object 'app_source'.
DBCC results for 'tmp_itemlifo'.
There are 0 rows in 0 pages for object 'tmp_itemlifo'.
DBCC results for 'LOCALE'.
There are 0 rows in 0 pages for object 'LOCALE'.
DBCC results for 'proj'.
There are 0 rows in 0 pages for object 'proj'.
DBCC results for 'Sheet1$'.
There are 361 rows in 73 pages for object 'Sheet1$'.
DBCC results for 'item_lang'.
There are 0 rows in 0 pages for object 'item_lang'.
DBCC results for 'dept_supv'.
There are 0 rows in 0 pages for object 'dept_supv'.
DBCC results for 'apparms'.
There are 1 rows in 1 pages for object 'apparms'.
DBCC results for 'tmp_job_split'.
There are 0 rows in 1 pages for object 'tmp_job_split'.
DBCC results for 'LOCALSTR'.
There are 0 rows in 0 pages for object 'LOCALSTR'.
DBCC results for 'proj_all'.
There are 0 rows in 0 pages for object 'proj_all'.
DBCC results for 'itemcust'.
There are 22 rows in 1 pages for object 'itemcust'.
DBCC results for 'discount'.
There are 0 rows in 0 pages for object 'discount'.
DBCC results for 'apparms_all'.
There are 1 rows in 1 pages for object 'apparms_all'.
DBCC results for 'tmp_journal'.
There are 9350 rows in 433 pages for object 'tmp_journal'.
DBCC results for 'LOOKUP000'.
There are 0 rows in 0 pages for object 'LOOKUP000'.
DBCC results for 'proj_bol'.
There are 0 rows in 0 pages for object 'proj_bol'.
DBCC results for 'kotra_IDSCustList'.
There are 7299 rows in 93 pages for object 'kotra_IDSCustList'.
DBCC results for 'itemcust_all'.
There are 22 rows in 1 pages for object 'itemcust_all'.
DBCC results for 'dispcode'.
There are 6 rows in 1 pages for object 'dispcode'.
DBCC results for 'applicant'.
There are 0 rows in 0 pages for object 'applicant'.
DBCC results for 'tmp_lc_tax_dist'.
There are 0 rows in 0 pages for object 'tmp_lc_tax_dist'.
DBCC results for 'LSTATUS000'.
There are 0 rows in 0 pages for object 'LSTATUS000'.
DBCC results for 'proj_bol_item'.
There are 0 rows in 0 pages for object 'proj_bol_item'.
DBCC results for 'itemcustprice'.
There are 3 rows in 1 pages for object 'itemcustprice'.
DBCC results for 'distacct'.
There are 101 rows in 10 pages for object 'distacct'.
DBCC results for 'appmt'.
There are 189 rows in 6 pages for object 'appmt'.
DBCC results for 'tmp_ledger'.
There are 0 rows in 0 pages for object 'tmp_ledger'.
DBCC results for 'LanguageIDs'.
There are 33 rows in 1 pages for object 'LanguageIDs'.
DBCC results for 'proj_inv_hdr'.
There are 0 rows in 0 pages for object 'proj_inv_hdr'.
DBCC results for 'itemcustprice_all'.
There are 3 rows in 1 pages for object 'itemcustprice_all'.
DBCC results for 'div_mgr'.
There are 0 rows in 0 pages for object 'div_mgr'.
DBCC results for 'appmtd'.
There are 596 rows in 26 pages for object 'appmtd'.
DBCC results for 'tmp_matltran'.
There are 0 rows in 0 pages for object 'tmp_matltran'.
DBCC results for 'License'.
There are 1 rows in 1 pages for object 'License'.
DBCC results for 'proj_inv_item'.
There are 0 rows in 0 pages for object 'proj_inv_item'.
DBCC results for 'itemlifo'.
There are 12 rows in 1 pages for object 'itemlifo'.
DBCC results for 'do_hdr'.
There are 0 rows in 0 pages for object 'do_hdr'.
DBCC results for 'aps_parm'.
There are 1 rows in 1 pages for object 'aps_parm'.
DBCC results for 'tmp_matltran_amt'.
There are 0 rows in 0 pages for object 'tmp_matltran_amt'.
DBCC results for 'LoginCfg'.
There are 1 rows in 1 pages for object 'LoginCfg'.
DBCC results for 'proj_inv_item_all'.
There are 0 rows in 0 pages for object 'proj_inv_item_all'.
DBCC results for 'itemloc'.
There are 9265 rows in 635 pages for object 'itemloc'.
DBCC results for 'do_line'.
There are 0 rows in 0 pages for object 'do_line'.
DBCC results for 'aps_seq'.
There are 13 rows in 1 pages for object 'aps_seq'.
DBCC results for 'tmp_phyinv'.
There are 0 rows in 0 pages for object 'tmp_phyinv'.
DBCC results for 'MATADDQ000'.
There are 0 rows in 0 pages for object 'MATADDQ000'.
DBCC results for 'proj_pck_hdr'.
There are 0 rows in 0 pages for object 'proj_pck_hdr'.
DBCC results for 'itemloc_all'.
There are 9265 rows in 564 pages for object 'itemloc_all'.
DBCC results for 'do_seq'.
There are 0 rows in 0 pages for object 'do_seq'.
DBCC results for 'aps_site'.
There are 0 rows in 0 pages for object 'aps_site'.
DBCC results for 'tmp_pick_itemdet'.
There are 79 rows in 3 pages for object 'tmp_pick_itemdet'.
DBCC results for 'MATDELOUT000'.
There are 0 rows in 0 pages for object 'MATDELOUT000'.
DBCC results for 'proj_pckitem'.
There are 0 rows in 0 pages for object 'proj_pckitem'.
DBCC results for 'itemprice'.
There are 1233 rows in 73 pages for object 'itemprice'.
DBCC results for 'dynamic_table'.
There are 57 rows in 1 pages for object 'dynamic_table'.
DBCC results for 'apsplan'.
There are 0 rows in 0 pages for object 'apsplan'.
DBCC results for 'tmp_pick_itemloclot'.
There are 119 rows in 4 pages for object 'tmp_pick_itemloclot'.
DBCC results for 'MATL000'.
There are 2989 rows in 274 pages for object 'MATL000'.
DBCC results for 'proj_ship'.
There are 0 rows in 0 pages for object 'proj_ship'.
DBCC results for 'itemprice_all'.
There are 1233 rows in 76 pages for object 'itemprice_all'.
DBCC results for 'ecn'.
There are 0 rows in 0 pages for object 'ecn'.
DBCC results for 'apsplandetail'.
There are 0 rows in 0 pages for object 'apsplandetail'.
DBCC results for 'tmp_pick_itemtot'.
There are 63 rows in 2 pages for object 'tmp_pick_itemtot'.
DBCC results for 'MATLALT000'.
There are 0 rows in 0 pages for object 'MATLALT000'.
DBCC results for 'proj_wip'.
There are 0 rows in 0 pages for object 'proj_wip'.
DBCC results for 'itemrev'.
There are 0 rows in 0 pages for object 'itemrev'.
DBCC results for 'ecndist'.
There are 0 rows in 0 pages for object 'ecndist'.
DBCC results for 'aptrx'.
There are 229 rows in 49 pages for object 'aptrx'.
DBCC results for 'tmp_ser'.
There are 0 rows in 0 pages for object 'tmp_ser'.
DBCC results for 'MATLATTR000'.
There are 2424 rows in 52 pages for object 'MATLATTR000'.
DBCC results for 'projcost'.
There are 0 rows in 0 pages for object 'projcost'.
DBCC results for 'itemvend'.
There are 1699 rows in 94 pages for object 'itemvend'.
DBCC results for 'ecnh'.
There are 0 rows in 0 pages for object 'ecnh'.
DBCC results for 'aptrxd'.
There are 251 rows in 25 pages for object 'aptrxd'.
DBCC results for 'tmp_ship'.
There are 0 rows in 1 pages for object 'tmp_ship'.
DBCC results for 'MATLDELV000'.
There are 226 rows in 30 pages for object 'MATLDELV000'.
DBCC results for 'projlabr'.
There are 0 rows in 0 pages for object 'projlabr'.
DBCC results for 'itemvendprice'.
There are 1770 rows in 106 pages for object 'itemvendprice'.
DBCC results for 'ecnhitem'.
There are 0 rows in 0 pages for object 'ecnhitem'.
DBCC results for 'aptrxp'.
There are 64775 rows in 4076 pages for object 'aptrxp'.
DBCC results for 'tmp_snapshot_apdraftt'.
There are 0 rows in 0 pages for object 'tmp_snapshot_apdraftt'.
DBCC results for 'target4SQLdb$'.
There are 3720 rows in 33 pages for object 'target4SQLdb$'.
DBCC results for 'MATLGRP000'.
There are 0 rows in 0 pages for object 'MATLGRP000'.
DBCC results for 'projmatl'.
There are 0 rows in 0 pages for object 'projmatl'.
DBCC results for 'itemwhse'.
There are 2423 rows in 176 pages for object 'itemwhse'.
DBCC results for 'ecnitem'.
There are 0 rows in 0 pages for object 'ecnitem'.
DBCC results for 'aptrxp_all'.
There are 64775 rows in 3508 pages for object 'aptrxp_all'.
DBCC results for 'tmp_snapshot_appmt'.
There are 801 rows in 28 pages for object 'tmp_snapshot_appmt'.
DBCC results for 'kotra_OTCTarget_Old'.
There are 3600 rows in 76 pages for object 'kotra_OTCTarget_Old'.
DBCC results for 'MATLPBOMS000'.
There are 2502 rows in 106 pages for object 'MATLPBOMS000'.
DBCC results for 'projparm'.
There are 1 rows in 1 pages for object 'projparm'.
DBCC results for 'itemwhse_all'.
There are 2423 rows in 111 pages for object 'itemwhse_all'.
DBCC results for 'ecnpri'.
There are 0 rows in 0 pages for object 'ecnpri'.
DBCC results for 'aptrxr'.
There are 1 rows in 1 pages for object 'aptrxr'.
DBCC results for 'tmp_snapshot_appmtd'.
There are 2315 rows in 101 pages for object 'tmp_snapshot_appmtd'.
DBCC results for 'kotra_ETHTarget_old'.
There are 2160 rows in 48 pages for object 'kotra_ETHTarget_old'.
DBCC results for 'MATLPLAN000'.
There are 0 rows in 0 pages for object 'MATLPLAN000'.
DBCC results for 'projsale'.
There are 0 rows in 0 pages for object 'projsale'.
DBCC results for 'jmatlc'.
There are 0 rows in 0 pages for object 'jmatlc'.
DBCC results for 'ed_major'.
There are 0 rows in 0 pages for object 'ed_major'.
DBCC results for 'aptrxt'.
There are 0 rows in 0 pages for object 'aptrxt'.
DBCC results for 'tmp_snapshot_aptrx'.
There are 9443 rows in 588 pages for object 'tmp_snapshot_aptrx'.
DBCC results for 'MATLPPS000'.
There are 1661 rows in 70 pages for object 'MATLPPS000'.
DBCC results for 'projtask'.
There are 0 rows in 0 pages for object 'projtask'.
DBCC results for 'job'.
There are 16484 rows in 1618 pages for object 'job'.
DBCC results for 'edi_bol'.
There are 0 rows in 0 pages for object 'edi_bol'.
DBCC results for 'aptxrd'.
There are 0 rows in 0 pages for object 'aptxrd'.
DBCC results for 'tmp_snapshot_aptrxd'.
There are 9936 rows in 270 pages for object 'tmp_snapshot_aptrxd'.
DBCC results for 'MATLRULE000'.
There are 0 rows in 0 pages for object 'MATLRULE000'.
DBCC results for 'projtask_all'.
There are 0 rows in 0 pages for object 'projtask_all'.
DBCC results for 'job_all'.
There are 16484 rows in 334 pages for object 'job_all'.
DBCC results for 'edi_bol_item'.
There are 0 rows in 0 pages for object 'edi_bol_item'.
DBCC results for 'ar_batch_counter'.
There are 0 rows in 0 pages for object 'ar_batch_counter'.
DBCC results for 'tmp_snapshot_aptrxp'.
There are 0 rows in 0 pages for object 'tmp_sna

View 7 Replies View Related

SQL 2012 :: Full Text Index How To Make It NOT To Index Embedded Or Attached Documents

Sep 30, 2015

I am using Full Text Index to index emails stored in BLOB column in a table. Index process parses stored emails, and, if there is one or more files attached to the email these documents get indexed too. In result when I'm querying the full text index for a word or phrase I am getting reference to the email containing the word of phrase if interest if the word was used in the email body OR if it was used in any document attached to the email.

How to distinguish in a Full Text query that the result came from an embedded document rather than from "main" document? Or if that's not possible how to disable indexing of embedded documents?

My goal is either to give a user an option if he or she wants to search emails (email bodies only) OR emails AND documents attached to them, or at least clearly indicate in the returned result the real source where the word or phrase has been found.

View 0 Replies View Related

Clustered Index On Client_ID+ORderNO+OrdersubNo, If I Create 3 Noncluster Index On Said Column Will It Imporve Performance

Dec 5, 2007



Dear All.

We had Teradata 4700 SMP. We have moved data from TD to MS_SQL SERVER 2003. records are 19.65 Millions.

table is >> Order_Dtl

Columns are:-

Client_ID varchar 10
Order_ID varchar 50
Order_Sub_ID decimal
.....
...
..
.
Pk is (ClientID+OrderId+OrderSubID)

Web Base application or PDA devices use to initiate the order from all over the country. The issue is this table is not Partioned but good HP with 30 GB RAM is installed. this is main table that receive 18,0000 hits or more. All brokers and users are using this table to see the status of their order.

The always search by OrderID, or ClientID or order_SubNo, or enter any two like (Client_ID+Order_Sub_ID) or any combination.

Query takes to much time when ever server receive more querys. some orther indexes are also created on the same table like (OrderDate, OrdCreate Date and Status)

My Question are:-


Q1. IF Person "A" query to DB on Client_ID, then what Index will use ? (If any one do Query on any two combination like Client_ID+Order_ID, So what index will be uesd.? How does MS-SQL SERVER deal with these kind of issues.?

Q2. If i create 3 more indexes on ClientID, ORderID and OrdersubID. will this improve the performance of query.if person "A" search record on orderNo so what index will be used. (Mind it their would be 3 seprate indexes for Each PK columns) and composite-Clustered index is also available.?

Q3. I want to check what indexes has been used? on what search?

Q4. How can i check what table was populated when, or last date of update (DML)?

My Limitation is i Dont Create a Partioned table. I dont have permission to do it.



In Teradata we had more than 4 tb record of CRM data with no issue. i am not new baby in db line but not expert in sql server 2003.


I am thank u to all who read or reply.

Arshad

Manager Database
Esoulconsultancy.com

(Teradata Master)
10g OCP










View 3 Replies View Related

Integration Services :: Rebuild Index / Refresh Index And Stats Improves Ssis Package Performance

Oct 28, 2015

My SSIS package is running very slow taking so much time to execute, One task is taking 2hr for inserting 100k records, i have disabled unused index still it is taking time.I am rebuilding/Refreshing indexes and stats once in month if i try to execute on daily basis will it improve my SSIS Package performance? 

View 2 Replies View Related

Index Was Out Of Range. Must Be Non-negative And Less Than The Size Of The Collection. Parameter Name: Index

Jan 22, 2006

Keep getting this error when positioning to the last page of a report.

Using Server 2003...SqlRpt Svcs 2000 sp2

Detail error msg:

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown. (rrRenderingError) Get Online Help

Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

Anyone have any suggestions?  Any way to find out what collection is blowing?...or where parameter name: index comes from?

View 47 Replies View Related

Index Table1 And Select For 647.600 Records.. It Is So Slow.. But I Have No Index :)???

Jun 20, 2008

hello friends
i have table1 and 200 coulumn of table1 :) i have 647.600 records. i entered my records to table1 with for step to code lines in one day :)
i select category1 category2 and category3 with select code but i have just one index.. it is productnumber and it is primarykey..So my select code lines is so slow.. it is 7-9 second.. how can i select in 0.1 second ? Should i create index for category1 and category2 and category3 ? But i dont know create index.. My select code lines is below.. Could you learn me and show me index for it ?? or Could you learn me and show me fast Select code lines and index or etc ??? Also my search code line have a dangerous releated to attaching table1 with hackers :)
cheersi send 3 value of treview1 node and childnode and child.childnode to below page.aspx :)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
If Request("TextBox1") IsNot Nothing ThenTextBox1.Text = Request("TextBox1")
End If
If Request("TextBox2") IsNot Nothing ThenTextBox2.Text = Request("TextBox2")
End If
If Request("TextBox3") IsNot Nothing ThenTextBox3.Text = Request("TextBox3")
End If
End If
Dim searchword As String
If Request("TextBox3") = "" And Request("TextBox2") = "" Then
searchword = "Select * from urunlistesi where kategori= '" & Request("TextBox1") & "'"
End If
If Request("TextBox3") = "" Then
searchword = "Select * from urunlistesi where kategori= '" & Request("TextBox1") & "' and kategori1= '" & Request("TextBox2") & "'"
End If
If Request("TextBox3") <> "" And Request("TextBox2") <> "" And Request("TextBox1") <> "" Then
searchword = "Select * from urunlistesi where kategori= '" & Request("TextBox1") & "' and kategori1= '" & Request("TextBox2") & "' and kategori2= '" & Request("TextBox3") & "'"
End If
SqlDataSource1.SelectCommand = searchword
End Sub

View 11 Replies View Related

The Index Entry For Row ID Was Not Found In Index ID 3, Of Table 357576312

Jul 9, 2004

Hi,

I'm running a merge replication on a sql2k machine to 6 sql2k subscribers.
Since a few day's only one of the merge agents fail's with the following error:

The merge process could not retrieve generation information at the 'Subscriber'.
The index entry for row ID was not found in index ID 3, of table 357576312, in database 'PBB006'.

All DBCC CHECKDB command's return 0 errors :confused:
I'm not sure if the table that's referred to in the message is on the distribution side or the subscribers side? A select * from sysobjects where id=357576312 gives different results on both sides . .

Any ideas as to what is causing this error?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved