I have created several apps using Nitro App Builder where I have a function in my SQL statement. This is a function we use regularly to retrieve an account's current balance and is used like "select acctbal(accountNumber) as Balance from mylib/myfile". On each app I create with the App Builder, the function works great on the first page of the grid but then gets an error when paging to the next page.
The error is:
An unexpected error occurred on the server. See Valence error log for further details.
Description: SQL statement prep failure (SQLSTT=42845) - SQL0583 - Use of function ACCTBAL in PRODLIB not valid.
Error Log ID: 7844
So it works fine on the first page and also for all records when I click my icon to download the results to Excel, but not when I page through on the grid. This is a problem on each of the apps where I have included this function.
The error is:
An unexpected error occurred on the server. See Valence error log for further details.
Description: SQL statement prep failure (SQLSTT=42845) - SQL0583 - Use of function ACCTBAL in PRODLIB not valid.
Error Log ID: 7844
So it works fine on the first page and also for all records when I click my icon to download the results to Excel, but not when I page through on the grid. This is a problem on each of the apps where I have included this function.
Comment