If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 11 Trigger Report through cmd

Started by zgeorge, 14 Feb 2019 09:26:14 AM

Previous topic - Next topic

zgeorge

Cognos masters,

I am attempting to schedule a report to run when our ETL jobs have finished running (to get the newest data). I have been able to successfully do this and receive the report when I run call the trigger through the cmd window. What I find happening is I'll call the trigger and it'll successfully fire. I'll then call it again shortly after and it'll fail. It doesn't seem to have a pattern of when it'll succeed and fail.

The error I receive when it fails is as follows:
"Note that if a schedule was not triggered, it may be because the current user does not have sufficient permissions to access the schedule. For more information see the Administration and Security Guide."

Has anyone encountered this before?

dougp

Something is different between the two times you fire the trigger.

zgeorge

Thank you but I'm calling the same command, same trigger both times nothing changes.

zgeorge

I've found this error in our log files if this help anyone.

CNC-DS-0001 The following Delivery Service general error occurred: DLS.CogConfigRestClient com.ibm.jsse2.util.h: PKIX path building failed: java.security.cert.CertPathBuilderException: PKIXCertPathBuilderImpl could not build a valid CertPath.; internal cause is:     java.security.cert.CertPathValidatorException: The certificate issued by CN=ABCD Root CA2 is not trusted; internal cause is:     java.security.cert.CertPathValidatorException: Certificate chaining error

Thanks for the help!