What's new in Customer Journeys?

Connect and learn more!
Updates to OAS SQL for “Failed to Load SQL” error — Cloud Customer Connect
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

Updates to OAS SQL for “Failed to Load SQL” error

edited Sep 8, 2023 5:50PM in Student Financial Aid

While testing the BI Publisher to OAS migration in 23C, an issue was discovered where certain data models received a "Failed to Load SQL" error. It was determined this was due to how OAS interprets a "Regular Expression" syntax. We will be updating three of our product data models, used for our Aid Offer Letter, Aid Offer Letter (Max Award Version) and the Provisional Aid Offer Letter, to utilize the "ON OVERFLOW TRUNCATE WITH COUNT" operation. Please see our attachment to use as a template for updating any custom data models that currently contain a regular expression.

Howdy, Stranger!

Log In

To view full details, sign in.


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