Install Error with FewsFeed 4.0.0 - News Feeds

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

Home All Forums

Install Error with FewsFeed 4.0.0

9/19/2008 12:29 AM

John Cornelison

Joined: 7/15/2005

Posts: 429

Install Error with FewsFeed 4.0.0

[Repost: as when I set Thread Status from blank to Informative, the content of the message was cleared: How very rude!]

My upgrade from 3.x to 4.0 started OK and seems to have completed OK, but that ominous word "Failure" during an intermediate SQL operation made me wonder if all was well. I thought I'd post this in case it might help others.

Resource Upload Logs

StartJob	Starting Installation
StartJob	Reading files
Info	Loading 04.00.00.SqlDataProvider
Info	File 04.00.00.SqlDataProvider read successfully
Info	Loading 04.00.00.Txt
Info	File 04.00.00.Txt read successfully
Info	Loading DNN_NewsFeeds.dnn
Info	File DNN_NewsFeeds.dnn read successfully
Info	Loading DotNetNuke.Modules.News.dll
Info	File DotNetNuke.Modules.News.dll read successfully
Info	Loading Resources.zip
Info	File Resources.zip read successfully
Info	Loading Uninstall.SqlDataProvider
Info	File Uninstall.SqlDataProvider read successfully
EndJob	Reading files done.

StartJob	Reading Installation Manifest file
Info	DNN file is in valid 3.0 format.
Info	xml loaded.
Info	Loading files info
Info	Loading Modules info
Info	Loading Control info for 'News Feeds (RSS)' module
EndJob	Manifest file finished successfully

StartJob	Begin Sql execution
Info	Executing 04.00.00.SqlDataProvider
StartJob	Start Sql execution: 04.00.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /**** DATA MIGRATION ****/ INSERT INTO dbo.News_Feeds ( [CacheTime], [FeedUrl], [ModuleID], [Password], [User] ) SELECT -1, (SELECT SettingValue FROM dbo.ModuleSettings ms1 WHERE ms1.ModuleID=m.ModuleID AND ms1.SettingName='xmlsrc') AS xmlsrc, m.ModuleID, (SELECT SettingValue FROM dbo.ModuleSettings ms1 WHERE ms1.ModuleID=m.ModuleID AND ms1.SettingName='password') AS password, (SELECT SettingValue FROM dbo.ModuleSettings ms1 WHERE ms1.ModuleID=m.ModuleID AND ms1.SettingName='account') AS account FROM dbo.DesktopModules dm INNER JOIN dbo.ModuleDefinitions md ON md.DesktopModuleID=dm.DesktopModuleID INNER JOIN dbo.Modules m ON m.ModuleDefID=md.ModuleDefID WHERE dm.ModuleName = 'DNN_NewsFeeds' AND NOT (SELECT SettingValue FROM dbo.ModuleSettings ms1 WHERE ms1.ModuleID=m.ModuleID AND ms1.SettingName='xmlsrc') IS NULL
EndJob	End Sql execution: 04.00.00.SqlDataProvider file

EndJob	Finished Sql execution

StartJob	Creating files
StartJob	Expanding Resource file
EndJob	Resource Files created

Info	Created E:\Domains\VashonSoftware.com\wwwroot\bin\DotNetNuke.Modules.News.dll
Info	Created E:\Domains\VashonSoftware.com\wwwroot\DesktopModules\News\Providers\DataProviders\SqlDataProvider\04.00.00.SqlDataProvider
Info	Created E:\Domains\VashonSoftware.com\wwwroot\DesktopModules\News\Uninstall.SqlDataProvider
Info	Created E:\Domains\VashonSoftware.com\wwwroot\DesktopModules\News\04.00.00.Txt
Info	Created E:\Domains\VashonSoftware.com\wwwroot\DesktopModules\News\DNN_NewsFeeds.dnn.config
EndJob	Files created

StartJob	Registering DesktopModule
Info	Registering Definitions
Info	Registering Controls
EndJob	Registering finished

EndJob	Installation successful.

- John
www.VashonSoftware.com

9/19/2008 4:01 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: Install Error with FewsFeed 4.0.0

Each time, you see an issue during execution, there might be an issue, you may not notice in module behaviour immediately, since a script might be enhanced to cover a specific situation or an sproc is called in dedicated use caes only - or even, the issue will show up on next module upgrade. It is always important, that the module is properly installed and an installation issue should not be ignored. The installation procedure has been tested during beta tests and the release process, but it is difficult for us, to cover all possible scenarios.

In your case, the failed statement is used to upgrade existing data, i.e. the db structure seems having updated properly and one or more existing modules might not be upgraded properly to work in new environment, please verify all news module instances and its news feeds.

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

Install Error with FewsFeed 4.0.0

These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)