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? :-/
Developer forum
E-mail notifications
SQL Error after installation (own server)
Søren Alexandersen
Replies
Imar Spaanjaars
Posted on 29/06/2012 22:21:12
Did you get the DefaultEmptyData8Sql? There's a special version for DW 8 on the Downloads page.
Cheers,
Imar
Cheers,
Imar
Søren Alexandersen
Posted on 29/06/2012 22:29:28
Hi Imar
Yes I did.. sorry I didn't mention that.
I downloaded all files from the website today. All version 8 :-)
Yes I did.. sorry I didn't mention that.
I downloaded all files from the website today. All version 8 :-)
Imar Spaanjaars
Posted on 29/06/2012 22:34:18
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
Cheers
Imar
Søren Alexandersen
Posted on 29/06/2012 22:35:55
Thanks..
Could you elaborate on "make sure you ran all the updates for BW by resetting the version numbers" ?
Could you elaborate on "make sure you ran all the updates for BW by resetting the version numbers" ?
Imar Spaanjaars
Posted on 29/06/2012 22:37:27
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
Cheers,
Imar
Søren Alexandersen
Imar Spaanjaars
Posted on 29/06/2012 22:57:52
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
Posted on 29/06/2012 23:00:36
I am begging to doubt the versions, because update.xml said 611 (?)
Søren Alexandersen
Posted on 29/06/2012 23:00:56
"beginning".. I meant to write :-)
Søren Alexandersen
Posted on 29/06/2012 23:02:06
Just double checked. My Application .zip-file was named Application(8.0.2.2)
Imar Spaanjaars
Posted on 29/06/2012 23:05:54
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
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
Posted on 29/06/2012 23:07:10
That's now an older version too.... ;-)Just double checked. My Application .zip-file was named Application(8.0.2.2)
You must be logged in to post in the forum