Install AIC and DU with offline Automation Suite (2023.4, offline, external Orchestrator, custom DB name, platform app disabled ).
The issue when install AIC and DU with offline Automation Suite and external Orchestrator
###################################### documentunderstanding ########################################### TestName Status Message ------------------------------------------------------------------------------------------- Document Understanding Connection PASSED Able to connect with documentunderstanding database using authentication mechanism provided Document Understanding FullTextSearch PASSED Full Text Search is enabled in sql sever. ###################################### aievents ########################################### TestName Status Message ------------------------------------------------------------------------------------------- AIEvents Database Connection FAILED Unable to connect to Database AutomationSuite_Platform . If AutomationSuite_Platform is not created, please allow the installer to create a new database by setting 'create_db: true' in the cluster_config.json file or pre-create the database named AutomationSuite_Platform and this error could also occur due to permission issue on the database Write-Error: /usr/uipath/preinstall/Main.ps1:115 Line | 115 | Main | ~~~~ | Failed: One or more validation failed + [[ failed == \f\a\i\l\e\d ]] + error 'Presync checks failed' ++ date +%Y-%m-%dT%H:%M:%S%z + echo -e '\e[0;31m[ERROR][2023-11-03T14:48:50+0000]:\e[0m Presync checks failed' [ERROR][2023-11-03T14:48:50+0000]: Presync checks failed
Resolution:
- Uninstall the cluster for offline deployment and clean up the OSD disk using How to uninstall the cluster?
- Restart the installation after enabling the platform app in cluster config JSON file and setting the SQL connection string to be for custom DB.
Example:
"platform": {
"enabled": true,
"sql_connection_str": "Server=tcp:DB.database.windows.net,1433;Initial Catalog=DB ;Persist Security Info=False;User Id=user sql ;Password='XXXXX ';MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Max Pool Size=100;"
},