Developer forum

Forum » Development » SQL Error after installation (own server)

SQL Error after installation (own server)

Søren Alexandersen
Reply
I just installed version 8 on my own server (Windows 2008 Server R2, 64 bit, SQL Server 2008).
I imported the DefaultEmptyDataSQL into a new database, after which I now get this error. (See the attatched image)
(I have tried changing the collation on the database. no luck)

What am I doing wrong? :-/
fejl.png

Replies

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Did you get the DefaultEmptyData8Sql? There's a special version for DW 8 on the Downloads page.

Cheers,

Imar


 
Søren Alexandersen
Reply
 Hi Imar

Yes I did.. sorry I didn't mention that. 
I downloaded all files from the website today. All version 8 :-)

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
In that case, I don't know what's going on. Never had that before. Try using the SQL Server Profiler to figure out which statement is breaking the app. Also, make sure you ran all the updates for DW by resetting the version numbers.

Cheers

Imar

 
Søren Alexandersen
Reply
 Thanks..
Could you elaborate on "make sure you ran all the updates for BW by resetting the version numbers" ?
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Take a look at step 12, all the way at the bottom of this article: http://devierkoeden.com/articles/custom-modules-part-1-introduction.aspx

Cheers,

Imar

 
Søren Alexandersen
Reply
 Just tried the profiler. It stop at this statement (attached)

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply

This runs fine on my machine against any DW 8 database. Can you figure out what it is it doesn't like? And are you really sure your site is using a DW 8 database that has been fully updated?

 

Imar

 
Søren Alexandersen
Reply
 I am begging to doubt the versions, because update.xml said 611 (?) 
 
Søren Alexandersen
Reply
 "beginning".. I meant to write :-)
 
Søren Alexandersen
Reply
 Just double checked. My Application .zip-file was named Application(8.0.2.2)
 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
611 is an older version. If you look in Admin/Update/updates.xml.aspx you can see it's from February this year. Here's what I would try:

1. Reset both numbers to 1 (in /Files/update.xml and /Files/UpdateVersion_ecom.xml

2. Restart IIS. Or, when this is a production server, restart the associated application pool, or make the web.config for the site dirty by making a change to it, saving it and then undoing that change). This causes the application to recycle and then DW will execute the updates,.

If it then keeps failing, check the updatelog.html.aspx file and make sure DW can write to the /Files folder.

Cheers,

Imar

 
Imar Spaanjaars Dynamicweb Employee
Imar Spaanjaars
Reply
Just double checked. My Application .zip-file was named Application(8.0.2.2)
That's now an older version too.... ;-)

 

You must be logged in to post in the forum