Create Metric Package Error

Cognos 8 Business Intelligence Metric Studio
1

Hi All,

i try to make package using db2 which is the database that i create is using
"cmm_create_db.sh dbinstance user_name password dbname drive dbalias "
after create datasource for metric store, when i try to use this database for metric package, it show me error :

CMM-APP-3268

Could not connect to the specified data source. Ensure that the connection and signon settings are correct and that the database server is running.
creating DBInstance for connection=com.cognos.pmal.datasource.DBConnectionInfo@caa0caa
getting user DBAccessor
CMM-APP-3255 The data source “mcd” references a database that could not be accessed.
executing Java call…
Executing call (com.cognos.cmm.worker.setup.newMetricsPackage.NewMetricsPackageReview) for page ‘new_mpwizard_review’.
ALP worker executing call pid=new_mpwizard_review call=[
CallName=‘com.cognos.cmm.worker.setup.newMetricsPackage.NewMetricsPackageReview’ CallParamName=‘getCall1’ IsJavaCall=‘true’ ProcParamCount=‘16’ FirstParamIndex=‘1’ ForceExecute=‘false’ Session=‘’
DataSetNames=[‘ReviewValues’]
ParamMeta=[ Param=[getCall1=[Param-List=‘top’ {
Param=[class=‘com.cognos.cmm.worker.setup.newMetricsPackage.NewMetricsPackageReview’ source=‘literal’ Properties=]
Param=[ticket source=‘request-attr’ Properties=]
Param=[cmm.SafeMode source=‘request-param’ Properties=]
Param=[cmmOriginalURL source=‘request-param’ Properties=]
Param=[mode source=‘request-param’ Properties=]
Param=[cancelURL source=‘request-param’ Properties=]
Param=[defaultName source=‘request-param’ Properties=]
Param=[defaultDescription source=‘request-param’ Properties=]
Param=[defaultScreenTip source=‘request-param’ Properties=]
Param=[datastoreName source=‘request-param’ Properties=]
Param=[defaultLocation source=‘request-param’ Properties=]
Param=[defaultLocationDisplay source=‘request-param’ Properties=]
Param=[dataSourceSignonPath source=‘request-param’ Properties=]
Param=[callerCarryValues1 source=‘request-param’ Properties=]
Param=[installCancelURL source=‘request-param’ Properties=]
Param=[installCancelPID source=‘request-param’ Properties=]
Param=[installNextPID source=‘request-param’ Properties=]
Param=[datasetNames=‘’ source=‘literal’ Properties={dataset1=‘ReviewValues’}]
}
]
source=‘inline-list’ [top] Properties=]
]]
Executing DefaultWorker for page ‘new_mpwizard_review’.
ONCLIENTERROR_ALERTPAGE not handled by application
Executing page ‘new_mpwizard_review’, from pageMap ‘setupPageMap’, via request:

QUERY_STRING=‘datasource=mcd&dataSourceSignonPath=&encoding=UTF-8&b_action=mms.run&cancelURL=%2fibmcognos%2fcgi-bin%2fcognos.cgi%3fb_action%3dxts.run%26m%3dportal%2fcc.xts%26m_folder%3diE29B38CA7C5947F7A5F63508D6F0D5D6&datastoreName=mcd&defaultDescription=&m=&pid=new_mpwizard_review&m_new_class=&cmm.SafeMode=&defaultScreenTip=&defaultLocationDisplay=Public+Folders&m_path=CAMID(%22%3a%22)&fromCMM=&defaultLocation=storeID(‘iE29B38CA7C5947F7A5F63508D6F0D5D6’)&cmmOriginalURL=&defaultName=mcdb’
Parameters = {
datasource=[‘mcd’]
dataSourceSignonPath=[‘’]
encoding=[‘UTF-8’]
b_action=[‘mms.run’]
cancelURL=[‘/ibmcognos/cgi-bin/cognos.cgi?b_action=xts.run&m=portal/cc.xts&m_folder=iE29B38CA7C5947F7A5F63508D6F0D5D6’]
datastoreName=[‘mcd’]
defaultDescription=[‘’]
m=[‘’]
pid=[‘new_mpwizard_review’]
m_new_class=[‘’]
cmm.SafeMode=[‘’]
defaultScreenTip=[‘’]
defaultLocationDisplay=[‘Public Folders’]
m_path=[‘CAMID(“:”)’]
fromCMM=[‘’]
defaultLocation=[‘storeID(‘iE29B38CA7C5947F7A5F63508D6F0D5D6’)’]
cmmOriginalURL=[‘’]
defaultName=[‘mcdb’]
}
Attributes = {
cmm.cmm=‘com.cognos.cmm.MetricsManager@77e477e4’
cmm.session='Session: ’
alp.instance=‘com.cognos.jpf.control.Alp@7a4e7a4e’
alp.request.done=‘new_mpwizard_review’
ticket=‘xxx’
contentLang=‘EN’
alp.app.attach=‘com.cognos.jpf.dispatcher.MessageContextWrapper@50ae50ae’
alpAction=‘2’
productLang=‘EN’
errorPageForm=‘com.cognos.jpf.error.ErrorPageForm@4ca44ca4’
}

Any idea for this error??
Really appreciate for your help

2

Did you create a datasource connection in Cognos administration tab in Cognos connection to the database?
the logs suggest to me that you did not do that? If so does the test of that datasource connection work?

3

Hi Martijn,

Thanks for your reply.
Yes i create datasource connection in cognos administration and succeed in test of datasource connection, but i also create in metric package step too and still show the same error.
I try to repeat step by step to create metric store :

  • create database using cmm_create_db.sh script using username db2inst1
  • grant appropriate (in cognos installation guide) privilege for db2inst1 on database that has been created
  • copy db2java.jar, db2jcc.jar, db2jcc_license_cu.jar to /webappps/p2pd/WEB-INF/lib
  • add environment variable :
    DB2DIR=/opt/IBM/db2/V9.7
    DB2INSTANCE=db2inst1
    LIBPATH=$LIBPATH:/opt/IBM/db2/V9.7/lib32
  • add ODBC datasource in odbc.ini and odbcinst.ini, copy odbc.ini to /bin, rename to .odbc.ini
  • made link file in /bin
    ln -s libcogudad2.so libcogudad2.a
  • exec .profile file, restart cognos service

and voilaaa… it worked…
i don’t know what step that i’m missing before.
but thanks a lot Martijn…

4

thanks for your reply. Have fun! :slight_smile:

5

Hello everyone!

I have the exact same problem. I created the db2 database using the command “cmm_create_db dbinstance user_name password dbname drive dbalias”. I created a datasource connection in Cognos Administration and the test of datasource connection succeeded. I grant the appropriate privileges and copied db2java.jar, db2jcc.jar, db2jcc_license_cu.jar to /webappps/p2pd/WEB-INF/lib but I still get this error message.

Any suggestions??
Thanks a lot in advance!! ;D

6

did you restart the cognos service…? :slight_smile: works for me when i am really stuck…