Uploaded image for project: 'Shell OneHub'
  1. Shell OneHub
  2. SO-2079

LogError- ORA-01460 - uygulanamayacak veya anlaşılamayan bir dönüştürme istendi

    XMLWordPrintable

    Details

      Description

      Bu hata 16 Kasımda 47 kere, 17 Kasımda 8 kere alınmış.
      Olağan şüpheli : PartnerCard/PartnerCardDetailMassUpdate

      2022-11-17 08:34:29.5601|Error|2022-11-17 08:34:29.556956 ThreadID:29 (ERROR) OracleRelationalCommand.ExecuteReaderAsync() : Oracle.ManagedDataAccess.Client.OracleException (0x80004005): ORA-01460: uygulanamayacak veya anlaşılamayan bir dönüştürme istendi
      at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
      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, Int64 internalInitialJSONFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, 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 System.Data.Common.DbCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
      — End of stack trace from previous location —
      at Oracle.EntityFrameworkCore.Storage.Internal.OracleRelationalCommandBuilderFactory.OracleRelationalCommandBuilder.OracleRelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObject parameterObject, CancellationToken cancellationToken)
      2022-11-17 08:34:29.5601|Error|Failed executing DbCommand (158ms) [Parameters=[:p0='?' (Size = 2000), :p1='?' (Size = 2000), :p2='?' (Size = 2000), :p3='?' (DbType = DateTime), :p4='?' (Size = 2000), :p5='?', :p6='?' (Size = 2000), :p7='?' (Size = 2000), :p8='?' (Size = 2000), :p9='?' (Size = 2000), :p10='?' (Size = 2000), :p11='?' (Size = 2000), :p12='?' (Size = 2000), :p13='?' (Size = 2000), :p14='?' (Size = 2000), :p15='?' (Size = 2000), :cur1='?' (Direction = Output) (DbType = Object)], CommandType='Text', CommandTimeout='0']
      DECLARE
      TYPE "rONEHUB_AUDIT_LOGS_0" IS RECORD
      (
      "AUDITID" NUMBER(10)
      );
      TYPE "tONEHUB_AUDIT_LOGS_0" IS TABLE OF "rONEHUB_AUDIT_LOGS_0";
      "lONEHUB_AUDIT_LOGS_0" "tONEHUB_AUDIT_LOGS_0";
      v_RowCount INTEGER;
      BEGIN

      "lONEHUB_AUDIT_LOGS_0" := "tONEHUB_AUDIT_LOGS_0"();
      "lONEHUB_AUDIT_LOGS_0".extend(1);
      INSERT INTO "ONEHUB_AUDIT_LOGS" ("ACTION", "AFFECTEDCOLUMNS", "APPLICATIONCODE", "DATE", "IP", "NEWVALUES", "NOTE", "OLDVALUES", "OWNERCODE", "PLATENO", "PRIMARYKEY", "RESOURCEID", "RESOURCENAME", "TABLE_NAME", "USERID", "USERNAME")
      VALUES (:p0, :p1, :p2, :p3, :p4, :p5, :p6, :p7, :p8, :p9, :p10, :p11, :p12, :p13, :p14, :p15)
      RETURNING "AUDITID" INTO "lONEHUB_AUDIT_LOGS_0"(1)."AUDITID";
      OPEN :cur1 FOR SELECT "lONEHUB_AUDIT_LOGS_0"(1)."AUDITID" FROM DUAL;
      END;

        Attachments

          Activity

            People

            Assignee:
            selma Selma Öztaşkın
            Reporter:
            Seher Seher Bayar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: