cancel
Showing results for 
Search instead for 
Did you mean: 

System is Hanging when do posting for Goods Receipt with Serial No. allocation.

Former Member
0 Kudos

Dear Friend,

            

             When we do goods receipt for  large No. of Item (for ex: 5000 item ) with serial number assigning through xls sheet  in DI API. Assigning serial no for item in for loop.

 

              Same time we do goods Issues  with Batch no. for Large no. of item . Goods issue posting is completed very quickly  but Goods Receipt posting is not completed when assing Serial no.

 

            Some time document is added successfully.

 

            Some time System is getting Hanging.

 

How do handle the this type of problem.

  

Please help me.

     

Regards,

K Sakthivel

Accepted Solutions (0)

Answers (1)

Answers (1)

Johan_H
Active Contributor
0 Kudos

Hi,

Adding a serial number takes more time because several (sql) checks need to be made. Upon goods Issue the serial numbers already exist, so it does not require as much work/time.

Adding 5000 new serial numbers will take so much time that it is easy for some other process to run at the same time, due to which deadlocks can occur, hanging the sytem.

Have you tried creating the goods receipt before or after business hours, when no one else (including any add ons) is using the system?

Regards,

Johan

Former Member
0 Kudos

Hai,

       This company is working  on shift basis  24/7 (Production Company), All 24 hours is business hours only.

       we are doing Goods Receipt posting with Serial No. through our Add-On and Version is 8.8

is any other solution.

Regards,

K Sakthivel

Johan_H
Active Contributor
0 Kudos

Hi,

The problem is that adding 5000 serial numbers is simply going to take time. There is no way around that.

So there really are only 4 possible solutions:

  1. Add the receipt at a time that the system is going to be used as little as possible, or figure out if there is a time when at least the items in question will not be accessed by any other process.
  2. Divide the Goods Receipt into smaller chunks, build a timer method into your application, add each chunk separately, and stop and retry a second or two later if a chunk hangs the system.
  3. Combine 1 and 2
  4. The same as 1 and/or 2, and implement a replicated database, and make all reading (for example reporting) processes use that database instead of the live one.

Regards,

Johan