A customer had written a custom workflow that tracked and managed specific networked assets in their environment. The specific details of each asset, such as name, location, IP Address, etc, had been properly rendering in a grid component , but after an Asset Management upgrade, any additional new assets of this type had incomplete records, missing one or more of the specific details. The data missing was also not consistent.
The custom workflow was using a generated SQL query component to capture the asset information, and then rendering it in a form to be able to manage it. The actual SQL query used in the generated integration component was extracted and tested, returning all of the relevant data. The problem was that the grid component in the form was somehow not rendering all of it.
Republishing the project did not seem to resolve it. However, it was discovered that this customer uses Workflow’s Enterprise Management on the SMP and that all of his projects were maintained there.
The solution ended up being very simply that the libraries in the Repository, once refreshed and the project was republished, the problem disappeared.
To refresh the Libraries, open your SMP console, and Click on the Manage tab > Workflow Enterprise Management. Click on the correct repository and click refresh. You then can publish the workflow project.