Bulk Import via API failing, HTTP Status 500, Error code 7005

Bulk Import via API failing, HTTP Status 500, Error code 7005

HI Zoho reports...

I am trying to copy from one database into another.  I select a query from database 1, table A and insert into database 2, table A.


This works fine for "Table A"...but is failing for "Table B"...

However, when I iterate through the list and call "addRow" on a record by record basis the data can be loaded.

Here are my API parameters for the IMPORT:

bulk_params={'ZOHO_ACTION':'IMPORT', 'ZOHO_API_VERSION':'1.0', 'ZOHO_OUTPUT_FORMAT':'JSON', "authtoken": Config.AUTHTOKEN,
 'ZOHO_ERROR_FORMAT':'JSON', 'ZOHO_AUTO_IDENTIFY': True, 'ZOHO_ON_IMPORT_ERROR': "ABORT", 
 'ZOHO_IMPORT_FILETYPE': 'JSON', 'ZOHO_IMPORT_TYPE': "APPEND",
 'ZOHO_CREATE_TABLE': False}


I am puzzled by ...

1. Why the bulk IMPORT works for Table A (Personalization-Header ), but not Table B (Personalization-Details)    --> This proves the general mechanics work.

2.  Why row by row calling of Report Client "addRow" ...works to insert the exact same query into Table B.

3.  The error code I get, for Table B, is 7005.

4.  Previous posts suggest the authtoken might be to blame, but given item #1...(this exact same code works for other tables).... I don't think its authentication  

5.  I have also tried different on Errors ...(Skip Row...and Set Empty Columns)...but to no avail..the bulk import still fails.

any suggestions or thoughts ?