Evolution 1.19.1.6 Oracle 18x

Al ejecutar una nomina me manda este error, sucede cuando intenta actualizar

2021-04-12 15:47:56,349 [18] FATAL a74ed656-d7a8-4520-9488-4ad3ea854e70 - Error al actualizar en la base los cursores modificables de la formulación del tipo de planilla 4-Planilla Quincenal

System.AggregateException: One or more errors occurred. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.OnRowUpdated(RowUpdatedEventArgs value)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)
   at Aseinfo.VH4.MicroServices.GenPla.Ejecutores.NetLangCursor.CloseCursor() in C:\vh4\VH4\MicroServices\GenPla\NetLang\NetLangCursor.cs:line 78
   at Aseinfo.VH4.MicroServices.GenPla.Ejecutores.EjecutorFormulacionNetLang.<>c__DisplayClass7_0.<EjecutarFormulas>b__8(String key) in C:\vh4\VH4\MicroServices\GenPla\NetLang\EjecutorFormulacionNetLang.cs:line 155
   at System.Threading.Tasks.Parallel.<>c__DisplayClass31_0`2.<ForEachWorker>b__0(Int32 i)
   at System.Threading.Tasks.Parallel.<>c__DisplayClass17_0`1.<ForWorker>b__1()
   at System.Threading.Tasks.Task.InnerInvoke()
   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
   at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object <p0>)
   --- End of inner exception stack trace ---
   at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
   at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
   at System.Threading.Tasks.Task.Wait()
   at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IList`1 list, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)
   at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, Action`1 body)
   at Aseinfo.VH4.MicroServices.GenPla.Ejecutores.EjecutorFormulacionNetLang.EjecutarFormulas() in C:\vh4\VH4\MicroServices\GenPla\NetLang\EjecutorFormulacionNetLang.cs:line 149
---> (Inner Exception #0) System.NullReferenceException: Object reference not set to an instance of an object.
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.OnRowUpdated(RowUpdatedEventArgs value)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at Oracle.ManagedDataAccess.Client.OracleDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)
   at Aseinfo.VH4.MicroServices.GenPla.Ejecutores.NetLangCursor.CloseCursor() in C:\vh4\VH4\MicroServices\GenPla\NetLang\NetLangCursor.cs:line 78
   at Aseinfo.VH4.MicroServices.GenPla.Ejecutores.EjecutorFormulacionNetLang.<>c__DisplayClass7_0.<EjecutarFormulas>b__8(String key) in C:\vh4\VH4\MicroServices\GenPla\NetLang\EjecutorFormulacionNetLang.cs:line 155
   at System.Threading.Tasks.Parallel.<>c__DisplayClass31_0`2.<ForEachWorker>b__0(Int32 i)
   at System.Threading.Tasks.Parallel.<>c__DisplayClass17_0`1.<ForWorker>b__1()
   at System.Threading.Tasks.Task.InnerInvoke()
   at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)
   at System.Threading.Tasks.Task.<>c__DisplayClass176_0.<ExecuteSelfReplicating>b__0(Object <p0>)<---

EDIT:

2021-04-12 16:00:54,932 [18] INFO  7e9ae405-5ed0-4cee-b759-0d5d79e06c99 - Inicializando Cursor [Modificable]: DescuentosEstaPlanilla
2021-04-12 16:00:54,933 [19] INFO  7e9ae405-5ed0-4cee-b759-0d5d79e06c99 - Inicializando Cursor [Modificable]: PA_PQN_PLANILLA_QUINCENAL
2021-04-12 16:00:54,932 [13] INFO  7e9ae405-5ed0-4cee-b759-0d5d79e06c99 - Inicializando Cursor [Modificable]: IngresosEstaPlanilla
2021-04-12 16:00:54,932 [6] INFO  7e9ae405-5ed0-4cee-b759-0d5d79e06c99 - Inicializando Cursor [ReadOnly]: QuiEmpInfo
2021-04-12 16:00:54,932 [7] INFO  7e9ae405-5ed0-4cee-b759-0d5d79e06c99 - Inicializando Cursor [Modificable]: ReservasEstaPlanilla

asked 12 Apr '21, 14:48

MiguelBustamante's gravatar image

MiguelBustamante
52193110116
accept rate: 31%

edited 13 Apr '21, 12:29

Fernando%20Paz's gravatar image

Fernando Paz ♦♦
17.3k81635


El error menciona "cursores modificables" la infraestructura no soporta que un cursor sea modificable cuando se hace join con varias tablas

link

answered 12 Apr '21, 14:57

sbarahona's gravatar image

sbarahona ♦♦
(suspended)
accept rate: 32%

Lo extraño es que es una nomina en desarrollo, no tiene mayor cantidad de cursores modificables solo los basicos de momento. Edite el original y te coloque los cursores, todos son una sola tabla.

Ese que aparece PA_PQN_PLANILLA_QUINCENAL es la tabla de la formula de la planilla y no un cursor como tal.

(12 Apr '21, 15:03) MiguelBustamante MiguelBustamante's gravatar image

Recuerdo un caso en el que se dió un error similar, porque el cursor modificable no retorno registros al momento de abrirlo y tenía un único registro o no tenía ninguno al momento de cerrarlo. Coincidentemente era una formualción C# sobre una base Oracle.

¿Podrías revisar si regresan registros los cursores modificables?

link

answered 13 Apr '21, 12:31

Fernando%20Paz's gravatar image

Fernando Paz ♦♦
17.3k81635
accept rate: 51%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Evolution en BitBucket

En este sitio puede acceder al código fuente, centro de descargas y reportar bugs, propuestas y mejoras para Evolution.

Evolution en JIRA

En este sitio puedes sugerir nueva funcionalidad para Evolution, o puedes votar por la funcionalidad ya propuesta por otros usuarios.

Tags:

×4

Asked: 12 Apr '21, 14:48

Seen: 411 times

Last updated: 13 Apr '21, 12:31

[Acerca de] [Preguntas Frecuentes] [Privacidad] [Soporte] [Contacto]
Copyright 2013-2018. Asesores en Informática