CME option field length limit

NICE CXone API & Integrations
1

Once again, in my daily quest to fulfill al my customer needs I run into yet another unforeseen problem. This time it has to do with the number of attached parameters one can attach to a call. The problem lies with defining EventData in CCon options. Since now we have more than forty userdefined parameters, defining them in EventData option of CCon is impossible, because the value for this option is longer than 255 bytes. Needless to say, if we do not define them in EventData, CCon would not write that data into EVREFEX table.

At first, I thought the problem lies only with CME, and tt seems like ConfigManager 5.1.505.04 and ConfigServer 5.1.511 fix this problem; however,then I noticed that it also affects Config Database, because the table for options is defined as follows:

create table cfg_app_option(

object_dbid numeric(10,0) null,

   object_type int null,

section varchar2(255) null,

opt varchar2(255) null,

val varchar2(255) null,

object_csid numeric(10,0) null

)

Did anyone else experience the same problem, where they simply had too many parameters which they could not define with CME? How did you solve it?

With best regards,

Vic

2

You can have several EventData options in CCon configuration to store big amount of attachdata to store in Database. EventData as firstone, EventData_n as second etc. Every option except last one must have a comma at the end. For example:

EventData=char,Descr,char(15),enquirytype,
EventData_1=char(5),GCTI_GLOBAL_WAITING_TIME,
EventData_2=char,ReleasingParty

255 character limit is removed in 8.x:

  • You are no longer limited to 255 characters in defining flexible option values in the Options and Annex tabs of configuration objects. You may now enter up to 4 Kb of text.
1 Like