Error 505 at DB Tools Close Connection

[Llisas]

Hi all, 

 

I have an error that doesn't affect the functionality of my program, so for the moment I'm just ignoring it, but anyway I would like to know what is its cause and how can I solve it, or if it's safe to ignore it.

 

I have a program that makes some tests and stores the data in some clusters, and then when the job is done it writes everything in a database. Then it asks if you want to start another job or end the program. Up to there everything works perfect. But if you choose to start another job without closing the program, after you complete it there's an error at the end of the database writing. The error is this:

 

Error 505 occurred at NI_Database_API.lvlib:DB Tools Close Connection.vi->Escritura DB.vi->Interfaz Principal.vi

 

Possible Reason: Open Command Object.

 

ADO Error: 0x000001F9

 

As you can see in the attached image, in my database writing subVI I only open connection, use two "Insert Data" blocks and then close connection. I don't have any command references to use the Free Object block, so I don't know what's wrong.

 

Thanks in advance for any help. 

 

[Tim_S]

Just taking a quick look at your diagram, there should be shift registers on the for loop on the connection reference and error cluster.

[Llisas]

Ouch, silly mistake, thanks for pointing it out. 

 

Finally I could solve the problem. I found out that the error 505 generates when there's an error in the operation and then in another iteration of the same operation a no-error overwrites the error. I used the shift registers in the for loop, and noticed that now another error showed, saying that I was writing a duplicate of a primary key. So I checked the array I was writing to the DB and in fact I had stored data from the previous operations that I already wrote in the DB. After fixing that the problem was solved.

 

Thanks! 

[JamesMc86]

I think I've been seeing a similar behavior that the built in functions appear to leak a command object on an error though I haven't dug deep enough to confirm this yet.