Hi. Ran into an issue in PB2022 Build 1892. We had migrated from PB2019 Build 2353.

Working on an item and suddenly a DataStore with a SQL Select datawindow attached started returning -1 on Retrieve(). I jumped through some hoops before finally re-creating the datawindow from scratch, and that resolved the issue.

When I compared existing to new I found that the table definition in the datawindow had added a "dbalias" property to each of my columns. The dbalias property was not on the newly created datawindow.

table(column=(type=char(32) updatewhereclause=yes name=keyname dbname="v_adm_settings.keyname" dbalias=".keyname" )

It must've done this when I opened it with PB2022 because it did not exist in PB2019 and source control shows it wasn't there prior to my modifying the datawindow. 

Once I removed all of those properties, my DataStore started retrieving properly again.

Something to check if you start having issues with retrieving data.