Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Error 25115 Wrong Page (potential Database Corruption). Try Running The Repair Utility.


 

Hi,
 
Please Help, I am very desparate for a solution to this one.
 
  I have an error appearing

"Error 25115 Wrong Page (potential database corruption). Try Running the Repair Utility."
 
I have SQL Server Enterprise set up with Merge replication, it is being used to Sync with Windows Mobile Devices as the subscribers.
 
All the Windows Mobile subscribers have been synchronising fine up until recently, when 1 of the Subscribing Windows Mobile devices received this error.
The day after, another device Synchronised fine the first time (note that the Synchronisation was a long one and the SDF grew in size dramatically while the synchronisation occured, but the Sync worked fine and the SDF dropped back to its initial size) The 2nd sync 5 mins later failed however so this Mobile device has the same error also.
 
Any suggestions as to the below are much appreciated

a) Why this error occurs?
b)How do you resolve this error?
c)What is the Repair utility mentioned in the error, and is it of use to me?

 
Thanks in advance, I am very greatful for any advice.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Error Message &&"Run Repair Utility&&" When Using Sqlceengine.repair
 

Hi there.
 
I have a corrupt .sdf database sat on a SD Card but i am unable to find a way to repair it.
 
So far I have tried a few different methods, most of which just tell me what i already know i.e. "the database is corrupt and needs repairing!!"
 
I am unable to open the file in SSMS object browser (see above message) which means i cant run repair / shrink utilites.
I am also unable to add the database to a vs2005 project (again see above message) meaning again i can't run any repair utilities.
 
I have also tried using the compact / Repair utility in Query analyser 3.0 on my Windows Mobile 5.0 PDA but once again i am greeted with an "error reading file - Run the Repair Utility" Message.
 
Lastly i've tried using the SQLCEengine.repair method and, depending on whether i do it on the PDA or on a desktop pc it throws the exceptions "Error occurred reading database file - run the repair utility"(PDA) or "invalid database type" (PC)
 
Can anyone shed any light as to whether there is another (easier???) way of doing this or if i just have to face it that this file is lost?
 
Thanks
 
ps. the code i used for the .repair is as below:

 

Dim conn As SqlCeEngine

Dim strdb As String

 

strdb = "SD CardPathnameDatabase.sdf"

 

conn = New SqlCeEngine(String.Format("Data Source={0}", strdb))
 

If conn.Verify = False Then

conn.Repair(Nothing, RepairOption.RecoverCorruptedRows)

MsgBox("Successfully Repaired")
 

End If

 

View Replies !   View Related
Get Error After Running SQL Database/Object Transfer Utility
After moving a database from one server to another using this utility, I get the error message

In file APPLIX7DEV.applix_database.PRV in statement on line 13
Transfer Status: Creating Permissions on destination database
Attempt to insert duplicate row in table 'sysprotects' with index 'sysprotects' in database
'applix_development_database'. Could drop and recreate
index with ignore duprow or allow duprow.

Should I be concerned?

Other then that it seemed to perform fine. Now I should note that this operation was performed after
issuing a checkpoint and truncate_only on the source database. Is there something else I should be concerned
about (i.e like matching fragment information - note the source database is on one device with its transaction log on a seperate
device and dido for the target database)?

View Replies !   View Related
The Database File May Be Corrupted. Run The Repair Utility To Check The Database File. [ Database Name = SDMMC Storage Cardwinp
 yes,I have an error, like 'The database file may be corrupted. Run the repair utility to check the database file. [ Database name = SDMMC Storage Cardwinpos_2005WINPOS2005.sdf ]'  .I develope a program for Pocket Pcs and this program's database sometimes corrupt.what can i do?please help me

View Replies !   View Related
Error While Running Bcp Utility
Hi all,

I m getting the following error while running the bcp utility.

Cannot insert null into column_name in table

something like this.

The value for that column is null in the input .csv file.

Instead of throwing error like this, i need those bad records should go in to the .BAD file and the remaining records should get uploaded into the database.

In my case the entire data upload is failing if any one bad record is there in the .csv file.

Can anybody help me. Its a bit urgent.

Thanks in advance,
Bharanidharan L

View Replies !   View Related
Error Running SSIS Pkg From Dtexec Utility
Hi All,

I developed my package in BI studio and tested runnning it through BI. Now when i have to deploy the package to main server it will be executed via batch job. This package requires an input file name too.
Now when i am trying to run the package on my loacal box using following command on command prormpt i get error given below.

COMMAND USED BY ME: DTExec /FILE 'C:ProjectIntegrationServicesSFRIntegrationServicesinpkgSFRLocation.dtsx' /SET Package.Variables[InputParamFileName].Value;'C:DataDumpInputLOC00022'

ERROR MESSAGE:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 1:29:54 PM
Error: 2008-02-22 13:29:54.96
Code: 0xC0011007
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Unable to load the package as XML because of package does not ha
ve a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2008-02-22 13:29:54.96
Code: 0xC0011002
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Failed to open package file "'C:ProjectIntegrationServicesSFR
IntegrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The speci
fied path is invalid.". This happens when loading a package and the file cannot
be opened or loaded correctly into the XML document. This can be the result of
either providing an incorrect file name was specified when calling LoadPackage o
r the XML file was specified and has an incorrect format.
End Error
Could not load package "'C:ProjectIntegrationServicesSFRIntegrationServices
inpkgSFRLocation.dtsx'" because of error 0xC0011002.
Description: Failed to open package file "'C:ProjectIntegrationServicesSFRInt
egrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The specifie
d path is invalid.". This happens when loading a package and the file cannot be
opened or loaded correctly into the XML document. This can be the result of eit
her providing an incorrect file name was specified when calling LoadPackage or t
he XML file was specified and has an incorrect format.
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Started: 1:29:54 PM
Finished: 1:29:54 PM
Elapsed: 0.047 seconds

PLease let me know solution to creating batch job for executing this pkg with input param.

View Replies !   View Related
Repair Torn Page?
I have inherited a poorly administered/maintained database thatcontains the following error:"I/O error (torn page) detected during read at offset 0x000018ee23e000in file 'F:Program FilesISSRealSecure SiteProtectorSiteDatabaseDataRealSecureDB.mdf"I do not have database backups and so therefore cannot restore fromthem. I want to move the database to a new platform and somehowrepair the torn page. Is this possible?

View Replies !   View Related
How To Repair Torn Page On SQL Data File?
I got help from Dan Guzman on how to set single-user-mode.Thank you very much.After seting single-user-mode, I run DBCC CHECKDB('MYDATABASE',REPAIR_REBUILD)Tehre are error messages.How can I repair torn page problem?Thanks.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related
Q About Running DBCC CHECKDB With Repair On MSDB
The DB I'm working with has some corruption in the msdb database, which is affecting job histories and logs (among other things). DBCC checkdb returns that all the other DBs are OK.

Q: Are there any issues or dangers I need to be aware of in running DBCC checkdb on the msdb database - in particular, can I run it with the repair_allow_data_loss option, and if I do, what are the likely ramifications?

Thanks for your help!

View Replies !   View Related
Running A SQL File From OSQL Command Line Utility
Hi,I have dumped a very large database from mysql (using mysqldump program)as a raw sql file. The reason was, convert this database to a MSSQLdatabase. Since mysqldump creates the file as raw sql file with thedatabase-table structures and the data in it, I thought using OSQL commandline utilities should work to out this whole database in MSSQL server.I have run this command from command line:osql -u sa -i mysqldump.sqlIt is going since yesterday. It has been almost 36 hours that it'sstarted. And in the mssql server, I see no database created yet. On thescreen of the command line, I see bunch of numbers are going in order. Iassume they are row numbers of the tables processed. But, if it is doing it,then where is it saving all this data ? I have checked the tempdb, pub db,other dbs, and I see no tables related to the database I am inserting. Willit populate it at the and of the job ? Or, am I doing something wrong here?Regards.Murtix.

View Replies !   View Related
Database Repair - Need Help Please!
I started getting errors everytime i try to access my webmail(horde), my zencart and my forum so i asked my website host and they say i need to repair the SQL database. I have no idea what this means, can someone help please?

The errors are:

Horde: A fatal error has occurred
Could not connect to database for SQL SessionHandler.
Details have been logged for the administrator.

Zencart: 0 DB_ERROR_NOT_CONNECTED
in:
[db_cache table]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

SMF Forum: Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

Please help, i am totally lost!

View Replies !   View Related
Page 2 - What Am I Doing Wrong?
Quote: Originally Posted by mustangman So my next question is, how would you write the SQL for this? It's a simple INNER JOIN. Since you are currently learning all of this, I'm going to give you time to research that a bit and try it out for yourself Ask if you have questions.


More specifically, your homework is this

I want the first and last name of an employee and the first and last name of his boss

View Replies !   View Related
Potential Image Problem -- Error
Hello guys,

 

I am trying to find a solution to this problem.

 

Background:

 

1.  I start with a blank 2005 DB

2.  Restore backup of 2000DB to blank 2005 db with overwrite.

3   Make some minor updates to schema of new 2005 db.

4  Configure Queue and Service for SQL Notifications.

5.  Manually update compatibility to 90 (2005) because SQL Notifcation will not work properly when Compatibility set to 80(2000).  note:  Step 1 starts at 90, but restore resets it to 80.

6  Alter DB owner to SA

7.  Run app with SQL notifications and get this error is the SQL log:

 

    "Potential Image Problem at 07x801AD0:  read 0xE9 instead of 0x8B"

 

An Exception is also thrown:

 

    "A severe error occurred with the current command.  The result set, if any, should be discarded."

 

Error level is 20.

 

 

Thanks for any help.

 

Scott

View Replies !   View Related
How To Repair Sql Table - Error In DTS
I have schedule DTS to import every day few tables. It had been workinggreat and had no problem. All of a sudden I started getting this error.ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THETASK. 1 UNIDENTIFIED ERROR.Thanks.

View Replies !   View Related
Compact And Repair Database
I'm an Access man moving towards SQL Server and I'm interested in knowing if there is a utility for my SQL Server version 7 database that is similar to Access' Compact and Repair utility? I'd like a recommendation from a guru on what Prevenatative Maintenance measures I should be running daily/weekly/monthly etc...

Thanks in advance.
dog

View Replies !   View Related
Repair Corrupted Database?
I am backing up SQL 6.5 DB using Backup Exec 7.2 on NT 4.0 server SP4 with SQL server agent. The backup job ends in Failed status and a warning that DBname is corrupt. I then try to run DBCC Checkdb, newalloc, and checkcatalog commands to repair the DB. No further ahead yet. Are there any other commands that I can perform on the DB so that the corruption can be repaired, or verified there indeed is corruption of DB?

View Replies !   View Related
Compact And Repair Database ?
I want to use function "Compact and repair database" in SQL Server2000 which like function Access 2003.
How can i do ?
Thank you very much.

View Replies !   View Related
Suspect Database - How To Retrieve And Repair
Running SQL 7, Standard version. I had a database marked 'suspect'. I copied the MDF and LDF files to another directory, then deleted the suspect database. I tried to create a new database and attach the MDF file to it. It did not work. Any other ideas? I have no other backups of the data. I am willing to pay for consulting over the phone if necessary.

View Replies !   View Related
Repair Database And Delete Transaction Log
How can I repair the database (5 gb) and remove the transaction log (45 gb). Whenever I run the maintanence wizard, it corrupts the db and I have to restore the db. Whenever I try to shrink the transaction log, the query runs but it doesn't shrink it at all. Is there a manual method for either of these and if so, how?

View Replies !   View Related
Error Using Verify/Repair Methods Of SqlCeEngine
I have a compact pc program that uses a sql server database (sdf file).
I want to check the database integrity when program starts so I added a call to veriy method of SqlCeEngine.

The verify function always returns false even the database is OK and I can work with it.

when I call repair it throws the exception : "The specified module could not be found"

The code is :

string connectionString = "Data Source = '" + m_dbFullName + "'";

SqlCeEngine engine = new SqlCeEngine(connectionString);

if(engine.Verify() == false)

{

 engine.Repair(null, RepairOption.RecoverCorruptedRows);

}

The database exists and the path to it is correct:

dbFullName  = "\program files\MyApp\MyDB.sdf"

I also tried out some different connection strings but it did not help:

"Data Source = ' MyDB.sdf  '"

"Data Source = 'MyDB.sdf  "

"Data Source=' MyDB.sdf  '"

"Data Source=MyDB.sdf"

Please any one can help me with this ???????????????????

View Replies !   View Related
Potential Loss Of Data Error On Flat File Source
 

I'm getting a very strange potential loss of data error on my flat file source in the data flow.  The flat file is fixed width and the column in question is defined as numeric [DT_NUMERIC].  The transform runs great if this column IS NOT A ZERO.  As soon as a zero value is found, I get the error. It errors on the flat file source, so I haven't been able to use a data viewer to see what's going on.
 
Please Help!?
 
Thanks,
Scott Mescall

View Replies !   View Related
Repair Northwind Database In SQL Server Management Studio Express
Hi all,

Long time ago, I downloaded the Northwind and pubs databases from the Microsoft website (I do not remember the details of it)  and installed these two databases together into the SQL Server Management Studio Express of my PC (Microsoft Windows XP Pro). I tried to learn an example of using "User Instance" (source code was from a book) on the Northwind database located in my SQL Server Management Studio Express.  I just find out that my Northwind database has the title only and no tables at all. If I click on the "+" in front of the "Northwind", I got the following error message:

       Microsoft SQL Server Management Studio Express

     

        Failed to retrieve data for this request.(Microsoft SqlServer.Express.SmoEnum)

 

        Additional information:

         One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from backup. (Microsoft SQL Server, Error: 5173)..

 

Please help and tell me how I can repair this Northwind database in my  SQL Server Management Studio Express.

 

Scott Chang

 

P. S.

 

I deleted the name 'Northwind' in my SQL Server Management Studio Express,  executed the "SQL2005DBScriptsInstnwind" program and I got the following error message:    Msg 1802, Level 16, State 4, Line 1

                   CREATE DATABASE failed. Some file name listed could not be created. Checked related errors.

                   Msg 5170, Level 16, state 1, Line 1

                   Cannot create file 'c:Program FilesMicrosoft SQL ServerMSSQL.1DATAorthwindorthwind.ldf' because it already exist. Change the file path or the file name, and retry the operation.

                   Msg 15100, Level 16, State 1, Procedure sp_dboption, Line 64

                   The database 'Northwind' does not exist. Use sp_helpdb to show available database.

                   Msg 911, Level 16, State 1, Line 1

                   Could not locate entry in sysdatabases for database 'Northwind'. No entry found with that name. Make sure that name is entered correctly  

View Replies !   View Related
DataAdapter.Update Is Running This Query... What Is Wrong With It?
My DataAdapter.Update() Method is running this query against my database and all the parameters and the formatting looks correct to me.  I was wondering if anyone could identify obvious errors....  Thanks!
 
exec sp_executesql
N'NewUpdateCommand',
N'@Name nvarchar(50),
@PriContactFName nvarchar(50),
@PriContactLName nvarchar(50),
@PriContactWork nvarchar(20),
@PriContactFax nvarchar(20),
@PriContactCell nvarchar(20),
@PriContactEmail nvarchar(50),
@MainOfficeLocationAddr1 nvarchar(50),
@MainOfficeLocationAddr2 nvarchar(50),
@MainOfficeLocationCity nvarchar(50),
@MainOfficeLocationState nvarchar(50),
@MainOfficeLocationZip nvarchar(15),
@Description nvarchar(50),
@Original_ClientID int,
@ClientID int',
@Name=N'Brinker International',
@PriContactFName=N'Steves',
@PriContactLName=N'Maubley',
@PriContactWork=N'913-876-9876',
@PriContactFax=N'913-098-8765',
@PriContactCell=N'913-987-7654',
@PriContactEmail=N'a@b.c',
@MainOfficeLocationAddr1=N'1234 Burkwood',
@MainOfficeLocationAddr2=NULL,
@MainOfficeLocationCity=N'Tallahassee',
@MainOfficeLocationState=N'Florida',
@MainOfficeLocationZip=N'99111',
@Description=N'This is a good client.',
@Original_ClientID=1,
@ClientID=1
 Msg 102, Level 15, State 1, Line 15
Incorrect syntax near 'NewUpdateCommand'.

View Replies !   View Related
Flat File -&&> Table: Error Using I/E Wiz, Date..could Not Be Converted..potential Loss Of Data
 

The following error is encountered when importing a delimited flat file with date of fomat "dd.mm.yyyy"

 

Error: 0xC02020A1 at Data Flow Task, Source - DCDtest_xpt [1]: Data conversion failed. The data conversion for column "value date" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

 

This was when I manually built the package.

I get the same error when using the Import/Export wizard

 

I am even using the "suggest types" button and have tried sampling the default number of rows (?200) and also 2000.

 

The type it suggests is DT_DATE.

But reading the BOL, this would appear to be the wrong type:

http://msdn2.microsoft.com/en-us/library/ms141036.aspx (obviously the right hand doesn't know what the left hand is doing)

 

seems to indicate that

DT_DBTIMESTAMP

is the correct value

(I cannot believe that they have different datatypes in SSIS than in SQL. I can't believe for a minute this is for all the hundreds of thousands of Oracle users who obviously switched to SSIS when they saw what a high quality product it is.)

 

I tried other DT_... values but no dice.

 

Can anyone help?

 

 

I always thought that Classic ASP was the worst product I've ever worked with from the Microsoft stable, but I was wrong.

I am fed up of having to post on this board (no wonder it is so 'popular')

Talking to peers, reading books, googling nearly always enables me to figure out a problem with any application I have ever used, but SSIS breaks the mould in sheer crapness and the weirdnes and unfathomability of its cryptic errors,.

Rant over (for today)

 

View Replies !   View Related
Running A Large Number Of SSIS Packages (with Dtexec Utility) In Parallel From A SQL Server Agent Job Produces Errors
Hi,
 
I have stumbled on a problem with running a large number of SSIS packages in parallel, using the €œdtexec€? command from inside an SQL Server job.
 
I€™ve described the environment, the goal and the problem below. Sorry if it€™s a bit too long, but I tried to be as clear as possible.
 
The environment:
Windows Server 2003 Enterprise x64 Edition, SQL Server 2005 32bit Enterprise Edition SP2.
 
The goal:
We have a large number of text files that we€™re loading into a staging area of a data warehouse (based on SQL Server 2k5, as said above).
 
We have one €œmain€? SSIS package that takes a list of files to load from an XML file, loops through that list and for each file in the list starts an SSIS package by using €œdtexec€? command. The command is started asynchronously by using system.diagnostics.process.start() method. This means that a large number of SSIS packages are started in parallel. These packages perform the actual loading (with BULK insert).
 
I have successfully run the loading process from the command prompt (using the dtexec command to start the main package) a number of times.
 
In order to move the loading to a production environment and schedule it, we have set up an SQL Server Agent job. We€™ve created a proxy user with the necessary rights (the same user that runs the job from command prompt), created an the SQL Agent job (there is one step of type €œcmdexec€? that runs the €œmain€? SSIS package with the €œdtexec€? command).
 
If the input XML file for the main package contains a small number of files (for example 10), the SQL Server Agent job works fine €“ the SSIS packages are started in parallel and they finish work successfully.
 
The problem:
When the number of the concurrently started SSIS packages gets too big, the packages start to fail. When a large number of SSIS package executions are already taking place, the new dtexec commands fail after 0 seconds of work with an empty error message.
 
Please bear in mind that the same loading still works perfectly from command prompt on the same server with the same user. It only fails when run from the SQL Agent Job.
 
I€™ve tried to understand the limit, when do the packages start to fail, and I believe that the threshold is 80 parallel executions (I understand that it might not be desirable to start so many SSIS packages at once, but I€™d like to do it despite this).
 
Additional information:

The dtexec utility provides an error message where the package variables are shown and the fact that the package ran 0 seconds, but the €œMessage€? is empty (€œMessage: €œ).
Turning the logging on in all the packages does not provide an error message either, just a lot of run-time information.
The try-catch block around the process.start() script in the main package€™s script task also does not reveal any errors.
I€™ve increased the €œmax worker threads€? number for the cmdexec subsystem in the msdb.dbo.syssubsystems table to a safely high number and restarted the SQL Server, but this had no effect either.
 
The request:

Can anyone give ideas what could be the cause of the problem?
If you have any ideas about how to further debug the problem, they are also very welcome.
 Thanks in advance!
 
Eero Ringmäe

View Replies !   View Related
Help! Database Properties Page Error
I seem to have a problem with the HTML file that displays the properties on a database. Each time I select the database I receive the following error message: "Con_Menu Page is undefined. Do you want to continue running scripts on this page......"

Can anyone Help?

View Replies !   View Related
May Be A Corruption Error ? Need Help.
This error message was thrown in a SQL server 7.0 database. Please let me know the cause and fix.

I/O error (bad page ID) detected during read of BUF pointer = 0x14682100, page ptr = 0x64ac8000, pageid = (0x1:0x33b0), dbid = 51, status = 0x801, file = E:xxxabcd.mdf

View Replies !   View Related
Database Corruption
Hello, Everyone:

How to check if a database is corrupted, and how to fix the corruption? Thanks.

ZYT

View Replies !   View Related
Database Corruption (Please Help!!)
Hi,
I created a nonclustered index on sysobjects table. After that, when I
create a new object and sysobjects is modified, the database does not work
properly. I used DBCC CHECKDB to repair it. It works but as soon as a new
object is created, again database get corrupted (CHECKDB reports error). I
cannot drop this index with DROP INDEX command.
I'm wondered if an index on system table cannot be dropped, why it can be
created? If it is allowed to create index, why it corrupts the database?
I found this link:
http://support.microsoft.com/kb/106122
Although it mentions SP_FixIndex can drop such indexes but there are no description about it.
Any help would be greatly appreciated.
Leila

View Replies !   View Related
SQL 6.5 Database Corruption
Hi I'm new to SQL, and have a big problems that I need help with. I just hired on to as the Network Admin for the company, the company has an NT4.0 box with SQL 6.5 running. The previous administrator has never done a SQL backup of the dbase, so no import or restore can be done. Now the SQL application was corrupted, it would not regconize itself or can be register. After the reinstallation of the SQL 6.5, there are still a folder of data under Mssql. I assumed that this is the dbase but have no idea what the the dbase actually call, if browse through using explore you will see the files name VMData.dat 550 mb in size and VMLog.dat 25 mb in size. If anyone know how I can retrieved this dbase it would be great help, or if you know of a firm that I can contact that would work too. Thank you for your help in advance.

View Replies !   View Related
Database Corruption
Hi All,

I have a database was showing (Suspect). It looks not able to log into the SQL database. After I reboot the machine it turned to recovering for a while and then changed to suspect again. I did the following steps:
1. set database to emergency mode (Status = -32768)
2. after that I tried to do DBCC checkdb but I received “cannot open ‘database’…”

So I have to restore the database from latest backup but I lost one-hour data. My questions are:
1. how to recovery the corruption database instead of restoring from backup?
2. From following error log, does anyone know what is the reason causing database “suspect”?

The database is running at SQL7 and SP1. The database has 1g data (50% free space). The Log file has 600MB.


Thanks for any info/advice,

Stella Liu

Error Log:
2000-01-31 16:07:04.92 spid11 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 11, PSS = 0x4935b0cc, EC = 0x4935b27c
Stack Dump being sent to d:MSSQL7logSQL00007.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 01/31/00 16:07:59 spid 11
*
* Input Buffer 210 bytes -
* I N S E R T I N T O P P F R e p r e s e n t a t i v e s
* V A L U E S ( 4 4 1 1 8 , 1 1 7 9 4 3 1 4 , { f n g e t i m a g e
* ( 1 ) } ) e x e c s p _ d r o p o r p h a n s c o m m i t t r a
* n
*
************************************************** *****************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f67a2b Module(ntdll+7a2b) (ZwGetContextThread+b)
0x0077fc6b Module(sqlservr+37fc6b) (utassert_fail+1a0)
0x005a6741 Module(sqlservr+1a6741) (Page::MakeInsertSpace+45)
0x0040df03 Module(sqlservr+df03) (PageRef::InsertRows+132)
0x005b0531 Module(sqlservr+1b0531) (XDES::UndoPageOperation+228)
0x00431ceb Module(sqlservr+31ceb) (XDES::RollbackToLsn+22a)
0x00430560 Module(sqlservr+30560) (XDES::Rollback+14e)
0x00431abf Module(sqlservr+31abf) (XCB::Rollback+2f9)
0x0051ac85 Module(sqlservr+11ac85) (clean_process+162)
0x005b22fd Module(sqlservr+1b22fd) (language_exec+5f9)
0x4106135c Module(opends60+135c) (execute_event+659)
0x4106164b Module(opends60+164b) (process_commands+f3)
0x4109285a Module(ums+285a) (ProcessWorkRequests+ed)
0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ee8 Module(KERNEL32+4ee8) (lstrcmpiW+be)
2000-01-31 16:08:02.65 spid11 CImageHelper::GetSym Error - The specified module could not be found.

0x00000000 Module(sqlservr+ffc00000)
2000-01-31 16:08:03.34 kernel SQL Server Assertion: File: <page.cpp>, line=2809
Failed Assertion = 'sid >= m_slotCnt || m_slots[-sid].offset ==0'.
2000-01-31 16:08:03.51 spid11 Error: 3624, Severity: 20, State: 1.
2000-01-31 16:10:57.29 spid11 Error: 3314, Severity: 21, State: 4
2000-01-31 16:10:57.29 spid11 Error while undoing logged operation in database 'WebPDM'. Error at log record ID (56:11888:81)..
2000-01-31 16:10:57.37 spid11 Error: 9001, Severity: 21, State: 1
2000-01-31 16:10:57.37 spid11 The log for database 'WebPDM' is not available..
2000-01-31 16:12:39.73 spid11 Error: 3314, Severity: 21, State: 2
2000-01-31 16:12:39.73 spid11 Error while undoing logged operation in database 'WebPDM'. Error at log record ID (55:12913:1)..
2000-01-31 16:12:44.28 spid6 Closing file d:mssql7datawebpdmdata.mdf.
2000-01-31 16:12:44.46 spid6 Closing file d:mssql7datawebpdmlog.ldf.
2000-01-31 16:12:44.60 spid6 Starting up database 'WebPDM'.
2000-01-31 16:12:44.60 spid6 Opening file d:mssql7datawebpdmdata.mdf.
2000-01-31 16:12:44.92 spid6 Opening file d:mssql7datawebpdmlog.ldf.
2000-01-31 16:12:51.65 spid6 Recovery progress on database 'WebPDM' (7): 14 percent.
2000-01-31 16:12:55.39 spid6 Recovery progress on database 'WebPDM' (7): 28 percent.
2000-01-31 16:12:58.14 spid6 Recovery progress on database 'WebPDM' (7): 42 percent.
2000-01-31 16:13:08.39 spid6 102 transactions rolled forward in database 'WebPDM' (7).
2000-01-31 16:13:08.39 spid6 Recovery progress on database 'WebPDM' (7): 57 percent.
2000-01-31 16:13:08.40 spid6 Recovery progress on database 'WebPDM' (7): 71 percent.
2000-01-31 16:13:08.59 spid6 Using 'sqlimage.dll' version '4.0.5'
Dump thread - spid = 6, PSS = 0x41308084, EC = 0x41308234
Stack Dump being sent to d:MSSQL7logSQL00008.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 01/31/00 16:13:18 spid 6
*
*
************************************************** *****************************
-------------------------------------------------------------------------------
Short Stack Dump
0x77f67a2b Module(ntdll+7a2b) (ZwGetContextThread+b)
0x0077fc6b Module(sqlservr+37fc6b) (utassert_fail+1a0)
0x005a6741 Module(sqlservr+1a6741) (Page::MakeInsertSpace+45)
0x0040df03 Module(sqlservr+df03) (PageRef::InsertRows+132)
0x005b0531 Module(sqlservr+1b0531) (XDES::UndoPageOperation+228)
0x00431ceb Module(sqlservr+31ceb) (XDES::RollbackToLsn+22a)
0x005adfae Module(sqlservr+1adfae) (RecoveryMgr::UndoPass+1c8)
0x004d125a Module(sqlservr+d125a) (RecoveryMgr::RecoverDb+35c)
0x004ce9f7 Module(sqlservr+ce9f7) (DBTABLE::Startup+630)
0x004cdfd4 Module(sqlservr+cdfd4) (DBMgr::StartupDB+2c4)
0x006cc585 Module(sqlservr+2cc585) (TaskDbRestart::ProcessTskPkt+14f)
0x004d79e9 Module(sqlservr+d79e9) (GlobalTskMgrProc+117)
0x4109285a Module(ums+285a) (ProcessWorkRequests+ed)
0x41092d28 Module(ums+2d28) (ThreadStartRoutine+139)
0x7800bee4 Module(MSVCRT+bee4) (beginthread+ce)
0x77f04ee8 Module(KERNEL32+4ee8) (lstrcmpiW+be)
2000-01-31 16:13:18.95 spid6 CImageHelper::GetSym Error - The specified module could not be found.

0x00000000 Module(sqlservr+ffc00000)
2000-01-31 16:13:19.01 kernel SQL Server Assertion: File: <page.cpp>, line=2809
Failed Assertion = 'sid >= m_slotCnt || m_slots[-sid].offset ==0'.
2000-01-31 16:13:19.04 spid6 Location: page.cpp:2809
Expression: sid >= m_slotCnt || m_slots[-sid].offset ==0
SPID: 6
Process ID: 220
2000-01-31 16:13:19.07 spid6 Error: 3624, Severity: 20, State: 1.
2000-01-31 16:13:19.07 spid6 Error: 3314, Severity: 21, State: 3
2000-01-31 16:13:19.07 spid6 Error while undoing logged operation in database 'WebPDM'. Error at log record ID (56:11888:81)..
2000-01-31 16:14:50.73 spid6 Error: 3414, Severity: 21, State: 1
2000-01-31 16:14:50.73 spid6 Database 'WebPDM' (database ID 7) could not recover. Contact Technical Support..

View Replies !   View Related
SQL Synax Error For Updating Database Page
I was hoping someone could tell me what my syntax error is in my code: (this is my first time creating one of these!)

<cfquery name="JobPost"
datasource= "JobPost">
UPDATE Jobs (Position, Description, Requirements)
VALUES ('#Form.Position#', '#Form.Description#' , '#Form.Requirements#')
WHERE JobID=2
</cfquery>

I get the following diagnostic error in the browser:
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

SQL = "UPDATE Jobs (Position, Description, Requirements) VALUES ('Updated Receptionist', 'description updated You will take phone calls' , 'description updated Must be able to work a phone.') WHERE JobID=2"

Data Source = "JOBPOST"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (129:2) to (130:23) in the template file

View Replies !   View Related
Error 823 While Running Queries On A Database
Hi, I have the following error logged in SQL Server's error log whenever I run a query on a particular database :

2002-01-04 22:54:02.46 spid11 Error: 823, Severity: 24, State: 1 2002-01-04 22:54:02.46 spid11 I/O error 1117(The request could not be performed because of an I/O device error.) detected during read of BUF pointer = 0x14eac480, page ptr = 0x73c94000, pageid = (0x1:0x158c89), dbid = 8, status = 0x801, file = d:mssql7datamydb.mdf..

2002-01-05 05:54:22.01 kernel SQL Server terminating because of system shutdown. 2002-01-05 05:54:22.14 kernel LogEvent: Failed to report the current event. Operating system error = 31(A device attached to the system is not functioning.).

and get this error in the Results pane of Query analyzer : Server: Msg 823, Level 24, State 1, Line 1 I/O error 1117(The request could not be performed because of an I/O device error.) detected during read of BUF pointer = 0x14ace4c0, page ptr = 0x35df6000, pageid = (0x1:0x44b73), dbid = 14, status = 0x801, file = d:MSSQL7DATAmydb.mdf.

Connection Broken

select @@version returns, Microsoft SQL Server 7.00 - 7.00.961 (Intel X86) Oct 24 2000 18:39:12 Copyright (c) 1988-1998 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

Books Online Help on Error 823 indicates that it is a disk problem and suggests that DBCC checkdb needs to be run on the database. But, hardware diagnostics on the server do not report any disk problems and dbcc checkdb also returns no errors.

Help on the cause of error 823 would be greatly appreciated. Thank you, Praveena

View Replies !   View Related
Header Corruption Error
I am working on a PPC 2003 app in VS2005.  I have installed sscesa20.dll on my server, and I
can access it via the url.

I am getting an error when I run my app at the rda.Pull() line. The
error is:

"Header information is either corrupted or missing Minor Error
28035 Error Code 80072F76"

Here is my rda.Pull() line:

rda.Pull(
"CURRENTITEMLIST"
"Select * from ITEM where BRAND_NAME LIKE '" + item + "'",
rdaOleDbConnectString,
RdaTrackOption.TrackingOff,
"ErrorTable");

I have no idea what 'Header' the error refers to...Can anyone help
me out?

View Replies !   View Related
Can DBCC Fix Database Corruption?
Hi All,

Can some one tell me a basic database corruption message that a DBCC command can fix it.

To explain a little bit - this is what I am trying to do in a test/R&D environment:

1) Corrupt a database to simulate a simple/basic/less severity error message.
2) Run DBCC (dbname, repair_fast) or DBCC (dbname, repair_rebuild) to fix it.

So far I am unable to make DBCC fix the database corruption. My idea is to test the DBCC tool - what it can fix and what it cannot?

Bottomline is : I need to know some simplest way to corrupt a database so that DBCC command can successfully fix it.

Thanks in advance,
Sri

View Replies !   View Related
SqlCe Database Corruption
Hi; there;

      I know that power failure can corrupt a sdf file (http://support.microsoft.com/kb/296076/en-us)

      Apart from that, is there any other reason can corrupt a SqlCe2.0 sdf database?

 

Another problem I found in my sdf database is corrupted record. There is a record in the database has all field with "null" value. When I tried to compact this database in "Query Analyzer", it has cursor there forever. I can still open the database and view those record. I tried to delete this record by saying "delete from job where ... is null", that database is fixed!!! I can compact that dataase again.

Note: I have transaction when writing data to database and my application has quite a lot database corruption issue which is nightware now.

 

    Does anybody know what causes this and how to avoid this problem?

 

   

View Replies !   View Related
Error Running Insert Statement In A Database
When I run this query against PFGDSMRISSQLQ1 in Server manager 2005:use <database>INSERT INTO dbo.<table> (<column1>, <column2>, <column3>)VALUES     (12598,2900,1.00)I get this error:Msg 8624, Level 16, State 1, Line 5Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.Can someone please help.  Thanks!

View Replies !   View Related
Database Corruption From Simple Query
Hi-  I have questions about mobile database limits.  The application is entirely C# / Compact Framework 2.0, using VS2005.  Devices we support are all running WM5.   We're trying to incorporate what seems to be a large database that the application needs to talk to offline from any network, so it needs to be stored & hosted within the database and hence we started working with the various generations of what is now SQL Server Compact Edition.

In order to profile the responsiveness I worked up a test database with the general collection of fields we are interested in.  The main table has 80,000 rows with one primary key and one of the numeric fields indexed.  There is a 'nickname' table which contains about 150,000 items with just a string for a nickname and the key that nickname goes with.  With all the rows and an alpha index for the nickname field the database is about 42 mb.  Which is pushing the amount of storage on the handheld, but of our two models one is fine and one still has about 30 mb free with the DB on the handheld.

My problem seems to be that one kind of device can work with this database and one cannot.  The device I was using the prototype the application is a HP iPAC hx2490b.  On that device more than once I have corrupted the database, but not yet as a reproducible process.

My other device is a Dell Axim X51.  On that device I seem to corrupt the database with very simple actions.  Just now I tried a query like (From the Query Analyzer 3.0)





Code Snippet

Select * from ReagentNicknamesTable where alt_names like 'alpha%'

Which should hit 2099 of the 150,000 records.  I got about 400 back and then the table was corrupted. On this device I cannot recover the database as there isn't enough disk space for two copies of the DB.  So corruption in the field would be a showstopper.  But getting corruption from a simple query like this means I really can't use SSCE. 

This problem with the dell showed up when I was using the original device sql that came with VS2005.  (SQL Server Mobile?)  The cabs & dll's were dated from 2005 and had a build number of 3.0.5206.0.  I have since updated to the current version of SQL Server Compact Edition and the dlls have build number 3.0.5300.0.  The IDE is set to Compact Framwork 2.0, sp1:  cgacutil reports CF 2.0.6129.0.

So help!  Have I hit some listed or unlisted limits to SSCE on the Compact Framework?  thanks.

View Replies !   View Related
SSIS Project Running In Debug Mode Brings Up The Wrong Script Task In The Debugger
 

This would actually be funny if I weren't under serious time constraints right now. I have an SSIS project with several script tasks in the control flow. I put breakpoints in one of them to allow me to step through and see whats going on. However, when I start the project, the IDE brings up the script editor for a different script task. The breakpoints in this task are actually on the same line numbers as the task I need to debug but the code is all wrong. I checked the task for which the code is being displayed and there are no breakpoints there.
 
Thanks for the assist!
 
Don

View Replies !   View Related
Running A Web Page
hi.
does someone know how can i execute a web page from ssis.
for example i woul like to call http://www.hotmail.com

thanks

View Replies !   View Related
Running A SSIS Package As A Job Error - With A Connection To An Oracle Database
Hi,
 
I have installed MS SQL Server 2005 and Service Pack 2 on a new Windows 32-bit environment.  I also installed the 32-bit 10g client (the Administrator option).  The tnsnames.ora file is configured properly and I can tnsping to the Oracle database without any issues.  I have created a package in Visual Studio and it runs successfully when I execute the job manually.  I saved the package to the MS SQL Server and when I log into Management Studio to create a job for this package, I receive the following error:
 
Message
Executed as user: xxxSYSTEM. ...rsion 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:42:37 AM  Error: 2007-10-10 10:42:37.28     Code: 0xC0202009     Source: x Connection manager "x.x"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft OLE DB Provider for Oracle"  Hresult: 0x80004005  Description: "Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.    Provider is unable to function until these components are installed.".  End Error  Error: 2007-10-10 10:42:37.28     Code: 0xC020801C     Source: Data Flow Task OLE DB Source [18]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method ca...  The package execution fa...  The step failed.


I have created the package and logged into the server with the same ID to set up the job.  And I have set the ProtectionLevel property to "Don't Save Sensitive Data" since I know this has been an issue in the past when I tried automating the job.  I've four posts regarding this error message on the MSDN forums that aren't helpful at this moment - I'm hoping that someone will have found a solution since those posts.  Any suggestions are welcomed.

 
Thanks for your help!
Sue

View Replies !   View Related
Error In Running SSIS Package Wchich Was Created On A Database Having Different Collation.
Hi,

I have created a DTSX package on database with Chinese collation now i want to use english collation in database, to do that i created one new database this time with english collation,

I imported the above said DTSX package into the new english collation database but i am facing following error:

'Validation error. Import ASCII Promotin Properties: DTS.Pipeline : The LocaleID 9 is not installed on this system'

How to resolve this error.

Any help will be highly appreciated.

Thanks in advance.

Pintu

 

 

View Replies !   View Related
Cancel Synchronization = Database Corruption? Identity Ranges Problem
Hi all,

I have a SQL Server 2005 Compact Edition database that synchronizes with a SQL Server 2005 Standard database via merge replication.

The problem I have is when I cancel a synchronization, the database is left in such a state that I cannot add any new records. I dug around a bit and have found that in the INFORMATION_SCHEMA.COLUMNS view, AUTOINC_MAX has been incorrectly set to the same value as AUTOINC_MIN for the primary keys, which explains the 'out of range' error I get in my program when running off such a database.

In contrast, a non-corrupted database has AUTOINC_MAX set to AUTOINC_MIN + 999, presumably because of my subscriber identity range of 1000.

If this is the only thing that has gone wrong, all I need to do is programmatically set the AUTOINC_MAX values to AUTOINC_MIN + 999, however I can't find out where to do this (and INFORMATION_SCHEMA.COLUMNS is a view so it can't be updated obviously.)

I have also heard that 'compacting' the database may help, but I don't know how to do this either!

Any help would be immensely appreciated!

Regards,
Jonathan.

View Replies !   View Related
Running Dts From Asp Page To Create A File
I want to transform data from sql7 to a text (or excel) file. I'm using unc filename to a shared directory with 'everyone' 'control total' rights.

running the dts from enterprise manager works
running it with dtsrun : it works
running it using vbscript and package method : it does'nt fill the result file without any error (the same method with a dts transforming data from sql7 to sql7 will work)

I think the problem is a problem of user rights ?

View Replies !   View Related
Running SQL Server DTS Package From ASP.NET Page Problem
I'm having some problems running a DTS package from my ASP.NET appllication. It runs prefectly in debug from my local machine but as soon as I move it to the web server I receive the following error:
Error: -2147467259Source: Microsoft JET Database EngineDescription: The Microsoft Jet database engine cannot open the file '\serverBPayFilesPay3.xls'. It is already opened exclusively by another user, or you need permission to view its data.
The file is not opened by anyone else and the share permissions are full control for everyone.
My set up is as follows
serverA - Webserver & DB ServerserverB - File Server
The DTS package pulls in the file from serverB to a database table on serverA. The sa account is used for the database connection and connecting to the DTS package from the application. My code for running the DTS package is as follows -
  Private Sub ExecutePackage(ByVal server As String, ByVal package As String, ByVal username As String, ByVal password As String)

Const DTSSQLStgFlag_Default = 0
Const DTSStepExecResult_Failure = 1

Dim oPKG As DTS.Package, oStep As DTS.Step
oPKG = New DTS.Package

Dim sServer As String, sUsername As String, sPassword As String
Dim sPackageName As String, sMessage As String
Dim lErr As Long, sSource As String, sDesc As String

' Set Parameter Values
sServer = server
sUsername = username
sPassword = password
sPackageName = package

' Load Package
oPKG.LoadFromSQLServer(sServer, sUsername, sPassword, _
DTSSQLStgFlag_Default, , , , sPackageName)

' Set Exec on Main Thread
For Each oStep In oPKG.Steps
oStep.ExecuteInMainThread = True
Next

' Execute
oPKG.Execute()

' Get Status and Error Message
For Each oStep In oPKG.Steps
If oStep.ExecutionResult = DTSStepExecResult_Failure Then
oStep.GetExecutionErrorInfo(lErr, sSource, sDesc)
sMessage = sMessage & "Step " & oStep.Name & " Failed<br><br>Error: " & lErr & "<br>Source: " & sSource & "<br>Description: " & sDesc & "<br><br>"
Else
sMessage = sMessage & "Step " & oStep.Name & " Succeeded<br>"
End If
Next

oPKG.UnInitialize()

oStep = Nothing
oPKG = Nothing

' Display Results
'MsgBox(sMessage)

lblOutput.Text = sMessage

End Sub 
I'm using windows authentication with identity impersonate set to true. If I change to use basic authentication and enter my login when I go to the site the DTS package runs successfully. So I assume that I'm seeing this 'double hop' issue.
serverA is for testing so I moved the DTS package and web application to serverB so now everything is on the same server and should eliminate the double hop? No! Works perfectly from my PC in debug, but from the web server the same error occurs. Changing to basic authentication does not workaround the issue on the live server.
The DTS package always works when run from Enterprise manager.
I know this is a premissions issue - does anyone know what I'm doing wrong? Hopefully I've supplied enough info, if not just ask!

View Replies !   View Related
Error With Rs.exe Utility
I'm getting some errors when I run rs.exe from command line with regard to Parameters, and was hoping I might get some help here.  I'm somewhat new to RS.  I'm running SQL 2000 and RS 2000 on a Windows 2003 Server.

Here is my script:
***********************************************************
' File: RunReport.rss
Dim format as string = "Excel"
Dim fileName as String = "C:Export2.xls"
Dim reportPath as String = "/APSAgentCourseCompletionByUserGroup"

Public Sub Main()

    ' Prepare Render arguments
    Dim historyID as string = Nothing
    Dim deviceInfo as string = Nothing
    Dim showHide as string = Nothing
    Dim results() as Byte
    Dim encoding as string
    Dim mimeType as string = "ms-excel"
    Dim warnings() AS Warning = Nothing
    Dim reportHistoryParameters() As ParameterValue = Nothing
    Dim streamIDs() as string = Nothing
    rs.Credentials = System.Net.CredentialCache.DefaultCredentials

    ' Report Parameters
    Dim parameters(5) As ParameterValue
    parameters(0) = New ParameterValue()
    parameters(0).Name = "User Group"
    parameters(0).Value = "66179312-f341-4df7-a855-79c5b8abaf9f"
    parameters(1) = New ParameterValue()
    parameters(1).Name = "Start Date"
    parameters(1).Value = "12/22/2006"
    parameters(2) = New ParameterValue()
    parameters(2).Name = "End Date"
    parameters(2).Value = "2/17/2007"
    parameters(3) = New ParameterValue()
    parameters(3).Name = "Course Name"
    parameters(3).Value = "AA2B1AA0-E78A-4F84-834F-8EAAB75BEBD3"
    parameters(4) = New ParameterValue()
    parameters(4).Name = "Status To Include"
    parameters(4).Value = "0"
    results = rs.Render(reportPath, format, _
        Nothing, Nothing, parameters, _
        Nothing, Nothing, encoding, mimeType, _
        reportHistoryParameters, warnings, streamIDs)

    ' Open a file stream and write out the report
    Dim stream As FileStream = File.OpenWrite(fileName)
    stream.Write(results, 0, results.Length)
    stream.Close()

End Sub

'End of script
***********************************************************

As you can see, right now I've got all 5 report parameters hard-coded.

Here is the command line that I'm using as well as the error that I receive:

rs.exe -i c:RunReport.rss -s http://localhost/reportserver -t
Unhandled exception:  The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values.

Any insight that anyone can provide is greatly appreciated.

Thanks!

Ray

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved