asked on July 23

We have a laserfiche form that does a lookup function based on a stored procedure. One of those fields is called FilingAt. This token seems to be catching a value everytime we run it (confirmed via track tokens) however, when it runs the update word document activity it is terminating due to a stack empty error. the conditional desicion above the update word activity I even resorted to hardcoding based on this store procedure value. NOTHING is working. We have been at this for a day and it still seems to be throwing the error. 

 

We have narrowed it down this one field: FilingAt and it seems to only be happening with cases where the query is grouping a detail table of 2 or more. 

Things we have tried: 

1. Deleting and recreating token in assign token values 

2. Forcing the query to cast ending value as a varchar and mapping the values as a string in token and update word document field.

3. Inputting a conditional decision which hardcodes the values to then use in the update activity.

4. Wrapped our sum conditions in the query case with IFNULL

Query: 

CAST(
CASE
WHEN MAX(ppa25.PropertyNumber) IS NULL THEN 'ASR'
WHEN SUM(ppa25.TotalProposed) > 0 AND SUM(ppa25.TotalAssessorReduced) = 0 THEN 'ASR'
WHEN SUM(ppa25.TotalAssessorReduced) > 0 AND SUM(ppa25.TotalBoardReduced) = 0 THEN 'BOR'
WHEN SUM(ppa25.TotalBoardReduced) > 0 AND SUM(ppa25.TotalPTAB) = 0 THEN 'PTAB'
ELSE 'NA'
END
AS VARCHAR(10)) AS FilingAt

 

Highly confused what could be happening with this. Ive checked every other activity and we dont modify this token at all. The only things it is used for are conditions or an if statement within a token calculator to create another token. Does anyone have any recommendations? 

 

unnamed.png
unnamed.png (40.42 KB)
0 0