AnsweredAssumed Answered

Getting Error 500 - Internal Server Error on my first query portlet

Question asked by Alex_Feldstein on Aug 9, 2010
Latest reply on Aug 11, 2010 by Chris_Hackett
I have a query that works fine in SQL Server. It is complex as I mentioned before in another thread and am trying to learn how to convert it to NSQL.

I simplified the query for testing, and NSQL parses it fine and accepts it.

I create a portlet and attach this query to it.

I create a portlet page (actually a new tab on an existing page we already have) and attach the portlet to it.

When I run the program and click on the new tab I get:

"Error 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems."

This is a bogus and very unhelpful error message. Could be anything. It is not a server problem (Clarity works and all other pages are getting and displaying their data. I suspect the query, but it is now a test as simple (and worthless) as it could be: select a from b - it should work, right?
It is not a permissions error: I am using Clarity test environment with my credentials (an admin in Test) and everything else works fine.

Any ideas why I am getting this error? Pulling my hair already and can't figure this one out.