Register   Login
     
  Latest Posts  
RE: News Articles Tokens
by ray-isc on 3/21/2010 3:04 PM
RE: Can'd add photo
by rsobari on 3/21/2010 10:17 AM
Tracking image/file clicks
by spirit on 3/21/2010 8:46 AM
Catcha doesnt seem to work
by chaloum on 3/20/2010 8:16 PM
RE: Recently created articles are not shown in list
by atriage on 3/20/2010 10:15 AM
RE: Recently created articles are not shown in list
by spirit on 3/20/2010 10:08 AM
RE: Introducing the most powerful News Slider for Ventrian News Articles
by jhoelz on 3/19/2010 9:29 PM
Rich Snippets for Review, Ratings etc!
by georgelew on 3/19/2010 7:49 PM
Recently created articles are not shown in list
by atriage on 3/19/2010 11:18 AM
RE: News Articles Tokens
by spirit on 3/19/2010 10:43 AM
  Forums  
Subject: View Report Error for Subscription Expiring
Prev Next
You are not authorized to post a reply.

Author Messages
GlenWinUser is Offline
Gold Membership
Ventrian Master
Ventrian Master
Posts:840


6/20/2008 9:56 PM  

Hi Scott,

I run 3 instances of Subscription tool on the site ...I can view for Subscription Expiring for the Yellowpage Instatance but on the other 2 intances (Real Estate and Classifeds) It seem that when try to view report for for Subscription Expiring  then it return this error:

Error: View Reports is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: String or binary data would be truncated. The statement has been terminated. ---> 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DnnForge.SubscriptionTools.SqlDataProvider.ListReport(Int32 portalID, Int32 moduleID, ReportType reportType, DateTime dateStart, DateTime dateEnd) at DnnForge.SubscriptionTools.Entities.ReportController.List(Int32 portalID, Int32 moduleID, ReportType reportType, DateTime dateStart, DateTime dateEnd) at DnnForge.SubscriptionTools.Reports.cmdDisplay_Click(Object sender, EventArgs e) --- End of inner exception stack trace ---

GlenWinUser is Offline
Gold Membership
Ventrian Master
Ventrian Master
Posts:840


6/24/2008 3:46 PM  
Hi Scott,

Can you help me with this one? Thanks
Scott McCullochUser is Offline
Administrators
Ventrian Master
Ventrian Master
Posts:17204


6/24/2008 4:21 PM  
Do you have any subscriptions in this instance?

Scott McCulloch
Site Administrator
GlenWinUser is Offline
Gold Membership
Ventrian Master
Ventrian Master
Posts:840


6/24/2008 6:08 PM  
Yes , I do have a couple of 'test' subscriptions for each instance that I manually added in using Edit Receipt
GlenWinUser is Offline
Gold Membership
Ventrian Master
Ventrian Master
Posts:840


6/25/2008 7:58 AM  
Have You work out what caused the error Scott ?
You are not authorized to post a reply.
Forums > Modules > Subscription Tools > View Report Error for Subscription Expiring



ActiveForums 3.7