"Failed to open database at working path" upon level reload.

[westingtyler]

An old thread with a proposed solution no longer seems to exist, so I am asking again for the best solution to this issue. Here is the error, which occurs right after I try to load a level in Unity play mode, or even reload the same level.


Failed to open database at the working path: C:/Users/Administrator/AppData/LocalLow/Laureate Cable Studios/The Realm Sequencer\west_data_persistent\shf\Conversations.bytes
UnityEngine.Debug:LogError(Object)
SimpleSQL.SimpleSQLManager:Initialize(Boolean)
SimpleSQL.SimpleSQLManager:Awake()

Before there was a playmaker action to detach them manually before reloading levels, I think. I use playmaker, so that should work, but I never tested it originally because I wasn't at the stage to try it out, but now I am.

Now the error is happening WITHOUT needing to reload or change the level:


Failed to open database at the working path: C:/Users/Administrator/AppData/LocalLow/Laureate Cable Studios/The Realm Sequencer\west_data_persistent\shf\Locations.bytes
UnityEngine.Debug:LogError(Object)
SimpleSQL.SimpleSQLManager:Initialize(Boolean)
SimpleSQL.SimpleSQLManager:CreateCommand(String, Object[])
SimpleSQL.SimpleSQLManager:QueryGeneric(String, Object[])
SimpleSQL_Query_SingleRow:DoQuery() (at Assets/PlayMaker/Actions/SimpleSQL/SimpleSQL_Query_SingleRow.cs:75)
SimpleSQL_Query_SingleRow:OnEnter() (at Assets/PlayMaker/Actions/SimpleSQL/SimpleSQL_Query_SingleRow.cs:29)
HutongGames.PlayMaker.FsmState:ActivateActions(Int32) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:205)
HutongGames.PlayMaker.FsmState:OnEnter() (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:175)
HutongGames.PlayMaker.Fsm:EnterState(FsmState) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2767)
HutongGames.PlayMaker.Fsm:SwitchState(FsmState) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2714)
HutongGames.PlayMaker.Fsm:UpdateStateChanges() (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2642)
HutongGames.PlayMaker.Fsm:DoTransition(FsmTransition, Boolean) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2681)
HutongGames.PlayMaker.Fsm:ProcessEvent(FsmEvent, FsmEventData) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2272)
HutongGames.PlayMaker.Fsm:Event(FsmEventTarget, FsmEvent) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2375)
HutongGames.PlayMaker.Fsm:Event(FsmEvent) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2456)
HutongGames.PlayMaker.Actions.TriggerEvent:TriggerEnter(Collider) (at Assets/PlayMaker/Actions/TriggerEvent.cs:183)
PlayMakerProxyBase:DoTriggerEventCallback(Collider) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/PlayMakerProxyBase.cs:60)
PlayMakerTriggerEnter:OnTriggerEnter(Collider) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/PlayMakerTriggerEnter.cs:24)

here's an error that happens every time I start play mode now: 

Failed to open database at the working path: C:/Users/Administrator/AppData/LocalLow/Laureate Cable Studios/The Realm Sequencer\west_data_persistent\shf\Conversations.bytes
UnityEngine.Debug:LogError(Object)
SimpleSQL.SimpleSQLManager:Initialize(Boolean)
SimpleSQL.SimpleSQLManager:Awake()


and this:

NullReferenceException: Object reference not set to an instance of an object
SimpleSQL.SimpleSQLManager.CreateCommand (System.String cmdText, System.Object[] ps)
SimpleSQL.SimpleSQLManager.QueryGeneric (System.String query, System.Object[] args)
SimpleSQL_Query_SingleRow.DoQuery () (at Assets/PlayMaker/Actions/SimpleSQL/SimpleSQL_Query_SingleRow.cs:75)
SimpleSQL_Query_SingleRow.OnEnter () (at Assets/PlayMaker/Actions/SimpleSQL/SimpleSQL_Query_SingleRow.cs:29)
HutongGames.PlayMaker.FsmState.ActivateActions (Int32 startIndex) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:205)
HutongGames.PlayMaker.FsmState.OnEnter () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/FsmState.cs:175)
HutongGames.PlayMaker.Fsm.EnterState (HutongGames.PlayMaker.FsmState state) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2767)
HutongGames.PlayMaker.Fsm.SwitchState (HutongGames.PlayMaker.FsmState toState) (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2714)
HutongGames.PlayMaker.Fsm.UpdateStateChanges () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:2642)
HutongGames.PlayMaker.Fsm.Start () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/Classes/Fsm.cs:1925)
PlayMakerFSM.Start () (at C:/Users/Alex/Documents/Unity/Playmaker_1.9.0/Projects/Playmaker.source.unity/Assets/PlayMaker/PlayMakerFSM.cs:548)


if some of this is related to the playmaker action not being able to find a specific entry (ie, not written yet) would it be possible to get a modifed version of those actions (in this case, the Query Single Row) that allows for error cases like "if entry does not exist" or "if entry is blank/null"?

Keep up the great work!

[westingtyler]

here's a screenshot of an error that shows the file exists in the right location:

[echo17]

This is likely due to Unity placing a lock on the database file. When the scene is reloaded or the player goes into a paused state, that lock can prevent the application from re-accessing the database file. See this FAQ for more information: link

Fortunately, the SimpleSQL Playmaker actions come with a SimpleSQL_Close action that you can use before changing a scene. This should release the lock on the file before the scene closes. When the new scene opens, the SimpleSQLManager component will re-initialize the connection to the unlocked file.

If this does not solve your problem, you can send me a simplified version of your project and I will take a look to see what might be happening. Please see this FAQ for more information: link

[westingtyler]

Hey, thanks! When trying to google to find the playmaker actions, I keep getting an error that the page does not exist.

support9569.wixsite.com/echo17/simplesql.html

Where can I download this playmaker actions asset?

Update: ooh, I found them, at this address: 

support9569.wixsite.com/echo17/simplesql

The Playmaker wiki needs updating it seems!

[echo17]

Oct 5, 2018 14:14:40 GMT westingtyler said:

The Playmaker wiki needs updating it seems!

Good catch, yes it does! I recently had to port my website to a new location, so all support files moved as well. Sorry for the trouble.