You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

JBO-25184: Exception : oracle.jbo.JboException Invalid state

edited Oct 20, 2020 6:08PM in Sales 3 comments

Summary

Getting an exception in object function if I specify setMaxFetchSize(5000) for VO

Content

I have object function which will fetch records from custom object and try to update Account object based on the account_id got from custom object.

Normally script fetching 500 records from VO but I have 5000+ records. So I tried to set setMaxFetchSize(5000) for Custom Object VO but inside loop condition OrganizationProfile VO giving an error as "oracle.jbo.JboException Invalid state"

Even I tried to set setMaxFetchSize(5000) for OrganizationProfile too but facing the same error. 

If I didn't set fetch size for any of the VO then script running without error but fetching only 500 records from custom object.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!