Report - baq errors

Epicor ERP 10
,
1

I created a baq, report definition, report style, report. When I run the report I get following error:
BAQ execution returned errors:
Bad SQL statement.
Review the server event logs for details.

The BAQ Tests and Analyzes fine. I stripped all the fields out of the report - same error.

Per the error message, is there any logs or such that I can see more information?
Thanks!

2

Are you converting any data? Those are runtime errors and won’t show up in the Analyze button. Also different data types in a join.

You can see errors in the event viewer on the Epicor Application server.

image

Ross

3

OK! I was looking in wrong spot. I will double check all my joins. Thanks for the explanation - that was driving me buggy!