Overview

Your PreGRNFeed has been failing for several hours already and you'd like to investigate why.

Solution

The problem could be related to the buffer overflow. The solution is to reduce the number of chunks being returned to allow the request to process smaller chunks of PreGRN. Please create a Customer Support ticket asking to check the current chunk size and Customer Support will review the failure to gradually reduce chunk size more in case that the failure still occurs.

<supportagent>

1. Check the ORA message in the XDI logs (refer to the Logfiles section of the 'Troubleshooting Overview' article). You can find the description of the errors in the Oracle documentation.
2. In case the problem is related to the buffer overflow reduce the number of chunks (caller.chunk_size).
   1. Check current value:
      

      select chunk_size from xdi_180416.caller
      where service_operation = 'ff_service/preGRNFeed'

      Let's say chunk_size = 100
   2. Get back to the customer and propose to reduce it to 70 and review the failure to gradually reduce it more in case that the failure still occurs.
   3. Use this SQL query to change chunk size:
      

      update xdi_180416.caller set chunk_size = 70
      where service_operation = 'ff_service/preGRNFeed'

• xdi_180416 - is the latest XDI schema name

</supportagent>

Testing

After reducing the chink size PreGRNFeed webservice call should successfully complete.