vRealize Orchestrator search displays "search error:null" when searching for longer strings
book
Article ID: 338300
calendar_today
Updated On:
Products
VMware Aria Suite
Issue/Introduction
Symptoms: When using the search function in the vRealize Orchestrator client, you see "search error: null" displayed.
Environment
VMware vRealize Orchestrator 7.3.x
Cause
This can occur when there are duplicated scripting modules stored in the vRealize Orchestrator database.
Resolution
Prerequisites
Create a connection for the vRealize Orchestrator SQL plugin to the vRealize Orchestrator database. This connection will be used as an input for the workflow we will run.
Procedure
Download action_db_records_fix.package.gz attached to this article.
Unzip the workflow package and import into vRealize Orchestrator using the client.
Select the vRealize Orchestrator database from the SQL plugin as the input for the workflow and click submit
This workflow looks for and deletes duplicate records for scripting modules. If there is any question as to which of the duplicates should be deleted, the user is prompted for input. No configuration elements will be altered.
Test the search functionality in the vRealize Orchestrator client.