|
|
|
|
Joined: 1/31/2012
Posts: 9
|
|
|
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.
|
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 |
|
|
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hello,
Is this a clean installation or are you installing v.2.50 over a previous version?
Thanks,
|
|
|
|
| |
|
|
|
Joined: 1/31/2012
Posts: 9
|
|
|
It's the upgrade you said we needed to get for support. I am installing over an existing installation as I have customer data.
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
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:
-
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
-
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.
-
Confirm that all stored procedures and tables with a prefix of “Smith” in your database are deleted.
-
Confirm that all Smith files and folders in the DesktopModules folder are deleted and removed. i.e. SmithBillingManager, SmithBillMgrMyAccount, and SmithRegistration.
-
Reset iis to release the cache.
-
Install the latest BillingManager module.
-
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
-
Check the box titled “Enable Identity Insert”.
-
Click ok and finish the wizard.
-
Verify that the data was imported to your live tables
-
On your DNN portal navigate to the page where you want to add your Billing Manager module and add the module to the page.
-
Configure and test.
Thanks,
|
|
|
|
| |
|
|
|
Joined: 1/31/2012
Posts: 9
|
|
|
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:
|
A critical error has occurred.
Object reference not set to an instance of an object. |
|
|
|
|
| |
|
|
|
Joined: 1/31/2012
Posts: 9
|
|
|
I have installed the 2.5 on a clean dnn installation and get the same result. 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 --- |
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
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,
|
|
|
|
| |
|
|
|
Joined: 1/31/2012
Posts: 9
|
|
|
DNN 5.6.1.
No, the package never worked.
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hello,
Please see the following post: https://www.smith-consulting.com/Forums/forumid/10/threadid/11698/scope/posts.aspx
Thanks,
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Is package installation is lengthy process?
|
|
|
|
| |
|
|
|
Joined: 1/1/0001
Posts: 0
|
|
|
Hi Brian,
No, the package installation is a simple and straightforward process as long as your are installing on a stable DNN instance.
|
|
|
|
| |