Ask a question about install Bingo to sqlserver 2005

[feng Yao]

Dear Support, 

      I have to apologize to ask about these basis, and ask those simple and basic questions. 

      I want to use Bingo on sqlserver 2005 database , but I Run the "bingo-sqlserver-install.bat" file occurred error.

Error message:

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

--

-- _CheckMemoryAllocate

--

CREATE PROCEDURE [bingo].__CheckMemoryAllocate

    @dotnet_size_mb int,

    @block_size_mb int,

    @core_size_mb int,

    @bingo_schema nvarchar(max)

AS

  EXTERNAL NAME [bingo_assembly].[indigo.Bingo]._CheckMemoryAllocate

ADD SIGNATURE TO [bingo].__CheckMemoryAllocate BY CERTIFICATE bingo_certificate

  WITH PASSWORD = 'B!ngoB!ngo'

Msg 156, Level 15, State 1, Server ANDY\SQLEXPRESS, Line 1

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

Tested Configurations

Operating System:  Windows XP Professional

DataBase :               SQL Server 2005 Express (32-bit)

Installation Procedure:  bingo-sqlserver-install.bat -database mydb -dbaname sa -dbapass 123456 -y

Thank you for your help and your precious informations. 

Warmest Regards

Andy

 

    

[Mikhail Rybalkin]

Hello Andy,

Msg 156, Level 15, State 1, Server ANDY\SQLEXPRESS, Line 1

Usually such messages consist of two lines: line that you have posted and line with error description. For example

    Msg 156, Level 15, State 1, Server ANDY\SQLEXPRESS, Line 1

    Incorrect syntax near the keyword ...
Does your error message have some additional information?

It might be that installation script was developed and tested on machine with some different default configuration for t-sql scripts. Can you login under "sa" account and execute DBCC USEROPTIONS.

And before executing bingo-sqlserver-install.bat you need to execute bingo-sqlserver-uninstall.bat to remove partially added procedures and etc. because installer doesn't cleanup installed objects in case of error.

--
With best regards
Mikhail Rybalkin

[Mikhail Rybalkin]

Hello Andy,

"There is an error arround keyword 'ADD'".

This makes things more clear now. I have found explanation about this strange issue that have to be fixed in Service Pack 1.
http://blogs.msdn.com/b/stuartpa/archive/2005/10/03/476622.aspx
In that post it is mentioned that sqlcmd think that 'ADD' is a procedure and automatically adds EXEC statement before it. So can either install service pack (I have found that latest service pack is SP4) or add suggested workaround. But I think that it is better to install Service Pack.

Or if it is not possible to install Service Pack then as a workaround they suggested to add ';' before 'ADD' command. In this case you can modify bingo_create_methods.sql script file and add ';' before 'ADD' commands. For example:
;ADD SIGNATURE TO [$(bingo)].__CheckMemoryAllocate BY CERTIFICATE $(bingo)_certificate
  WITH PASSWORD = '$(bingo_pass)'
GO

If this doesn't help then we will create testing configuration that match yours one and will try to reproduce this issue. In this case could you please send us your full version of SQL Server?
SELECT @@version

--
With best regards,
Mikhail Rybalkin

On 4/21/2011 04:41, feng Yao wrote:

Dear Mikhail,

Thanks so much for your answer!

Yeah, There's line 2 in the error message which is in Chinese, then error message in english is :

"There is an error arround keyword 'ADD'".

I have redo it following your steps, still get the same error message.

I attached the screenshot of the result after excuting "DBCC USEROPTIONS". Please take a look.

Best Regards!

Andy

2011/4/21 Mikhail Rybalkin <ryba...@ggasoftware.com>

[feng Yao]

Dear Mikhail ,  

          The problem has been solved. Thank you so much for your help!

         

        With best regards!

[Mikhail Rybalkin]

Hello Andy,

The problem has been solved. Thank you so much for your help!

Great! But can you describe the solution. It might be useful for others.

--
With best regards,
Mikhail Rybalkin

[feng Yao]

Dear Mikhail,

      I just modified "bingo_create_methods.sql"  script file, add ';' before 'ADD' commands.

 For example:

;ADD SIGNATURE TO [$(bingo)].__CheckMemoryAllocate BY CERTIFICATE $(bingo)_certificate
  WITH PASSWORD = '$(bingo_pass)'
GO

And this solution works for me. Hope it will work for other friends who meet this problem.

Regards,

Andy

2011/4/23 Mikhail Rybalkin <ryba...@ggasoftware.com>