Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » SEVERE: An exception occurred during processing.../SELECT command denied to user...(When I deploy the report in the production server, BIRT throws an exception...)
SEVERE: An exception occurred during processing.../SELECT command denied to user... [message #894079] Fri, 06 July 2012 10:45 Go to next message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

Hello folks,

I am in a critical condition... Some one please help me...


Following is the piece of code which is passing the DB URL, user name and password.


Code to access DB
            <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://cwnnbk7g9zmv.us-east-1.rds.amazonaws.com/demo_gl</property>
            <property name="odaUser">demo_user</property>
            <encrypted-property name="odaPassword" encryptionID="base64">Z2xkZW1vMjAxMUBlZA==</encrypted-property>


Please note the ODA URL above and the response from the host below in the exception are different. I have no idea what is happening.


Following Error generated on browser report:-
The following items have errors:

Table (id = 4):
+ Can not load the report query: 4. Errors occurred when generating the report document for the report element with ID 4. (Element ID:4)



Exception :-

Jul 6, 2012 1:36:33 PM org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor execute
SEVERE: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Activity
Cannot get the result set metadata.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:SELECT command denied to user 'demo_user'@'ip-12-88-103-119.ec2.internal' for table 'activity'
 ;
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'demo_user'@'ip-12-88-103-119.ec2.internal' for table 'activity'
org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Activity
Cannot get the result set metadata.
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
SQL error #1:SELECT command denied to user 'demo_user'@'ip-12-88-103-119.ec2.internal' for table 'activity'
 ;
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT command denied to user 'demo_user'@'ip-12-88-103-119.ec2.internal' for table 'activity'
        at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
        at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
        at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)
        at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
        at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205)
        at org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
        at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
        at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
        at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
        at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
        at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
        at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
        at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
        at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)



I wanted to know few things, because Im pretty new to BIRT.

1. Is the DB authenticating the request or not?

2. Is the DB authenticating the request and rejecting due to some permission to the user?

3. Host in the ODA URL and Host in the error log are different.(Changing to the IP address of the server) Why??

expecting a reply soon.

Thanks in advance
sid...
Re: SEVERE: An exception occurred during processing.../SELECT command denied to user... [message #894083 is a reply to message #894079] Fri, 06 July 2012 10:54 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

The query is failing because demo user does not have permission, but why
the ip is changing I am not sure. Do you have any property binding on
the data source or are you using any scripting on the data source? Can
you post the report?

Jason

On 7/6/2012 10:45 AM, sidharth mv wrote:
> Hello folks,
>
> I am in a critical condition... Some one please help me...
>
>
> Following is the piece of code which is passing the DB URL, user name
> and password.
>
>
> Code to access DB
> <property
> name="odaDriverClass">com.mysql.jdbc.Driver</property>
> <property
> name="odaURL">jdbc:mysql://cwnnbk7g9zmv.us-east-1.rds.amazonaws.com/demo_gl</property>
>
> <property name="odaUser">demo_user</property>
> <encrypted-property name="odaPassword"
> encryptionID="base64">Z2xkZW1vMjAxMUBlZA==</encrypted-property>
>
>
> Please note the ODA URL above and the response from the host below in
> the exception are different. I have no idea what is happening.
>
> Following Error generated on browser report:-
> The following items have errors:
>
> Table (id = 4):
> + Can not load the report query: 4. Errors occurred when generating the
> report document for the report element with ID 4. (Element ID:4)
>
>
> Exception :-
>
>
> Jul 6, 2012 1:36:33 PM
> org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor execute
> SEVERE: An exception occurred during processing. Please see the
> following message for details:
> Failed to prepare the query execution for the data set: Activity
> Cannot get the result set metadata.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement
> does not return a ResultSet object.
> SQL error #1:SELECT command denied to user
> 'demo_user'@'ip-12-88-103-119.ec2.internal' for table 'activity'
> ;
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT
> command denied to user 'demo_user'@'ip-12-88-103-119.ec2.internal' for
> table 'activity'
> org.eclipse.birt.report.data.adapter.api.AdapterException: An exception
> occurred during processing. Please see the following message for details:
> Failed to prepare the query execution for the data set: Activity
> Cannot get the result set metadata.
> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement
> does not return a ResultSet object.
> SQL error #1:SELECT command denied to user
> 'demo_user'@'ip-12-88-103-119.ec2.internal' for table 'activity'
> ;
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: SELECT
> command denied to user 'demo_user'@'ip-12-88-103-119.ec2.internal' for
> table 'activity'
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)
>
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
>
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)
>
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
>
> at
> org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.executeQueries(ExtendedGenerateExecutor.java:205)
>
> at
> org.eclipse.birt.report.engine.executor.ExtendedGenerateExecutor.execute(ExtendedGenerateExecutor.java:65)
>
> at
> org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
>
> at
> org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
>
> at
> org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)
>
>
>
> I wanted to know few things, because Im pretty new to BIRT.
>
> 1. Is the DB authenticating the request or not?
>
> 2. Is the DB authenticating the request and rejecting due to some
> permission to the user?
>
> 3. Host in the ODA URL and Host in the error log are different.(Changing
> to the IP address of the server) Why??
> expecting a reply soon.
> Thanks in advance
> sid...
>


Jason Weathersby

BIRT Exchange
Re: SEVERE: An exception occurred during processing.../SELECT command denied to user... [message #894090 is a reply to message #894083] Fri, 06 July 2012 11:17 Go to previous message
sidharth mv is currently offline sidharth mv
Messages: 9
Registered: July 2012
Location: India
Junior Member

Jason,

Hats off sir..SOLVED

Actually I was designing the report in my Local DB and while deploying I'll changed the ODA URL.

So in production DB name is : demo_gl
In development DB name is : demo_local

Hope you got my blunder Razz

Whole day I spent on this Sad


      <property name="odaDriverClass">com.mysql.jdbc.Driver</property>
            <property name="odaURL">jdbc:mysql://cwnnbk7g9zmv.us-east-1.rds.amazonaws.com/demo_gl</property>
            <property name="odaUser">demo_user</property>
            <encrypted-property name="odaPassword" encryptionID="base64">Z2xkZW1vMjAxMUBlZA==</encrypted-property>


Check the difference in DB names.

            <xml-property name="queryText"><![CDATA[Select date(created_date), type_name, count(*)
from demo_local.activity a
where a.user_id = ?
group by date(created_date), type_name]]></xml-property>
           


Thanx again and keep up the good work Smile
Previous Topic:How to save old BIRT rptdesign in newer version?
Next Topic:Output Format
Goto Forum:
  


Current Time: Thu Apr 17 05:55:24 EDT 2014

Powered by FUDForum. Page generated in 0.03415 seconds