Showing posts with label wizard. Show all posts
Showing posts with label wizard. Show all posts

Sunday, March 11, 2012

Error 547

Hello kind people.
I'm converting a MS Access database into a SQL database by using the 'Upsizing Wizard' in Access. I get lots of error messages concerning constraints. I've solved some, but I'm stuck with 8 messages like this one:
ALTER TABLE "060 Common_indoor_info"
WITH CHECK ADD
CONSTRAINT "060 Common_indoor_info_FK00"
FOREIGN KEY ("Area code") REFERENCES "061 Area_description_facade"("Area code")
ALTER TABLE "060 Common_indoor_info"
CHECK CONSTRAINT "060 Common_indoor_info_FK00"

Server Error 547: The ALTER TABLE statement conflicted with the FOREIGN KEY
constraint "060 Common_indoor_info_FK00". The conflict occurred in database
"SakStairWayKopiSQL3", table "dbo.061 Area_description_facade", column 'Area code'.

I hope this is the right thread to post this.
Where can i find more info about these error messages?
I think the area code in the primary key table does not exists at the time you are altering the table for activating the foreign key.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Friday, February 17, 2012

Error -2147467259 upgrading SQL 6.5 to SQL 2000

I'm trying to upgrade several databases from SQL 6.5 SP5a to SQL 2000
and I receive the following error from the Upgrade Wizard:
Export Exit Code: -2147467259 -
c:\progra~1\micros~3\mssql\upgrade\export.exe -CodePage 1252
-DeviceType Pipe -AllTables yes -MasterPath C:\MSSQL\DATA\MASTER.DAT
-DatabaseName AAP -DevicePath \\.\pipe\~cnvpipe0
****
Time:09-02-2004 17:55:13.272
Error in file CnvBuf.cpp Line=1555 rc=109 Msg=Result Code = 0x0000006d
****Time : 09-02-2004 17:55:13
An Error occured while exporting table ACCOUNT
Time : 09-02-2004 17:55:13
An Error occured while exporting database AAP
Time : 09-02-2004 17:55:13
An error occured while importing table. Please check the error file.
Time : 09-02-2004 17:55:14
pSql65Server->DumpAllTables () failed. hr=-2147467259
Both SQL Server versions are on the same computer and I log on as a
domain administrator. Also, both SQL services start as Administrator.
DBCC CHECKTABLE on table ACCOUNT doesn't return any errors.
Any suggestions?
Thanks everyone.Don't knkow how the upgrade wizard works but it looks like it is bcping the
data out and getting an error. Maybe running out of space?
"Leandro Ordo?ez" wrote:
> I'm trying to upgrade several databases from SQL 6.5 SP5a to SQL 2000
> and I receive the following error from the Upgrade Wizard:
> Export Exit Code: -2147467259 -
> c:\progra~1\micros~3\mssql\upgrade\export.exe -CodePage 1252
> -DeviceType Pipe -AllTables yes -MasterPath C:\MSSQL\DATA\MASTER.DAT
> -DatabaseName AAP -DevicePath \\.\pipe\~cnvpipe0
> ****
> Time:09-02-2004 17:55:13.272
> Error in file CnvBuf.cpp Line=1555 rc=109 Msg=Result Code = 0x0000006d
> ****Time : 09-02-2004 17:55:13
> An Error occured while exporting table ACCOUNT
> Time : 09-02-2004 17:55:13
> An Error occured while exporting database AAP
> Time : 09-02-2004 17:55:13
> An error occured while importing table. Please check the error file.
> Time : 09-02-2004 17:55:14
> pSql65Server->DumpAllTables () failed. hr=-2147467259
> Both SQL Server versions are on the same computer and I log on as a
> domain administrator. Also, both SQL services start as Administrator.
> DBCC CHECKTABLE on table ACCOUNT doesn't return any errors.
> Any suggestions?
> Thanks everyone.
>