Open Forum

Expand all | Collapse all

"Invalid object name '[NAVDBName].dbo.[CompanyName]_$[TableName]$VSIFT$[Number]'. Statement(s) could not be prepared"

  • 1.  "Invalid object name '[NAVDBName].dbo.[CompanyName]_$[TableName]$VSIFT$[Number]'. Statement(s) could not be prepared"

    Posted Jan 11, 2019 06:42 AM
    "Invalid object name '[NAVDBName].dbo.[CompanyName]_$[TableName]$VSIFT$[Number]'. Statement(s) could not be prepared" error message when you run the SETAUTOCALCFIELDS function to calculate flowfields in Microsoft Dynamics NAV 2017

    In SQL server 2014, everything is ok.
    In Designer I can compile everything.

    ------------------------------
    Henrik Jensen
    IT Chief
    Ocean Prawns A/S
    ------------------------------
    NAVUG Summit - Post


  • 2.  RE: "Invalid object name '[NAVDBName].dbo.[CompanyName]_$[TableName]$VSIFT$[Number]'. Statement(s) could not be prepared"

    SILVER CONTRIBUTOR
    Posted Jan 16, 2019 10:04 AM
    Henrik,

          Have you examined the keys in the table design to make sure they are enabled? Try turning on the debugger to get to the exact line of code it is failing on. If you have no modifications in that area, check the cumulative updates to see if this bug has been reported and fixed.

    ------------------------------
    Joseph Flynn
    Sr. Dynamics NAV Developer
    Gold Star Foods INC
    Ontario CA
    ------------------------------

    NAVUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role