SmartConnector Forum
Schneider Electric support forum about SmartConnector applications for integration of other building management systems (BMS) into EcoStruxure Building Operation.
Link copied. Please paste this link to share this article on your social media post.
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?
Link copied. Please paste this link to share this article on your social media post.
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
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.