A new Flexera Community experience is coming on November 18th, click here for more information.
Upgrade Cognos to 2016 R1, on opening any reports/dashboard receive the following login failure message:
QE-DEF-0322 The connection string is invalid.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: FNMP-DW-DS
UDA-SQL-0031 Unable to access the "FNMP-DW-DS" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0534 Invalid connection string.
Refer to the 'Installing FlexNet Manager Suite 2016 R1' guide under topic - Install FlexNet Report Designer for more information.
Jan 17, 2018 01:57 PM
Running 2017 R3.. with ContentStore and FNMP Dashboard on same server. Still have error
Could you please check the connection details are correct for the mentioned datasource: FNMP-DW-DS on Cognos. To check this, on the Cognos UI if you are logged in as Analytics Administrator:
-Click on the Manage icon 'click mark icon' around the bottom left side of the navigation bar.
-Then navigate to Administration Console>Configuration>Data Source Connections.
-Notice the FNMP-DW-DS group listed
-Click on the above group and then click on the ‘More’ link under Actions on the right side of the page.
-Then navigate to Set Properties>Connection.
-Next to the ‘Connection String’ field, click on the pencil icon ‘Edit the connection string’.
-Check both the ‘Native’ and ‘JDBC’ tabs to make sure connection details there are correct. Also you could perform Test connection there to see which one is failing.
Thanks.