[IdP] Error executing query on SSO log

[IdP] Error executing query on SSO log

  
Forge Component
(26)
Published on 4 Jul by Telmo Martins
26 votes
Published on 4 Jul by Telmo Martins

We have noticed througth Service Center that are happen some errors with "Error executing query" message on SSO process. As the error do not occurr in every request to /IdP/SSO.aspx, I need some help to try to identify the reasons and the criticity for these items. 

Follow I will put error details, that are the same in all occurrances; our environment use a on premisses Oracle SGBD:


eSpace: IdP

RequestUrl: https://ourDomain/IdP/SSO.aspx (Method: POST)

FilePath: C:\...\PS\running\IdP.1556661045\IdP.aspx

.NET: 4.0.30319.42000

Stack:

[1] Error executing query.
   at ssIdP.Actions.FuncActionAddSamlMessage_Log.datasetGetSamlMessageByMessageID(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, String qpstMessageID)
   at ssIdP.Actions.ActionAddSamlMessage_Log(HeContext heContext, String inParamMessageID, String inParamResponseToMessageID, String inParamUsername, String inParamSessionIndex, DateTime inParamCreatedOn, String inParamIPAddress, String inParamRelatedURL, String inParamIdPIssuer, String inParamSPIssuer, Boolean inParamValid, String inParamNotValidError, Boolean inParamIncomingMsg, Int32 inParamSamlMessageTypeId, Int32 inParamSamlMessageBindId, String inParamRawSamlMessage, Boolean inParamFromMobile, Int32 inParamTenantId, Boolean& outParamRepeatedID)
   at ssIdP.Actions.ActionSAML_Response_Process(HeContext heContext, STSAMLMessageStructure inParamSAMLMessage, Int32 inParamConfigTenantId, Boolean& outParamIsValid, RCUserDataRecord& outParamUserData, String& outParamRelayState, STSAML_ValidationStructure& outParamValidation, String& outParamSessionIndex, String& outParamInResponseToMessageId, String& outParamNameID, RLClaimList& outParamClaims, String& outParamUserIdentifier)
   at ssIdP.Flows.FlowAuth.ScrnIdP.Preparation(HeContext heContext)

[2] ORA-00932: tipos de dados inconsistentes: esperava - obteve CLOB
   at OracleInternal.ServiceObjects.OracleCommandImpl.VerifyExecution(OracleConnectionImpl connectionImpl, Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
   at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, Boolean isDescribeOnly, Boolean isFromEF)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at OutSystems.HubEdition.DatabaseProvider.Oracle.ExecutionService.ExecutionService.ExecuteReader(IDbCommand cmd)
   at #jmb.#smb.ExecuteReader(String description, Boolean isApplication, Boolean transformParameters, Boolean skipLog)
   at OutSystems.Internal.Db.DatabaseAccessProvider`1.ExecuteQuery[T](Command cmd, GenericRecordList`1 rl, String description, Boolean transformParameters, Boolean skipLog)
   at ssIdP.Actions.FuncActionAddSamlMessage_Log.datasetGetSamlMessageByMessageID(HeContext heContext, Int32 maxRecords, IterationMultiplicity multiplicity, Int64& outParamCount, String qpstMessageID)


Hi Tiago,

Just guessing, but by the error, the issue can be caused by the column NotValidError on the SamlMessage_Log entity. That column has 5000 length and in Oracle the driver can return as CLOB instead of String/VARCHAR2.

Having that said, it seems some bug not related with the component, that's not even a advanced query, it's a standard aggregate as I'm expecting that those conversions are made automatically.

If possible please follow up with the product support team since from what I'm aware that conversion should be done automatically.

Regards

Hi Telmo,


Ok, I'll try to go ahead with the suport team and I update here when I've news about it.


Thank you for your quick response.


Regards.