DValert BOB loading error - OLE DB error: OLE DB or ODBC error

DValert BOB loading error - OLE DB error: OLE DB or ODBC error

When you have an issue processing the PMS Bob like “Internal error: The operation terminated unsuccessfully. OLE DB error: OLE DB or ODBC error: Invalid column name ''''LengthOfStayAsOf2YrsAgo''''.

 That error is from OLAP when processing the PMS Metrics cube. To fix the issue the Full process in DVAlert to PMSMetrics cube should be checked
 How to check
      Open DVAlert Manager
      Go to Cube



Filter by PMS Bob


Select any PMS bob Import


Click on Dependent


And select Process Full for PMS Metrics


    • Related Articles

    • DVAlert Error - Number of records don't match between tmp and inc...

      So, DVAlert is failing, the message is something like this: "IdBatch: 658 The numbers of records between tmpfactPMSBOB and incfactPMSBOB not match for cube PMS BOB" The problem is most likely that one of more of the dimensions has duplicate All ...

    • DV Addin getting an error for SSPI Context

      Hi all, So, you are getting an error about the SSPI Context in your addin, and you want to know what to do next. First check that users are not in a different domain. Cross domain authentication may cause the SSPI context error. Second, check if the ...

    • Loading Forecast to GL Period for SBE

      Here is a quick video showing the steps necessary to load the forecast to the GL Period cube for SBE.  The 2020 Actual+Budget file is stored in a Budget Uploads folder on SBE. ...

    • BrandKarma/TrustYou interface stuck with error about System.UnauthorizedAccessException

      So, your BrandKarma/TrustYou interface is acting up.  It's generating a line like the below in it's error log: 20190221 14:05:32 | ExtractDataFromFile: .sftp System.UnauthorizedAccessException: Access to the path ...

    • Steps to Fix Rigid Relationships Error

      First search and open Visual Studio        ·         Go to “File” in the top left corner, then go to “Open”, and click on “Analysis Service Database” ·         Select the Datavision Database and click “OK” ·         It will take a couple of minutes ...