Is it Possible for the Processor to Check (Rather Than Ignore) the Case of Alternative IDs?

[Lydia]

Let's say I have two points with two similar Alternate IDs which are the same except for their cases.

1. RootContainer/Siemens TECs/TEC01/AIRFLOW and

2. RootContainer/Siemens TECs/TEC01/Airflow

Unfortunately, when two or more points with alternate IDs which are the same except for their case, I receive the following error:

2022-07-20 10:42:25.1746,Info,WorkerThread,<no principal>,EWS Server,Started,
2022-07-20 10:42:25.2446,Error,Processor,<no principal>,One or more errors occurred.
The AlternateId RootContainer/Siemens TECs/TEC01/AIRFLOW is already in use. AlternateId values must be unique.
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at eDriveSCProcessor.eDriveSCProcessor.Execute_Subclass()
at Mongoose.Process.Processor.Execute(CancellationToken token, ProcessorExecutionMode mode)
,["EWS Server"],

I would like SmartConnector to not ignore the case of the alternative IDs. Is this possible?

[ardak]

Hi Lydia,

Out of the box SmartConnector does not support this, but from what I can tell the only thing restricting this is the database collation. If you want to you could try changing it to a case sensitive one, for example

SQL_Latin1_General_CP1_CI_AS -> SQL_Latin1_General_CP1_CS_AS

I have not tested this, so use with caution.

BR

Armend