AnsweredAssumed Answered

REST API - Update Textarea Field with 40KB data amount

Question asked by Rene Ryhner on Sep 12, 2019
Latest reply on Sep 12, 2019 by Rene Ryhner

Dear community,


We're running our CRM (Version 8.0.3) on Windows with an IIS as web server. Database is Oracle. SUGAR-CRM is the only application on that server. Oracle is hosted on a separate Unix-Server in the same environment.


I use the SUGAR API to update my CRM data. The data for SUGAR are stored in an external database (Oracle). The JSON-call is programmed and executed in the database with PL/SQL. Currently I used the "bulk" entry point to update my CRM records.


In the same way I like to update a CLOB in the SUGAR DB (Textarea-Field, created in Studio). Content of this field is HTML. I tested this JSON-call with POSTMAN (real data and dummy "xyz"). The server response is always 500 if the data amount reaches more than 32KB . No entry, in SUGAR log nor in the PHP log.

ORACLE allow to store up to 4GB in this field.

 

 

The settings in PHP.ini are already very high (memory, max_upload etc. ) - File - php-info.


Is someone out there with a similar experience and a did find a solution?

 

Please don't hesitate to ask, if you need more information.

 

Best regards
Rene

Outcomes