topic Can not delete corrupt DB connection in Data Quality

Can not delete corrupt DB connection

Anonymous — Thu, 10 Aug 2017 23:40:56 GMT

I have just downloaded Talend Open Studio for Data Quality (6.4.1.20170623_1246)

I created a DB connection

When I try to open the connection I receive the following:

"The file myconnection_0.1.item cannot be read. it may be corrupted. Suggested fix: delete it."

When I try to delete (right click->Delete) I receive the following:

"The DB connection is locked, so you can't delete it. If this object is opened, you must close it before deletion."

Anyone encounter this issue before? Suggestions on how to resolve?

Thanks

Re: Can not delete corrupt DB connection

Bluemoon — Fri, 11 Aug 2017 13:45:49 GMT

DB connection locked only occur if you open Database connection panel, check if you left the panel open in the background. And also restart the studio it will unlock all the metadata which are locked.

Let me know if it is working or not

Re: Can not delete corrupt DB connection

Anonymous — Mon, 14 Aug 2017 20:50:29 GMT

Thanks for the reply, no luck.

I have restarted the studio several times and the issues remains.

Any other thoughts?

Thanks

Mark

Re: Can not delete corrupt DB connection

Bluemoon — Mon, 14 Aug 2017 23:38:43 GMT

Can you send screen shots of your error??

Re: Can not delete corrupt DB connection

Anonymous — Tue, 15 Aug 2017 10:28:48 GMT

Hello,

It seems the files of Talend Studio are corrupted. On which talend build version you got this issue?

Are you able to create a new metadata connection in your current studio?

Best regards

Sabrina

Re: Can not delete corrupt DB connection

Anonymous — Wed, 16 Aug 2017 00:12:31 GMT

Here are screen shots

Connection shows locked

Error when try to open (double click or right click open)

Error when try to delete

TOSDQDBLocked.PNG

Re: Can not delete corrupt DB connection

Anonymous — Wed, 16 Aug 2017 00:13:48 GMT

Other screen shots

TOSDQDBOpen.PNG

Re: Can not delete corrupt DB connection

Anonymous — Wed, 16 Aug 2017 00:14:46 GMT

Open Studio for Data Quality (6.4.1.20170623_1246)

Thanks for your help,

Mark

Re: Can not delete corrupt DB connection

Anonymous — Wed, 16 Aug 2017 00:23:51 GMT

Sorry Sabrina, I didn't answer your other question.

Yes I can create another metadata connection however when I try to open I receive the corrupted message again (see attached screen shot)

It isn't locked though so I can delete.

I should point out that I am using jTDS to establish Windows Authentication connections, here is the connection string I am using.

jdbc:jtds:sqlserver://servernameort/DB;instance=instancename;useNTLMv2=true;domain=domainname

Connections Check successfully

So it seems that every connection I establish at this point is corrupt

Thanks to all for the help,

Mark

TOSDQCorruptDBConnection.PNG