cancel
Showing results for 
Search instead for 
Did you mean: 

Error en informe de auditoría de Stock en la versión 8.81

Former Member
0 Kudos

Buenos días,

Un cliente está teniendo el siguiente inconveniente desde la actualización a la versión 8.81 PL05.

Al tratar de quitar un informe de auditoría de Stock de todos los artículos en un depósito determinado, con rango de fechas de 01/01/2009 al 08/08/2011, el sistema arroja el siguiente mensaje:

"No posee los recursos suficientes para completar esta acción. Seleccione menos registros de datos y vuelvalo a intentar. "

Hemo probado en la versión 2007 A PL11 emitir el mismo informe con los mismos parámetros y se ha tenido inconvenientes.

Alguién tiene alguna sugerencia de cómo solucionar este inconveniene?

OBS: La actualización se realizó desde la versión 2007 A PL11 directamente a la versión 8.81 PL05, alguién sabría decir si existe algún problema al hacer la actualización de esta manera?

Desde ya muchas gracias.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188440
Active Contributor
0 Kudos

Hola, me parece es un tema de funcionalidad de SAP para que no afectes el performance del servidor, con reportes tan grandes, vienen bloqueos en muchas tablas que afectan tu performance y en consecuencia la operacion de la empresa (transacciones)

Former Member
0 Kudos

Hola Mauricio,

Muchas gracias por la pronta respuesta.

No sabrías si hay alguna manera de evitar que salte este error? Ya que el cliente me reclama que con la versión anterior no tenía dicho inconveniente.

former_member188440
Active Contributor
0 Kudos

Hola, revisa esta nota de SAP

Symptom

You are working with SAP Business One version 2007A PL 48 or higher or with SAP Business One version 2007 B PL 11 or higher.

You run the Inventory Audit Report for all the items for a specific warehouse or for all the warehouses without specifying any date.

A validation message is displayed 'You have insufficient resources to complete this action. Select fewer records and try again. [Message 131-225]'.

Currently there is an application limitation to display a maximum of 205,000 records. Attempting to display more records than this will result in the validation message displayed to the user and no report generated.

This limitation in SAP Business One was implemented due to a restriction of memory usage (2GB) for each application running a 32-bit version of the Windows operating system.

Cause

Specific Solution

Solution

To determine the total number of records returned by the Inventory Audit Report for all the items and warehouses without any specific date run the following query:

SELECT count(*)

FROM [dbo].[OINM] T0 INNER JOIN [dbo].[OITM] T1 ON T1.[ItemCode] = T0.[ItemCode]

WHERE (T0.[TransValue] <> 0 OR T0. [InQty] <> 0 OR T0.[OutQty] <> 0 OR T0.[TransType] = 162 )

In order to run the Inventory Audit Report for all the items please use one of the following workarounds.

1. In order to receive the correct values for all warehouses and items when running the Inventory Audit Report, there is a possibility to set small range of dates and also to check the "Display OB for Items/Accounts with no Transactions" checkbox in the selection criteria of the report.

More information about this solution can be found in note number 1174122.

2. Run the attached SQL query which returns the selection criteria listing valid item ranges (Item Code from and to).

Note: These are the maximal ranges that can be chosen in the report in case the report is run without any other selection criteria defined (warehouse, dates etc.)

Please take note of this limitation with the Inventory Audit Report and review the business logic of your customer for the necessity to display all items for a specific warehouse or for all the warehouses without specifying any date.

Aqui el query que mencionan


SET NOCOUNT ON

DECLARE 
@max int, @count int,@counter int,@from int,@to int,@current int,@comment nvarchar (50),@first char (1),@next int

------------------------------------------------------------------
SET @max = 300000
------------------------------------------------------------------

CREATE TABLE dbo.#Temp1
([id] int IDENTITY,
 [ItemCode] nvarchar (50),
 [count] int)

CREATE TABLE dbo.#Temp2
([ItemCode_From] nvarchar (20),
 [ItemCode_To] nvarchar (50))

INSERT INTO dbo.#Temp1
SELECT T1.ItemCode, count (T0.ItemCode) 'count'
FROM OITM T1
LEFT JOIN OINM T0 ON T0.ItemCode = T1.ItemCode
WHERE T1.InvntItem = 'Y'
GROUP BY T1.ItemCode
ORDER BY T1.ItemCode

SET @comment = '***More than ' + CAST(@max AS nvarchar (10)) + ' lines***'

declare Currs CURSOR SCROLL
for 
select [id]
From dbo.#Temp1
Order By [id]

Open Currs

Fetch next From Currs 
Into @from
While ( @@Fetch_Status = 0)
Begin

 SELECT @counter = 0,@to = @from,@first = 'Y'

 declare Currs2 CURSOR 
 for 
 select [id],[count]
 From dbo.#Temp1
 where [id] >= @from
 Order By [id]

 Open Currs2

 Fetch next From Currs2 
 Into @current, @count
 While ( @@Fetch_Status = 0)
 Begin
  
  SET @counter = @counter + @count
  IF @counter <= @max
   BEGIN
    SELECT @to = @current,@first = 'N'
    Fetch next From Currs 
    Into @next
   END
  ELSE
   BEGIN
    IF @first = 'Y'
     SET @to = -1
    ELSE
     BEGIN
      Fetch prior From Currs 
      Into @next
     END
    BREAK
   END
    
  Fetch next From Currs2 
  Into @current, @count

 End

 Close Currs2
 Deallocate Currs2

  INSERT INTO dbo.#Temp2 
  SELECT 
  (SELECT ItemCode FROM dbo.#Temp1 WHERE [id] = @from),
  ISNULL((SELECT ItemCode FROM dbo.#Temp1 WHERE [id] = @to),@comment)

Fetch next From Currs 
Into @from

End

Close Currs
Deallocate Currs

SELECT * FROM dbo.#Temp2
ORDER BY [ItemCode_From]

DROP TABLE dbo.#Temp1
DROP TABLE dbo.#Temp2

SET NOCOUNT OFF

Espero te sirva

Former Member
0 Kudos

Muchas gracias Mauricio, hago las pruebas y luego comento.

Former Member
0 Kudos

Hola buenas tardes, me esta ocurriendo el mismo error, pero yo tengo la version 2007A SP01 PL07. Lo curioso es que antes si me dejaba ejecutar el reporte seleccionando todos los almacenes ahora lo tengo que hacer por rango de almacenes.

Saben porque pasa esto en esta version? tambien tiene una limitante de record?

gracias.