Cannot Write Logfile Error 1059 : Circular Service Dependency

Feb 14, 2007

I have a problem that looks like it has not been discussed before in
these groups.

I have a simple SQLAgent job that runs sp_who (could be anything, but
let's just say sp_who for this example). I have set the jobstep to
write to an output file "T:out.txt". If the job is owned by an
admin, it runs fine and writes the output file. If it is owned by a
non-admin user, it gets the following error msg:

Warning: cannot write logfile t:out.txt. Error 1059 : Circular
service dependency was specified. The step failed.

I know about setting up the SQLAgent CMDExec proxy account, and have
done that. In fact, both SQLAgent and the SQLAgent cmdexec proxy use
the same domain account, which is in the administrator group of the
local server. So, I know that security is not the issue.

When a simple job runs and writes to an output file, what service or
service group could it be trying to start or modify? I looked through
the list of Services, and could not find any circular dependencies.
Is there a utility to detect this? Why would running under one
context (as an admin) be ok while the other context (non-admin on SQL,
but using the same admin domain service account) fails?

Thanks in advance for any info you might have.

View 3 Replies


ADVERTISEMENT

Sql Dependency And Service Broker.

Feb 16, 2007

Hi everyone,
 
                  Can anyone let meknow how do i enable a service broker. I am trying to enable a service broker for an issuetracker application to get change of events in my database. When ever i try enabling it using the ALTER DATABASE [ databse] set Enable_Broker. it takes abt more that 2 hrs or more but doesnt show as enabled.
 Thanks in Advance,
 Pawan Venugopal

View 2 Replies View Related

Service Broker And Sql Cache Dependency

Nov 17, 2006

Hi,

Our development team is building an application using .net framework 2.0 and sql server 2005 developer edition. They are using service broker and sql cache dependency classes in their code and we are running into a problem where the database used for their application is growing alarmingly in size, ends up using a log of memory and finally drags the machine. The database machine is a developer class machine used for development purpose only.

After we did our research we found the following:

1. the tables created by the team do not increase in size.

2. the system tables created by sql server for service broker and sql dependency grows very big during their usage.

sys.sysconvgroup
sys.sysdesend
sys.sysdercv

The above three tables have the same number of records and they are equal in size for eg, at one point they were 1.5 gb each amounting to total 5 gb out which the actual user created tables, indexes, sp amount to only 500 Mb.

There were some post in other forums that suggested to use triggers to close the open conversations and also use END CONVERSATIONS in the code. We have used that solution also but doesn't seem to solve the problem.

Is there a definite solution from microsoft for this issue.

Anybody has any insight to this. Thanks for your help in advance.

View 1 Replies View Related

Service Dependency On SQL Server And Restart/Restore

Jun 26, 2007

I have a service that depends on SQL Server service. Basically we make sure that our service only starts after SQL server service started. Unfortunately this dependency does not ensure that database is available.

Basically I observed in Application log that SQL server reports that it started to listen on a port. And then I see that recovery process started. As I understand SQL server is not available while database is in the recovery state.



Note: I might have not used a correct terminology to describe SQL server recovery process as I don't have access to Application log with the exact message at the moment. I can verify the message if necessary.

Because SQL server service is started our service starts and attempts to connect to the database. Service fails to connect to database, because of the restoration process. Once restoration is done service connects successfully.

I observed that restoration process starts every time machine is rebooted. It only takes a few minutes to run, but it is enough to generate a number of error messages in event log about failed SQL connections.

My first question is: Is it normal for database to enter into recovery state every time machine is rebooted?

My second question is: If it is a normal operation, is there any way to detect that SQL server is truly available, so our code does not have to try retry establishing connection many times

View 6 Replies View Related

Urgent DataBase Restore Logfile Path Error Message

May 8, 2007

I am having difficulty restoring a database (DB_1) with 2 datafiles and one log file, DB Structure is as following:

Filegroup PRIMARY with file name 'fnm_data' with physical file name and location D:dbfile_1.mdf,
Filegroup 'FG1' with file name 'fgnm1_data1' with physical file name and location F:dbfile_FG1.mdf,
One log file with file name 'fnm_log' with physical file name and location (E:loglog_db.ldf)

{Note} Logfile resides on E drive whereas Datafiles reside on several other drives.

I need to restore the DB on another machine. And I need to move the log file to a drive other than E.In this case it is K drive. Hence I have used the following code,

restore log DB_1 from disk='M:kupccciclog.txt'

WITH RESTRICTED_USER , MOVE 'fnm_log'

TO 'K:DBlog_db.ldf', recovery, replace,RESTART

go



When I try to restore from backup files, I keep error message saying "Physical file name E:loglog_db.ldf may be incorrect." 'fnm_log' cannot be restored. Use Move command to identify a valid location for the file.

Even though I am using Move command to move the log file.



Then I found that if I create a drive with E: and a folder named 'log' then restore program runs alright. That is, when E:log exists then code does run smoothly. All the restore code is looking for the presence of path of the log file from where it is been backed up. In this case it is E:log folder. Once the database is restored I could kill that directory and nothing happens. Also log file has been restored on K:DB only.

Why the restore code is looking for the initial drive letter and path even though I have used Move command? Is there an issue in my code?

Any help will be highly appreciated.

View 3 Replies View Related

Enable Caching Error During Sql Dependency Registration

Sep 11, 2006

Hey, I can't enable caching on my local computer..I use daspnet_regsql -S "localhostSQLEXPRESS" -E -d books -edand aspnet_regsql -S "AdminSQLEXPRESS" -E -d books -edto try to start but i get a login error...cannot open database "books" requested by login. The login failed. Login failed for user Computer2/Adminunable to connect to SQL database for cache dependency registrationI tested connection with vwd and sql express management and it connects so I don't know what i'm doing wrong since I followed the direction and I googled for answer but not coming up with anything that's helping me..anyone have this problem and know how to resolve so i can cache some data output on my project 

View 2 Replies View Related

Should I Use A Clr Function Or Write A Windows Service

Jul 9, 2007

hi all.

please help with my dilemma.

this is my task:

i should write a service that will run every 1 hour.

this service should check a folder.

inside this folder there are some xml files, all of them in the same format exactly.

when the service encounters with this xml file, it should open it,pull some data out of it, and update a table in the db.

NOW - I HAVE 2 OPTIONS, AND THIS IS THE DILEMMA:

should i write a clr function to do this task, or should i just write a standard c# windows service, that will open a connection to the db when it should perform update?

what are the advatages?

View 3 Replies View Related

Forward Dependency Error In SQL Server Reporting Services Table Names

Aug 27, 2007


Hi

I am creating a report on a database where some of the table names start
with the @ sign - ie @table1.

Reporting services picks this up as a parameter, instead of a table name in
my query, even though I am encapsulating the table name in square brackets
eg. [@table1]

I have several data sets in the report that i am using to populate valid
parameters. These datasets are all variations of queries from tables that
have @ as the first character.

When i then try to run the report i get an error message as follows:
"The report parameter pool has a default value or a valid value that depends
on the report parameter SD_POOLCONTRACTS. Forward dependencies are not valid"

This is frustrating as SD_POOLCONTRACTS is not a report parameter but one of
the database tables that has @ for it's first character.

here is the query that i use to obtain the valid values for the pool report
parameter that i am trying to set up.

SELECT distinct u_poolcode as Pool
FROM OCRD INNER JOIN
OCRG ON OCRD.GroupCode = OCRG.GroupCode INNER JOIN
CRD1 ON OCRD.CardCode = CRD1.CardCode inner JOIN
[@SD_POOLCONTRACT] INNER JOIN
[@SD_POOLCONTRCT_LINE] ON [@SD_POOLCONTRACT].DocEntry
= [@SD_POOLCONTRCT_LINE].DocEntry INNER JOIN
[@SD_CONTRACTS] ON [@SD_POOLCONTRCT_LINE].U_DocNo =
[@SD_CONTRACTS].DocNum ON
case when len(ocrd.fathercard) = 0 then ocrd.cardcode
else ISNULL(OCRD.FatherCard, OCRD.CardCode) end = [@SD_CONTRACTS].U_CardCode
WHERE (OCRD.CardType = 'c') AND (OCRG.GroupName LIKE N'producer%') AND
(CRD1.AdresType = 'b')
ORDER BY OCRG.GroupName, FatherCard, OCRD.CardCode

Any help would be appreciated.

View 1 Replies View Related

Subject: BCM Install Error - Logfile && SQL Path Path && MSSQL.1?

Apr 16, 2008

When trying to install Business Contact Manager (BCM) for Outlook 2007, the setup failed and I was refered to a log file in my Local Settings/Temp folder. The log actually says that Business Contact Manager was installed sucessfully! BCM is supposed to install SQL Express 2005 as an instance or as instance if SQL Express is already installed. There is an MSSMLBIZ instance in Services..

Who can I send the Log File to for analysis and the fix feedback?

When I first went into Computer Management and clicked on Services and Applications in the left panel, the error message appeared "Snap-in failed to intialize. Name: SQL Server Configuration Manager CLSID:{CA9F8727-31DF-41D2-975C-887D84903967} This message diappeared when I clicked on Services and Applications again. Under Services, there are 3 SQL services - one is an application that was uninstalled 3-4 weeks ago and I disabled this service. The other 2 are: SQL Server (MSSMLBIZ) and the other one is SQL Server (SQLEXPRESS) When I tried to start either of the last 2, the message appeared: Services "Could not start the SQL Server (MSSMLBIZ) service on Local Computer. Error 3: The system cannot find the path specified. Under Program Files/Microsoft SQL Server/MSSGL.1 folder is mostly empty. So, it seems like the Path in the Registry is not valid and that nothing is being installed in the MSSQL.1 folder. If so, how do I fix this?

How do I get the BCM SQL instance to install and run properly? what do the messages in Services mean and how do I resolve these.

Thank you!

Gary

View 3 Replies View Related

Circular Dependencies From Constraints

Jan 6, 2007

Hey!
 I am creating a kind of file browser for an application of mine. The principle is quite straight forward. It consists of folders and files. Each folder can contain other folders and files and so on. The twitch however is that i need a special root entity called site. The site is very much alike a folder but has some other properties. The site can contain folders and files.
To achieve this ive created te following tables (truncated for clearity):
####################            Sites          ##################### ID [Int]                   ## ...                         ####################
####################          Folders         ##################### ID [Int]                   ## SiteID [Int]             ## FolderID [Int]          ## ...                         ####################
####################          Files             ##################### ID [Int]                   ## SiteID [Int]             ## FolderID [Int]          ## ...                         ####################
 Both the folder table and the files table have a check constraint that ensures that either SiteID or FolderID is NULL. They WILL be part of EITHER a folder or a site. Not both!
Then i set up the foreign constraints as follows:Folders.FolderD -> Folders.IDFolders.SiteID -> Sites.IDFiles.FolderID -> Folders.IDFiles.SiteID -> Sites.ID
All constraints have cascade on delete and therefore the last of them cannot be created as it would be circular. (Wich it wont in this case, but theoreticaly its possible)
Iknow WHY this is rendering an error. But how can i work around it? Or would you suggest another design of the tables?

View 2 Replies View Related

Circular Reference To Update

Apr 25, 2008

I have a table like the following
Table=Items
Type / Name
3 / Active Item
3 / Active Item
4 / New Item
4 / New Item
5 / Old Item
5 / Old Item

How do I run a querry to update the Type Colum entrys from 5's to 3's? I have tried the following:
UPDATE Items SET Type = 3 WHERE Type = 5

The above querry passes SQL Querry analyzer, but the querry itself provides the following error: Unable to parse query text.
I think the error is due to the fact that I am using a circular reference to update the same Column that I am testing on.
MS-SQL 2005 SP-2

Any help would be FANTASTIC!

View 4 Replies View Related

Help - Tasks That Have Circular Dependencies

Sep 18, 2006

Hello,

I have a package, which calls a sub package to poulate a table depending on a flag in the database (using an ExecuteSQL task to return flagged table name).

The inner package populates some tables, and calculates what needs to be processed next. It sets the next flag.

However, I can't make this work in the control flow, as once the Execute package has completed, I need to start again from the top, as the flag will have changed to the next item.

I hope that I have explained this well enough.

I really need this to work, but SSIS will not let me create a circular dependency. Does anyone know a way around this, or can offer me an alternative solution??

I am getting desperate, so any suggestions will be welcome

Many thanks





View 4 Replies View Related

DB Design Question. Circular Reference?

Jun 25, 2007

I have a hypothetical question. Suppose you have three database tables. One represents the moneyin a cash register. This money can be composed of Dollars or any amount of change. At any particular time you might have no dollars in the register but only change, or both or vice versa. To represent this I created three tables. One for Currency, Dollars and Change. My database isset up so that there is a one to many relationship between the table CashRegister and Dollars. And also a one to many relationship between CashRegister and change.
Is this alright? Or is this somehow a circular reference?
 
CashRegister-----------CurrencyID(PK)
Dollars --> this table represents dollar amounts-------DollarsId(PK)typeOfCurrnecyAmount
Change --> this table represents coins------ChangeIdAmounttypeOfCurrnecy
MoneyType --> table Indicates the type of currency, change or dollars---------typeOfCurrnecy(PK)

View 5 Replies View Related

T-SQL (SS2K8) :: Circular Variable Reference

Mar 6, 2014

I'm going around in circles trying to visualise what's happening in this code,

declare @ReturnValue int, @ProcessFlag int
exec @ReturnValue=spGetProcessFlag @ProcessFlag output
select @ReturnValue as ReturnValue, @ProcessFlag as ProcessFlag

I get the feeling that the code runs spGetProcessFlag, and assigns the value to either @ReturnValue or @ProcessFlag.

By the way - next task is to direct SSIS whether to fail package or continue running.

View 1 Replies View Related

Circular Relationship-&&>can We Get Duplicate Records

Sep 20, 2006

Hi ,

I have two tables test1 and test2 .

Schema of table test1 is

A pk(primary key)

B

C fk (foreign key)

Schema of table test2 is

A

B pk

C fk

Table test1 and test2 have following relationships

1) test1.a pk -> test2.c fk

2) test2.b pk -> test1.c fk

Hence the two tables have circular relationship.

My question is when i query all rows of test1 based on a specific value of test1.a, can we get multiple rows in any case.

I am using following query to retrive the records:

select test1.* from A as A

inner join B on A.a=B.c

inner join A as AA on B.b= AA.c

where AA.a ='100'

Please let me know whether any duplicate row case is possible and if yes, please give any example.



Regards

View 1 Replies View Related

Transact SQL :: Find Circular Reference In The Table

Jun 1, 2015

Create table #tblActvity
(
activityIDvarchar (50),
activityParentIDvarchar(50)
)
Insert into #tblActvity
SElect '1',Null

[Code] ...

--If I pass activityId 3 or 2 or 4 it should return 0 as none of the activity is circular but If I pass 5, 6 or 7 it should return 1 as they have circular reference....

I need a sql qry which will require to find a circular reference in it.....

As in above sample of data ,If I pass activityId 3 or 2 or 4 to qry it should return 0 as none of the activity is circular but If I pass 5, 6  or 7 it should return 1 as they have circular reference....

View 4 Replies View Related

The SQL Server (SQLEXPRESS) Service Terminated With Service-specific Error 10013.

Jul 12, 2007

I have an almost virgin install of SQLExpres running on a WIN2K Pro system.

Have been able to create and connect db to Access 2000 without problem.



Now I wish to extend to remote connections. Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote.

Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors:



System Log:



The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013.



Application Log:



Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use.



TDSSNIClient initialization failed with error 0x271d, status code 0xa.



TDSSNIClient initialization failed with error 0x271d, status code 0x1.



Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.



SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.





If I change back to Local Connections Only or Local and Remote using named pipes only, the service starts up again without a problem.



After five days of investigating, researching, reinstalling and waiting I have to ask for help.



Any suggestions or leads?



Thank You in advance.

View 14 Replies View Related

An Error 1069 - )The Service Did Not Start Due To Logon Failure) Occurred While Performing This Service Operation ...

Oct 10, 2007

Hi All,

We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.

Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.

We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.

Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!

Error:

An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.


Regards,
Joseph

View 29 Replies View Related

SQL 2000 Reovery Fails Sometimes. Error Code (Error 3136). How To Make Database Write Mode?

Jan 7, 2008

Hello,

I am applying hourly differential backup to the backup server from production with the following command. This command makes the database on standby server into read only mode.


RESTORE DATABASE ARSYSTEM FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH MOVE 'arsystem' TO
'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
STANDBY = 'E:SQL backup from productionSQL daily diff back up'


Now I want to run a command which will put the database in write mode. I have created a job which would make the datbase Write mode. This job runs successfully sometimes and fails sometimes. I need to ensure that the job always succeeds. When it fails, how do I troubleshoot and what is the possible fix?

Thanks in advance.

The error message is

Cannot apply the backup on device 'E:SQL backup from productionSQL daily diff back up' to database 'ARSYSTEM'. [SQLSTATE 42000] (Error 3136) RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.


The steps for the job are as follows with the failing step highlighted in bold.


copy /y "\172.31.9.12Remedy BackupackupSQL backupsql_full_backup" "E:SQL backup from productionsql_full_backup"

copy /y "\172.31.9.12Remedy BackupackupSQL backupSQL daily diff back up" "E:SQL backup from productionSQL daily diff back up"

xp_cmdshell 'net stop "bmc remedy action request system server"'

exec rp_kill_db_processes 'ARSYSTEM'

RESTORE DATABASE ARSYSTEM

FROM DISK = 'E:SQL backup from productionsql_full_backup'

WITH

MOVE 'arsystem' TO 'd:ardataarsystem.mdf' ,

MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,

NORECOVERY


Failing step

RESTORE DATABASE ARSYSTEM

FROM DISK = 'E:SQL backup from productionSQL daily diff back up'

WITH

MOVE 'arsystem' TO 'd:ardataarsystem.mdf' ,

MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,

RECOVERY



xp_cmdshell 'del /f "E:SQL backup from productionsql_full_backup"'

xp_cmdshell 'del /f "E:SQL backup from productionsql daily diff back up"'

xp_cmdshell 'net start "bmc remedy action request system server"'





I have scheduled the following hourly diffential restore job too which never fails.

RESTORE DATABASE ARSYSTEM FROM DISK = 'E:SQL backup from productionsql_full_backup'
WITH MOVE 'arsystem' TO
'd:ardataarsystem.mdf' ,
MOVE 'arsystem_log' TO 'D:ARLOGARsystem' ,
STANDBY = 'E:SQL backup from productionSQL daily diff back up'
EXEC MASTER..XP_CMDSHELL 'del /f "E:SQL backup from productionSQL daily diff back up"'

View 12 Replies View Related

Who Can Tell Me What's Mean Of My Db Logfile?

May 13, 2004

In my database named aa ,there are always some words like this:


2004-05-12 09:44:48.96 spid73 Starting up database 'aa'
2004-05-12 09:44:49.17 spid73 Starting up database 'aa'
2004-05-12 09:44:49.36 spid73 Starting up database 'aa'
2004-05-12 09:44:49.56 spid73 Starting up database 'aa'
2004-05-12 09:44:53.37 spid79 Starting up database 'aa'
2004-05-12 10:02:41.96 spid73 Starting up database 'aa'.
2004-05-12 10:02:42.24 spid73 Starting up database 'aa'.
2004-05-12 10:02:43.61 spid73 Starting up database 'aa'.
2004-05-12 10:02:43.80 spid73 Starting up database 'aa'.
2004-05-12 10:02:44.02 spid73 Starting up database 'aa'.
2004-05-12 10:02:44.24 spid73 Starting up database 'aa'.
2004-05-12 10:36:42.84 spid82 Starting up database 'aa'.

who can tell me how to resolve this problem?

View 2 Replies View Related

What If The Logfile(s) Are Lost?

Nov 27, 2000

Hi, maybe someone has some clues to the following situation. Suppose from a SQL 7 database, only the log .ldf files are lost. All datafiles are present. Suppose there is no backup of this database. SQL Server will put the database in the SUSPECT status. The following question is very interesting to me: Can one recover from this situation??? I ask this, because when datafiles are lost, it's obvious that you have lost data, but since the transaction log files are a "bit special", I just wonder how one can survive such a situation.
I know that IF a database has only ONE log file associated with it, and this one log file gets lost, SQL Server will create on startup a new log file. But with multiple log files, it does not behave in this sympathic manner. Is there perhaps any way to recover (for example, an undocumented dbcc command or so) ?
I surely will appreciate any tip or suggestion !! Thanks!!!

View 1 Replies View Related

Shrink Logfile ?

Jun 9, 2000

How do I shrink my transaction log file ? The physical file are 10Gb in size but only contains 100Mb data so I want to shrink it to save diskspace. I tried DBCC SHRINKFILE command but the file dont shrink.

Any other methods to shrink a transaction log file ? Like backup/restore ?

Help !




Thanks

View 2 Replies View Related

How To Clear The Logfile

Jan 15, 2006

Hello guys!

I would like to clear the logfile. Could anybody tell me how to do this?
What I would like most would be to run SQL-Server without any log-file (while development). But I suppose that this is not possible.

Regards,
Fabian

my favorit hoster is ASPnix : www.aspnix.com !

View 3 Replies View Related

Erase LogFile

Feb 14, 2006

How to erase the content of logfile?

View 2 Replies View Related

Truncate Logfile

Feb 3, 2007

Dear all,

I am using SAP with MSSQl 2005. My transaction logfile is full. I took backup of transaction logfile and it should be truncated and shrink after the backup, but it did nothing. There is no error but the file size remain same.

I tried from SQL server management studio selecting database--right click--shrink--file. Then i try to release unused space, shrink, but not worked.

I also checked these steps while the SAP system was stopped.

Can anyone guide me what to do now?

Thanks

Imran Hasware

View 5 Replies View Related

DB Write Error

Aug 10, 2005

Hi, Any info will be greatly appreciated to fix this issue.

I am getting the following errors in my event log.
Error: 823, Severity: 24, State: 2
I/O error 2(The system cannot find the file specified.) detected during read at offset 0x00000004f7e000 in file 'F:Program FilesMicrosoft SQL ServerMSSQLDataPENANGwiptrack_targetpng_data2.ndf'.

I am getting these error when I run DBCC:

Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:9944) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9945) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9946) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9947) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9948) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9949) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9950) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:9951) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10168) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10169) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10170) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10171) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10173) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10174) with latch type UP. 2(The system cannot find the file specified.) failed.
DBCC results for 'PNG_TARGET'.
Server: Msg 8966, Level 16, State 2, Line 1
Could not read and latch page (3:10175) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10176) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10177) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10178) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10179) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10180) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10181) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10182) with latch type UP. 2(The system cannot find the file specified.) failed.
Server: Msg 8966, Level 16, State 1, Line 1
Could not read and latch page (3:10183) with latch type UP. 2(The system cannot find the file specified.) failed.
CHECKDB found 0 allocation errors and 23 consistency errors not associated with any single object.
DBCC results for 'sysobjects'.
There are 215 rows in 10 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 220 rows in 14 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1390 rows in 78 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 187 rows in 64 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 4 rows in 1 pages for object 'sysfiles1'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:87967) is missing a reference from previous page (3:10176). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Page (1:88969) is missing a reference from previous page (3:10183). Possible chain linkage problem.
DBCC results for 'syspermissions'.
There are 221 rows in 4 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 255 rows in 4 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 570 rows in 8 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 1 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 1 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 'TblReject'.
There are 396620 rows in 10949 pages for object 'TblReject'.
DBCC results for 'TblBoxGroup'.
There are 22669 rows in 380 pages for object 'TblBoxGroup'.
DBCC results for 'TblCustShipment'.
There are 4425 rows in 83 pages for object 'TblCustShipment'.
DBCC results for 'TblFlowDetail'.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10176) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 10 refers to child page (3:10176) and previous child (3:10177), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10177) allocated to object ID 421576540, index ID 8 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 421576540, index ID 8. Page (3:10177) was not seen in the scan although its parent (1:90702) and previous (1:87966) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10178) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 13 refers to child page (3:10178) and previous child (3:10179), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10179) allocated to object ID 421576540, index ID 8 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 421576540, index ID 8. Page (3:10179) was not seen in the scan although its parent (1:90702) and previous (1:87967) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10180) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 14 refers to child page (3:10180) and previous child (3:10178), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10181) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 15 refers to child page (3:10181) and previous child (3:10180), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10182) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 16 refers to child page (3:10182) and previous child (3:10181), but they were not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10183) allocated to object ID 421576540, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8980, Level 16, State 1, Line 1
Table error: Object ID 421576540, index ID 8. Index node page (1:90702), slot 17 refers to child page (3:10183) and previous child (3:10182), but they were not encountered.
There are 523629 rows in 9233 pages for object 'TblFlowDetail'.
CHECKDB found 0 allocation errors and 18 consistency errors in table 'TblFlowDetail' (object ID 421576540).
DBCC results for 'TblJob'.
There are 18895 rows in 623 pages for object 'TblJob'.
DBCC results for 'TblRejectDetailCross'.
There are 0 rows in 0 pages for object 'TblRejectDetailCross'.
DBCC results for 'TblStationChkPoint'.
There are 298610 rows in 6273 pages for object 'TblStationChkPoint'.
DBCC results for 'ci_control_TblBoxGroup'.
There are 0 rows in 1 pages for object 'ci_control_TblBoxGroup'.
DBCC results for 'ci_control_TblCustomer'.
There are 0 rows in 0 pages for object 'ci_control_TblCustomer'.
DBCC results for 'TblLine'.
There are 7 rows in 1 pages for object 'TblLine'.
DBCC results for 'ci_control_TblCustShipment'.
There are 0 rows in 1 pages for object 'ci_control_TblCustShipment'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:65650) is missing a reference from previous page (3:9950). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:80141) is missing a reference from previous page (3:9949). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:81931) is missing a reference from previous page (3:9948). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:88745) is missing a reference from previous page (3:9944). Possible chain linkage problem.
DBCC results for 'ci_control_TblDefect'.
There are 0 rows in 1 pages for object 'ci_control_TblDefect'.
DBCC results for 'ci_control_TblFlowDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblFlowDetail'.
DBCC results for 'TblStationQty'.
There are 487814 rows in 8946 pages for object 'TblStationQty'.
DBCC results for 'TblMachine'.
There are 5 rows in 1 pages for object 'TblMachine'.
DBCC results for 'ci_control_TblJob'.
There are 0 rows in 1 pages for object 'ci_control_TblJob'.
DBCC results for 'ci_control_TblJobDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblJobDetail'.
DBCC results for 'TblOperator'.
There are 470 rows in 7 pages for object 'TblOperator'.
DBCC results for 'ci_control_TblLine'.
There are 0 rows in 0 pages for object 'ci_control_TblLine'.
DBCC results for 'TblOperatorGroup'.
There are 22 rows in 1 pages for object 'TblOperatorGroup'.
DBCC results for 'TblTransaction'.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:91159) is missing a reference from previous page (3:9945). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:95791) is missing a reference from previous page (3:9951). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (1:857249) is missing a reference from previous page (3:9946). Possible chain linkage problem.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 4. Page (3:9630) is missing a reference from previous page (3:9947). Possible chain linkage problem.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9944) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9944) was not seen in the scan although its parent (1:86516) and previous (3:10996) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9945) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9945) was not seen in the scan although its parent (1:862260) and previous (1:81719) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9946) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9946) was not seen in the scan although its parent (1:2888) and previous (1:39804) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9947) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9947) was not seen in the scan although its parent (1:858889) and previous (1:84220) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9948) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9948) was not seen in the scan although its parent (1:51120) and previous (1:81279) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9949) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9949) was not seen in the scan although its parent (1:81180) and previous (1:79351) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9950) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9950) was not seen in the scan although its parent (1:51120) and previous (1:65448) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:9951) allocated to object ID 768057822, index ID 4 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 768057822, index ID 4. Page (3:9951) was not seen in the scan although its parent (1:60668) and previous (1:87177) refer to it. Check any previous errors.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:921) is missing a reference from previous page (3:10169). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:17475) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:55333) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:58600) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:66724) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73049) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:73183) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:77526) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:80853) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:82680) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:83104) is missing a reference from previous page (3:10170). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:83310) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:85752) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:87603) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:91416) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:91418) is missing a reference from previous page (3:10173). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:92037) was not encountered.
Server: Msg 8979, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:92278) is missing references from parent (unknown) and previous (page (3:10168)) nodes. Possible bad root entry in sysindexes.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:94476) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:98109) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:99231) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:100289) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:103626) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:104154) is missing a reference from previous page (3:10175). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:104303) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:107339) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:110106) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:985785) is missing a reference from previous page (3:10174). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989636) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989637) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989638) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989639) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989640) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989641) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989642) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989643) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989644) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989645) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989646) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989647) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989648) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989649) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989650) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989651) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989652) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989653) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989654) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989655) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989656) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989657) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989658) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989659) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989660) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989661) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989662) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989663) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989664) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989665) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989666) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989667) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989668) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989669) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989670) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989671) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989672) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989673) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989674) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989675) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989676) was not encountered.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (1:989677) was not encountered.
Server: Msg 8978, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Page (1:990949) is missing a reference from previous page (3:10171). Possible chain linkage problem.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:4460) was not encountered.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10168) allocated to object ID 768057822, index ID 8 was not seen. Page may be invalid or have incorrect object ID information in its header.
Server: Msg 8981, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. The next pointer of (1:83310) refers to page (3:10168). Neither (3:10168) nor its parent were encountered. Possible bad chain linkage.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10169) allocated to object ID 768057822, index ID 8 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 768057822, index ID 8. Page (3:10169) was not seen in the scan although its parent (1:9152) and previous (1:989626) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10170) allocated to object ID 768057822, index ID 8 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 768057822, index ID 8. Page (3:10170) was not seen in the scan although its parent (1:76565) and previous (1:83980) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10171) allocated to object ID 768057822, index ID 8 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 768057822, index ID 8. Page (3:10171) was not seen in the scan although its parent (1:925) and previous (1:34912) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10173) allocated to object ID 768057822, index ID 8 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 768057822, index ID 8. Page (3:10173) was not seen in the scan although its parent (1:76565) and previous (1:78785) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10174) allocated to object ID 768057822, index ID 8 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 768057822, index ID 8. Page (3:10174) was not seen in the scan although its parent (1:985742) and previous (1:80575) refer to it. Check any previous errors.
Server: Msg 2533, Level 16, State 1, Line 1
Table error: Page (3:10175) allocated to object ID 768057822, index ID 8 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 768057822, index ID 8. Page (3:10175) was not seen in the scan although its parent (1:88169) and previous (1:83978) refer to it. Check any previous errors.
Server: Msg 8977, Level 16, State 1, Line 1
Table error: Object ID 768057822, index ID 8. Parent node for page (3:10339) was not encountered.
There are 4277643 rows in 97804 pages for object 'TblTransaction'.
CHECKDB found 0 allocation errors and 111 consistency errors in table 'TblTransaction' (object ID 768057822).
DBCC results for 'ci_control_TblLot'.
There are 0 rows in 1 pages for object 'ci_control_TblLot'.
DBCC results for 'ci_control_TblMachine'.
There are 0 rows in 0 pages for object 'ci_control_TblMachine'.
DBCC results for 'ci_control_TblOperator'.
There are 0 rows in 1 pages for object 'ci_control_TblOperator'.
DBCC results for 'ci_control_TblOperatorGroup'.
There are 0 rows in 0 pages for object 'ci_control_TblOperatorGroup'.
DBCC results for 'TtmpTransaction'.
There are 0 rows in 0 pages for object 'TtmpTransaction'.
DBCC results for 'TblCPQWeekNbr'.
There are 53 rows in 1 pages for object 'TblCPQWeekNbr'.
DBCC results for 'ci_control_TblPartDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblPartDetail'.
DBCC results for 'TblCPQYearNbr'.
There are 180 rows in 1 pages for object 'TblCPQYearNbr'.
DBCC results for 'TblKitModSNRship'.
There are 472666 rows in 5462 pages for object 'TblKitModSNRship'.
DBCC results for 'ci_control_TblPartSupplier'.
There are 0 rows in 0 pages for object 'ci_control_TblPartSupplier'.
DBCC results for 'TblShift'.
There are 3 rows in 1 pages for object 'TblShift'.
DBCC results for 'ci_control_TblReject'.
There are 0 rows in 1 pages for object 'ci_control_TblReject'.
DBCC results for 'ci_control_TblRejectDetail'.
There are 0 rows in 1 pages for object 'ci_control_TblRejectDetail'.
DBCC results for 'ci_control_TblShift'.
There are 0 rows in 0 pages for object 'ci_control_TblShift'.
DBCC results for 'ci_control_TblStation'.
There are 0 rows in 1 pages for object 'ci_control_TblStation'.
DBCC results for 'ci_control_TblStationChkPoint'.
There are 0 rows in 1 pages for object 'ci_control_TblStationChkPoint'.
DBCC results for 'ci_control_TblStationQty'.
There are 3 rows in 1 pages for object 'ci_control_TblStationQty'.
DBCC results for 'ci_control_TblTester'.
There are 0 rows in 0 pages for object 'ci_control_TblTester'.
DBCC results for 'ci_control_TblTransaction'.
There are 0 rows in 1 pages for object 'ci_control_TblTransaction'.
DBCC results for 'TblCustomer'.
There are 7 rows in 1 pages for object 'TblCustomer'.
DBCC results for 'TblTester'.
There are 16 rows in 1 pages for object 'TblTester'.
DBCC results for 'ci_control_TblKitModSNRship'.
There are 0 rows in 1 pages for object 'ci_control_TblKitModSNRship'.
DBCC results for 'ci_control_TblSystemBuild'.
There are 1 rows in 1 pages for object 'ci_control_TblSystemBuild'.
DBCC results for 'TblRejectDetail'.
There are 104402 rows in 2403 pages for object 'TblRejectDetail'.
DBCC results for 'TblJobDetail'.
There are 1107946 rows in 23608 pages for object 'TblJobDetail'.
DBCC results for 'TblPartSupplier'.
There are 79 rows in 1 pages for object 'TblPartSupplier'.
DBCC results for 'TblDefect'.
There are 21113 rows in 337 pages for object 'TblDefect'.
DBCC results for 'png_ci_TblRowCount'.
There are 24 rows in 1 pages for object 'png_ci_TblRowCount'.
DBCC results for 'TblTbSetup'.
There are 1 rows in 1 pages for object 'TblTbSetup'.
DBCC results for 'TblStationQty1'.
There are 61755 rows in 974 pages for object 'TblStationQty1'.
DBCC results for 'TtmpStationProdLoad'.
There are 57 rows in 1 pages for object 'TtmpStationProdLoad'.
DBCC results for 'TblPartDetail'.
There are 3053 rows in 93 pages for object 'TblPartDetail'.
DBCC results for 'TblLot'.
There are 515677 rows in 11268 pages for object 'TblLot'.
DBCC results for 'TblStation'.
There are 474 rows in 11 pages for object 'TblStation'.
DBCC results for 'TblSystemBuild'.
There are 128623 rows in 2362 pages for object 'TblSystemBuild'.
DBCC results for 'dtproperties'.
There are 0 rows in 1 pages for object 'dtproperties'.
DBCC results for 'TblEqMaster'.
There are 0 rows in 1 pages for object 'TblEqMaster'.
DBCC results for 'TblEqMasterSNRShip'.
There are 0 rows in 1 pages for object 'TblEqMasterSNRShip'.
CHECKDB found 0 allocation errors and 152 consistency errors in database 'PNG_TARGET'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (PNG_TARGET ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

View 4 Replies View Related

Establishing Logfile Size And % Used Using Sql

Apr 27, 2001

Hi there,

I want to write a sql query (for SQL7 & 2K) that gives the size and space used of the log file for a given database. I can do it for data files using sysfiles/sysindexes, but can see how I can do it for the logfile.

I know I can use DMO or dbcc sqlperf(logspace), but I want to understand how and where the information is kept in system tables.

View 2 Replies View Related

Logfile Lost In HDD Crash

Dec 18, 2000

Hi, i am not familiar with MSSQL so maybe it's not as difficult to you as it is to me - in brief:

SQL version: Microsoft SQL Server 7.00 - 7.00.699 (Intel X86)

Errorlog shows:
Starting up database 'CH2'.
Opening file E:CH2DATA1CH2DATA1.mdf.
Opening file E:CH2DATA2CH2DATA2.ndf.
Opening file E:CH2DATA3CH2DATA3.ndf.
File D:CH2LOG1CH2LOG1.ldf does not exist - unable to activate.

Enterprise Manager
Shows database CH2 (suspect)

Executing script:
sp_add_log_file_recover_suspect_db CH2, CH2LOG1, 'D:CH2LOG1CH2LOG1.ldf', 1000
Shows errormessage "The database 'CH2' does not exist."

How can i get a new logfile?
What if i created a new db 'CH2' and then replaced the data files?
What do i have to tell MSSQL to create a new logfile on startup?
All scenarios shown in Books On Line only seem to solve problems
if you do have a logfile and need more space.

Greetings from Switzerland /Lothar

View 2 Replies View Related

Moving LogFile From One Disk To Another

Apr 11, 2002

I am trying to move a logfile from one disk to another. I've detached the database, moved the logfile to another disk and reattached the database. I used the sp_detach and sp_attach_db to specify the paths of the *.MDF and *.LDF. I've tried it through Enterprise Manager and with boths ways I get an error message saying: "Error 9003: The LSN (201:48:2) passed to log scan in database 'DatabaseName' is invalid". Does anyone know what this means and how I can get around this. I've even tried to attach the database with the logfile in the original path and I still get that error. Need Help Please!

Thanks

View 2 Replies View Related

Hughe Logfile After A DELETE

Feb 3, 2004

Hi

I have a business case where I have a database with a size of 2 GB. In my business case I want to delete 70% of the contents in the database. During the delete the size of the database(including the logfile) grows up to 10 GB. When I look on the database in the SQL Server Enterprice Manager there are only 700 MB used of these 10 GB.

The deletes are performed with ordinary SQL-statements "DELETE FROM X WHERE Y = 1 AND Z = 2..."

Thankfull for hints on how to solve this problem.

Regards,
Peter

View 14 Replies View Related

Automatic Logfile Truncation

Apr 10, 2008

Gurus,

Everyweek I am truncating the logfiles. I want to automate the truncate logfiles on every sunday. Anyone can help me to automate this process..

Thanks
-- Krishna

View 15 Replies View Related

Deleting Records In The Logfile

Jul 20, 2005

I have a database that is used to store a lot of data. We load the data on adaily basis, several thousand records per day. The Log file is not needed,so whats the best way to delete the records in it and reduce the sizeThanksDerrick

View 1 Replies View Related

Shriking Logfile Using WIZARD

Mar 31, 2008



Hi All


What is the Database ->All Tasks -->ShrikDatabase ->Files --> in ShrikAction Shrikfile to ...Here there is minium MB

what is the Minimum MB,If I shrik the Log file minimum MB is there any possiblility to loss data.

View 4 Replies View Related







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