kb66: Collection with many added filters fails, as does attempt to copy filters

After adding filters to a collection it fails with an error that includes "ValueOverflow: SAP DBTech JDBC: Parameter 8: value too large." If you attempt to copy the filter to other computers, the copy will fail and the application may be removed from the target computer. The problem is that the filtering information has exceeded the size allocated for the field where it is stored in the database. To resolve the problem the size of the Parameters column must be increased in the Collections table. You can increase the size of the column as follows:

1. Start SapWWW
   • On Windows, this process is started by starting the SAP DB WWW service.
   • On Linux, this process is started by executing:
     /etc/rc.d/init.d/firenze_sapdbWebAdm start

   When you are finished using the SAP Web Interfaces, you can stop SapWWW by executing:

   /etc/rc.d/init.d/firenze_sapdbWebAdm stop

2. Use the following URL to access the WebSQL interface (substituting the name of your Management Station for YourMgmtStation):

   http://YourMgmtStation:7230/websql

   Enter the name of the Management Station in the "Server name" field, enter fzedb1 in the "Database name" field, and enter the same user and password that you specified for the Longitude account during the install. Click the Logon button.

   ***Note: If you later change the password for the default Longitude user in the Longitude Web UI, this will not change the password of the SAP database user, so you will still need to specify the password that you entered during the installation of Longitude when you access the SAP interfaces, even if you now use a different password when logging into the Longitude Web UI.
   ***

3. Paste the following SQL statement into the "Path of Stored Statement:" box:

   ALTER TABLE "FZE_GRP1"."COLLECTIONS" MODIFY ("PARAMETERS" Varchar (2000) ASCII)

4. Click the Execute button. This will increase the size of the Parameters column to 2000.