I was recently working with a client who was having trouble installing the 8.3 Web Action items manifest (Infor v8.3 Action Items VFS.zip). Within this manifest are actions like create triggers or drop indexes. Whenever these Database Definition Language commands were attempted they would receive the dreaded and completely useless “Object Reference not Set to an Instance of an Object” error. Looking in the log files on the App Architect server it showed a little more information:
ERROR Sage.SalesLogix.SLXSystemProvider [(null)] – The call to GetNativeConnection returned an invalid result.
What the what?
It turns out that one simple hidden thing was causing this issue.
When setting up the Connection Manager server data link definition, you have to go into the All properties and make two changes:
1) Set persist security from false to true. This allows saving the SQL user password in the definition
2) Click the Reset Value button in the Integrated Security property. This is needed even though there is no value showing in the Integrated Security property.
It turns out that item number 2 was the culprit on this. Once the connection was adjusted, the web manifest could install without issue. A warning on this also. While the client was seeing errors when installing the Action Items manifest, there are actually similar commands that get run when restoring the 8.3 project backup with the “Rebuild Schema from Project” check box ticked. Thing is there are no errors shown during the restore so those can easily be missed. They are logged to the server log. Luckily, installing the first web manifest did throw on on screen error to alert us of the problem.