Invalid License File

[sesa481917_brid]

2018-11-30 10:30:05.1451,Info,Portal,admin,Licenses,CreateThumbprint,ET=61 mSec,
2018-11-30 10:30:08.1674,Error,Service,<no principal>,Padding is invalid and cannot be removed.
at System.Security.Cryptography.RijndaelManagedTransform.DecryptData(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode paddingMode, Boolean fLast)
at System.Security.Cryptography.RijndaelManagedTransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount)
at SxL.Common.Crypto.Decrypt(String value, String keyValue, String initializationVector)
at Mongoose.Common.Data.ExtensionMethods.Decrypt(IEncryptable encryptable, String encryptionKey)
at Mongoose.Service.Data.MongooseDbContext.OnObjectMaterialized(Object sender, ObjectMaterializedEventArgs e)
at System.Data.Entity.Core.Objects.ObjectContext.OnObjectMaterialized(Object entity)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.RaiseMaterializedEvents()
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StopMaterializingElement()
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[TResult](Expression expression)
at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
at Mongoose.Service.Licensing.AntiRollbackDateTime.get_UtcNow()
,["Current WindowsIdentity is NT AUTHORITY\\SYSTEM"],

.

.

.

.
2018-11-30 10:30:12.2015,Error,Portal,admin,Invalid license file.

Your license has expired. Please contact your distributor/vendor to renew the license.
at Mongoose.Service.Portal.Root.Licenses.LicensesController.<>c__DisplayClass7_0.<AddLicenses>b__1(Object <p0>)
at Mongoose.Common.ExtensionMethods.ExecuteAndLogCall[TController,TRequest,TResponse](TController controller, String methodName, TRequest request, Func`2 methodToLog)
,["Licenses","A5196A6827F14DEDA43AA11C244AC338"],
2018-11-30 10:30:13.1815,Error,Service,<no principal>,Padding is invalid and cannot be removed.
at System.Security.Cryptography.RijndaelManagedTransform.DecryptData(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount, Byte[]& outputBuffer, Int32 outputOffset, PaddingMode paddingMode, Boolean fLast)
at System.Security.Cryptography.RijndaelManagedTransform.TransformFinalBlock(Byte[] inputBuffer, Int32 inputOffset, Int32 inputCount)
at SxL.Common.Crypto.Decrypt(String value, String keyValue, String initializationVector)
at Mongoose.Common.Data.ExtensionMethods.Decrypt(IEncryptable encryptable, String encryptionKey)
at Mongoose.Service.Data.MongooseDbContext.OnObjectMaterialized(Object sender, ObjectMaterializedEventArgs e)
at System.Data.Entity.Core.Objects.ObjectContext.OnObjectMaterialized(Object entity)
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper.RaiseMaterializedEvents()
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.StopMaterializingElement()
at System.Data.Entity.Core.Common.Internal.Materialization.Shaper`1.SimpleEnumerator.MoveNext()
at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext()
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source)
at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__1[TResult](IEnumerable`1 sequence)
at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)
at System.Data.Entity.Core.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[TResult](Expression expression)
at System.Data.Entity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)
at System.Linq.Queryable.FirstOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
at Mongoose.Service.Licensing.AntiRollbackDateTime.get_UtcNow()
,["Current WindowsIdentity is NT AUTHORITY\\SYSTEM"],

---

I keep getting the same error- saying my license is invalid/expired even after requesting a new license

I'm trying to simiply install a developer license to make my own smart connector. 

any help would be greatly appreciated, thanks!

[JeffBowman · Accepted solution]

Hello,

I see a couple things that look weird here to me.

The first is it seems that the encryption key you are using, is not valid for your database. Did you at some point either create a new database or re-install smart connector keeping the old database?

If the answer is yes to the above, there is a likely a mismatch between the actual Encyrption Key that is used to decryped encrypted values in your database and the encryption key that the installed Smart Connector instance is trying to use. So in this case, the Anti-rollback mechanism (which is in the database), cannot correctly read the correct value, so it assumes that someone was messing with the time on the PC to try and get around an expired license and it is not allowing the new license to be used.

I would try the following:

1. Uninstall Smart Connector, including the database (which happens by default so no need do anything special)

2. Re-install Smart Connector.

3. Try again.

If the above isn't true (the mismatched encryption key). I would try the following.

1. Stop the Smart Connector Service 

2. Using a SQL Management Studio, open up the Smart Connector database

3. Find dbo.Settings table and edit the rows.

4. Find the ArdtValue setting and remove that row.

5. Start the Smart Connector Service

6. Try installing the license again.

Let me know how it goes!

Best Regards,

-Jeff

[sesa481917_brid]

Hi Jeff, 

Deleting my old database and re-installing smartconnector has solved my issue with the licensing. 

Thank you! 

Linda