here is the log
Error:
“DiagnosticFrameworkWrapper.CustomerFacingException: One or more SQL errors has been encountered:\nA value in either the row to be inserted or a trigger in the database is out of range.\r\n at Nirvana.Data.SQLBasedProvider.ExecuteNonQuery(String sqlCommand, List1 clauses, Int32 commandTimeout)\r\n at Nirvana.Data.SQLBasedProvider.ExecuteNonQuery(Context context, String sqlCommand, List1 clauses, Int32 commandTimeout)\r\n at Nirvana.Data.SQLBasedProvider.UpdateRow(Context context, SqlTable table, Dictionary2 updateValues, Dictionary2 keyValues)\r\n at Nirvana.Data.DatabaseProvider.SqlData.SqlTable.UpdateRow(Context context, SqlRow row)\r\n at Nirvana.Data.APIBasedProvider.ExternalApiData.UpdateRowsIndexed(Context context, Op op, ITable table, List1 colTypes, List1 keyPositions, Int32 columnSliceMapping, List1 changedRowKeyPositions)\r\n at Nirvana.Data.APIBasedProvider.ExternalApiData.UpdateRows(Context context, Op op, PhysicalSchema physicalSchema, List1 colTypes, List1 keyPositions, Int32[] columnSliceMapping, List1 changedRowKeyPositions)\r\n at Nirvana.Data.DataLayer.UpdateTableRows(Context context, Op op, Int32 ownerId, AppTable appTable, List1 colTypes, List1 keyPositions, Int32 columnSliceMapping, List1 changedRowKeyPositions)\r\n at Nirvana.Internal.InternalAPI.UpdateTableRowInternal(Context context, Op op, Int32 userId, Int32 executeAs, ChangeEventWorkflowRuleEvaluator changeEventWorkflowRuleEvaluator)\r\n at Nirvana.Internal.InternalAPI.PerformOperation(Context context, Op op, Int32 userId, String appTemplateVersion, Boolean& success, String& errorMessage, Exception& errorException, UpdateModeEnum requiredUpdateMode, RowOperation rowOperation)" Properties: { "TableName": "universal_data", "apiLevel": "2", "appStartTime": "2020-10-09T02:37:26.359Z", "appTemplateVersion": "1.000374", "build": "bf408bdfb8c5f96e1609-1602180545257-a1370031", "checkCache": "true", "clientId": "bbc81a6a-f312-4ffa-9a21-566320f76b65", "dataStamp": "2020-10-09T02:37:50.813Z", "isPreview": "true", "lastSyncTime": "", "localVersion": "1.000374", "locale": "en-US", "mechanism": "QuickEdit", "requestId": "15451969", "requestStartTime": "2020-10-09T02:38:07.171Z", "timestamp": "2020-10-09T02:37:50.807Z", "tzOffset": "240", "viewName": "Job Notes", "AppTemplateVersion": "1.000374", "RowSize": 5704, "AppTemplateName": "e326ce69-8cb6-4dca-98fd-8efe241c2340", "Operation": "Edit row", "RecordType": "Stop", "Errors": "Unable to add/edit/delete row in table 'universal_data'. → One or more SQL errors has been encountered:\nA value in either the row to be inserted or a trigger in the database is out of range.", "Exception": "DiagnosticFrameworkWrapper.CustomerFacingException: One or more SQL errors has been encountered:\nA value in either the row to be inserted or a trigger in the database is out of range.\r\n at Nirvana.Data.SQLBasedProvider.ExecuteNonQuery(String sqlCommand, List1 clauses, Int32 commandTimeout)\r\n at Nirvana.Data.SQLBasedProvider.ExecuteNonQuery(Context context, String sqlCommand, List1 clauses, Int32 commandTimeout)\r\n at Nirvana.Data.SQLBasedProvider.UpdateRow(Context context, SqlTable table, Dictionary2 updateValues, Dictionary2 keyValues)\r\n at Nirvana.Data.DatabaseProvider.SqlData.SqlTable.UpdateRow(Context context, SqlRow row)\r\n at Nirvana.Data.APIBasedProvider.ExternalApiData.UpdateRowsIndexed(Context context, Op op, ITable table, List1 colTypes, List1 keyPositions, Int32[] columnSliceMapping, List1 changedRowKeyPositions)\r\n at Nirvana.Data.APIBasedProvider.ExternalApiData.UpdateRows(Context context, Op op, PhysicalSchema physicalSchema, List1 colTypes, List1 keyPositions, Int32 columnSliceMapping, List1 changedRowKeyPositions)\r\n at Nirvana.Data.DataLayer.UpdateTableRows(Context context, Op op, Int32 ownerId, AppTable appTable, List1 colTypes, List1 keyPositions, Int32[] columnSliceMapping, List1 changedRowKeyPositions)\r\n at Nirvana.Internal.InternalAPI.UpdateTableRowInternal(Context context, Op op, Int32 userId, Int32 executeAs, ChangeEventWorkflowRuleEvaluator changeEventWorkflowRuleEvaluator)\r\n at Nirvana.Internal.InternalAPI.PerformOperation(Context context, Op op, Int32 userId, String appTemplateVersion, Boolean& success, String& errorMessage, Exception& errorException, UpdateModeEnum requiredUpdateMode, RowOperation rowOperation)”,
“ReturnedFromCache”: false,
“Performance”: “{“Version”:1,“Time”:“00:00:02.8980434”,“PerformanceTimingRoot”:{“Mid”:154,“Params”:{“ParamList”:[{“Pid”:13,“Value”:“universal_data”}]},“Timer”:{“Time”:“00:00:02.8980434”},“Children”:[{“Mid”:5,“Timer”:{“Time”:“00:00:02.8966911”},“Children”:[{“Mid”:112,“Timer”:{“Time”:“00:00:02.8952237”},“Children”:[{“Mid”:108,“Timer”:{“Time”:“00:00:02.8951448”},“Children”:[{“Mid”:113,“Timer”:{“Time”:“00:00:02.8943374”},“Children”:[{“Mid”:111,“Timer”:{“Time”:“00:00:02.3421018”},“Children”:[{“Mid”:224,“Params”:{“ParamList”:[{“Pid”:1,“Value”:“bol_crew_start”}]},“Timer”:{“Time”:“00:00:02.3403841”},“Children”:[{“Mid”:225,“Timer”:{“Time”:“00:00:00.0667008”},“Children”:},{“Mid”:226,“Timer”:{“Time”:“00:00:02.2734536”},“Children”:[{“Mid”:228,“Timer”:{“Time”:“00:00:01.2420476”},“Children”:[{“Mid”:97,“Params”:{“ParamList”:[{“Pid”:17,“Value”:“universal_data_Images/70c1f19b.bol_crew_start.023807.png”}]},“Timer”:{“Time”:“00:00:01.2418838”}}]},{“Mid”:388,“Timer”:{“Time”:“00:00:00.9202929”}}]}]}]},{“Mid”:36,“Timer”:{“Time”:“00:00:00.5502261”},“Children”:[{“Mid”:374,“Timer”:{“Time”:“00:00:00.1120409”},“Children”:[{“Mid”:373,“Timer”:{“Time”:“00:00:00.1115806”}}]},{“Mid”:377,“Timer”:{“Time”:“00:00:00.3139761”},“Children”:[{“Mid”:372,“Timer”:{“Time”:“00:00:00.3137093”}}]}]}]}]}]}]}]},“IsEmpty”:false}”,
“Result”: “Failure”
}
LinkedIn
Twitter
