Unexpected end of file

henningp

Hi All,<br />
<br />
I changed a line of my sql-statement in my dataset and now I'm getting continuously the error<br />
<br />
An unexpected internal exception occurred. <br />
Error Code:Error.GUIException.invokedByUnexpectedException<br />
Error Message:Unexpected end of file<br />
<br />
when I try to edit the dataset or preview the report. I reverted the changes in the XML-File but the error is still there!<br />
<br />
At first the SQL-Code was:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT
w.combinedname_reversed as name,
MIN(wp.controldaysquantity) AS maxDays,
[...]
FROM
flatworkpackagesview w LEFT JOIN workpackages wp
ON wp.id = w.id
GROUP BY w.combinedname_reversed
ORDER BY w.combinedname_reversed;</pre>
<br />
I changed it to:<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT
w.combinedname_reversed as name,
-- Only for example
CASE
MIN(wp.controldaysquantity) WHEN 1 THEN 0
ELSE MIN(wp.controldaysquantity)
END AS maxDays,
[...]
FROM
flatworkpackagesview w LEFT JOIN workpackages wp
ON wp.id = w.id
GROUP BY w.combinedname_reversed
ORDER BY w.combinedname_reversed;</pre>
<br />
Then the error occurs. But it still occurs when I change the code to the previous version.<br />
<br />
<br />
Any ideas?<br />
<br />
Thanks in advance,<br />
Henning

thuston

That is strange. Maybe you have an invalid character?

Try removing all --comments and whitespace (tabs and new lines).
Also remove the ; from the end.
Essentially, toss everything you don't need.

If it still fails, try and make a new DataSet and then compare the XML and see if you can find a difference.