• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

DBreorg issue

 1 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
John Crudele
Veteran Member Send Private Message
Posts: 50
Veteran Member
11/18/2013 1:28 PM
running LSF9 , Windows/Sql2008

When I run a dbreorg i get the following error

File GMCODES 
ERROR File alreadt exists in Phase Create file while processing file GMCODES

Error Text  CreateSQLFile(dbo.GMCODES)
CM sfSQLMaker Execute command
SQL Server error code 2714 There is already an object named "gmcodes" in the database

I was given a solution of dropping the table in SQL and rerun dbreorg

Does this seem correct or will it cause other issues

Thanks
JC 
Kwane McNeal
Veteran Member Send Private Message
Posts: 479
Veteran Member
11/18/2013 1:41 PM
If the table has no records (and I'm assuming it does not), then yes, that should work.
If it *does* have records, then you'll want to back them up, then drop the table.

typically, a 'create table BLAH as select * from GMCODES;', should do a quick and dirty backup.

Kwane