Dashboard throws error on compile, works fine in design

Hi All,

I am developing a simple dashboard in Epicor 9. It is linked to an External BAQ which is pulling data from sql view.

The dashboard seems to work fine in design mode. But when I am hitting the ‘Test Application’ button on Deploy Dashboard, it is throwing this compile error:

--------compile errors------------
Error: CS1002 - line 68 (67) - ; expected
Error: CS1002 - line 69 (68) - ; expected
Error: CS1525 - line 69 (68) - Invalid expression term ‘.’
Error: CS1002 - line 69 (68) - ; expected
Error: CS1026 - line 70 (69) - ) expected
Error: CS1002 - line 70 (69) - ; expected
Error: CS1525 - line 70 (69) - Invalid expression term ‘)’
Error: CS1002 - line 71 (70) - ; expected
Error: CS1002 - line 72 (71) - ; expected
Error: CS1525 - line 72 (71) - Invalid expression term ‘.’
Error: CS1002 - line 72 (71) - ; expected
Error: CS1026 - line 73 (72) - ) expected
Error: CS1002 - line 73 (72) - ; expected
Error: CS1525 - line 73 (72) - Invalid expression term ‘)’

** Compile Failed. **

I haven’t written any custom code so I am not sure what above errors are about.

Any idea?

Thanks.

Ok, so this is resolved.

The problem was that the SQL view had field names with spaces (e.g. Customer.Address AS [Customer Address].

After I removed spaces I am able to do ‘Test Application’.

Thanks.