Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Error: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.gs_GetVersion"
Options
Previous Topic Next Topic
davenel
#1 Posted : Monday, 24 May 2010 4:58:01 AM(UTC)
Rank: Newbie

Joined: 24/05/2010(UTC)
Posts: 1
I am trying to install Gallery Server Pro locally on my Dev box. I already host with Discountasp.net which is why I am wanting to see if this will meet my need.

OS:Windows 7 Professional 64bit
SQL 2008 Developer (SP1), 64 bit
Silverlight 3.2
VS 2010

I have bumped around most my day, initially trying to add the gs to my existing web project. I then decided just to get a standalone up and runnning and go from there.

First I ran inot the sqlLite issues and found answers in the forum for that. Removed every reference, including in the galleryservepro.config file.

I built a brandnew, basic/standard db called GalleryServerPro. I now launch the default.apsx?g=install page and get the following error:


http://localhost:65233/default.aspx?g=install.

Timestamp
5/24/2010 7:38:48 PM

Exception Type
System.Data.SqlClient.SqlException

Message
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.gs_GetVersion", or the name is ambiguous.

Source
.Net SqlClient Data Provider

Target Site
Void OnError(System.Data.SqlClient.SqlException, Boolean)

Stack Trace
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteScalar()
at GalleryServerPro.Data.SqlServer.SqlDataProvider.GetDataSchemaVersionString()
at GalleryServerPro.Data.SqlServer.SqlDataProvider.VerifySchemaVersion()
at GalleryServerPro.Data.SqlServer.SqlDataProvider.InitializeDataStore()
at GalleryServerPro.Business.AppSetting.Initialize(ApplicationTrustLevel trustLevel, String physicalAppPath, String appName)
at GalleryServerPro.Web.Util.InitializeBusinessLayer()
at GalleryServerPro.Web.Util.InitializeApplication()

Exception Data
HelpLink.ProdName: Microsoft SQL Server

HelpLink.ProdVer: 10.00.2531

HelpLink.EvtSrc: MSSQLServer

HelpLink.EvtID: 4121

HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink

HelpLink.LinkId: 20476

Error Handling Exception: The following error occurred while handling the exception: System.Data.SqlClient.SqlException - Could not find stored procedure 'dbo.gs_AppErrorInsert'. Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at GalleryServerPro.Data.SqlServer.Error.PersistToDataStore(IAppError appError)
at GalleryServerPro.Data.SqlServer.Error.Save(IAppError appError)
at GalleryServerPro.Data.SqlServer.SqlDataProvider.AppError_Save(IAppError appError)
at GalleryServerPro.ErrorHandler.Error.Record(Exception ex)
at GalleryServerPro.Web.Controller.AppErrorController.LogError(Exception ex)
at GalleryServerPro.Web.Controller.AppErrorController.HandleGalleryExceptio n(Exception ex)

App Error ID
-2147483648

Gallery ID
1

++++++++++++++++++++++++++

I saw another person had this error on 5/12/2010, but there does not seem to be a followup on the thread.

Any help please. I have a feeling this is a great product, and will meet many needs I have been looking for for a while now, but need to get it up and going.

Thanks
Back to top
Roger Martin
#2 Posted : Monday, 24 May 2010 6:24:13 AM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
This error will happen when all of the following are true:

* You manually updated the connection string in web.config to point to a database that does not have any GSP tables.
* You updated web.config and galleryserverpro.config to use the SQL Server provider rather than the SQLite provider.
* You open default.aspx in a browser before running the installer.

Under these conditions, GSP is trying to retrieve data from the database but, since the tables haven't been set up, an error occurs.

The fix is to run the installer before doing anything else. The installer is invoked by appending ?g=install to the web page, like this: default.aspx?g=install

What is strange is that you are claiming that you *are* invoking the installer, and yet you get this error. I have just been studying the code and I can't see any mechanism for this error to occur other than what I said above. I could be wrong - the code may be taking an unexpected path, but the most likely cause is the simplest - that this is simply the wrong page being invoked.

If you are sure you are invoking things correctly, then the best thing I can suggest is to use an alternate method to set up the database objects so that when your application tries to access the database, the objects are already there. Probably the easiest way to do this is to use the MS Web Platform Installer to create an installation.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET