AppSync: Discovering Oracle Databases on RHEL server fails with "ERROR: value too long for type character varying(255)"
Summary: The length of the mount options specified on the host is limited to 255 characters.
This article applies to
This article does not apply to
This article is not tied to any specific product.
Not all product versions are identified in this article.
Symptoms
When discovering Oracle databases from the AppSync GUI, the process fails with the following error.
Server log:
07-31-2019 11:11:36.005 WARN [default task-64] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] [APPSYNC SERVER NAME] [] SQL Error: 0, SQLState: 22001
07-31-2019 11:11:36.005 ERROR [default task-64] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] [APPSYNC SERVER NAME] [] ERROR: value too long for type character varying(255)
07-31-2019 11:11:36.005 ERROR [default task-64] [org.jboss.as.ejb3.invocation] [APPSYNC SERVER NAME] [] WFLYEJB0034: EJB Invocation failed on component AWEntityServiceBean for method public com.emc.apollo.datamodel.PersistentEntity com.emc.apollo.datamodel.BaseServiceBean.create
07-31-2019 11:11:36.005 ERROR [default task-64] [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] [APPSYNC SERVER NAME] [] ERROR: value too long for type character varying(255)
07-31-2019 11:11:36.005 ERROR [default task-64] [org.jboss.as.ejb3.invocation] [APPSYNC SERVER NAME] [] WFLYEJB0034: EJB Invocation failed on component AWEntityServiceBean for method public com.emc.apollo.datamodel.PersistentEntity com.emc.apollo.datamodel.BaseServiceBean.create
Cause
The length of the mount options parameter passed to AppSync during discovery of one of the host's filesystems was greater than 255 characters long.
AppSync does not currently support a mount options list longer than 255 characters.
The mount options and their length can be checked from the Agent Log where "discoverFilesystems" command is run.
Starting at "rw" and counting the characters to the end of the string (including spaces) results in more than 255 characters.
AppSync does not currently support a mount options list longer than 255 characters.
The mount options and their length can be checked from the Agent Log where "discoverFilesystems" command is run.
2019-07-31 11:11:35.638 acp.py[115]:main() Command: discoverFilesystems
2019-07-31 11:11:35.676 host.py[3516]:getFilesystems() fs: /<PATH TO FILESYSTEM>/ /mnt/<MOUNT PATH> nfs rw,nosuid,nodev,relatime,vers=3,rsize=65536,wsize=65536,namlen=255,acregmin=0,acregmax=0,acdirmin=0,acdirmax=0,hard,proto=tcp,timeo=600,retrans=2,sec=sys,mountaddr=<IP ADDRESS>,mountvers=3,mountport=12204,mountproto=udp,local_lock=none,addr=<IP ADDRESS> 0 0
2019-07-31 11:11:35.676 host.py[3516]:getFilesystems() fs: /<PATH TO FILESYSTEM>/ /mnt/<MOUNT PATH> nfs rw,nosuid,nodev,relatime,vers=3,rsize=65536,wsize=65536,namlen=255,acregmin=0,acregmax=0,acdirmin=0,acdirmax=0,hard,proto=tcp,timeo=600,retrans=2,sec=sys,mountaddr=<IP ADDRESS>,mountvers=3,mountport=12204,mountproto=udp,local_lock=none,addr=<IP ADDRESS> 0 0
Starting at "rw" and counting the characters to the end of the string (including spaces) results in more than 255 characters.
Resolution
Workaround:
At the direction and with the approval of the System Administrator:
At the direction and with the approval of the System Administrator:
Reduce the size of the mount options by removing some of the parameters which are not required.
For Redhat operating systems, the mount parameters can be modified by editing the /etc/fstab/ file on the host.
Re-mount the filesystems after making the change and try to re-discover the databases from AppSync.
For Redhat operating systems, the mount parameters can be modified by editing the /etc/fstab/ file on the host.
Re-mount the filesystems after making the change and try to re-discover the databases from AppSync.
Additional Information
The is currently no fix for this issue.
Note this article if calling in a service request.
Note this article if calling in a service request.
Affected Products
AppSyncProducts
AppSyncArticle Properties
Article Number: 000168149
Article Type: Solution
Last Modified: 18 Sept 2025
Version: 3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.