Re: Bug? VC causing "App did not load successfully...

Joseph_Seddik · 02-24-2022 11:52 PM

Hello,

In a table "COLA", I have a column named "Cumulative change", type: Percentage, with the following app formula:

IFS(
AND(ISNOTBLANK([Base Wage]), NOT(0 = [Base Wage])), 1,
IN([year-1], COLA[Year]), (1 + [Yearly Change]) * [year-1].[Cumulative change],
TRUE, 1
)

Where:

"Base Wage", type: Price, no formulas, user input.
"Year", type: Number, no formulas, user input.
"year-1", virtual, type: Ref, pointing to the same "COLA" table, App Formula: [Year] - 1
"Yearly Change", type: Percentage, no formulas, user input.

Works correctly, giving the desired behavior.

When I tried changing this column with the exact same setup to a Virtual Column, upon clicking Save in the editor, the app stays in "syncing" for few minutes (not seconds) and eventually fails with the following vague error:

<html><head>
<meta http-equiv="content-type" content="text/html;charset=utf-8">
<title>502 Server Error</title>
</head>
<body text=#000000 bgcolor=#ffffff>
<h1>Error: Server Error</h1>
<h2>The server encountered a temporary error and could not complete your request.<p>Please try again in 30 seconds.</h2>
<h2></h2>
</body></html>

Inside the editor, there is no error indication in Info or in any other place.

Any thoughts please? Thanks.

Update:

The whole app is just one small table. Here it is:

Update 2:

This is a link to the app's editor:

https://www.appsheet.com/Template/AppDef?appName=COLA-5317163

Steve

Hmmm... How large is this table? How large is the table the year-1 column references?

Joseph_Seddik

Pretty small actually, just 13 rows. The whole app is just one small table. Here it is:

Thank you Steve!

Steve

😕

I have no idea, then! Very odd!

Joseph_Seddik

Thank you!

I've tried replacing this part [year-1].[Cumulative change], with its equivalent:

ANY( SELECT(COLA[Cumulative change],
[Year] = [_THISROW].[Year] - 1
))

Same behavior, works as a normal column, but not a virtual column.

Joseph_Seddik

This is a link to the app's editor:

https://www.appsheet.com/Template/AppDef?appName=COLA-5317163

Joseph_Seddik

@Steve Thank you!

Bug? VC causing "App did not load successfully"