ConnectPHP converted code was not able to handle the huge data...
Summary
ConnectPHP converted code was not able to handle the huge data...Content
Hi,
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.
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.
Tagged:
0