Knowledgebase article 217

DataTables warning (Ajax error) - Oracle


If you are using Oracle and receive "DataTables warning (Ajax error), you will need to modify 3 tables from LONG RAW data type to BLOB.  The error seems to happen when large amount of data is being pulled by the filters.





Here are the 3 commands to convert from LONG RAW data type to BLOB:

ALTER TABLE attachments MODIFY ( filedata BLOB );
ALTER TABLE mailconfigfile MODIFY ( filedata BLOB );
ALTER TABLE ssoconfigfile MODIFY ( filedata BLOB );

Group eHD Standard Support Last modified Apr 26, 2023 Type Public Viewed 151