HomeHome Product Discus... Product Discus...Billing ManagerBilling ManagerBilling Mgr 2.5 install failsBilling Mgr 2.5 install fails
Previous
 
Next
New Post
1/31/2012 11:27 AM
 

I have purchased your 2.5 version to fix the problems with 2.0.  I get the following error when trying to install, please advise ASAP.

 

Package Installation Report

See below for the results of the package installation
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - Smith Billing Manager
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - 01.00.00.SqlDataProvider
Info Created - 01.00.00.SqlDataProvider
Info Executing 01.00.00.SqlDataProvider
Info Start Sql execution: 01.00.00.SqlDataProvider file
Info End Sql execution: 01.00.00.SqlDataProvider file
Info Created - 02.10.00.SqlDataProvider
Info Executing 02.10.00.SqlDataProvider
Info Start Sql execution: 02.10.00.SqlDataProvider file
Info End Sql execution: 02.10.00.SqlDataProvider file
Info Created - 02.11.00.SqlDataProvider
Info Executing 02.11.00.SqlDataProvider
Info Start Sql execution: 02.11.00.SqlDataProvider file
Info End Sql execution: 02.11.00.SqlDataProvider file
Info Created - 02.12.00.SqlDataProvider
Info Executing 02.12.00.SqlDataProvider
Info Start Sql execution: 02.12.00.SqlDataProvider file
Info End Sql execution: 02.12.00.SqlDataProvider file
Info Created - 02.14.00.SqlDataProvider
Info Executing 02.14.00.SqlDataProvider
Info Start Sql execution: 02.14.00.SqlDataProvider file
Info End Sql execution: 02.14.00.SqlDataProvider file
Info Created - 02.16.00.SqlDataProvider
Info Executing 02.16.00.SqlDataProvider
Info Start Sql execution: 02.16.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'InvoiceNo'. 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) CREATE PROCEDURE dbo.Smith_BillMgrGetSubscriptionByIID @invoiceNo int AS select p.*, s.* from Smith_RegPayHist p inner join Smith_Subscription s on p.PayHistID = s.PayHistID where p.InvoiceNo = @invoiceNo
Info End Sql execution: 02.16.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - Smith Billing Manager
Info Starting Installation - Smith Billing Mgr My Account
Info Starting Installation - Module
Info Module registered successfully - SmithBillMgrMyAccount
Info Component installed successfully - Module
Info Starting Installation - Assembly
Info Assembly registered - bin\App_Web_current.ascx.68353db8.dll
Info Created - bin\App_Web_current.ascx.68353db8.dll
Info Assembly registered - bin\App_Web_myaccountsettings.ascx.68353db8.dll
Info Created - bin\App_Web_myaccountsettings.ascx.68353db8.dll
Info Assembly registered - bin\App_Web_myaccountinvoice.ascx.68353db8.dll
Info Created - bin\App_Web_myaccountinvoice.ascx.68353db8.dll
Info Component installed successfully - Assembly
Failure Package Installation aborted
Info Installation Failed - Smith Billing Mgr My Account
Info Deleted temporary install folder
EndJob Installation Failed

 

 
New Post
1/31/2012 2:32 PM
 
Hello,

Is this a clean installation or are you installing v.2.50 over a previous version?

Thanks,
 
New Post
1/31/2012 2:35 PM
 

It's the upgrade you said we needed to get for support.  I am installing over an existing installation as I have customer data.

 
New Post
1/31/2012 3:24 PM
 

Hello,

In addition to recommending the upgrade, we had also advised to perform the upgrade in a test environment first and make sure you have a full backup before installing on your live site.

At this point I would recommend backing up your the Smith data tables and perform a clean installation of the module, then restore your data using the following steps:

  1. First backup your live data - In SQL Management Studio
  • Create a new database titled “SmithBackup”
  • Connect to the database you are exporting "from"
  • Right click on the database you are exporting from to start theImport/Export wizard
  • Select the "Tasks" item, then either click the "Export Data" menu item.
  • Follow the wizard and export the following tables:
    • Smith_BillMgrCustomer
    • Smith_BillMgrInvoice
    • Smith_BillMgrInvoiceDetail
    • Smith_BillMgrProducts
  1. From the dnn->host menu uninstall the Smith Billing Manager and Smith Billing Mgr My Account. Makesure you check the delete files box when you uninstall.
  2. Confirm that all stored procedures and tables with a prefix of “Smith” in your database are deleted.
  3. Confirm that all Smith files and folders in the DesktopModules folder are deleted and removed. i.e. SmithBillingManager, SmithBillMgrMyAccount, and SmithRegistration.
  4. Reset iis to release the cache.
  5. Install the latest BillingManager module.
  6. Restore your live data - In SQL Management Studio
  • Right click on your live database you are importing to
  • Select the "Tasks" item, then either click the "Import Data" menu item.
  • Follow the wizard to import the following tables
    • Smith_BillMgrCustomer
    • Smith_BillMgrInvoice
    • Smith_BillMgrInvoiceDetail
    • Smith_BillMgrProducts

On the following wizard screen check the box next to the tables you want to import and click “Edit Mappings

  1. Check the box titled “Enable Identity Insert”.
  2. Click ok and finish the wizard.
  3. Verify that the data was imported to your live tables
  4. On your DNN portal navigate to the page where you want to add your Billing Manager module and add the module to the page.
  5. Configure and test.

Thanks,

 
New Post
2/7/2012 9:06 AM
 

I have followed your instructions twice now.  I have deleted all you said, did a clean install with 2.5, then imported the data back in.  However, I cannot get to the billing manager settings screen.  I get the following error.  Please advise ASAP.

 

Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. ---> System.Web.HttpParseException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. ---> System.Web.HttpParseException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. ---> System.Web.HttpException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase, Boolean throwOnError) at System.Web.UI.TemplateParser.ProcessInheritsAttribute(String baseTypeName, String codeFileBaseTypeName, String src, Assembly assembly) at System.Web.UI.TemplateParser.PostProcessMainDirectiveAttributes(IDictionary parseData) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ProcessException(Exception ex) at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseReader(StreamReader reader, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseFile(String physicalPath, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseInternal() at System.Web.UI.TemplateParser.Parse() at System.Web.UI.TemplateParser.Parse(ICollection referencedAssemblies, VirtualPath virtualPath) at System.Web.Compilation.BaseTemplateBuildProvider.get_CodeCompilerType() at System.Web.Compilation.BuildProvider.GetCompilerTypeFromBuildProvider(BuildProvider buildProvider) at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace ---

 

Also, when I click on the settings for the main screen I get the following:

 

Error A critical error has occurred.
Object reference not set to an instance of an object.

 

 
New Post
2/8/2012 9:05 AM
 

I have installed the 2.5 on a clean dnn installation and get the same result. PLEASE ADVISE ASAP.

 

Error Error: is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. ---> System.Web.HttpParseException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. ---> System.Web.HttpParseException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. ---> System.Web.HttpException: Could not load the assembly 'App_Web_billmgrsettings.ascx.61ca2ac0'. Make sure that it is compiled before accessing the page. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase, Boolean throwOnError) at System.Web.UI.TemplateParser.ProcessInheritsAttribute(String baseTypeName, String codeFileBaseTypeName, String src, Assembly assembly) at System.Web.UI.TemplateParser.PostProcessMainDirectiveAttributes(IDictionary parseData) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ProcessException(Exception ex) at System.Web.UI.TemplateParser.ParseStringInternal(String text, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseReader(StreamReader reader, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseFile(String physicalPath, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseInternal() at System.Web.UI.TemplateParser.Parse() at System.Web.UI.TemplateParser.Parse(ICollection referencedAssemblies, VirtualPath virtualPath) at System.Web.Compilation.BaseTemplateBuildProvider.get_CodeCompilerType() at System.Web.Compilation.BuildProvider.GetCompilerTypeFromBuildProvider(BuildProvider buildProvider) at System.Web.Compilation.BuildProvidersCompiler.ProcessBuildProviders() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl() --- End of inner exception stack trace ---

 

 
New Post
2/8/2012 1:35 PM
 
Hello,

By the look of the issues you posted above, it seems that the all the files in the installation package are being prevented from being installed properly. Which version of DNN were you originally running the module in?

After installing, did the module function properly before imported your data?

Thanks,
 
New Post
2/8/2012 1:40 PM
 

DNN 5.6.1.

No, the package never worked.

 
New Post
2/9/2012 4:55 PM
 
Hello,

Please see the following post:
https://www.smith-consulting.com/Forums/forumid/10/threadid/11698/scope/posts.aspx

Thanks,
 
New Post
2/6/2013 1:18 AM
 
Is package installation is lengthy process?
 
New Post
2/7/2013 4:02 PM
 
Hi Brian,

No, the package installation is a simple and straightforward process as long as your are installing on a stable DNN instance.
 
Previous
 
Next
HomeHome Product Discus... Product Discus...Billing ManagerBilling ManagerBilling Mgr 2.5 install failsBilling Mgr 2.5 install fails