Forum

HomeHomeCoreCoreGeneralGeneralOWS_SiteUrls   error when copying siteOWS_SiteUrls error when copying site
Previous
 
Next
New Post
2/18/2014 1:31 PM
 

1. made a copy of database with a new dbuser and new dbname

2. made a copy of  website

changed settings in web.config. 


......

Site runs fine, with exeptions

some functions in some configs say OldDatabase is not online any more even when I insert full name to  database in the insert query, like 

.....

INSERT INTO [New_Database_Name].[dbo].[TableName]
(
name
)
VALUES(
'DNN'
)

.....

I have tried copying config and creating a new one but this reference to old table persists. 

trying to delete old user and old user schema from new database results in


Error:Expand/Collapse

Database 'Old Database name' cannot be opened because it is offline.

 

Then I tried to  delete old user and old user schema from the new database

where I run into this..


Msg 3729, Level 16, State 1, Line 4
Cannot drop schema 'Old User Name' because it is being referenced by object 'OWS_SiteUrls'


So  conclusion I come to that somewhere there exist a  OWS_SiteUrls that reference the Old  Database. 


My knowledge is limited, so is my brain.  what can I do ?


New Post
2/19/2014 12:16 AM
 
Hi dnnhost,

1. you have to edit two lines in web.config:

<connectionStrings>
    <!-- Connection String for SQL Server 2008/2012 Express -->
    <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;Initial Catalog=dbname;User ID=
;Password=XXX" providerName="System.Data.SqlClient" />
  </connectionStrings>


<appSettings>
    <!-- Connection String for SQL Server 2008/2012 Express - kept for backwards compatability - legacy modules   -->

    <add key="SiteSqlServer" value="Data Source=.\SQLExpress;Initial Catalog=
;User ID=dbuser;Password=XXX" />

 

2. you have copied the full path of the dnn installation?  good.

3. you have entered a new virtual  site in iis?

 

4. check your owsconfig,  if exists INSERT INTO [Old_Database_Name].[dbo].[TableName] as you described.

To prevent those errors, i use a custom variable "@FocusDB = [Database_Name].[dbo]." in my config, so it looks like 

INSERT INTO [|@FocusDB,Variable][TableName]

 

 cheers, richard

New Post
2/24/2014 1:04 AM
 

Finally figured out my problem. 

There was a hardcoded TRIGGER in the table I was inserting to. 

the  Trigger was upgrading an other table with  link to the old database.


Thanks for  help  :)

Previous
 
Next
HomeHomeCoreCoreGeneralGeneralOWS_SiteUrls   error when copying siteOWS_SiteUrls error when copying site


 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • info@openwebstudio.com

Bookmark & Share Bookmark and Share