Skip to main content

Install Appvance IQ Database Schema

  1. Open guidance
MySQLWorkbenchIf

Installwarning appears, click OK
MacOS14.png

Select Apple Menu and click System PreferencesClick Privacy & SecurityClick the AIQGeneral tab and select Open Anyway, and then Open
MacOS15.png



MacOS16.pngIf version compatibility issues occur, please try alternate download from https://downloads.mysql.com/archives/workbench/When MySQL Workbench appears, assuming a database schemaconnection onlydoes withnot already exist, click MySQL Connections + (add) button
MacOS17.pngEnter a name for the installerconnection in the Connection Name box
Enter the hostname, port and credentials (if needed) and click OK
MacOS18.pngFollow any prompts for updating the passwordClick the newly created connection, for example AIQ as illustrated below
MacOS19.pngSelect File and click Open SQL Query Script...Browse to <AIQ>\TestNode\webapps\AppvanceServer\WEB-INF\classes\databaseSelect MySQLInitial.sql and click OpenSelect Query and click Execute (All or migrationSelection)Select processFile supportedand byclick Open SQL Script...From the targetsame AIQlocation, version.select Schema changes affect platform stability, upgrades, reporting,MySQLAppvance.sql and executionclick history.OpenSelect 

BeforeQuery installation

  • Confirm AIQ version, database version, host, schema name, user permissions,
and backupclick status.VerifyExecute charset, collation, packet size, case-sensitivity, and storage requirements.Coordinate downtime and rollback if the schema is being created(All or migratedSelection) in

Troubleshooting

a

Error sharedCode: environment.Use1419. approved scripts only;You do not manually edit schema objects without support guidance.

Validation workflow

  1. Run schema creation or migration fromhave the approvedSUPER installerprivilege orand script.
  2. Confirmbinary AIQlogging canis connectenabled
with

If you get the configuredabove error while running the MySQLAppvance.sql script on AWS RDS, make sure that the RDS parameter group has the value 1 (ON) for the log_bin_trust_function_creators parameter. The RDS database user.

RunMUST login,be Scenariorebooted Editor,for Serviceparameter Suite,changes to take effect.

Next step: Update MySQL Max Packet and reportingCase smokeSettings

tests.Review AIQ and database logs for permission, migration, or object errors.

Last updated: OctoberSeptember 7,18, 20262024

If you have any feedback on this topic, please contact us at documentation@appvance.ai

Back to top