Eclipse Community Forums: BIRT » Dataset results are incomplete

Home » Archived » BIRT » Dataset results are incomplete(SQL database Dataset setup with JDBC)

Dataset results are incomplete [message #1004116]

Tue, 22 January 2013 11:00

Eclipse User

My connecton to a SQL database seems to be made but when I create a new data set it returns an incomplete tables list. It is from a Maximo asset management system and sent to me as maxdb75.bak. I restored the file in MS SQL server 2012 and can see all the tables there. When I set up a datasource and data set in BIRT I only get aboout 10% of the table list. My driver is: com.microsoft.sqlserver.jdbc.SQLServerDriver ( v4.0) and my URL is: jdbc:sqlserver://JAS1LT00130;databaseName=maxdb75

Re: Dataset results are incomplete [message #1004691 is a reply to message #1004116]

Wed, 23 January 2013 12:11

Eclipse User

Go to Window->Preferences->Report Design->JDBC Data Set and increase your limit for visible tables/schemas.

Re: Dataset results are incomplete [message #1058409 is a reply to message #1004691]

Mon, 13 May 2013 22:19

Eclipse User

You're very welcome. Let us know whenever you have questions! Smile

Re: Dataset results are incomplete [message #1064487 is a reply to message #1058409]

Wed, 19 June 2013 09:22

Eclipse User

I'm seeing the same sort of issue now, but with a twist. I'm using BIRT 2.6.2 because it's the only officially supported version for creating reports with HP's WebInspect Enterprise vulnerability scanner.

I have a good connection to our SQLServer 2008 with the com.microsoft.sqlserver.jdbc.SQLServerDriverv 4.0 jdbc driver, but I only see a subset of the tables and views. I've set the max number of schemas to 200 and max number of tables in each to 500 for the display. Even after restarting Eclipse, it has no effect.

Any ideas what else I can try?

TIA,

Joe

Re: Dataset results are incomplete [message #1064537 is a reply to message #1064487]

Wed, 19 June 2013 14:28

Eclipse User

How many are you expecting and how many are you seeing? If you write a query for one that you don't see, does the query still run? If so, I know you are bound to 2.6.2, but can you try a different version just to see if you get a different result?

Re: Dataset results are incomplete [message #1064646 is a reply to message #1064537]

Thu, 20 June 2013 07:52

Eclipse User

Thank you, Michael.

My bad. I was looking for the wrong views. Once I started looking in the correct database for the correct views, the problem disappeared. Magic! Embarrassed

Thanks,

Joe

Re: Dataset results are incomplete [message #1064784 is a reply to message #1064646]

Fri, 21 June 2013 02:15

Eclipse User

Ah. Well, it's better to be something simple like that rather than an issue you couldn't get around. Smile

Let us know whenever you have questions!

Previous Topic:	Maximo-BIRT Previous or Next Record
Next Topic:	populate a lsitbox or radio button

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Mar 15 11:15:46 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter