Error when create metadata from database

CloverDX Platform
1

Hi,

I create metadata from MS SQL database, it is always said “Metadata extraction failed: The result set is closed” what dose it mean? why it show the error and how to solve it?

Thanks.

2

Hi Jean,

I have a lot of questions if I may:

1. Which version of CloverETL and MS SQL do you have?
2. Does it happen with all tables or just with the specific one?
3. Does it happen in some other DBs like MySQL or Oracle?
4. Does it happen in local project or in CloverETL Server project?
5. Which steps did you follow before this error appeared? (Preferred way is via Outline pane → Metadata → New metadata → Extract from database.)
6. Did Window → Show view → Other… → General → Error log show some stack trace of the error?
7. Did you use standard sqljdbc.jar driver?

Thank you in advance for all details.

Kind regards,

3

Hi,
1. Clover Version: 3.5.0.036M2 and MS SQL 2012.
2. Just specific one that have field type Date (from my first estimate).
3. It just happen when use MSSql, for DB2 is not error, for oracle I never try.
4. In local project.
5. It appeared when I do at Outline pane → Metadata → New metadata → Extract from database.
6. Yes, it show error ( as in attached picture below).
7. I use sqljdbc4.jar driver.

Thanks,

4

Hi Jean,

Can you please send us create statement of the specific database table?

We will try to reproduce this behavior on our side. I hope it should help us to solve this issue.

5

I am facing the same issue. Any updates on this one?

6

Hi bruno,

Could you provide us with more details, please? See my very first reply in this topic.

Thanks,

7

Hi Guys

What is work around this?
I am having same issue.

1. Version: 4.0.3.007, MSSQL 2008R2
2. Does it happen with all tables or just with the specific one? Did not tried
3. Did not tried
4. In CloverETL local project?
5. It appeared when I do at Outline pane → Metadata → New metadata → Extract from database.
6. Yes, it show error
7. I use sqljdbc4.jar driver.

8

Hi tushu373,

the points (questions) provided by Lubos earlier in this thread were placed in order to find out the original cause of the issue. Without trying them it is difficult to reproduce the issue. Therefore, could you please try these points and provide us with the results?

Thanks!