StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Error (Invalid object name 'dbo.SFSUserRolePermissionInfo')

Error (Invalid object name 'dbo.SFSUserRolePermissionInfo')

Michael Reese — Wed, 28 May 2008 10:52:15 GMT

I am getting the above error after logging into my application. I created a security project, deployed it into my application (with data) via the DDT.

It happens at this point

Protected Overridable Sub OnAttemptLogin()

RaiseEvent AttemptLogin(Me, EventArgs.Empty)

End Sub

Michael

RE: Error (Invalid object name 'dbo.SFSUserRolePermissionInfo')

Trent L. Taylor — Wed, 28 May 2008 10:52:15 GMT

That is somewhat of a tough question :) First, make sure that the views are in your profile...that would be the first step. If not, then you will want to reimport them into the DDT, then redeploy. That would be the first place to look.

RE: Error (Invalid object name 'dbo.SFSUserRolePermissionInfo')

Michael Reese — Tue, 27 May 2008 19:35:07 GMT

In the same database. Had some errors. I tried to redeploy and cannot get the views. What should I do?

Thanks

RE: Error (Invalid object name 'dbo.SFSUserRolePermissionInfo')

Trent L. Taylor — Tue, 27 May 2008 19:04:17 GMT

It looks like Greg is on the trail...it doesn't look like your security tables were deployed with your application or you are using a separate database for security and did not set the data source key for the security tables...you might double-check your deployed environment on these points.

RE: Error (Invalid object name 'dbo.SFSUserRolePermissionInfo')

Greg McGuffey — Tue, 27 May 2008 18:42:01 GMT

Looks like all the security views didn't get deployed. First (just to be sure), have you deployed the security tables/views/etc. to the database? When you deployed were there any errors?