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

ConnectPHP converted code was not able to handle the huge data...

Received Response
edited May 20, 2019 6:14PM in General Technical Discussions 1 comment


ConnectPHP converted code was not able to handle the huge data...



The cron job uses deprecated IAPI(org_create/org_update) function to import the bulk data. As part of the upgrade process,we are trying to replace these deprecated functions with relevant ConnectPHP object model, but cron job is failing with below error message

FIRST_OCCUR: 05/17/19 05:31:06
LAST_OCCUR: 05/17/19 05:31:06
DB API Error
   API Fcn: execute() [SQLStatement.cpp: 632]
 Called By: app_trans_sql_insert() [transactions.c: 526]
 SQL Error: Records: 2  Duplicates: 0  Warnings: 0
   Message: Unable to allocate sufficient storage for queryPointer!

As per our understanding, the ConnectPHP doesn't allow to commit more than 97k plus records in a single execution. We have also tried to split the import files into multiple batches and reset the file pointer/variable, but it is still failing with the same error.

Howdy, Stranger!

Log In

To view full details, sign in.


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