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

SQL
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

SQL
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:


[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC Drivers]
"Progress OpenEdge 10.2B driver"="Installed"


[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\Progress OpenEdge 10.2B Driver]
"Driver"="[DLC]\\bin\\pgoe1025.dll"
"Setup"="[DLC]\\bin\\pgoe1025.dll"
"DriverODBCVer"="3.52"
"APILevel"="1"
"ConnectFunctions"="YYN"
"CPTimeout"="60"
"FileUsage"="0"
"SQLLevel"="0"
"UsageCount"="1"

[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.

Thursday, December 20, 2012

Progress 4GL PF file

Progress 4GL PF file Local database -db C:\Data\databasename -inp 8192 -mmax 5120 -d ymd -T C:\TEMP TCP remote database -db databasename -N TCP -H localhost -inp 8192 -mmax 5120 -S portNumber -d ymd -T C:\TEMP