PACMAN
Hello all !

First many thanks for this great software - an investment I do not regret.

Here's my problem :

I'm running the beta PB 4306 under Vista. So far so good, everything worked fine until one day when, while opening PB, I got this message : "couldn't create or connect to the database".

I checked the forums and tried the solutions suggested but to no avail : I don't have/find the output.log file, restored backup (with Vista) doesn't solve the problem, creating a new brain and merging it with the original one doesn't work.

It seems I still have all the info (notes, attachements) in the directories.


In one word : HELP !


Best regards,

Patrick.
Entia non sunt multiplicanda praeter necessitatem/pluralitas non est ponenda sine necessitate

LES FAITS SONT TÊTUS - LA PENSEE EST INSOUMISE - L'INCERTITUDE EST LIBERATRICE - A QUAND LA PROCHAINE BIFURCATION ?
Quote
jostber
Can you try to reinstall 4306, or if that fails try this:

http://forums.thebrain.com/tool/post/thebrain/vpost?id=2535085

And then reinstall 4306?

TheBrain 8.0.2.2 Slackware 14.2 KDE 4.10.3 Java 1.8 / (Windows 7)
Quote
mlapointe
Today I have exactly the same problem, running in Vista with Service Pack 1.  Reinstalling did not work. Neither did opening the brain from a brain zip. I get the following message:

PersonalBrain 4 could not create or connect to the database. Please make sure you\do not already have this Brain open and try again.
Interestingly, I've no problem opening the couple of (nearly empty) brains that I put on this new laptop as tests, only the 10K+ links database ported over from another computer that is, of course, the only one I need.

Michelle LaPointe




Quote
mosaic
Michelle,

I had similar experience in the last couple of days of initial experiment with PB4.1.3.6, even though we are using different version, this might help?

First make sure that you have no instance of PB running, you can do so by running the taskmanager (by hitting Control-Shift-Esc), in the bottom left corner, click on show processes from all users, if there is, and you are sure you can't bring it back (some hint might be, did you put the window on autohide mode? did you run it under a different user name?), kill the process (stress: only kill the process if you can't bring it back)

After that, go to your whatever_brain directory, check whether there is a brain.lck file, delete it.

Restart PB.
Brain Matters!
-------------------------
Profile 1 - PB:4.5.0.8
OS: Vista Ultimate SP1
Java: 1.6.0_07
Profile 2 - PB:4.5.0.6
OS: WInXP running inside VMware
Java: 1.6.0_06
Quote
mlapointe
Hey, thanks, Mosaic! 

I like this idea much better than rolling back to a previous version. I'll try it first.

Michelle

Quote
PACMAN
Sorry, my mistake : I found the output.log file... I thought it was supposed to be in my _brain directory.

Here is it's content :

Initializing Brain stage 1, time: 1
Database driver: org.h2.Driver
Database location: D:/PAC/REFERENCES/Gnoséothèque_brain/brain
Attempting to connect to existing database directly with exclusive access...
Failed to restore connection, databasePath=D:/PAC/REFERENCES/Gnoséothèque_brain/brain - Thread: Thread[Thread-34,6,main]
org.h2.jdbc.JdbcSQLException: Database D:\PAC\REFERENCES\Gnoséothèque_brain\brain_db\brain not found [90013-72]

>>>> in this directory I have a couple of brain.109.nnn.lob.db files (nnn = 3 digit number), brain.data.db, brain.index.db, and brain.trace.db <<<<

        at org.h2.message.Message.getSQLException(Message.java:92)
        at org.h2.message.Message.getSQLException(Message.java:96)
        at org.h2.message.Message.getSQLException(Message.java:74)
        at org.h2.engine.Engine.openSession(Engine.java:56)
        at org.h2.engine.Engine.openSession(Engine.java:127)
        at org.h2.engine.Engine.getSession(Engine.java:110)
        at org.h2.engine.Session.createSession(Session.java:229)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:976)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:957)
        at org.h2.Driver.connect(Driver.java:57)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.thebrain.personal.model.phoenix.v.void(PhoenixBrainStore.java:241)
        at com.thebrain.personal.model.phoenix.v.D(PhoenixBrainStore.java:1444)
        at com.thebrain.personal.model.phoenix.v.for(PhoenixBrainStore.java:1295)
        at com.thebrain.personal.model.phoenix.v.a(PhoenixBrainStore.java:1248)
        at com.thebrain.personal.model.phoenix.a.a(PhoenixBrain.java:228)
        at com.thebrain.personal.view.d.a(MainFrame.java:1183)
        at com.thebrain.personal.view.d.access$21(MainFrame.java:1166)
        at com.thebrain.personal.view.d$6.run(MainFrame.java:1148)
        at java.lang.Thread.run(Unknown Source)
Database connection failed.
Failed to connect to the database.
Failed to initialize Brain. databasePath=D:/PAC/REFERENCES/Gnoséothèque_brain/brain brainName=Gnoséothèque createIfNonExistent=false
About to shutdown due to window close...
Shutdown stage 1
Shutdown stage 2
stbs 1
stbs 2
stbs 3
Shutdown stage 3
Dock layout data saved.
Shutdown completed
Entia non sunt multiplicanda praeter necessitatem/pluralitas non est ponenda sine necessitate

LES FAITS SONT TÊTUS - LA PENSEE EST INSOUMISE - L'INCERTITUDE EST LIBERATRICE - A QUAND LA PROCHAINE BIFURCATION ?
Quote
mlapointe
And here's my output log, with similar information:

Operating system: Windows Vista
winlaf look and feel is off - using custom event queue
Look and feel set to: com.sun.java.swing.plaf.windows.WindowsLookAndFeel

PersonalBrain Pro Version 4306

Java 1.6.0_03
Locale: en_US (Country: United States; Language: English)
Language file: English
Default encoding: Cp1252

Jun 8, 2008 2:33 AM

Program Location = C:\Program Files\PersonalBrain
Program Settings Location = C:\Users\Michelle\AppData\Roaming/PersonalBrain
Start Thought = 2,1
Text filters are present.
Text filters are present and enabled. Documents will be converted.
HTML filters are not available or are disabled. Documents will not be converted.
Checking registry for shell new commands...
Configuring notes editor...
Configuring notes editor completed.
Notes menus initialized
Completed Shell New Search.

This application was created using:

BrainSDK - The Visual Network Interface
----------------------------------------------------------------------------------
(C) 1998-2006 TheBrain Technologies LP.
Email: info@thebrain.com
Phone: 310-751-5000
http://www.thebrain.com

animation set to delay of 20
animation set to delay of 20
Setting default Plex font to system font Dialog.plain
Setting spellcheck to true
Hotkey set
Time to initialized main window: 4138
REQUEST:http://www.thebrain.com/personal/updateCheck?os=Windows+Vista&version=4306&edition=2&c=25&a=198&i=5
animation set to delay of 40
Update check response:




version:4306
message:Increased reliability and fixes.
href:http://www.thebrain.com/#-53

Close completed in 0
Initializing Brain stage 1, time: 2
Database driver: org.h2.Driver
Database location: C:/Users/Michelle/Documents_brain/brain
Attempting to connect to existing database directly with exclusive access...
Database connection successful - normal.
Min database version: 4300
File root: Files
Full file root: C:\Users\Michelle\Documents_brain\Files
Database is version 4306
Set column selectivity in 251
Init database is complete
Initializing Brain stage 2, time: 591
Initializing Brain stage 3, time: 591
Initializing Brain stage 4, time: 596
Initializing Brain stage 5, time: 600
Initializing Brain stage 7, time: 600
Initializing Brain stage 8, time: 600
Completed Initializing Brain, time: 723
Load completed in 723
UI initialization stage 1, time: 0
UI initialization stage 2, time: 12
UI initialization stage 2.1, time: 14
UI initialization stage 3, time: 18
PBS.open 1, time = 0
PBS.open 2, time = 3
PBS.open 3, time = 3
PBS.open 1, time = 0
PBS.open 2, time = 2
PBS.open 3, time = 2
UI initialization stage 4, time: 28
UI initialization stage 4.1, time: 28
UI initialization stage 4.2, time: 28
UI initialization stage 5, time: 28
UI initialization stage 6, time: 35
Creating trash folder at C:\Users\Michelle\Documents_brain\trash
UI initialization stage 7, time: 68
UI initialization stage 8, time: 73
BrokenFiles:
  [Empty]

UI initialization stage 9, time: 74
UI initialization complete, time: 90
Starting rebuild of instant search cache
Completed rebuild of instant search cache in 3
  Size of ID hash at completion: 1
stbs 1
stbs 2
stbs 3
Saving Brain info to .brain file C:\Users\Michelle\Documents.brain
Closing database connections...
Database connections closed.
Close completed in 128
Initializing Brain stage 1, time: 1
Database driver: org.h2.Driver
Database location: C:/Users/Michelle/ML2620_4_brain/brain
Attempting to connect to existing database directly with exclusive access...
Failed to restore connection, databasePath=C:/Users/Michelle/ML2620_4_brain/brain - Thread: Thread[Thread-32,6,main]
org.h2.jdbc.JdbcSQLException: General error: java.lang.Error: rowcount remaining=-96 SYS [50000-72]
    at org.h2.message.Message.getSQLException(Message.java:92)
    at org.h2.message.Message.convert(Message.java:175)
    at org.h2.engine.Database.<init>(Database.java:223)
    at org.h2.engine.Engine.openSession(Engine.java:58)
    at org.h2.engine.Engine.openSession(Engine.java:127)
    at org.h2.engine.Engine.getSession(Engine.java:110)
    at org.h2.engine.Session.createSession(Session.java:229)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:976)
    at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:957)
    at org.h2.Driver.connect(Driver.java:57)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.thebrain.personal.model.phoenix.v.void(PhoenixBrainStore.java:241)
    at com.thebrain.personal.model.phoenix.v.D(PhoenixBrainStore.java:1444)
    at com.thebrain.personal.model.phoenix.v.for(PhoenixBrainStore.java:1295)
    at com.thebrain.personal.model.phoenix.v.a(PhoenixBrainStore.java:1248)
    at com.thebrain.personal.model.phoenix.a.a(PhoenixBrain.java:228)
    at com.thebrain.personal.view.d.a(MainFrame.java:1183)
    at com.thebrain.personal.view.d.access$21(MainFrame.java:1166)
    at com.thebrain.personal.view.d$6.run(MainFrame.java:1148)
    at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Error: rowcount remaining=-96 SYS
    at org.h2.message.Message.getInternalError(Message.java:129)
    at org.h2.table.TableData.addIndex(TableData.java:193)
    at org.h2.engine.Database.open(Database.java:562)
    at org.h2.engine.Database.<init>(Database.java:204)
    ... 18 more
Database connection failed.
Failed to connect to the database.
Failed to initialize Brain. databasePath=C:/Users/Michelle/ML2620_4_brain/brain brainName=ML2620_4 createIfNonExistent=false
About to shutdown due to window close...
Shutdown stage 1
Shutdown stage 2
stbs 1
stbs 2
stbs 3
Shutdown stage 3
Dock layout data saved.
Shutdown completed


Quote
PACMAN
Hi again,

here's my output log, using the 4.5 version.

First PB opened the "Test" brain, then I tried to open my brain "Gnoséothèque", still unsuccessfully :

Operating system: Windows Vista
winlaf look and feel is off - using custom event queue
Look and feel set to: com.sun.java.swing.plaf.windows.WindowsLookAndFeel

PersonalBrain Pro Version 4500

Java 1.6.0_05
Locale: fr_BE (Country: Belgique; Language: français)
Language file: English
Default encoding: Cp1252

13-juin-2008 8:50

Program Location = C:\Program Files\PersonalBrain
Program Settings Location = C:\Users\Patrick\AppData\Roaming/PersonalBrain
Start Thought = 2,1
Text filters are present.
Text filters are present and enabled. Documents will be converted.
HTML filters are not available or are disabled. Documents will not be converted.
Checking registry for shell new commands...
Completed Shell New Search.
Configuring notes editor...
Configuring notes editor completed.
Notes menus initialized

This application was created using:

BrainSDK - The Visual Network Interface
----------------------------------------------------------------------------------
(C) 1998-2008 TheBrain Technologies LP.
Email: info@thebrain.com
Phone: 310-751-5000
http://www.thebrain.com

animation set to delay of 20
Setting default Plex font to system font Dialog.plain
Setting spellcheck to true
Hotkey set
Time to initialized main window: 21087
REQUEST:http://www.thebrain.com/personal/updateCheck?os=Windows+Vista&version=4500&edition=2&c=40&a=974&i=79
animation set to delay of 33
Close completed in 0
Initializing Brain stage 1, time: 146
Database driver: org.h2.Driver
Database location: D:/PAC/REFERENCES/Test_brain/brain
Attempting to connect to existing database directly with exclusive access...
Database connection successful - normal.
Min database version: 4300
File root: Files
Full file root: D:\PAC\REFERENCES\Test_brain\Files
Database is version 4306
Set column selectivity in 134
Init database is complete
Initializing Brain stage 2, time: 2745
Initializing Brain stage 3, time: 2745
Initializing Brain stage 4, time: 2751
Initializing Brain stage 5, time: 2755
Initializing Brain stage 7, time: 2755
Initializing Brain stage 8, time: 2755
Completed Initializing Brain, time: 2927
Load completed in 2927
UI initialization stage 1, time: 0
UI initialization stage 2, time: 24
UI initialization stage 2.1, time: 24
UI initialization stage 3, time: 28
PBS.open 1, time = 1
PBS.open 2, time = 5
PBS.open 3, time = 5
PBS.open 1, time = 0
PBS.open 2, time = 1
PBS.open 3, time = 1
UI initialization stage 4, time: 40
UI initialization stage 4.1, time: 40
UI initialization stage 4.2, time: 40
UI initialization stage 5, time: 40
UI initialization stage 6, time: 52
Creating trash folder at D:\PAC\REFERENCES\Test_brain\trash
UI initialization stage 7, time: 442
UI initialization stage 8, time: 589
BrokenFiles:
[Empty]

UI initialization stage 9, time: 591
UI initialization complete, time: 663
EXCEPTION IN SQL:SELECT COUNT (*) FROM InstantSearch
org.h2.jdbc.JdbcSQLException: Table INSTANTSEARCH not found; SQL statement:
SELECT COUNT (*) FROM InstantSearch [42102-72]
        at org.h2.message.Message.getSQLException(Message.java:92)
        at org.h2.message.Message.getSQLException(Message.java:96)
        at org.h2.message.Message.getSQLException(Message.java:74)
        at org.h2.command.Parser.readTableOrView(Parser.java:4065)
        at org.h2.command.Parser.readTableFilter(Parser.java:911)
        at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1406)
        at org.h2.command.Parser.parseSelectSimple(Parser.java:1504)
        at org.h2.command.Parser.parseSelectSub(Parser.java:1400)
        at org.h2.command.Parser.parseSelectUnion(Parser.java:1279)
        at org.h2.command.Parser.parseSelect(Parser.java:1267)
        at org.h2.command.Parser.parsePrepared(Parser.java:390)
        at org.h2.command.Parser.parse(Parser.java:286)
        at org.h2.command.Parser.parse(Parser.java:258)
        at org.h2.command.Parser.prepareCommand(Parser.java:230)
        at org.h2.engine.Session.prepareLocal(Session.java:283)
        at org.h2.engine.Session.prepareCommand(Session.java:244)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1020)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:1216)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:163)
        at com.thebrain.personal.model.phoenix.b.c.<init>(PSEntry.java:21)
        at com.thebrain.personal.model.phoenix.b.b.a(PreparedStatementCache.java:84)
        at com.thebrain.personal.model.phoenix.v.if(PhoenixBrainStore.java:2490)
        at com.thebrain.personal.model.phoenix.v.Q(PhoenixBrainStore.java:2455)
        at com.thebrain.personal.model.phoenix.a.c$1.run(DBBasedSearcher.java:49)
java.lang.NullPointerException
        at com.thebrain.personal.model.phoenix.v.if(PhoenixBrainStore.java:2503)
        at com.thebrain.personal.model.phoenix.v.Q(PhoenixBrainStore.java:2455)
        at com.thebrain.personal.model.phoenix.a.c$1.run(DBBasedSearcher.java:49)
Keyboard hook installed.
Starting rebuild of instant search cache (D)
Completed rebuild of instant search cache in 13
IO exception while checking for latest version
redundant autohide call
stbs 1
stbs 2
stbs 3
Saving Brain info to .brain file D:\PAC\REFERENCES\Test.brain
Closing database connections...
Database connections closed.
Close completed in 251
Initializing Brain stage 1, time: 0
Database driver: org.h2.Driver
Database location: D:/PAC/REFERENCES/Gnoséothèque_brain/brain
Attempting to connect to existing database directly with exclusive access...
Failed to restore connection, databasePath=D:/PAC/REFERENCES/Gnoséothèque_brain/brain - Thread: Thread[Thread-35,6,main]
org.h2.jdbc.JdbcSQLException: General error: java.lang.Error: rowcount remaining=-94 SYS [50000-72]
        at org.h2.message.Message.getSQLException(Message.java:92)
        at org.h2.message.Message.convert(Message.java:175)
        at org.h2.engine.Database.<init>(Database.java:223)
        at org.h2.engine.Engine.openSession(Engine.java:58)
        at org.h2.engine.Engine.openSession(Engine.java:127)
        at org.h2.engine.Engine.getSession(Engine.java:110)
        at org.h2.engine.Session.createSession(Session.java:229)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:976)
        at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:957)
        at org.h2.Driver.connect(Driver.java:57)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.thebrain.personal.model.phoenix.v.void(PhoenixBrainStore.java:224)
        at com.thebrain.personal.model.phoenix.v.E(PhoenixBrainStore.java:1480)
        at com.thebrain.personal.model.phoenix.v.for(PhoenixBrainStore.java:1331)
        at com.thebrain.personal.model.phoenix.v.a(PhoenixBrainStore.java:1272)
        at com.thebrain.personal.model.phoenix.a.a(PhoenixBrain.java:228)
        at com.thebrain.personal.view.d.a(MainFrame.java:1199)
        at com.thebrain.personal.view.d.access$21(MainFrame.java:1182)
        at com.thebrain.personal.view.d$6.run(MainFrame.java:1164)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.Error: rowcount remaining=-94 SYS
        at org.h2.message.Message.getInternalError(Message.java:129)
        at org.h2.table.TableData.addIndex(TableData.java:193)
        at org.h2.engine.Database.open(Database.java:562)
        at org.h2.engine.Database.<init>(Database.java:204)
        ... 18 more
Database connection failed.
Failed to connect to the database.
Failed to initialize Brain. databasePath=D:/PAC/REFERENCES/Gnoséothèque_brain/brain brainName=Gnoséothèque createIfNonExistent=false
Detected WM_QUERYENDSESSION
About to shutdown due to shutdown hook call or WM_QUERYENDSESSION...
Shutdown stage 1
Shutdown stage 2
closeBrain q stage 1
stbs 1
stbs 2
stbs 3
closeBrain q stage 2
closeBrain q stage 3
Shutdown stage 3
Dock layout data saved.
Shutdown completed
Successfully executed shutdown code after WM_QUERYENDSESSION
Entia non sunt multiplicanda praeter necessitatem/pluralitas non est ponenda sine necessitate

LES FAITS SONT TÊTUS - LA PENSEE EST INSOUMISE - L'INCERTITUDE EST LIBERATRICE - A QUAND LA PROCHAINE BIFURCATION ?
Quote
jostber
Why are the slashes in these references different?

" Saving Brain info to .brain file D:\PAC\REFERENCES\Test.brain
Closing database connections...
Database connections closed.
Close completed in 251
Initializing Brain stage 1, time: 0
Database driver: org.h2.Driver
Database location: D:/PAC/REFERENCES/Gnoséothèque_brain/brain"




TheBrain 8.0.2.2 Slackware 14.2 KDE 4.10.3 Java 1.8 / (Windows 7)
Quote
PACMAN
I don't know :-s
Entia non sunt multiplicanda praeter necessitatem/pluralitas non est ponenda sine necessitate

LES FAITS SONT TÊTUS - LA PENSEE EST INSOUMISE - L'INCERTITUDE EST LIBERATRICE - A QUAND LA PROCHAINE BIFURCATION ?
Quote
Harlan
Pacman,

Sorry no one from TheBrain saw your request for help earlier.

If you send a zip of your _brain\brain_db folder to us at support@thebrain.com, we will take a look and see what is going wrong. I'm fairly confident we will be able to get everything working for you.
Regards,
-Harlan
Quote
Harlan
Harlan wrote:
Pacman,

Sorry no one from TheBrain saw your request for help earlier.

If you send a zip of your _brain\brain_db folder to us at support@thebrain.com, we will take a look and see what is going wrong. I'm fairly confident we will be able to get everything working for you.


mlapointe,

The above also applies to you. Apologies again for not seeing these posts earlier.

Regards,
-Harlan
Quote

Newsletter Signup  Newsletter        Visit TheBrain Blog   Blog       Follow us on Twitter   Twitter       Like Us on Facebook   Facebook         Watch Us on Youtube  YouTube       

TheBrain Mind Map & Mindmapping Software     Download TheBrain Mind Mapping Software