What does this mean when running turboscripts version m - dnn 7.4.2

Oct 28, 2015 at 7:45 PM
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "dbo.dbo.[temp822293990]]" because it does not exist or you do not have permissions.
Cannot find the object "dbo.dbo.[temp1510296441]]" because it does not exist or you do not have permissions.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource
1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
ClientConnectionId:c83e9a68-6aad-4dce-ac57-5489010928df

-- drop AF foregn keys with known issues:
IF EXISTS (SELECT * FROM Sys.Foreign_Keys WHERE Parent_Object_id = OBJECT_ID(N'dbo.[activeforums_ForumTopics]')
                         AND name = N'FK_activeforums_ForumTopics_activeforums_Replies')
ALTER TABLE dbo.[activeforums_ForumTopics] 
 DROP CONSTRAINT [FK_activeforums_ForumTopics_activeforums_Replies]
-- make sure, all constraints are enabled
IF (ServerProperty(N'EngineEdition') != 5) --Check for not running on SQL Azure
EXEC sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
Oct 28, 2015 at 10:30 PM
it looks like there are temp tables in your database (leftovers from an install attempt ?) with disabled FK constraints.
Please check the database for outdated tables or invalid constraints
Nov 11, 2015 at 4:47 PM
Hi Sebastian

Yes in fact I have 2 temp tables that I cannot delete that are used for a 3rd party module. Not sure why they are used that way. When I try to delete them I get this error. I am the admin on the site and the tables exist in the catalog. Is there a way around this. I am not using the module anymore.

drop table dbo.dbo.[temp1510296441]
Msg 3701, Level 11, State 5, Line number 1
Cannot drop the table 'dbo.dbo.temp1510296441', because it does not exist or you do not have permission.
Nov 11, 2015 at 5:03 PM
Edited Nov 11, 2015 at 5:06 PM
teambound,
schemas cannot be nested, i.e. either dbo.dbo.[temp1510296441] is a table in dbo database (in dbo schema) or dbo.[dbo.temp1510296441] is the name of a (badly named) table within your database (in dbo schema).
do you see any table dbo.temp1510296441 listed in SQL Server Management Studio?
Nov 11, 2015 at 5:08 PM
Sebastian

dbo.dbo.[temp1510296441] is the actual table name in the table list. How do I get rid of it?

Thanks!
Nov 11, 2015 at 5:18 PM
teambound, can you rightclick and click "delete"?
otherwise, if all other tables are named like "dbo.tabs" and this one is listed as "dbo.dbo.[temp1510296441]", you may execute:
DROP TABLE "dbo.[temp1510296441]"
if the table is listed as "dbo.dbo.[temp1510296441]]", you need to execute
DROP TABLE "dbo.[temp1510296441]]"
Best,
Sebastian
Marked as answer by leupold on 1/10/2016 at 6:06 AM
Nov 11, 2015 at 5:45 PM
Well then. Everything worked fine once I deleted the tables. Even though the table name was dbo.dbo.[temp1510296441]] I had to use DROP TABLE "dbo.[temp1510296441]" . Turbo ran fine.

Thanks for pointing me in the right direction.

Carl
Nov 11, 2015 at 5:50 PM
Carl,

thanks for your feedback, I am glad, if I could be of any help.

Sebastian