StrataFrame Forum

Cannot create column on exisiting table

http://forum.strataframe.net/Topic28077.aspx

By Jason Seidell - 8/24/2010

On one of my tables I get the attached error when trying to create a package after adding or renaming any columns on the table.  This only occurs for a single table in the database, and it does not matter what I name the column or what data type/other options are specified.

I dunno what to do next?  Any help?
By Trent L. Taylor - 8/24/2010

Well, this is really not enough information. First, I would try the following in trying to troubleshoot any deployment issue:



1. Deploy to a clean SQL Server instance or database to make sure that this isn't an update issue. If it is created clean (versus updating existing structures) then you have someplace to start.



2. Look through your object history to see if you have something stepping on this table/field.



If you cannot find your problem using the above steps, then you will need to send us a backup of your existing structures to which you are deploying and the PKG file from which you are deploying your structures.