Hi guys, I have been here with this same problem, and got very useful information but am still stuck in there. I have applied all hotfixes. But my Client cannot run the Adjust Cost - Item Entries Batch Job! It interestingly get’s stuck at the same item. My test environment in Office runs and finishes perfectly, in fact I have done it over and over with the data restored from the clients entire backups. I have just been there, and just to rule out “code looping” simply decided to create a local dtabase and run native Navision Attain Client on the database. The batch job has succeeded. That now means the problem has to do with the SQL Server or it’s parameters. I need someone out there with experience to help me out. Basc parameters I have worked at are: Primary data file 4,000MB Sec, data file 10,000MB Transaction Log File 8,520MB The rest of my parameters are defaults basically! I appreciate your expedited help, Robert
What happens? Error message, hanging, crash, internal error? What does it do when it gets to that item, and what is the last Profiler statement written to the Server?
Thanks, the batch simply keeps repeating. I can see the entry numbers reach max and start again, on same item, and that means it can go on for a year! Very funny! Robert
Seems like very strange behaviour. Maybe some object used by the functionality is not properly compiled. Try recompile all involved objects.
This is nothing to do with file sizes or expansion. This is a C/SIDE or application bug. If it works without failure against Navision Server (I guess you’re not able to determine that) it is a C/SIDE bug for the SQL implementation. I would recommend reporting it but you’ll need to simplify the reproduction if you can in order for MS to look at it.
HI Robert Mutyaba, I was also experienced the same error with you, we use Navision 3.60 using Average Costing Method. To solve your current problem you can do : 1. Run Adjust Cost using Native Database then restore to the SQL Database. 2. If you are using average costing check on “Item Ledger Entries” for the item that has a problem, find the entries that “Applied Entry to Adjust”. = yes then set to No. After that you can run the Adjust cost. Applied all the hotfix will not solve your problem if you don’t correct some data correction on your database, you should ask your NTR the document how to correct the data or Just Find it on the partnerguide for the request no. “GB-428-264-ME8J”. Hope you can solve the problem.