Community Forums
Results 1 to 2 of 2

Thread: Staging Error and Data warehouse Error

  1. #1
    Join Date
    Jan 2019
    Posts
    3

    Question Staging Error and Data warehouse Error

    Hi Flexera Users,

    Firstly thanks for the wonderful platform for discussing about the FNMS app as a whole


    Recently i have deployed FNMS, after deployment i facing this 2 errors.

    Can some one help me with this issue.

    Thanks,
    Vishnu Priyan
    Attached Images Attached Images  

  2. #2
    Join Date
    May 2010
    Location
    Melbourne, Australia
    Posts
    48
    Hi Vishnu,

    If you click on the "Download log" log shown next to the failure, the log file there may contain some more specific details to point you to the problem.

    The error likely indicates that the "inventory" database has not been set up properly, or possibly that the name of a different database (not the "inventory" database) has been configured in the FlexNet inventory database source connection details. Some things to check are:
    1. Verify that the inventory database name and other connection details are configured correctly for the FlexNet Manager Suite inventory source connection in the beacon UI.
    2. Verify that the inventory database has been created, and you can execute the following query against it (this is similar to the query that the process will be trying to execute, assuming you are using a current FlexNet Manager Suite release):
      Code:
      SELECT
      case
      --	when substring(dc.Value, 1, 3) = '7.8' and @FileUsageTableExists = 1 then '7.8.1'
      	when substring(dc.Value, 1, 3) = '7.8' then '7.8.0'
      --	when substring(dc.Value, 1, 3) = '7.6' and @FileUsageTableExists = 1 then '7.8.1'
      	else dc.Value
      end AS Version
      FROM dbo.databaseConfiguration AS dc
      WHERE dc.Property = 'SchemaVersion'

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •