<![CDATA[Hexagon Safety & Infrastructure - Post to topic CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation]]> http://support.hexagonsafetyinfrastructure.com/infocenter/index?page=home Post to topic CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation en Copyright © 2002, 2012, Oracle and/or its affiliates. All rights reserved. Oracle Knowledge Information Manager http://blogs.law.harvard.edu/tech/rss <![CDATA[CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation]]> Custom columns in common_event_call that have been added to the main event information dialog in Calltaker/Dispatcher are not being written to the database during event creation. In the event info dialog, if I populate data in a COTS field (e.g. common_event_call.clname) and a custom field (e.g. gender) then both fields create/update fine in the database (config records appear to be correct). However, if I populate data ONLY in a common_event_call custom field in the event info dialog then literally nothing happens, the trigger to insert a new record in common_event_call table doesn't occur. Same issue occurs for updating an existing event.

I'm running CAD 9.4 Q1 2019 and a colleague had this same issue and ended up transferring his custom common_event_call columns to the common_event table.

]]> 2019-09-16 02:05:14 Etc/GMT <![CDATA[RE: CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation]]> I logged an SR for this against 9.3 MR5: 1-1798057381, there's a CR-E: 1-UP3GD8 with status Deferred Accepted, so I'm guessing it's probably never going to be 'fixed'.  

We put all our custom columns against common event instead.

]]> 2019-09-17 15:15:30 Etc/GMT <![CDATA[RE: CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation]]> Thanks Louise, much appreciated! I need to improve my Siebel search skills! ;-)

I've moved the custom columns to the common_event table also.

p.s. Small world, was on a coffee break with two of your former colleagues down here in Melbourne (Richard and MJ) running this issue by them just before seeing your reply!

]]> 2019-09-26 00:17:39 Etc/GMT <![CDATA[RE: CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation]]> We like to share our CAD knowledge with the colonies :-) And MJ was too grumpy so we gave him back!

]]> 2019-09-27 15:27:03 Etc/GMT