Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Data returned in BIOVue is not up to date in Microsoft Dynamics SL

Data returned in BIOVue is not up to date in Microsoft Dynamics SL

Symptoms

Consider the following scenario in Microsoft BIO Vue and Microsoft Dynamics SL:
  • You log on to BIO Vue, and you select a view.
  • You review the data that is returned in the view.
When you do this, you notice that the data that is returned in the view is not current. You expect the data to match the data in Microsoft Dynamics SL.

↑ Back to the top

Resolution

To resolve this problem, re-create and rerun the Microsoft BIO DTS package. To do this, follow these steps.

Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
  1. Truncate the BIOFact, BIOStepLog, and BIOLog tables in the Microsoft BIO database in Microsoft SQL Server Management Studio. To do this, open a new query window, and then run the following SQL statements against the Microsoft BIO database:
    Truncate table biofact
    Truncate table biosteplog
    Truncate table biolog
  2. Re-create the DTS package in the Microsoft BIO application. To do this, follow these steps:
    1. On the View menu in Microsoft BIO, click Administration, and then select Data Extract.
    2. Click the Recreate button.
  3. Run the DTS package from the Microsoft BIO application on the Data Extract tab.
  4. To manually process the Cubes, follow these steps:
    1. Click Builder on the Microsoft BIO menu.
    2. Select Cube Catalog.
    3. Select the first cube on the list.
    4. In the Cube Catalog window, click Next on the Cube Wizard tab until you are prompted to process the cube. Make sure that the following check boxes are selected before you continue:
      • Fully Process Cubes
      • Update Shared Dimensions
      • Process Related Cubes
    5. Click Process.
    6. Repeat steps A through E for each cube.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kbsolomon, kb

↑ Back to the top

Article Info
Article ID : 2567293
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 129