Eclipse Community Forums: BIRT » SEVERE: An exception occurred during processing.../SELECT command denied to user...

Home » Archived » 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

Eclipse User

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

Eclipse User

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...
>

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Sun Jul 06 09:56:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter