IBM Cognos analytics Product images don’t show in Event Studio

When trying to access Event studio , images/icons are missing. Errors show up when trying to accessing any icons.

Errors like below:

  • Object doesn’t support property or method ‘select Tab’ [getMessageFrame().selectTab(‘AgentTask-tasknumber’,’report’);]
  • ‘doAction’ is underfined[doAction(‘url’)]

 

Screenshot of Event Studio which is having missing images when accessed

event studio issue c11

Solution:

Mostly this issue is happening because of IIS configuration. To make sure this- open the dispatcher URL at server and check Event studio. Event studio should be working as  required. Now this tells us that there is some issue with IIS configuration.

Go through the event studio steps by following IIS configuration guide- Event studio section

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_gateway_iis.html

Though you might have run the bat file given by IBM, It might still not do all of it correctly. Its better to double check.

When I had this issue. Event Studio  at URL Rewrite was missing 1 condition and Logical processing was set to “Match All”. I added that missing condition and changed Logical processing to “Match Any”

 

Following article talks about similar issue at UNIX server

https://www-01.ibm.com/support/docview.wss?uid=swg22010297

 

Cognos how to hide pages/fields based on output format

 

create a render variable with ‘Expression Definition:’ as

ReportOutput () in ( ‘spreadsheetML’) –this would give output only for excel output report
ReportOutput () in ( ‘PDF’) — this would give specified output only for pdf output report.
ReportOutput () not in ( ‘PDF’) — This will hide specified output for pdf output report

Values that you could pass are:
items: [xlsxData, CSV, spreadsheetML, HTML, layoutDataXML, PDF, XML, XLWA, MHT, rawXML, XHTML, singleXLS, HTMLFragment]
case sensitive: true
Source:
https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_md.10.2.1.doc/c_crx_reportoutput.html

 

BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.

I was getting following Cognos framework error while opening the model.

BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.

I got this error for framework 11.0 after we had a patching on windows.

I reinstalled the software in same path with same version and it worked.
None of the framework models were effected.

 

source:

https://www.ibm.com/support/pages/node/260415

 

Cognos analytics temp folder files unable to delete

At cognos Server- UDA and TMP files are few files which get created when a report is been run. These files will be deleted automatically after the report run is finished.
We might be in a situation when this files go big and not getting deleted after the session. At that time you can delete them manually. But if you are not able to delete manually (assuming you are having admin rights) then you need to check at cognos connection if any reports are running at background. Make sure there are no reports running in background, if they are then notify user and kill them.
An other option is  to kill few services at task manager(not the cognos server related) and check whether the temp files are deleted or not.

 

topic:
cognos analytics uda files unable to delete
cognos analytics UDA Temp Files

resource:
http://www-01.ibm.com/support/docview.wss?uid=swg21358858
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.tg_bitshoot.doc/c_cognos8runsoutoftempspace.html

cognos – You don’t have access to this asset. It might have been disabled, deleted or your permissions might have been reduced. Verify the state of the asset at its expected source location. You can remove the asset from your recent items by tapping OK.

Cognos analytics user gets a below error message –

No Access
You don’t have access to this asset. It might have been disabled, deleted or your permissions might have been reduced. Verify the state of the asset at its expected source location. You can remove the asset from your recent items by tapping OK.

User will get this access error request when they are trying to access the report from recently run reports which they had lost access to.
Once access given they shouldn’t see this error.

Cognos access issue user

error: cognos Content Manager failed to start because it could not load driver “com.microsoft.sqlserver.jdbc.SQLServerDriver”.

issue- In Cognos analytics(11.0.5+) when you are trying to configure content store with SQL server data base for the first time you will get the error – “cognos Content Manager failed to start because it could not load driver “com.microsoft.sqlserver.jdbc.SQLServerDriver”.”

Solution is mentioned in below website:
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.inst_cr_winux.doc/t_MSdriver_SSLconfig.html

Microsoft JDBC driver are found in below  microsoft website:
https://www.microsoft.com/en-us/download/details.aspx?id=55539

Download the file – sqljdbc_6.2.2.1_enu.tar.gz from above microsoft link.
Extract the above file and find the file – “sqljdbc42.jar” and place it at cognos installation –  install_location/drivers folder.

Re-open Cognos configuration and test the Content store.

 

for data source connection to work
keep “sqljdbc_auth.dll” file at drivers, bin64 folder.

 

Cognos analytics- how to run a report using URL

Check below link for details.
http://www-01.ibm.com/support/docview.wss?uid=swg21983556

By using above mentioned steps your final url will look like

http://servername:9300/bi/v1/disp?b_action=cognosViewer&run.outputFormat=HTML&run.prompt=true&ui.object=storeID (%22insert_StoreID_here%22)&ui.action=run&cv.header=false&cv.toolbar=false
9300[servername/ibmcognos/cgi-bin/cognosisapi.dll?b_action=cognosViewer&run.outputFormat=HTML&run.prompt=true&ui.object=storeID(%22insert_StoreID_here%22)&ui.action=run&cv.header=false&cv.toolbar=false

Pass data item/query item into Hyperlink. How to get Google maps links at Cognos.

For this example I am using google maps.
Google maps URL –
https://www.google.com/maps/search/?api=1&query=58.698017,-152.522067

Create 2 query items with latitude and longitude. Say [Query Item Latitude], [Query Item Longitude]
create a new data item say – [Query Item_google maps url] with
https://www.google.com/maps/search/?api=1&query= ‘ ||cast([Query Item Latitude] as varchar(10))||’,’|| cast([Query Item Longitude] as varchar(10))

at report studio drag hyperlink to your list report.
Select Hyperlink and change properties as follows
Source type – Data Item value
Data Item Value – [Query Item_google maps url]
Googlemaps

Run the report. You should be able to get to google maps from the hyperlink.

Another google map URL you can play with –
https://maps.google.com/?hl=en&ll={LATITUDE},{LONGITUDE}&t=m&z=19&vpsrc=6&layer=c&cbll={LATITUDE},{LONGITUDE}&cbp=12,15.61,,0,0

Here is the URL API guide from google: https://developers.google.com/maps/documentation/urls/guide