"Schema 'USER' does not exist" error message when
using Cloudscape database in the development environment
|
Technote
(FAQ)
Problem
|
After applying 6.0.0.1, you get a "Schema 'USER' does not
exist" error message when using Cloudscape database either through loader
utilities or directly from the command line.
|
Cause
|
There is a problem with Cloudscape database that only
surfaces after dropping and recreating stored procedures. During
application of WebSphere Commerce fix pack 1, stored procedures are
dropped and recreated, so this issues arises after fix pack
application.
|
Solution
|
To resolve this, use username 'app' when connecting to
Cloudscape database manually. Or, if you are using loader tools, make the
following changes in the idresgen.bat and massloader.bat:
Modify this line:
set user=user
to
set user=app
This issue will be corrected in the next fix pack release.
|