Under OTAG server --> Trusted Servers when I try to delete an existing Content Server instance I get the following error. Reading the error it appears the application is unable to delete the key in the table because of referential integrity problem. The problem is this is my test instance of OTAG and I installed it with Derby database (probably a bad idea). I do not know how to go about connecting to the database to manually delete the entry and remove the referential integrity constrain. Any help would be appreciated. I tried installing the Squirrel SQL client but am not sure what connection string and login/password to use. Please advice.
Thanks,
Pradeep
Internal Exception: java.sql.SQLIntegrityConstraintViolationException: DELETE on table 'PROVIDER' caused a violation of foreign key constraint 'EVENTPROVIDER_NAME' for key (ContentServer). The statement has been rolled back.
Error Code: 20000
Call: DELETE FROM PROVIDER WHERE (NAME = ?)
bind => [1 parameter bound]
Query: DeleteObjectQuery(com.opentext.otag.common.notifications.Provider@334ac45e)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
at com.opentext.otag.rest.impl.ProvidersImpl.deleteProvider(ProvidersImpl.java:106)
