Topic: Could not get schema names
Could not get schema names
I make any stransformation with data-staging (H2), then try to use updated datastore and getting exception:
Could not get schema names
Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-163]
I restart DC, datastore is opened.
Could not get schema names
Database is already closed (to disable automatic closing at VM shutdown, add ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-163]
I restart DC, datastore is opened.
Are you using the latest (2.4.2) version of DC? Actually we had a few issues fixed regarding the staging DB in this version.
Hello, Kasper.
Answer on you question is: Yes, I am using latest 2.4.2 version of DC. I worked with prev. version (2.4.1) befor, but so exception fired only now.
I copied *.dat file from folder 2.4.1 to latest's version folder.
Please help.
Regards.
Answer on you question is: Yes, I am using latest 2.4.2 version of DC. I worked with prev. version (2.4.1) befor, but so exception fired only now.
I copied *.dat file from folder 2.4.1 to latest's version folder.
Please help.
Regards.
I'm not entirely sure I understand the sequence of actions. Can you spell them out more explicitly? When you restart the application, is the datastore then still not accessible?
Kasper,
sorry for my bad english. I get this error, when try to transform table from H2 datastore sequentially. May be it happens because datastore is big enough. It includes 12 tables.
sorry for my bad english. I get this error, when try to transform table from H2 datastore sequentially. May be it happens because datastore is big enough. It includes 12 tables.
To my knowledge there's practically no limit to the amount of tables that H2 can have. Certainly it will be capable of having more than 12.
I just tried on my own machine and could not reproduce your issue.
Is it possible for you to share your H2 database? It would be just a zipped version of your "datastores" folder.
I just tried on my own machine and could not reproduce your issue.
Is it possible for you to share your H2 database? It would be just a zipped version of your "datastores" folder.
Hello, Kasper.
Yes, I ready to share archive and listening you directions.
Yes, I ready to share archive and listening you directions.
can you email it to kasper.sorensen [at] humaninference.com? Please zip it first, or else our spam filter will surely reject it.
Hi Timoshinm,
I received your zipped database, opened it, did a simple transformation and created a new staging table, without any issues. So I could not reproduce :(
Did you check that maybe your the table name you are creating already exists or something like that?
I received your zipped database, opened it, did a simple transformation and created a new staging table, without any issues. So I could not reproduce :(
Did you check that maybe your the table name you are creating already exists or something like that?
Log in by clicking the login link at the top of the screen
Go back to forum.
