Fw: forecast error

Fw: forecast error

Problem: Stored Procedures in both staging and production dbs were causing data columns for both act and fcst wx stations to be switched(cloudp% to wdir, wdir to wind speed, wind speed to cloud%). The source file looked correct.
Diagnosis: When debugging to a local db (with no history), the columns were not switched. Must be in the DB.
Solution:
  1. Delete SPs:
    1. go to the db in question in SSMS
    2. go to the Programmability folder
    3. go to Store Procedures
    4. locate the SPs that correspond to the affected tables and delete them
  2. Run the ingest task again and verify the columns and newly ingested data look right
  3. Clean the remaining affected data:
    1. determine when the error started
    2. open DataUtility,
    3. get the affected tables within the affected time span
    4. fix the data
    5. re-ingest the new table with DataUtility

    • Related Articles

    • No models to access

      The problem here was that users could log in but were then told that they had not been assigned any models to access.  The users table was appropriately populated.  The problem was that even though the web app could access the perfectly fine users ...