StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » StrataFlix: Error Searching People

StrataFlix: Error Searching People

Bill Cunnien — Thu, 25 Mar 2010 17:29:22 GMT

The following error was received when I attempted to run a people search, then double-clicked on one of the results:

[quote]Could not find stored procedure 'dbo.PeopleMaintenance_RetrieveAllData'.[/quote]

I thought I downloaded the most recent version.

Thanks,
Bill

RE: StrataFlix: Error Searching People

Edhy Rijo — Thu, 25 Mar 2010 17:29:22 GMT

Hi Sam,

I posted a download link for the version of the database I have.

[url=http://forum.strataframe.net/FindPost26630.aspx]http://forum.strataframe.net/FindPost26630.aspx[/url]

RE: StrataFlix: Error Searching People

Sam Tenney — Thu, 25 Mar 2010 16:26:03 GMT

Trent,

I am just a beginner, so I am not sure about this report, but in the StrataFlix database I do not see a PeopleImages table relating to the PeopleImagesBO. I think this is what is causing an "Invalid object name 'PeopleImages'" error when trying to LoadAllPeopleData.

Sam Tenney

RE: StrataFlix: Error Searching People

Sam Tenney — Thu, 25 Mar 2010 13:34:22 GMT

Hi Edhy,

Thanks for the stored procedure, but after successfully creating the stored procedure, I am now getting another error. The error is:

Invalid object name 'PeopleImages'.

I am just a beginner and have no idea why this is happening.

Sam Tenney

RE: StrataFlix: Error Searching People

Trent L. Taylor — Mon, 08 Mar 2010 09:26:57 GMT

I will repost this database when the next update is posted. Sorry for the trouble! :crazy:

RE: StrataFlix: Error Searching People

Larry Caylor — Fri, 05 Mar 2010 11:38:06 GMT

I'm having the same issue and I downloaded it this morning.

RE: StrataFlix: Error Searching People

Trent L. Taylor — Tue, 02 Mar 2010 08:49:52 GMT

OK, I will take a look at this and see what is going on.

RE: StrataFlix: Error Searching People

Bill Cunnien — Tue, 02 Mar 2010 07:23:49 GMT

Yes...I downloaded and reinstalled it yesterday. It is still not showing up.

RE: StrataFlix: Error Searching People

Trent L. Taylor — Mon, 01 Mar 2010 15:34:45 GMT

Hmmm....Edhy is getting you going but I am concerned that you don't have the most recent. Did you download this from the My Account area?

RE: StrataFlix: Error Searching People

Edhy Rijo — Mon, 01 Mar 2010 13:37:40 GMT

Hi Bill,

Here is the sp:

[codesnippet]
USE [StrataFlix]
GO

/****** Object: StoredProcedure [dbo].[PeopleMaintenance_RetrieveAllData] Script Date: 03/01/2010 14:00:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[PeopleMaintenance_RetrieveAllData] @peoplePk INT,
@includePeople BIT
AS
BEGIN

-- Determine if the people result set should be included
IF @includePeople = 1
BEGIN
-- Retrieve the people data result set
SELECT
*
FROM People
WHERE pl_pk = @peoplePk;
END

-- Retrieve all of the movies (filmography) for the person
SELECT
MovieCast.*,
Movies.mv_Title,
Movies.mv_Year
FROM MovieCast
LEFT JOIN Movies ON mc_mv_pk = mv_pk
WHERE mc_pl_pk = @peoplePk
ORDER BY Movies.mv_Year;

-- Retrieve the images associated with the people
SELECT
*
FROM PeopleImages
WHERE pli_pl_pk = @peoplePk;

END
GO

EXEC sys.sp_addextendedproperty @name=N'DDT_Priority', @value=10 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'PROCEDURE',@level1name=N'PeopleMaintenance_RetrieveAllData'
GO

[/codesnippet]

RE: StrataFlix: Error Searching People

Bill Cunnien — Mon, 01 Mar 2010 13:09:54 GMT

No. It is not located in the list of sprocs.

RE: StrataFlix: Error Searching People

Trent L. Taylor — Mon, 01 Mar 2010 12:48:19 GMT

Is that sproc in the database you have? You can find it through SSMS in the programmability area.