BMT-IMP-0002 error with FM

[Yizi]

Hi there, getting the following error when trying to update the package:

Code Select Expand

BMT-IMP-0002 Failed to execute metadata request. Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.
CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2014-10-13-10:34:01.721-#54


I've followed the following fix from IBM and the issue still remains, anyone got any ideas?

http://www-01.ibm.com/support/docview.wss?uid=swg21643723

Cognos: 10.2.1
FP: 3
OS: Windows Server 2008 R2
Application: Framework Manager

[Yizi]

Found a solution, at the package level, in the properties section change query mode from Dynamic to compatible.

[MFGF]

Changing from Dynamic to Compatible means you're not using JDBC at all, so it's just bypassing the issue not fixing it. You still have an issue with publishing packages using Dynamic Query Mode.

From the message you posted, it looks like you're probably using the wrong SQL Server JDBC driver (sqljdbc4.jar). What version is the one you uave currently? Where did you obtain it from?

Cheers!

MF.

[akgusev]

As for me, the same proplem was fixed by the next steps:
1. Download MS JDBC  Driver 4.1 from Microsoft official website (http://www.microsoft.com/en-us/download/details.aspx?id=11774). Choose exactly 4.1 version of driver (it maybe important if you use Java 7).
2. Unzip to any directory.
3. Delete sqljdbc.jar and sqljdbc4.jar from c10_64_InstallPath\webapps\p2pd\WEB-INF\lib and c10_64_InstallPath\v5dataserver\lib directories. If sqljdbc_auth.dll is exist in second one, you should delete it too.
4. Copy only sqljdbc4.jar from directory created in step 2 to the directories specified in step 3. Also copy sqljdbc_auth.dll in c10_64_InstallPath\v5dataserver\lib. Don't forget to check string 'databaseJNIPath' in c10_64_InstallPath\v5dataserver\databaseDriverLocations.properties (as for me it was 'databaseJNIPath=C:\\c10_64_InstallPath\v5dataserver\lib').
The import was OK after this simple operations.