KevinHarder.com

Here's the classic "if you're reading this, then it must have worked" post.  I made the jump to...

The final version of Community Server 1.1 was released today. Go download it now while it's fresh! Community...

I have been back and forth for a while on which direction to go with regard to software to host my blog....

Finally switched to Community Server

1.1.  Very exciting!!  Set up was very simple. ...

Simon Dingley and Young Joo found a bug in the latest version of the DotText-CS-Converter (v2.2). It...

There seems to be a small resurgence in migrating .Text to Community Server after the CS 2007 release

Great tool,

I have some problems, look below

System.Data.SqlClient.SqlException: Invalid column name 'BlogGroup'.

Invalid column name 'Flag'.

Invalid column name 'Flag'.

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)

at System.Data.SqlClient.SqlCommand.ExecuteReader()

at KevinHarder.DotText_CS_Converter.MainForm.GetDotTextBlogs(String host) in C:\CommunityServer\Packages\DotText-CS-Converter\source_code\Main.vb:line 1654

at KevinHarder.DotText_CS_Converter.MainForm.pageDotTextBlogs_BeforeDisplay(Object sender, EventArgs e) in C:\CommunityServer\Packages\DotText-CS-Converter\source_code\Main.vb:line 1584

at Divelements.WizardFramework.WizardPageBase.OnBeforeDisplay(EventArgs e)

at Divelements.WizardFramework.Wizard.GoNext()

at Divelements.WizardFramework.Wizard.c(Object A_0, EventArgs A_1)

at System.Windows.Forms.Control.OnClick(EventArgs e)

at System.Windows.Forms.Button.OnClick(EventArgs e)

at System.Windows.Forms.Button.WndProc(Message& m)

at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)

at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)

at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************

mscorlib

Assembly Version: 1.0.5000.0

Win32 Version: 1.1.4322.2032

CodeBase: file:///c:/windows/microsoft.net/framework/v1.1.4322/mscorlib.dll

----------------------------------------

DotText-CS-Converter

Assembly Version: 2.2.0.0

Win32 Version: 2.2.0.0

CodeBase: file:///C:/Documents%20and%20Settings/teriksson/My%20Documents/n-jweb(intranet)/conversion_tool/DotText-CS-Converter_v2.2/DotText-CS-Converter/DotText-CS-Converter.exe

Thomas,

What version of .Text are you trying to upgrade from? From the error message, it looks like one or more columns the converter is looking for is missing from the .Text tables. If you are running a version prior to 0.95, try upgrading to v0.95 before running the converter.

- Kevin

Hi Kevin,

While migrating the tool gives me the following error in the log:

6/28/2005 9:43:16 PM: Converting articles.

6/28/2005 9:46:54 PM: Failed to create article 13 en 14 AUG: Solar. Exception was thrown!

6/28/2005 9:46:54 PM: Error occured during conversion!

Error Message: Violation of PRIMARY KEY constraint 'PK_forums_Categories'. Cannot insert duplicate key in object 'cs_Post_Categories'.

The statement has been terminated.

Stack Trace: at KevinHarder.DotText_CS_Converter.Conversion.Convert() in C:\CommunityServer\Packages\DotText-CS-Converter\source_code\Conversion.vb:line 340

Please advise :-)

I get to the 'Converting Posts' stage of the import and get the error 'Execute permission denied on object 'cs_PostCategory_CreateUpdateDelete_With_Identity' and I can't seem to overcome the error. The log file is no help as it simply states that an exception was thrown for each post it attempted to import.

Any help would be appreciated.

Hi Simon,

When you convert with the option to preserve the .TEXT ID's, the converter will temporarily create a couple of stored procedures that are used for converting posts and categories. It looks like the converter on your machine is getting a permissions error when trying to run those procs.

Can you verify that the CS connection string you are using has db owner permission on your database? If not, then you could try modifying the custom_sql_objects.sql file that comes with the converter and add grant statements for the db user you are using. Let me know if you need any help. Cheers!

Hi Kevin,

My host does not allow me to create a dbo user. Your assistance in overcoming this problem would be greatly appreciated thanks.

I am currently having a problem with this tool. I am pointing the tool to my hosted .Text installation and hosted CS installation.

Below is from the error log.

7/6/2005 4:56:24 AM: Attempting to create user youngj.

7/6/2005 4:56:24 AM: User youngj already existed in the CS site. Using the existing instance.

7/6/2005 4:56:24 AM: Attempting to create weblog youngj.

7/6/2005 4:56:24 AM: Blog youngj already existed in the CS site. Using the existing instance.

7/6/2005 4:56:24 AM: Reading .Text blog content for 1 blogs.

7/6/2005 4:56:26 AM: Finished reading .Text blog content.

7/6/2005 4:56:26 AM: Starting to convert posts.

7/6/2005 4:56:26 AM: Failed to create post SQL Server Best Practices Analyzer. Exception was thrown!

7/6/2005 4:56:26 AM: Error occured during conversion!

Error Message: EXECUTE permission denied on object 'cs_PostCategory_CreateUpdateDelete_With_Identity', database 'ekyk200_cs', owner 'dbo'.

Stack Trace: at KevinHarder.DotText_CS_Converter.Conversion.Convert() in C:\CommunityServer\Packages\DotText-CS-Converter\source_code\Conversion.vb:line 313

As you can see, the error is about EXECUTE permission of stored procedure.

The strange thing is that EXECUTE permission is removed from the stored procedure after running the tool even if I correctly set it using GRANT statement right before running the tool. This keeps happening.

When I stepped thru the code using VS debugger, it craps out on line 67 of SqlCommonDataProvider.vb.

Any idea?

By the way, I can successfully post via CS's admin interface. This is what confuses me... :(

Hi everyone, I am on vacation out of town this week and will return this weekend. I will respond to everyones comments and emails on Sunday. Sorry for the delay!

Young Joo, I was having the same problem but unfortunately my SQL is not too good. I managed to overcome the problem by running the tool so that is creates the required store procedures and then letting the tool fail because of the lack of execute permissions. I then opened up the custom_sql_objects.sql file and removed everything from it so the store procedures would not be dropped next time the tool ran. I then used Enterprise Managager to give my user execute permissions on the sp's and it worked :)

Simon... Thanks for your help. I should have spent more time looking at the source code. I thought cs_weblog_Post_Create_With_Identity and cs_PostCategory_CreateUpdateDelete_With_Identity were part of CS. Didn't realize they were created by the tool.

The problem is that custom_sql_objects.sql is missing 'GRANT EXECUTE' statements for each stored procedure. I force my developers to use the template that includes both DROP PROCEDURE statement as well as GRANT EXECUTE statement because of this issue. You can never assume that the SQL user your application uses is a part of a proper group or has appropriate execute permission which is what Kevin must have assumed. I added GRANT EXECUTE statements with my SQL user and it worked.

Another thing I noticed about how the tool execute the stored procedure. It will fail the script ends with 'GO' statement because of how the tool builds SQL statement from the file and how it depends on 'GO' statement to figure out when to send collected SQL statement to the database. So I guess not including 'GO' at the end was kind of a hack... even if it's not a good practice. This is sort of like a boundary condition hack...

Simon and Young,

Thank you both very much for finding my mistake and posting it here. I am sorry I wasn't more help last week - I was out-of-town and checking my blog by cell phone.

I just created a new blog post about that issue, and added the grant statements to sql script in the current version of the converter.

Hi Kevin, I got an error when converting .95 to CS1.1 RC3:

Invalid Columnname 'lsActive'

Any sugesstions where to look for the error ?

Thanks very much

Will you be updating this to CS 2.0??

yes we need version 2.0 pls pls  :D