Database is in Use

MicroStrategy is a platform which provides Business Intelligence service, interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution.

Integrating Salesforce.com and other applications with MicroStrategy, will turbocharge your operational reporting with advanced analytics and excellent visualization in MicroStrategy.

In such an environment, MicroStrategy is able to mix data from Sales, product, operations with financial data and give insights which are not possible to derive from just one application. These reports can be displayed inside Salesforce.com using a Canvas application. This enables users to view MicroStrategy reports without navigating out of Salesforce.

Some of the problems encountered in MicroStrategy in such integrations are:

1. Database is in Use.

Solution: Set the CreateDB parameter to 2.

The following are valid values for the ‘Create Database/CreateDB’ setting:

  • If set to 0 (No), the driver will check to see if a database exists and if does not find one the connection will fail.   The driver will not attempt to create the locally embedded database.
  • If set to 1 (ForceNew), the driver will delete the existing database if it exists and will create a new database for each new connection.
  • If set to 2 (NotExist), and the driver detects an existing database it will not attempt to create the database.  If the driver does not find an existing database it will create the database.

2. QueryEngine encountered error: Connect failed.

2017-10-01 20:21:41.534-05:00 [HOST:xyz123-1.abc123.com][PID:xxxx][THR:2837067520][Query Engine][Error][0x80042300] QueryEngine encountered error: Connect failed.

Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [HY000:-40: on SQLHANDLE] [MicroStrategy][ODBC Salesforce driver][Salesforce]General error: java.util.ServiceConfigurationError: javax.xml.ws.spi.Provider: Provider com.ddtek.sforce.externals.org.apache.cxf.jaxws22.spi.ProviderImpl could not be instantiated: java.lang.NoClassDefFo Connection String: DSN=SF;UID=abc@xyz.com;..

Solution: This is due to JDK environment setup issue and requires a manual restart.

3. “column not found” issue

Solution: “REFRESH SCHEMA SFORCE;” before the query of the cube, so this should run every time the cube is executed.

If you need any additional details on Salesforce.com and integration, please feel free to contact ketan.benegal@thecloudfountain.com.

Previous
Next

Author: CloudFountain

We started as a side business in 1999 and have since grown to become a leading provider of IT solutions for businesses. With around 30 employees across several countries, we offer a wide range of services, including IT support, hosting, and custom software development.Over the years, we have served approximately 1000 customers, ranging from small startups to large enterprises. Our mission is to provide cutting-edge technology solutions that help our clients achieve their business goals. We pride ourselves on our exceptional customer service and attention to detail, and we work closely with each client to understand their unique needs and provide tailored solutions that meet their specific requirements.At CloudFountain, we believe that technology can be a powerful tool for growth and success. That’s why we stay on top of the latest trends and advancements in the industry, so we can provide our clients with the best possible solutions. Whether you need IT support, hosting services, or custom software development, our team of experts is here to help. Contact us today to learn more about how we can help your business succeed.