Forums

Not answered The request for procedure 'services' failed because 'serv...

Feed from this thread

NK

Posted on Jun 8, 2010 (permalink)

Hi,

After I installed the Sitefinity 3.7.xxx. Then I created a new project and logged in as admin. When I clicked the Administration from the menu bar I got an error "The request for procedure 'services' failed because 'services' is a view object."

and here is the sitefinity.log error

6/8/2010 8:25:35 AM [UNKNOWN]
************************************************************************************
ID: 84ce037d-a3f6-4859-83cf-6665017b4ddb; Code: 3005; Occurrence: 2; Sequence: 18
------------------------------------------------------------------------------------

Application information:
Machine name: CMS-MIL
OS Version: Microsoft Windows NT 5.2.3790 Service Pack 2
Product Version: 3.7.2096.2
Application Path: C:\Program Files (x86)\telerik\Sitefinity3.7\WebSites\CMSSite\
Debug: True

Process information:
Process ID: 984
Process Name: w3wp

Request information:
Request URL: /CMSSite/Sitefinity/Admin/CmsAdmin/Services.aspx
Rewrite URL: http://localhost/CMSSite/Sitefinity/Admin/CmsAdmin/Services.aspx
Url Referrer: http://localhost/CMSSite/Sitefinity/Admin/Default.aspx
Is Authenticated: True
Authentication Type: Forms
User: admin
User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; WOW64; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
User Address: 127.0.0.1

Variables:
CmsHttpRequest: /CMSSite/Sitefinity/Admin/CmsAdmin/Services.aspx
AspSessionIDManagerInitializeRequestCalled: True
RadControlRandomNumber: 0

- L0 -------------------------------------------------------------------------------

Exception Type: System.Data.SqlClient.SqlException

Message: The request for procedure 'services' failed because 'services' is a view object.

Source: .Net SqlClient Data Provider

Stack Trace:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   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.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Nolics.ORMapper.DataProviders.SQLBlockBuilder.EndStatement(SQLCommandEventArgs args, DataRow row)
   at Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecQueryProcedure(StmtContext context, DataRow queryData)
   at Nolics.ORMapper.DataProviders.SQLBlockBuilder.ExecuteQuery(StmtContext context, DataRow queryData, Int32 maxRows, String group)
   at Nolics.ORMapper.DataProviders.SQLDataProvider.ExecQuery(DataSet queries)
   at Nolics.ORMapper.Base.QueryBase`1.LoadQuery(Int32 maxElements, Int32 fromElement)
   at Nolics.ORMapper.Base.QueryBase`1.Load(Int32 maxElements, Int32 from)
   at Nolics.ORMapper.Base.QueryBase`1.LoadAll()
   at Telerik.Search.Data.DefaultProvider.GetServices()
   at Telerik.Search.WebControls.Admin.ControlPanel.LoadMainScreenTemplate()
   at Telerik.Search.WebControls.Admin.ControlPanel.CreateChildControls()
   at System.Web.UI.Control.EnsureChildControls()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.AddedControl(Control control, Int32 index)
   at Telerik.Cms.Web.UI.ServiceList.CreateChildControls()
   at System.Web.UI.Control.EnsureChildControls()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Control.PreRenderRecursiveInternal()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
------------------------------------------------------------------------------------

Can anyone help?

Thanks,

Reply

Radoslav Georgiev Radoslav Georgiev

Posted on Jun 8, 2010 (permalink)

Hi NK,

Thank you for using our services.

When you created the website and connected it to a database did you use a blank database or you have connected the website to an already existing db with tables and other db objects already existing there? Also could you please let us know what kind of DB are you using? We do have a stored procedure called Services. From the stack trace it seems that your DB has another object called Services which is a view. Sitefinity does not create any Views in your database.

Regards,
Radoslav Georgiev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

Reply

NK

Posted on Jun 8, 2010 (permalink)

Hi,
I am using SQL 2005. This is a whole newly created DB and I just reused the Users. that was all.

When I created a new project then I pointed to that new DB.

Thanks,

Reply

Radoslav Georgiev Radoslav Georgiev

Posted on Jun 8, 2010 (permalink)

Hi NK,

Could you please let us know how you reused the users? Also if you create a new project and do not reuse the users is this behavior reproducible?

Kind regards,
Radoslav Georgiev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

Reply

NK

Posted on Jun 8, 2010 (permalink)

Hi,
The reuser of Users from Database/Security/Users. This type of user has been user in another Sitefinity project.

When I created a new DB. I allowed this reuser of User to be able to connect and login to this DB.

Do you recommen that I should create a new user in DB with new user.

Thanks,

Reply

Radoslav Georgiev Radoslav Georgiev

Posted on Jun 8, 2010 (permalink)

Hello NK,

Now I understand what you saying. No the database user which is used to make the connection string can be re-used. You just need to verify that the user you are adding to this db has db_owner privileges over the database.

Kind regards,
Radoslav Georgiev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

Reply

NK

Posted on Jun 8, 2010 (permalink)

Hi,
Yes, I do check on that:

Schemas owned by this user: db_onwer
Database role membership: db_owner

Still got error.

Thanks,

Reply

Radoslav Georgiev Radoslav Georgiev
Posted on Jun 10, 2010 (permalink)

Hi NK,

I have tried to reproduce your issue several times already however to no avail. You can try out the attached project I am sending. If you reproduce the issue on this project please open a support ticket and send over the project and its database.

Greetings,
Radoslav Georgiev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Attached files
- samplewebsitedb.zip
- samplewebsite.rar
Reply

Forums

Not answered The request for procedure 'services' failed because 'serv...

DevTools for .NET

Kendo UI

Test Studio

Sitefinity

TeamPulse

Call us

Anonymous

About Telerik