EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB440435: The error "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" encountered when configuring the MicroStrategy Intelligence Server if a SQL Server is used as a metadata repository

Community Admin

• Strategy

This Knowledge Base article describes a known issue in MicroStrategy 10.x that may arise when using the MicroStrategy ODBC Wire Protocol driver for Microsoft SQL Server when language settings of the driver are not adjusted to reflect the language of the Intelligence Server machine. A solution to change the behavior is provided below.

SYMPTOM
In Strategy 10.x, the following error message might be encountered when configuring the Strategy Intelligence Server via Strategy Configuration Wizard if a Microsoft SQL Server is used as a metadata repository.
 


The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

The error message displayed in the Strategy Configuration Wizard:

ka04W00000148I5QAI_0EM44000000A6Vx.png

The error message "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" might be displayed in various languages, e.g. French, Spanish, German, etc. The one below displays in French.

ka04W00000148I5QAI_0EM44000000A6XA.png

STEPS TO REPRODUCE
1. Create a DSN pointing to the metadata in Microsoft SQL Server database via Connectivity Wizard using the Strategy ODBC Driver for Microsoft SQL Server. 
2. In the Strategy Configuration Wizard select Configure Intelligence Server.
3. In the Metadata Connection dialog box select the DSN created in the step 1. 
4. Fill in all the required information in the next steps of the Intelligence Server Configuration.
5. After clicking Finish in the last step of the configuration, the error message  "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" is displayed.
CAUSE
This is a known issue caused by the discrepancy between various language settings in the environment which often depend on how a SQL Server has been configured.
ACTION
The issue might be resolved by changing the language settings of the DSN via Microsoft ODBC Data Source Administrator.
Note: For Linux, you can use the same steps used for Windows. Thee error message can be resolved by adding the language parameter (e.g., "

lang=english
") in the affected DSN in the 
odbc.ini
file. 
 
1. Create a new DSN via Strategy Connectivity Wizard.

ka04W00000148I5QAI_0EM44000000A6WR.png
ka04W00000148I5QAI_0EM44000000A6Wg.png

2. Edit the new DSN via Microsoft ODBC Data Source Administrator.
3. Select Configure, and the Advanced tab.

ka04W00000148I5QAI_0EM44000000A6WX.png

4. In the language field, type in the name of a language (e.g. GERMAN, SPANISH, FRENCH, etc.) which is the language set on the SQL Server side, as well as on the Intelligence Server machine.
In the example below it is Spanish.

ka04W00000148I5QAI_0EM44000000A6X5.png

5. Save the DSN and configure the Intelligence Server to the new DSN.

ka04W00000148I5QAI_0EM44000000A6X0.png

Article Reference Number: 
  KB440435

Comment

0 comments

Details

Knowledge Article

Published:

March 29, 2018

Last Updated:

November 9, 2020