Tuesday, January 17, 2017

Angular2 issues with Vaadin Combo box. Using [ngModel] and (selected-item-changed) to set selected id value. not using [(ngModel)] selected-item-changed fires 3 times: 1) with 1st item in list - no matter what selection 2) same value as first 3) null value result: no selection is made. findings: item-value-path has wrong path. selected-item-changed fires 2 times: 1) with correctly selected value 2) null value result: no selection is made. findings: selected-item-changed handler was (re)setting the selected value to an invalid property, resulting in value being null a.selected-item-changed fires 2 times: 1.a) with correctly selected value 2.a) with 1st item in list result: wrong selection is made. b.selected-item-changed fires 2 times: 1.b) with previous selection 2.b) with correct value result: correct selection is made. c.selected-item-changed fires 1 time: 1.c) with correct value findings: item-value-path was using a key that could be null for selected item. selected-item-changed handler was (re)setting the selected value to correct value again, resulting in second change event firing. If key was valid and unique, selection was made correctly.

Wednesday, July 01, 2015

A Remote action is reporting a 'not found' exception.

The remote action is passing an incorrect number of parameters or one of the parameters is NULL. If the signature looks good, it is likely a null reference causing this error. Visualforce.remoting.Manager.invokeAction( 'traction_Page_Controller.submitForm', JSON.stringify(formData), function(result, event) { if (event.type !== 'exception') { console.log(result); } else { console.log('exception *!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!*!'); } } ); Visualforce Remoting Exception: Method 'submitForm' not found on controller traction_Page_Controller. Check spelling, method exists, and/or method is RemoteAction annotated

Tuesday, July 08, 2014

Adding, Removing, Re-Adding SQL accounts

Management Studio
[Server\Instance]>Security>Logins >> Add Login

SELECT SUSER_SID('<<username>>')

SELECT * FROM sys.server_principals SP where SID = <<user sid>>

Management Studio
[Server\Instance]>Databases>Object>Security>Users>User >> Delete User (Repeat as necessary)

[Server\Instance]>Security>Users>User >> Delete User

sp_droplogin <<username>>

SELECT SUSER_SID('<<username>>')

SELECT * FROM sys.server_principals SP where SID = <<user sid>>

Management Studio
[Server\Instance]>Security>Logins >> Add Login

Tuesday, March 18, 2014

ASP.Net Site loading slowly. MVC Site loading slowly. WCF service loading slowly. Cannot write to trace/error log files. File path is wrong

Thursday, November 28, 2013

App Pool service account password needs to be reset and account unlocked.

Cannot generate SSPI context.

Exception Details: System.Data.SqlClient.SqlException: Cannot generate SSPI context.
Source Error:             
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Cannot generate SSPI context.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +6298249 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +245 System.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec) +486 System.Data.SqlClient.SqlInternalConnectionTds.Login(ServerInfo server, Int64 timerExpire, String newPassword) +468 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover) +324 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +6317999 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +6318120 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +354 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +703 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +54 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +6319384 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +81 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1657 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +88 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6322807 System.Data.SqlClient.SqlConnection.Open() +258 System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +65 System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +33 System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +32 System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +63 System.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute(Expression expression) +45 System.Linq.Queryable.Count(IQueryable`1 source) +310...

Tuesday, August 27, 2013

ODBC Driver Issue:  Progress OpenEdge 10.2B - error code 193

You are trying to create a 64bit ODBC connection using a 32bit driver and the 32bit driver does not appear in the 32bit ODBC connection manager (SysWOW64)

You need to add the following keys:

"Progress OpenEdge 10.2B driver"="Installed"


[DLC] should refer to the 10.2B installation directory

Tuesday, January 08, 2013

System.ServiceModel.Security.SecurityNegotiationException: The caller was not authenticated by the service. ---> System.ServiceModel.FaultException: The request for security token could not be satisfied because authentication failed. Call is set to not-local, but is referring back to dev-services.