SYMPTOM:
After creating a dashboard in Strategy Analytics Desktop 10.4 Hotfix 5 or higher, the user encounters an error when trying to upload it into Strategy Web. Both Desktop and the Intelligence Server are the same version and hotfix. The dashboard was created using data from SQL Server 2016, which was certified as a data source beginning in 10.4 Hotfix 5.
"An error has occurred
We are sorry for the inconvenience. Please contact your administrator for help.
(The source manipulator found a missing dependency. Object: <DBMS id=xxx is not found. A total of 6 object(s) need it, one of which is xxx DB Instance id=xxx. Please turn on the log for more information. The source manipulator found a missing dependency. Object: %1 is not found. A total of %4 object(s) need it, one of which is %2 %3. Please turn on the log for more information.)"
STEPS TO REPRODUCE:
CAUSE:
Strategy 10.4 Hotfix 5 certified SQL Server 2016 as a data source. In Strategy Analytics Desktop, users can select SQL Server 2016 as the database version without any additional steps. After installing hotfix 5 or higher on the Intelligence Server, the SQL Server 2016 database object is not automatically added to the metadata. When the user tries to upload a dashboard that uses this database version, the necessary DBMS object for SQL Server 2016 is not found.
ACTION:
Upgrade the Strategy SQL Server Wire Protocol ODBC Driver on the Intelligence Server and install the SQL Server 2016 DBMS object. See the following KB articles for the necessary steps:
How to upgrade the Strategy SQL Server Wire Protocol ODBC Driver in Strategy Secure Enterprise 10.4.0 -10.4.4 and 10.5 - 10.9 running on Windows Operating Systems
How to upgrade the Strategy SQL Server Wire Protocol ODBC Driver in Strategy Secure Enterprise 10.4.0 -10.4.4 and 10.5 - 10.9 running on Linux operating systems
KB43537: How to install DBMS objects provided by Strategy Technical Support
KB440834
