I created a few alert storage profiles and pretty much used the defaults for everything. Under the advanced properties, the key column is listed as ALERT_LOG_ID for each profile. Looking at the database table that was created, it’s ALERT_LOG_ndx. Why is there a difference?
The mixed case is also a bit odd. I’m assuming you’re using quoted identifiers in the generated create table statement? I can’t speak for other RDMSs, but I’m using Oracle and quoted identifiers like that make the field name case-sensitive. Took me a while to figure out what was going on and why queries like “select alert_log_ndx from alert_log” weren’t working.