The following SQL error was unexpected. Invalid column name 'license'.

The following SQL error was unexpected. Invalid column name 'license'.

This question is answered

Hi all,

I met an error below when I run report from Microsoft Dynamics NAV 2013 R2 Development Environment. Why the error occurred and how to solve it?

Your assistance is greatly appreciated!

Thanks & Regards,

Vanessa

Verified Answer
All Replies
  • Can you please specify which report did you run, in order to replicate the error?

    Thanks

  • Has this report been modified by your NAV partner? If so, this may be a question for your NAV partner.

  • Please check the table $ndo$dbproperty in your database. i think the problem is the missing column license. If so , create the field manuallly (Image,null)

  • Hi Daniele,

    First of all, thanks for your reply.

    I just run standard Report 206 - Sales Invoice, never modify this report.

    In addition, this database is migrate from NAV 2009 into NAV 2013 R2; hence, am I miss out anything or need to add anything in system?

  • Hi Alex,

    First of all, thanks for your reply.

    I run the standard report (Report 206 - Sales Invoice), no any modification on this report.

    BTW, this database is migrate from NAV 2009 into NAV 2013 R2; thus, am I miss out anything or need to add anything in system? Please advise.

    Thanks again!

    Regards,

    Vanessa

  • Hi Arndt,

    First of all, thanks for your reply.

    I have checked SQL Server Management Studio and got "license (image, null)" in $ndo$dbproperty. Anything else I should check or add in? 

    Best Regards,

    Vanessa

  • Please Check again in table $ndo$tenantproperty

  • Hi Arndt,

    Thanks you for your help. After I added "license" in $ndo$tenantproperty, all run as usual.

    Thousand thanks again.

    Best regards,

    Vanessa