error during inventory reconcile

(0) Share

Report

Posted on by c4c4571f00c7433e841...

1,110

i am facing an error during inventory reconcile, "a save operation on the table iv_reconcile_temp" cannot find the table. "

i click on ok, and reconcilation continues, but after some time during reconcilation again and again same error occured, and at the end of reconcilation different errors occured, e.g FP could not close table.

i have to close fiscal year with in 1,2 week, what is this error, and what's its impact, and if same error occured during fiscal year closing, then can it cause some disturbance in gp??

i have a sql server, and a terminal, and both are on LAN, in a single server rack, and its ping time is less then 1ms.

*This post is locked for comments

All responses (3)

Answers (2)

Suggested answer

c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: error during inventory reconcile

thx, its done without any error
Verified answer

Almas Mahfooz 11,006 User Group Leader on at

Like (0)

Report

RE: error during inventory reconcile

do followings.

1. check space available on your machine, if space is too small, make some space.

2.From Temp folder, delete TNT*.idx, TNT*.dat and TNT*.tmp files. Temp folders path should be something like C:\Users\Almas\AppData\Local\Temp

3.Restart your SQL Server.
Verified answer

soma 24,410 on at

Like (1)

Report

RE: error during inventory reconcile

Please take a backup of your company database and run the checklinks for inventory module, mostly it will correct your issue. Before closing the year of any module, you need to run the checklinks for appropriate module.

Note: If checklinks doesn't show any error message, it wont through any error while closing the year.

Hope this helps!!!