U00011021 Host 'DB Service Agent' is not active!

Document ID : KB000103059
Last Modified Date : 22/06/2018
Show Technical Document Details
Issue:
A Database Connector object (SQL CONN) has been created. When the validity of the referenced database is checked though the button 'Test Connection', the test aborts and returns the error message: 

U00011021 Host 'DB Service Agent' is not active!

 
Cause:
The Database Service is not started on the is One Automation System.

 
Resolution:
The solution is to start the Database Service over the Service Manager Dialog.

The Database Service must be started with this kind of command : 

java -jar -Xmx256M <path to SQL agent>\bin\ucxjsqlx.jar -service -i<path to SQL agent>\bin\ucsrv.ini

If a similar Service is not created already in the Service Manager Dialog it must be added.