Hi Jon,

we arrived at this number by deduction honestly.... we used chunks of decreasing size to understand why we were having issues pushing data into the table via the API.. we ran chunk sizes of 1000 500 100 and 10rows.
 2000 row chunks stopped at 8000 inserted.
 1000 row chunks stopped at 9000 inserted.
 500 row chunks stopped at 9500 inserted
 100 row chunks stopped at 9800 inserted and
 10 row chunks stopped at 9890...

It seemed reasonable to assume we were narrowing in on a 9900 row limit which I think we can all agree makes little sense but we aren't sure why this is so...

Took a look at the log file..
Labkey.log file indicated "java.sql.SQLException: Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them."

The attached file contains that error report...

Thanks,

WH