Options

Adjust Cost Batch Error "This interger is too long&quot

anooanoo Member Posts: 2
I'm facing an error "This interger is too long" while running Adjust Cost Item Entries batch job.

Does anybody have any clue about it....i have been trying to solve this problem for too long but no luck :(

Please help

Regds
Anoop

Comments

  • Options
    ovicashovicash Member Posts: 141
    Have you used the debuger? Where does it stop?
    ovidiu

    Best Regards
  • Options
    WaldoWaldo Member Posts: 3,412
    Have there been some modifications on this functionality?
    Which version are you working on?
    Did you try the debugger?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    It does not really look like an error in the standard. Go to Codeunit Inventory Adjustment in Tools, Object Designer and look at the Modified flag. Maybe also for Codeunit Item Jnl - Post Line. If it is checked, try to find the guy who modified it.
  • Options
    ssinglassingla Member Posts: 2,973
    I am receiving the following error while running the adjust cost batch job:

    The following SQL server error occured while accessing the GL Entry Table:
    8115,"22003",[Microsoft][ODBC Sql server driver]{Sql Server}
    Arithmatic overflow eror converting expression to data type numeric.

    Any help will be appreciated.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    WaldoWaldo Member Posts: 3,412
    Have there been some modifications on this functionality?
    Which version are you working on?
    Did you try the debugger?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    ssinglassingla Member Posts: 2,973
    No modification exist in this functionality. The entry number on which the error appears is a transfer shipment. While adjusting it runs in a loop where the same entry number appears more than couple of times.
    We are using Navision 3.7 with SQL server 2000.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    WaldoWaldo Member Posts: 3,412
    Strange ... I did a test in a default database without problems ...

    Did you try it in a native environment? Take a backup, restore in a fbk (native) and run it again?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    ssinglassingla Member Posts: 2,973
    Thanks Waldo.

    Will restore in Native DB and check.
    Database size is 6 gb I have no idea how much time it will take to restore. [-o<
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    WaldoWaldo Member Posts: 3,412
    Does the debugger give you more info on what's going wrong?
    When you restored in native, is the debugger pointing to the same issue?

    ... if all of this is standard NAV, I think you'll have to post a support request to Microsoft through partnersource.

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    ssinglassingla Member Posts: 2,973
    Thanks Waldo.

    I will see if I get any additional info in the debugger, once the database is restored.
    This is weekend, Does MS works on weekends.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    WaldoWaldo Member Posts: 3,412
    If you have a very good contract with Microsoft, they do.

    We have got a PABS contract (Partner Advantage Business Solutions), and that makes them available 24/7 :D

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    ssinglassingla Member Posts: 2,973
    Thanks for your help.
    I guess we also have that kind of contract.
    Anyway the problem is solved. It was due to exchange rate precision which was set to 0.01. Now it has been changed to 1.00.
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    WaldoWaldo Member Posts: 3,412
    Perfect =D> .

    How did you find this solution?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • Options
    ssinglassingla Member Posts: 2,973
    The techie sitting in the head office found it =D> . I will ask him and then explain it here.
    May be it help others
    CA Sandeep Singla
    http://ssdynamics.co.in
  • Options
    abhaydalal8722abhaydalal8722 Member Posts: 27
    please help i am facing the same problem in Navision 4.0.
    it will be very beneficial if somebody posts how the solution was found
  • Options
    SavatageSavatage Member Posts: 7,142
    ssingla wrote:
    Thanks for your help.
    I guess we also have that kind of contract.
    Anyway the problem is solved. It was due to exchange rate precision which was set to 0.01. Now it has been changed to 1.00.
  • Options
    abhaydalal8722abhaydalal8722 Member Posts: 27
    i saw the solution but i dont think, that is the problem at my end.

    The functionality of Adjust Item cost Entries is now using Cost Element Buffer table and its in this buffer that actual cost is going too long which cannot happen due to exchange rate precision. I am new to navision and finding it very hard to trace if its a data error or code error that is causing this problem ](*,) Please help
Sign In or Register to comment.