No matching buffer found for level-PeopleSoft

This error => "No matching buffer found for level" in PeopleSoft, usually comes with a long description after this which is not that friendly and confuses the user. The complete error text is provided below

---------------------------
Microsoft Internet Explorer
---------------------------
No matching buffer found for level. (15,26)

When retrieving data for a page, a data value was retrieved for which there was no matching data value at a higher level scroll entry.  (For example, at scroll level 2, a value of ABC was read in and scroll level 1 contained this higher level field but did not have a row with a key value of ABC.)  This usually occurs because of an error in a database record or view; or because of improper deletion of values in a database.  Correct the page definition or contact your system administrator.
---------------------------
OK  
---------------------------

To understand how to go about and fix this error..The key statement of the error message is " was no matching data value at a higher level scroll entry".. This means, you are trying to open a component that contains multiple scroll levels. (Level 0, Level 1 and Level2) etc.

Consider the following table setup:

Level=>0
TV
BRANDID
BRANDNAME
Level=>1
TV CITY
BRANDID
CITYID
COUNTRY
Level =>2
TV STORE
BRANDID
CITYID
STOREID
PRICE

Now, one row in TV table can have multiple rows in TV CITY for BRAND ID..on the same lines one row in TV CITY can have multiple rows in TV STORE for BRANID and CITY ID combination. Assume that all these tables are put together in a single component in PeopleSoft and the search record for the component allows query based on BRANDID

Now, the error comes in a scenario where a row in TV STORE table has no match for CITYID in TV CITY table..Even though the Brand ID matches. For example, consider the rows below

BRANDID
BRANDNAME


1
Samsung






BRANDID
CITYID
COUNTRY

1
Chicago
US

1
California
US





BRANDID
CITYID
STORE ID
PRICE
1
Chicago
ST1
900
1
California
ST2
1200
1
Florida
ST3
1400

Here, the CITYID "Florida" does not have a match in TV CITY table, possibly because of a deletion. When you try to open the page in PeopleSoft GUI for this BRANDID, this error will be thrown.

To fix the error, the row corresponding to the CITYID "Florida" needs to be deleted.

2 comments:

  1. Thanks, helped me fix an issue.

    ReplyDelete
  2. Do you know the reason why this error does not come if the component is effective dated and we open it in Include/Correct History mode?

    ReplyDelete