Sentiment details table schema migration<!-- /*NS Branding Styles*/ --> .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Sentiment details table schema migration Overview This article describes the schema migration process for the sys_sentiment_details table in the Platform AI Agents and Skills app (uxc-generative-ai). Why this upgrade is needed In earlier versions of the app, the sys_sentiment_details table extends the task table and has the update_synch attribute set to true. In the latest schema, the table no longer extends task, and the update_synch attribute has been removed. A standard app upgrade does not remove the existing table extension or reset the update_synch attribute. As a result, additional migration steps are required to align the table with the latest schema. Before you begin Before starting this migration, ensure that you have the admin role. Migration steps Step 1: Install the dependency application Download the attached uxc-generative-ai-deps-12.1.1-app.zip file. Sideload the ZIP file by navigating to: Navigator > System Applications > Install Application Installing this dependency application performs the following actions: Creates the sys_sentiment_details_backup table using the latest schema defined in sys_sentiment_details_backup.xmlRuns the fix script glidefix_sys_sentiment_details_data_backup.xml Migrates data from the original sys_sentiment_details table to the sys_sentiment_details_backup tableDrops the original sys_sentiment_details table Step 2: Upgrade the main application Install uxc-generative-ai version 12.1.8 or later. This version includes the fix script glidefix_sys_sentiment_details_data_migration.xml, which runs automatically one time only and performs the following actions: Creates the sys_sentiment_details table using the latest schemaMigrates data from the backup table to the newly created sys_sentiment_details table Result After these steps are completed, the sys_sentiment_details table is updated to match the latest schema with data migrated from old schema.