I am using the BulkInsert extension and have followed the documented steps; however, the data is not being inserted into the database table.
The data exists in the list, and the physical table name is correctly set, as confirmed during debugging. There are no errors during execution, but no records are inserted into the table.
Could anyone please advise on what might be missing or how to properly perform the insert using the BulkInsert extension? Any guidance would be greatly appreciated.
Based on the advice provided, I was able to resolve the issue. Initially, the BulkInsert server action was placed inside a loop, which resulted in no data being inserted. After moving the BulkInsert action outside of the loop, the data was successfully inserted into the table.
Thank you very much for the guidance and support.
Hello @Ngu War Hlaing,
There is one scenario here that may not be 100% accurate. One thing that could be missed or inserted incorrectly is the table name. In this case, the table name should be the physical name, not the one shown in Service Studio.
Another possibility is that the process is actually inserting the data but takes some time due to the large data set. In that case, you could check Service Center for any slow queries that might be logged.
If everything is already set up correctly as mentioned in the documentation, and if it’s okay with you, could you share the OML (of course, if possible)?
Glad to hear it, you’re welcome anytime.