Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

DBD Deploying error

Hi Experts!
I am trying to deploy a design from DBD and I get this error:
RUN_DEPLOYMENT: Error updating deployment projections tableError updating deployment projections table
What should I check? can't find more info about this error.
any suggestions?
Thanks
Keren

Answers

  • Looks like all the projections are not up-to-date? Do you see any projection name in the log?
    You can run refresh like below.
    select REFRESH('') will refresh projections for a particular table.
    select REFRESH() will refresh all non up to date projections.

  • Hi Nimmi!
    Thanks that actually did the trick.
    Many thanks!
    Keren

  • I'm glad I was able to help. Thanks.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.