Question

I'm trying to use obj-browse to examine my index table entries but I keep getting <Can't use property "pzPVStream" in this report. It's not a column and it doesn't exist in the Blob.>

I'm trying to use obj-browse to examine my index table entries but I keep getting <Can't use property "pzPVStream" in this report. It's not a column and it doesn't exist in the Blob.>

I can avoid the error by filtering on some properties, but then I don't get all the properties.  The documentation says there's a way to get all the properties (exposed columns) but it's not clear how.  Thanks.  /Eric

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Comments

Keep up to date on this post and subscribe to comments

November 18, 2015 - 10:10pm

Is this perhaps related/similiar to  SR-76665

November 19, 2015 - 8:51am
Response to JoelMcLeish

That seems to be for an older version (4 years old !)  I'm on Pega 7.  It would be nice to know the answer, although I did it the tedious way for now, spelling out each property I really needed to see on one of the filter lines.  /Eric

November 19, 2015 - 8:56am
Response to ericosman_GCS

Eric,

I'm not sure the context, but pzPVStream isn't in the blob because it IS the blob. Are you trying to intentionally browse the pzPVStream? I would think removing any mention of it in your obj-browse should make the error go away.

- Mike

November 19, 2015 - 4:59pm
Response to ericosman_GCS

Hey Eric,

There is a discussion on Mesh around that SR that spells out an almost identical scenario, the reason i suggested the relation.

This issue was a prpc issue and taken over by Kip.

Setup a simple reproduction of the customer’s scenario. This issue occurs if the Select checkbox is not selected, which causes the select statement to utilize pzPVStream in the select statement. If the external table does not have this column then the customer will receive this issue.

Provided the customer with HFix-5974. This hotfix was developed to address this issue.

It may be 4 years old but it may be worth checking if that Hfix made it into a release.

November 19, 2015 - 11:04am

Iam not sure whether this answer's your question but so as to retrieve all the properties using obj-browse method you should not  check any row under Select. Please see below snapshot for reference

2015-11-19 23_59_47-Pega Designer Studio.png

November 19, 2015 - 2:21pm

Bhanu, when I try to do it similarly to your example, I get the error I reported.  Here's my snaps.  /Eric

browsesetup.jpgbrowseerror.jpgbrowsetrace.jpg

Pega
November 19, 2015 - 3:15pm

Hi Eric,

When you perform obj-browse and if you have not selected any row or Filters, it would fetch the complete blob data from the table, if you have selected any row or Filters it will only return the value of those properties on each embedded page.

In your case i assume that Index-MyProp table doesn't have the blob column, selecting one row in your obj-browse method will resolve your issue.

November 19, 2015 - 3:37pm

Yes, i believe error is because of not selecting any property in the select fields.

November 19, 2015 - 4:19pm
Response to Venkata_D

As already mentioned, if I filter on some property, the filtering works, but in that case the resultant items in the Code-Pega-List only have the value of the property I filtered on.

I want to see ALL the properties (i.e. all the exposed columns) shown.   /Eric

Pega
November 19, 2015 - 7:35pm
Response to ericosman_GCS

In that case you have to include all the properties in the select field options. I don't think so there is an option to include all the properties on the resultants page when there is no blob column in the table.

December 10, 2015 - 9:17am

This "Nov 19, 2015 7:35 PM" may be the answer but I'm not sure.  If it is, I suggest it be documented !    In summary:  There are times when one wants obj-browse to return ALL the columns.   This seems to be quite easy to do if there happens to be a blob involved, but it is unclear how to do it when no blob exists.   For user-defined tables, it is very common for there not to be a blob.  [ hmmm, is it easy to set a Boolean on my table to indicate that yes-it-has-a-blob   ?   Might that be an answer ? ]   The "Nov 19, 2015 7:35 PM" note suggests that one must explicitly spell out all the columns on the obj-browse parameters if there is no blob and you want all the data but that doesn't seem like a useful way to do it since that set of columns may change.  /Eric

July 11, 2017 - 10:06am

Hi ericosman_GCS 

Your answer above says that it is easy to retrieve column values using Obj-Browse when the table has a BLOB. I have a requirement where I need to fetch few property-values for a given set of work objects, from the Blob data. I tried to use Obj-Browse to fetch it but I guess we can give only the direct column names in the select portion. Please suggest. Thanks

July 24, 2017 - 3:16pm

I am no longer needing more info on this discussion.  Thanks everyone who responded.