Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Custom Script - Long Time Execution — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Script - Long Time Execution

Received Response
26
Views
8
Comments
edited Jun 8, 2022 11:56AM in General Technical Discussions 8 comments

Content

Hello,

I have a custom script which fetch contact data from CSV file and generates contact records with customization.

 Rows in CSV file: 99500

Script includes: set_time_limit(0);

Issue: When i execute script from browser, script can generate only 4000 contact records per execution, however i have executed same script on different environment, at this time script generates 23000 records per script execution.

Is there any setting i need to change somewhere?

Please guide.

EDIT:

After looking at log message, it shows:

Thanks,

Monish

Code Snippet

             DB API Error
     SQL Fcn: execute() [SQLStatement.cpp: 641] 
   Called By: trans_log_flush_generic() [transactions.c: 380]
    API Fcn.: _sql_execute() returned 0
   SQL Error: Records: 300  Duplicates: 0  Warnings: 0
       Error: Unable to allocate sufficient storage for queryPointer! 
        

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!