Error: I-QO051: Output is invalid (ORA-936). Contact Target Software for assistance - User Defined Output Entry

Client reported the"I-QO051: Output is invalid (ORA-936).  Contact Target Sofware for assistance."  error  after making an update to one of their outputs.  

Article Number: 100770

Products:

  • Team_Approach
The issue was that the SQL syntax in the output for the a field had a null after (+)=.
In the example provided, Telephone Number had the  T2.PREFERRED_TELEPHONE(+) =.  The resolution was to update the syntax to be  T2.PREFERRED_TELEPHONE(+) = 'Y'.
 

Environment

 RSR
 TA

Was this article helpful?

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!