CS issue when trying to add new contact when email addrees was not found
Since a few weeks we have an issue when adding a new contact over CS because senders address was not found. It happens in one of four cases.
There is a msssage om top of the screen like the one below.
we recreated all indizees on table email and even run dbsetup to check sequence.
I ckeched table email and could not found any records with obviuos invalid content like special chars (ascii 1 to 30).
So what can cause the issue?
Thanks for Help
Allt Svar (3)
Hi,
If you can reproduce this error, try opening the browser console and opening the network tab. On the HTTP request that failed, look at the response tab, it should show the error that is being returned by the API there.
You could also check the log file from CRM web to see what error is being logged. (see LogFolder property in the web.config)
Hello I found this several times in the CRM Log:
They have about 31000 records in table email and person, the most often used mail domain is about 2000 records (big company)
Error 2024-09-09T09:16:36.85 SuperOffice.Data.Dialect.Dialect XXXXXX(93) - Authorized (Employee)Administrator: Administrator: Has full access to all data. Can maintain all aspects of the system EMail.FindContactOrPersonByEmailNameWithLimit Connecting Industry info@connectingindustry.com.au 1000 1000 MSSQL - 15 \\xxxxxxxxxx (crm7), Database serial #: 1501246654, Database Expiration Date: Wednesday, 12 February 2025 xxxxxxx 1501246654 SuperOffice 10.1.6 NetServer 10.1 Release (Build: Release_OnSite_10.1.6_2022.10.06-05) 10.1.0.0 10.1.6.838 Release_OnSite_10.1.6_2022.10.06-05 Default xxxxxxx NetServer Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at SuperOffice.Data.Dialect.Dialect.InvokeToSql(Object[] toSqlArguments) mscorlib Sanity check: You should not have more than 20000 items in an IN clause. Actual count: 20267 at SuperOffice.Data.Dialect.SqlServerCommon.ToSql(In arg) SoDataBase
Exception Message:Exception has been thrown by the target of an invocation.
Exception Source:mscorlib
Exception Target:System.Object InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at SuperOffice.Data.Dialect.Dialect.InvokeToSql(Object[] toSqlArguments)
Is this issue fixed in a newer version?
Hi,
In 10.3.1 the email search was optimized, see Improve recipients search performance, possibly this was also fixed, you could try by upgrading to 10.3.3.?