Month: March 2018

error: CFG-ERR-0103 Unable to start IBM Cognos service. Execution of the external process returns an error code value of -1

Posted on by tekweirdo in Cognos Analytics

Cognos service fails to start by error –

” CFG-ERR-0103 Unable to start IBM Cognos service. Execution of the external process returns an error code value of -1 ”

When this error happens it happens mainly due to issue related to content store.

a. test content store. If its working then it might have got corrupted.

b. dispatcher port may be in use.

 

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

 

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

Posted on by tekweirdo in Cognos Analytics

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.

 

send test email from server using powershell

Posted on by tekweirdo in windows

use below code to send test email from server to check whether you are able to connect to smtp server.

send-mailmessage -from (“[give email address here]”) -to (“[give email address here]”) -subject “[wubject text here]” -body “[body of message here] ” -smtpServer “[smtp server name]”

send-mailmessage -from (“tek-jedi@tek-jedi.com”) -to (“tek-jedi@tek-jedi.com”) -subject “Test smpt” -body “testing smtp server email ” -smtpServer “smtp.tek-jedi.com”

tableau how to add filter at dashboard

Posted on by tekweirdo in tableau

If a worksheet had a filter and you drag that sheet into dashboard, filter will show up on dashboard. But if you had added filter at sheet later after adding sheet to dashboard this new filter will not show up automatically.
Follow below steps to get the filter added.

Go to Dashboard
select the required sheet
click on drop down menu
go to “Filters”
select required fields which you want to add as filter. This will show up on dashboard.