You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Getting Error in ScrollSelect

8 replies [Last post]
Guest's picture
Guest

I am getting "No Matching Buffer error" when doing ScrollSelect on Component record.rowinit to populate level 2 scroll.

Here is the code
ScrollSelect (2, Level1_rec, Level2_rec, Level2_rec, "Where clause");

I have taken the trace for the scrollselect .. and SQL is fetching the Data.
Level1 scroll is auto select. So I am assuming that I'll have data in Level1 Scroll when coming thru Component Search Page. But looks like this is cribbing.

Any Idea what could be the problem and possible solution.

A solution which I have got is changing ScrollSelect to RowScrollSelect, and it is working fine.

Why such behavior.?

Thanks in Advance
Nitin

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Getting Error in ScrollSelect

Hi Nitin and welcome to the site!

The reason why you are getting such and error is because PeopleSoft can not match a child row to the parent row on your scroll. The reason why RowScrollSelect is working fine is because it doesn't have the logic to place the selected child rows under the correct parent rows, so a match is not important.

I would re-write your code to use the "Select" rowset method instead as the two function you are using are for backward compatibility only (unless you are on a very old PeopleSoft version).

Good Luck!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: Getting Error in ScrollSelect

This is the old code which is cribbing now. I am working on SCM- IN 8.9 but the code exists from 8.4 SP1.

My question is error but WHY?.

I know No matching buffer errors comes when you place child without parent.
Still what is causing the error in scrollselect, when 1st Level scroll is auto select and 2nd level scroll is filling thru above scrollselect.

My logic is saying since it is on Component Recrod rowinit.. where I m trying to fill the whole scroll on first fire of rowinit.
Thus the sucessive child for 2nd , 3rd so on are coming into the buffer before the parent (2nd rowinit) comes.
But want some hard fact to prove it.

Thanks
Nitin

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Getting Error in ScrollSelect

I am getting "No Matching Buffer error" when doing ScrollSelect on Component record.rowinit to populate level 2 scroll.

Rowinit is a good place for the ScrollSelect function. Question though, on what level are you placing your function call? is it on the parent scroll record or the child scroll record (level 2)?!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: Getting Error in ScrollSelect

Its on parent record i.e. Level1 rec

Thanks
Nitin

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Getting Error in ScrollSelect

hmmm, It sounds like your doing every thing right! How about your 2nd scroll, is it marked as no auto select? I'm kind of out of ideas at the moment :(

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: Getting Error in ScrollSelect

Yes .. 2nd level scroll is as no auto select.

Regards
Nitin

Nitin's picture
User offline. Last seen 5 years 43 weeks ago. Offline
Joined: 06/30/2008
Posts: 73
Re: Getting Error in ScrollSelect

Problem resolved
Cause :- Orphan Data in 2nd level record in database.
Solution :- Modified the 2nd level select record (View) to have a join with Level1 rec.

WHY rowscrollselect was working? because it was eliminating the orphan record thru ScrollSelect where clause.

Regards
Nitin

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Getting Error in ScrollSelect

we kind of thought about this at the very beginning, didn't we? :) - Anyway, thanks for sharing your findings with us, this is what makes a community worth coming back to!

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog