Troubleshooting - User Data Repository

This section contains some troubleshooting information for the User Data Repository.

Users Unable to Save Custom Data or Tables when using MySQL for the User Data Repository

If you are using MySQL to store the User Data Repository and users encounter problems saving tables or custom data (particularly large tables or groups), then you may need to increase the MySQL maximum packet size. The default value of this setting is 1MB, which means that MySQL will reject any query that is larger than 1MB in size.

If a user tries to save a table or custom data that exceeds the configured limit, then the user will see an error message in SuperWEB2 and a message similar to the following will appear in the SuperWEB2 logs (superweb2-stdout.log):

CODE

[EL Warning]: 2014-05-07 09:54:46.85--UnitOfWork(1817198711)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2170279 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
Error Code: 0

To resolve this issue:

Stop the MySQL server.
Edit the MySQL configuration file. This file is called my.ini on Windows deployments, and my.cnf on Linux deployments. It is located in the MySQL server program data directory (for example, C:\ProgramData\MySQL\MySQL Server 5.6 on Windows or /etc/mysql/ on Linux).
In the [mysqld] section, increase the maximum packet size. For example:
CODE
```
max_allowed_packet=500M
```
The appropriate packet size will depend on the size of the tables you are creating. You may need to experiment with some different values to find a setting that works for you.
Restart the MySQL server.

Warning Message in Log Files - "Table Doesn't Exist" or "User Lacks Privilege or Object Not Found"

When you first start SuperWEB2 with the default user data repository configuration, or for the first time after setting up a connection to an external user data repository database, you may notice one of the following warning messages in the SuperWEB2 logs:

Table 'udr.txd' doesn't exist
user lacks privilege or object not found: TXD

These messages can be safely ignored. They are generated by SuperWEB2 checking to see if the user data repository tables have been created. When SuperWEB2 detects that the user data repository tables have not been created, it will automatically create them. Therefore these messages will not be displayed the next time you start it up.

The following are examples of the types of error message you may see in the log files:

CODE

[EL Warning]:
2014-09-16 15:11:57.384--UnitOfWork(844740433)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'udr.txd' doesn't exist
Error Code: 1146
Call: SELECT OBJECTUID, CREATEDBY, CREATION, CONTENT, DBID, FOLDERID, ID, MODIFIED, MODIFIEDBY, NAME, PERMITTEDUSER FROM TXD
Query: ReadAllQuery(referenceClass=TxdData sql="SELECT OBJECTUID, CREATEDBY, CREATION, CONTENT, DBID, FOLDERID, ID, MODIFIED, MODIFIEDBY, NAME, PERMITTEDUSER FROM TXD")
[EL Warning]:
2014-09-16 15:11:57.394--UnitOfWork(844740433)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.5.1.v20130918-f2b9fc5): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'udr.txd' doesn't exist
Error Code: 1146
Call: SELECT * FROM TXD
Query: DataReadQuery(sql="SELECT * FROM TXD")

CODE

[EL Warning]: 2016-07-27 17:36:20.761--UnitOfWork(922115783)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseExceptio
n
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: TXD
Error Code: -5501
Call: SELECT OBJECTUID, CREATEDBY, CREATION, CONTENT, DBID, FOLDERID, ID, MODIFIED, MODIFIEDBY, NAME, PERMITTEDUSER FROM TXD
Query: ReadAllQuery(referenceClass=TxdData sql="SELECT OBJECTUID, CREATEDBY, CREATION, CONTENT, DBID, FOLDERID, ID, MODIFIED, MODIFIEDBY, NAME, PERMITTEDUSER FROM TXD")
[EL Warning]: 2016-07-27 17:36:20.792--UnitOfWork(922115783)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.2.v20151217-774c696): org.eclipse.persistence.exceptions.DatabaseExceptio
n
Internal Exception: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: TXD
Error Code: -5501
Call: SELECT * FROM TXD
Query: DataReadQuery(sql="SELECT * FROM TXD")