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
  2. Topics

KB268163: Error "Failure due to insufficient maximum key length" is received when connecting to Oracle Database Cloud when using JDBC on MicroStrategy Secure Enterprise 10.2


Community Admin

• Strategy


When attempting to connect to Oracle Cloud Database using JDBC on MicroStrategy Secure Enterprise 10.2, the following error may be received: "Failure due to insufficient maximum key length."

SYMPTOM
When attempting to connect to Oracle Cloud Database using JDBC on Strategy Secure Enterprise 10.2, the following error may be received:


Database error <32>: JdbcConnectionWrapper::Connect failed. Error type: Jdbc 
success with info. Jdbc operation attempted: Connect. [HY000:0: on SQLHANDLE] 
[Strategy][Oracle JDBC Driver]Failure due to insufficient maximum key 
length according to the installed JCE jurisdiction policy files. Please 
install "Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction 
Policy Files’

 
STEPS TO REPRODUCE

  •  Using Strategy Web or Strategy Developer, click “Add External data"
  • Click database and choose any of of the following: Build a Query, Type a Query, Pick table.
  • Select “Add a new source” and input the parameters similar to what is below:
    
    Database: Oracle Database Cloud
    Version: Oracle 11gR2 or Oracle 12c

    • On one tier input the following:
      
      port, SID, username, Password and source name.

  • Check the "Edit connection string" checkbox and input the following being sure to replace entries in bold with the necessary entries per the required environment. 
    
    JDBC;DRIVER={com.Strategy.jdbc.oracle.OracleDriver};
    URL={jdbc:Strategy:oracle://IPAdress:Port;SID=ORCL;
    EncryptionLevel=accepted; DataIntegrityLevel=accepted}; 
    MSTR_JDBC_JAR_FOLDER=Z:\Driver Directory; driverFile="myoracle.jar";


    It should look similar to the following when complete:
ka04W000000OcwWQAS_0EM440000002SYW.jpeg
  • Click OK and attempt to use the newly created data source and the following error will be received:
ka04W000000OcwWQAS_0EM440000002SYb.jpeg

 
CAUSE
The issue is caused by not having the correct libraries on the system in order to use JCE.
 
ACTION
Follow the steps below in order to address the error.

  1. Download the Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files for the required JAVA version, e.g. JDK 7
  2. Replace local_policy.jar and US_export_policy.jar in the JAVA path, e.g.
    • On Windows: C:\Program Files (x86)\Common Files\MicroStrategy\JRE\170_51\Win64\lib\security
    • On Mac: Strategy Desktop.app\Contents\jre1.7.0_51.jre\Contents\Home\lib\security

Comment

0 comments

Details

Knowledge Article

Published:

July 6, 2017

Last Updated:

July 6, 2017