Search This Blog

Wednesday, September 19, 2012

RFC select statement

When using the RFC capabilities in BPMC, the feed fails with the error: FIELD_NOT_VALID, even though the select list contains a confirmed valid list of fields.

For example:
Select RYEAR, RPMAX FROM FAGLFLEXT

As a solution, remove the white space between the comma and the field name.

For example:
Select RYEAR,RPMAX FROM FAGLFLEXT

The white space can cause the problems with field name resolution.

No comments:

Post a Comment