Eclipse Community Forums: BIRT » Table not Showing in Connected Oracle Database in BIRT

Home » Archived » BIRT » Table not Showing in Connected Oracle Database in BIRT(Remote Oracle Database Successfully Connected to BIRT But Tables Are Not Showing)

Show: Today's Messages :: Show Polls :: Message Navigator

Table not Showing in Connected Oracle Database in BIRT [message #1829101]

Thu, 25 June 2020 07:47

Linkon Ruhul

Messages: 1
Registered: June 2020

Junior Member

I have connected a remote oracle database by its IP address in BIRT through a VPN network. It shows the connection successfu but tables are not showing. Just Stored Procedure is showing there.

I have also increased the maximum number of tables in the following manner:
Windows -> preferences -> Report design -> Dataset Editor -> JDBC Dataset -> Property "Maximum number of tables"

But still, it's not working!

Is there any solution? Please help me.

Report message to a moderator

Re: Table not Showing in Connected Oracle Database in BIRT [message #1831120 is a reply to message #1829101]

Tue, 11 August 2020 21:30

Thomas Gutmann

Messages: 21
Registered: April 2020

Junior Member

Hello Linkon,

If you have a valid connection and you can see the procedures but not the table then it sounds like an GRANT issue on your database use.

Can you select your missing tbales with your db-user with an sql developer?
Because sometimes it can be that you need additional grants of your tables for example when the table isn't an original table on your db-user.
And if it a table on another user then you need the SELECT GRANTs on it.

Kind regards
Thomas

Report message to a moderator

Previous Topic:	Align on Decimal Point for Negative Numbers with Parentheses
Next Topic:	Using an IN clause on an integer with report parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:32:01 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter