Thursday, November 4, 2010

Derby Access Denied Error - TDIv7.x


Solution:
1. Stop ALL running processes of the Derby instance associated with TDI. By default this instance runs on port 1527
ps -ef | grep 1527
kill -9


2. Locate the Directory Path specified in the 'com.ibm.di.store.database' parameter found in the solution.properties file.
Example: com.ibm.di.store.database=jdbc:derby://localhost:1527//opt/IBM/TDI/V7.1/TDISysStore;create=true

3. Modify the 'derby.properties' file found in the [TDI_InstallDir]/etc & [TDI_SolutionDir]/etc
Add the following parameter to the files.
derby.system.home=
Example: derby.system.home=/opt/IBM/TDI/V7.1

1 comment:

  1. Thanks for this info. It helped a lot. I was starting to get really tired of that error message.

    ReplyDelete