Terrarium Server - Strange periodic message in EventLog

Hot Topic

Refreshing DataGridView when I close Detail Form
Property Grid Question
Reference a from from a Class
Web DataGrid Selection
TaskVision client destroyed my PC!
.NET Popup Toasts (msn like), need to make more slick and smooth
"The terrarium server is experiencing temporary difficulties. This is probably why you are not receiving any animals. Please bear with us while we get the issue resolved."
toolStripStatusLabel.Text doesn't update?
DataGridView and ComboBoxColumn problem
Application Menu Accelerators do not work in Managed C++ 2.0 with VS 2005 IDE

Windows Forms

How to change the keys in the config file
Sending mail with VB.Net
Checkbook register control?
Data Adapter Error with DateTime
Disabling all the Panel elements...
DataGrid Column Title
Sample Code: TreeGridView - collapsing/expanding DataGridView
ScrollBars location for panel
Panels Vs User Controls
Process won't terminate, even with call to Environment.Exit()

Terrarium Server - Strange periodic message in EventLog

Event Type:Error
Event Source:Terrarium Reporting WebService - ReportPopulation
Event Category:None
Event ID:0
Date:02.03.2004
Time:17:34:36
User:N/A
Computer:FIESTA
Description:
System.Data.SqlClient.SqlException: Cannot resolve collation conflict for equal to operation.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = 0, current count = 1.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at TerrariumServer.NonPageServices.OnReportingTimerElapsed(Object src, ElapsedEventArgs args) 
===============
What is the problem

Answer this question

Terrarium Server - Strange periodic message in EventLog

  • Charles Salfity

    If I read the error message correctly, it indicates that there is a bug in the code whereby a transaction is started but neither commited nor rolled back before another transaction is started.

  • mightymoe

    I'll be sure to look into this for the next release.  Looks like there may be a problem if the SQL Server has collate set to something other than the default.  We should handle this, if possible.

  • NeilQiu

    Solved!
    How to solve: run SQL Enterprise Manager, locate Terrarium database, goto stored procedures. Locate TerrariumAggregate procedure, open it and change the following line:
    CREATE TABLE #ExtinctSpecies (Name varchar(250)) to
    CREATE TABLE #ExtinctSpecies (Name varchar(250) COLLATE SQL_Latin1_General_CP1_CI_AS)

    Click OK, to save.

    Seems to work now.
  • Terrarium Server - Strange periodic message in EventLog
Answer this question