Bulk-insert follow-up fixes

What does this MR do?

Closes #209346 (closed)

Addresses a few smaller bulk-insert related issues that we had broken out into #209346 (closed).

• simplify test that was resetting row ID counter
• split up exception that was raised in response to a missing PK
• fix exception message that included PK value

Does this MR meet the acceptance criteria?

Conformity

• [-] Changelog entry
• [-] Documentation (if required)
• Code review guidelines
• [-] Merge request performance guidelines
• Style guides
• Database guides
• [-] Separation of EE specific content

Availability and Testing

• Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.
• [-] Tested in all supported browsers
• [-] Informed Infrastructure department of a default or new setting change, if applicable per definition of done