2005 IR Help Posted August 27, 2006 Share Posted August 27, 2006 By: mezclax - mezclax Error executing report query 2004-08-24 05:23 Dear all; I have this prob when i try to view the report in the web using jasper report. Could anyone please help me. FYI, i also test the query statement in the oracle db, it's works fine. Thank you in advance Regards Mezclax [java] 89839 [socketListener-0] ERROR jasper.JasperReportServer - Error cr eating report: Error executing report query : [java] SELECT kmsEventlog.*, eventActivityId.description, statusId.StatusD esc, kioskInfo.FriendlyName FROM ((kmsEventlog inner join eventActivityId on kms Eventlog.eventActivityId = eventActivityId.ID) inner join statusId on kmsEventlo g.StatusValue = statusId.StatusValue ) inner join kioskInfo on kmsEventlog.kiosk Id = kioskInfo.KioskId ; By: Chuck Deal - cdeal RE: Error executing report query 2004-08-24 05:37 You said that you tested it in oracle and since it doesn't look like there is a syntax problem (at least at first glance). then I can only think of one other thing. I know in our web app we have one db user that all connections run as and we also have an admin account. Is it possible you are testing that SQL as one user but that your web app is running as another user? Possibly a user who does not have permission to run that SQL? By: mezclax - mezclax RE: Error executing report query 2004-08-24 19:41 Thanks for the info Chuck. I tested the Sql for the oracle with the same user that i define in the web app. But in the oracle it can run the query statement but not in the web app. thanks Mezclax Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now