Options

SQL Errorrrrrrr!!

suvidhab_ssuvidhab_s Member Posts: 16
edited 2011-12-30 in NAV Three Tier
Hi,

We are using NAV 2009 SP1 with SQL Server 2008 R2.

While Trying to post a Consumption Entry, We are facing the below shown error..



PLZ HELP :|

Answers

  • Options
    ara3nara3n Member Posts: 9,255
    i suggest to install sp1 for sql 2008 r2
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    suvidhab_ssuvidhab_s Member Posts: 16
    Thanks for the suggestion... But It did not help :? :roll:
    Anything else??
  • Options
    EgnazEgnaz Member Posts: 111
    Have you restarted the sql server?
    Are you using any stored procedures in this process on the sql server?

    Regards,
    egnaz
  • Options
    suvidhab_ssuvidhab_s Member Posts: 16
    Yes I restarted SQL Server and It dint help either.
    This process is not using any stored procedure.

    Error comes when i try to post a Consumption entry from Navison!! :|
  • Options
    EgnazEgnaz Member Posts: 111
    Hi suvidhab_s,

    after a little bit more of research I found and interesting link for you: http://connect.microsoft.com/SQLServer/ ... e-1-line-1
    Looks like a sql error with database names with non latin characters. Maybe this could help you to locate the problem.

    Keep me up to date please.

    Regards,
    egnaz
  • Options
    suvidhab_ssuvidhab_s Member Posts: 16
    Hii...

    Thank you for your suggestions.

    I Re-Indexed the tables in connection with the process and It worked \:D/
  • Options
    EgnazEgnaz Member Posts: 111
    You're welcome.
    Thank you for telling us your solution.
Sign In or Register to comment.