FM DQM Error

[MFGF]

mrcool wrote in a private message:

Hi MFGF,

My package is in dynamic mode and when I update the query subjects I am getting following error:
BMT-IMP-0002 Failed to execute metadata request. java.lang.NullPointerException

I couldn't find more details in log. I am able to validate and test the query subjects. Any ideas?

Thanks,
mc

Hi,

Have you checked your user has relevant capabilities to import/update metadata? Take a look at the following technote:

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

Cheers!

MF.

[mrcool]

Thanks MF. Issue was with one of the jdbc drivers.

[Aish]

I am facing the same issue @MFGF and @mrcool
Please let me know how you resolved it

I am using Cognos Analytics 11.0.13 and unable to import stored procedure in FM from SQL server.
Getting the BMT Java null pointer exception error.
JDBC connection tests successfully and works fine
Drivers are in place according to JRE version in <install location>/drivers (sqljdbc42.jar and sqlauth.dll)
Capabilities checked and permissions exist for user to import metadata

When I test with CQM,I am able to import.
Please check how I can debug, as its not clear in logs too

Raised a case with IBM already