Support Article
There was a problem getting a list: code: 904 SQLState: 42000
SA-47335
Summary
Usage of pyTextValue in the value field for the Obj-Browse method fails.
Error Messages
There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "PYTEXTVALUE": invalid identifier
Steps to Reproduce
- Create a test activity on Pega 7.3.1.
- Create a step with Obj-Browse with a property in a condition (such as, .pyPurpose Is Not Equal .pyTextValue).
For example, browse Data-Admin-System-Settings class with a condition such as, .pyPurpose Is Not Equal .pyTextValue. - Run this activity without specifing a value for .pyTextValue.
Root Cause
A software use or operation error. The pyTextValue is used in the value field.
Resolution
Here’s the explanation for the reported behavior:
pyTextValue is a Value List. Hence, pyTextValue(1) or pyTextValue(2) must be used instead of just pytextValue.
Published April 12, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.