Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Error Installing DNN Integration Module

add-ons

We are using DNN 5.x and trying to integrate Gemini.
==============
Package Information

The following information was found in the package manifest.

 Name: The Package Name (eg. CompanyName.Name)

CounterSoft.Gemini.IssuesTracker

 Type: The Package Type

Module

 Friendly Name: The friendly name for this package

CounterSoft Gemini Issues

 Description: Description of the Package

This module integrates CounterSoft Gemini Issues Tracker with DotNetNuke.

 Version: The version of the Package

1.0.0

 Owner: The Owner of the Package

CounterSoft

 Organization: The Organization responsible for the Package

CounterSoft

 Url: The Author's Url

http://www.countersoft.com

 Email Address: The Package Author's Email Address

support@countersoft.com========================
This is the ERROR:

Error loading files from temporary folder - see below StartJob Starting Installation Info Starting Installation - CounterSoft.Gemini.IssuesTracker 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 Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Foreign key 'FKCounterSoftGeminiIssuefilterModules' references invalid table 'dbo.Modules'. Could not create constraint. See previous errors. 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) ALTER TABLE dbo.[CounterSoftGeminiIssuefilter] WITH CHECK ADD CONSTRAINT [FKCounterSoftGeminiIssuefilterModules] FOREIGN KEY([ModuleId]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE System.Data.SqlClient.SqlException: Foreign key 'FKCounterSoftGeminiIssueViewAttributeModules' references invalid table 'dbo.Modules'. Could not create constraint. See previous errors. 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) ALTER TABLE dbo.[CounterSoftGeminiIssueViewAttribute] WITH CHECK ADD CONSTRAINT [FKCounterSoftGeminiIssueViewAttributeModules] FOREIGN KEY([ModuleId]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE Info End Sql execution: 01.00.00.SqlDataProvider file Info Finished Sql execution Failure Installation Failed - Script Info Installation Failed - CounterSoft.Gemini.IssuesTracker Info Deleted temporary install folder EndJob Installation Failed

xrtech
· 1
xrtech
Replies (7)
helpful
0
not helpful

It seems that your database owner is not dbo. Please check this in SQL Server and make sure that DNN's web.config file is configured with that owner:
        <add name="SqlDataProvider" type="DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider" connectionStringName="SiteSqlServer" upgradeConnectionString="" providerPath="~\Providers\DataProviders\SqlDataProvider\" objectQualifier="" databaseOwner="dbo" />


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Our connection string in the DNN web.config uses the sa password and the sa is the owner of the db:

<connectionStrings>
    <!-- Connection String for SQL Server 2005/2008 Express > -->
    <add name="SiteSqlServer" connectionString="Data Source=daisy\xr2k8sql;Initial Catalog=dotnetnuke;User ID=sa;Password=xxxxxxxxx" providerName="System.Data.SqlClient" />
    <!-- Connection String for SQL Server 2005/2008
    <add name="SiteSqlServer" connectionString="Data Source=daisy\xr2k8sql;Database=dotnetnuke;uid=sa;pwd=xxxxxxxxx ;databaseowner=dbo"/>
    -->
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2005/2008 Express - kept for backwards compatability - legacy modules    -->
    <add key="SiteSqlServer" value="Data Source=daisy\xr2k8sql;Initial Catalog=dotnetnuke;User ID=sa;Password=xxxxxx" />
    <!--Connection String for SQL Server 2005/2008 - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="daisy\xr2k8sql;Database=dotnetnuke;uid=sa;pwd=xxxxxxx;"/> -->

We are using SQL 2008, not the express version so I am not sure why those are commented out when we set up the site, the install asked our db platform ..


xrtech
· 1
xrtech
helpful
0
not helpful

After reviewing the error in further detail, it is not referencing the named table structure we have in the db.  Our table names are dnn_<tablename> ...

Is there anyway to edit the install script so that it looks for the table prefix ?


xrtech
· 1
xrtech
helpful
0
not helpful

We have updated our SQL to use the objectqualifier setting.
Please use the attached.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Thanks for the update, but now, it looks like there are lingering objects from the failed install.

I though the install scripts removed everything before they attempted to recreate them ...

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There is already an object named 'PKCounterSoftGeminiIssueViewAttribute' in the database. Could not create constraint. See previous errors. 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 TABLE dbo.[dnnCounterSoftGeminiIssueViewAttribute]( [id] [int] IDENTITY(1,1) NOT NULL, [ModuleId] [int] NOT NULL, [CreatedDate] [datetime] NOT NULL, [AttributeValue] [int] NOT NULL, [Attributename] varchar NOT NULL, [AttributeSequence] [int] NOT NULL, CONSTRAINT [PKCounterSoftGeminiIssueViewAttribute] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (IGNOREDUPKEY = OFF) ON [PRIMARY] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Cannot find the object "dbo.dnnCounterSoftGeminiIssueViewAttribute" because it does not exist or you do not have permissions. 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 NONCLUSTERED INDEX [dnnIXCounterSoftGeminiIssueViewAttribute] ON dbo.[dnnCounterSoftGeminiIssueViewAttribute] ( [id] ASC )WITH (IGNOREDUPKEY = OFF) ON [PRIMARY] System.Data.SqlClient.SqlException: Cannot find the object "dbo.dnnCounterSoftGeminiIssueViewAttribute" because it does not exist or you do not have permissions. 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) ALTER TABLE dbo.[dnnCounterSoftGeminiIssueViewAttribute] WITH CHECK ADD CONSTRAINT [FKCounterSoftGeminiIssueViewAttributeModules] FOREIGN KEY([ModuleId]) REFERENCES dbo.[dnn_Modules] ([ModuleID]) ON DELETE CASCADE


xrtech
· 1
xrtech
helpful
0
not helpful

I dropped the tables manually that were created, reran the new install script and it worked great.

Thanks!


xrtech
· 1
xrtech
helpful
0
not helpful

Thanks for letting us know, glad all is well now. Your feedback (good or bad) is welcomed.


Saar Cohen
· 5000
Saar Cohen