NullPointerException issue with sys_ai_record_activity table - Known Error

NullPointerException issue with sys_ai_record_activity table Description Customers may encounter a NullPointerException when the platform attempts to read or write data to the GenAI Record Activity table (sys_ai_record_activity).

This issue occurs because the sharded tables for sys_ai_record_activity are not fully created or synchronized during:

Installation of the GenAI Q4 plugin (com.glide.ai_record_activity), or Upgrade to ZP4 / YP11 / AP0 As a result, runtime access to the table fails, leading to errors similar to:

Error getting record for sys_ai_record_activity: java.lang.NullPointerException

This issue does not impact all instances and may appear intermittently depending on plugin installation or upgrade timing.

Steps to Reproduce

Steps to Reproduce:

Install the GenAI Q4 feature or upgrade an existing instance to ZP4/YP11/AP0. Ensure the plugin com.glide.ai_record_activity is installed. Trigger a GenAI operation that records or reads activity data. Observe system logs or error output. The following error may appear: Error getting record for sys_ai_record_activity: java.lang.NullPointerException

Cause:

The table sys_ai_record_activity uses sharding (16 shards) and relies on an entry in sys_table_rotation for shard management.

In some upgrade or installation scenarios, the shard tables are not fully created or synchronized, even though the base table and plugin are present. This leads to null references when the platform attempts to access shard metadata or records.

Workaround Repairing the AI Record Activity plugin forces proper shard creation and synchronization.

Option 1: Plugin Manager (UI)

Navigate to System Definition → Plugins. Search for GenAI Record Activity (com.glide.ai_record_activity). Click Repair. Wait for the repair process to complete. Option 2: Background Script

Run the following script as an administrator:

var pluginId = 'com.glide.ai_record_activity';

var pm = new GlidePluginManager(); var result = pm.repair(pluginId);

gs.print('Repair initiated for plugin: ' + pluginId);

After repair, the missing shard tables are created and the issue is resolved.

Resolution / Fix Status :

A permanent fix is under investigation to ensure automatic shard creation and synchronization during plugin installation and instance upgrades, without requiring manual repair.

Until the fix is delivered, plugin repair is the recommended workaround.

Impacted Release Version Details:

Starting from ZP4/YP11

Note: This issue can only be observed when com.glide.ai_record_activity plugin is installed. We can disable this feature by turning off this sys_property "glide.ai.field_indicators.enabled".