LAPI Error 101107

LapiException: CreateObjectEx Failed. Message=Error adding categories to node errMsg=Error saving generated number. Status=101107

Scenario: Bunch of categories need to be applied to a newly created folder structure and sub objects. I was trying to add a document into Livelink via LAPI. If the folder structure for where document goes does not exist, then the LAPI app creates it with the correct categories, attributes, permissions, RM Classifications, etc... However, if the structure exists, even though the category may have been applied incorrectly, then the app will just load the document into the folder structure.

Potential cause: I'm still looking into since there are so many moving parts and factors involved with this enterprise solution.... for loading documents non-natively (if that's a word) into Livelink. (DAMN architects)
What I think is happening is that -

• The category DNE at the expected parent level.
• The attributes were not populated correctly.
• ADN (automatic document numbering) had an issue

I strongly believe it has something to do with ADN because I have found issues with SQL Injections. You attempt to load a document with reserved SQL words like UNION and JOIN and ADN freaks out. Special characters like apostrophe mess it up too. We have patched ADN with a quick fix from the vendor but still run into this 101107 error. It's like Livelink is failing during the database writes into ADN along with the external file store and the attribute tables. WTF....

What a pain in the ass to resolve. Logging on the Livelink is so process intensive.