StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



Deal with Deployment Data being emptyExpand / Collapse
Author
Message
Posted 09/26/2006 1:05:57 PM
StrataFrame Beginner

StrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame BeginnerStrataFrame Beginner

Group: Forum Members
Last Login: 08/30/2007 12:23:01 PM
Posts: 25, Visits: 64
Added the tables for Messaging, then set up Deployment Data tasks (In a possibly misguided attempt to distribute the messages that I will be creating).

Fails on deployment, apparently trying to insert into the tables (I don't have data in them yet).

Seems to be more polite to either do nothing rather than try to insert nothing, or to log something such as "No data available to deploy to table XXX" as an info message.

Getting:
An error occurred while creating a stored procedure.
ExecuteNonQuery failed for Database 'MyDatabaseName'
An exception occurred while executing a Transact-SQL statement or batch.
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for em...

Also would be nicer if it indicated which table it's trying to deploy to in the message, I happen to know it's the deployment data since I don't have any stored procedures to deploy yet
Post #3075
Posted 09/26/2006 4:17:11 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 09/26/2008 8:30:36 AM
Posts: 2,685, Visits: 1,886
Does it fail during the deployment of the data or does it fail during the packaging of the data?  You will know the difference between deploying and packaging by if the error comes before or after the deployment process asks for your username/password and server to deploy to (packaging comes before, deployment comes after).


www.bungie.net
Post #3092
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 6:03am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.