The Flexera Community is currently in maintenance mode to prepare for the upcoming launch of the new community. Click here for more information.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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.:confused:

Can some one help me with this issue.:o

Thanks,
Vishnu Priyan
(1) Reply
ChrisG
By Community Manager Community Manager
Community Manager
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:
[LIST=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.
  • 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):

    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'

  • (Did my reply solve the question? Click "ACCEPT AS SOLUTION" to help others find answers faster. Liked something? Click "KUDO". Anything expressed here is my own view and not necessarily that of my employer, Flexera.)