Solution export problems

Various problems can occur when exporting a solution from IBM® Case Manager.

Symptoms

When you export the solution, the IBM Case Manager administration client displays a message like one of the following messages:

The solution could not be exported because of the following error: EXPORT failed. 
0 items processed: 0 succeeded, 0 failed. Apache Derby experienced a sql exception.
Create table tablename. A lock could not be obtained within
 the time requested. FNRAM9042

The solution could not be exported because of the following error: EXPORT failed. 
0 items processed: 0 succeeded, 0 failed. Apache Derby experienced a sql exception. 
Create table tablename(hashcode int, mapkey varchar(76), 
mapdata varchar(32672)) Table/View 'TABLENAME' already exists 
in Schema 'APP'.  FNRAM9042

The solution could not be exported because of the following error: EXPORT failed. 
42 items processed: 42 succeeded, 0 failed. An unexpected exception occurred. The 
unexpected exception is chained to this exception. A lock could not be obtained 
within the time requested  FNRAM9042

Causes

These export problems can be caused by two or more users exporting a solution at the same time.

When you export a solution, you might encounter Derby or SQL errors if another user tries to export a solution on the same system at the same time.
(For WebSphere® Application Server on AIX or Linux only) You might be unable to export a solution if two users previously attempted to export two solutions at the same time.

Resolving the problem

To resolve the problem:

If you are exporting a solution while someone else is also exporting a solution, wait until the other solution is exported and try the operation again.
If you can't export a solution because of a previous simultaneous export attempt, delete the WebSphere Application Server folder /opt/IBM/WebSphere/AppServer/derby/P8DerbyTmpDB. Then, try the export again.