Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Cannot run scheduler from command line in OBIEE 11g

Received Response
25
Views
1
Comments
Baligera D-Oracle
Baligera D-Oracle Rank 2 - Community Beginner
edited Aug 13, 2024 6:00PM in Oracle Analytics Cloud and Server

Hi Team,

I Need help on this issue ,SR#3-14111559051:

Customer is using OBIEE 11g with SSO Native authentication configured.They are with obiee 11.1.1.9.0 on  Oracle Solaris on SPARC (64-bit)

Customer have a urgent need to configure scheduler from the command prompt so that they can trigger it when their ETL jobs of loading data is done.

Customer was trying the following command but it doesn't work.

echo pwdfile | saschinvoke -u weblogic -j 20 -m 172.16.1.174:9705

Getting below error:

Give administrator password:

[server/NQSScheduler/SchClientMarshaller/Src/SCCUtils.cpp:369] [nQSError:

13057] Error From BI Security Service:

oracle.webservices.provider.ProviderException:

javax.xml.ws.WebServiceException: [OBI-SEC-00111] FailedAuthentication : BI

Security access denied - web service credentials are invalid..

[nQSError: 68021] Message from Oracle BI Scheduler.

Execution Error: [nQSError: 13057] Error From BI Security Service:

oracle.webservices.provider.ProviderException:

javax.xml.ws.WebServiceException: [OBI-SEC-00111] FailedAuthentication : BI

Security access denied - web service credentials are invalid..

[nQSError: 68021] Message from Oracle BI Scheduler.

I found that below action plan is working fine in windows but it will not work on Oracle Solaris on SPARC (64-bit)

----------------------------------------------------------------------------------------------------------------------------------------------

1. Include the password in a text file:
saschinvoke -u userid -j jobid < c:\password.txt

where userid represents the user name, jobid represents the id of the job in questions and password.txt represents the name of the file holding the password.

2. Use the echo command to mimic the prompt for the password:
echo <password>|saschinvoke -u userid -j jobid

where userid represents the user name, jobid represents the id of the job in questions and password represents the password.

Referred Docs :

  1. 1.How To Run SASCHINVOKE In OBIEE 11.1.1.5 Without Prompting User/Password In Windows (Doc ID 1352410.1)
  2. 2.OBIEE 11g: SASchinvoke Prompt for a Password when Run in a Batch Job (Doc ID 1501908.1)
  3. Error Executing Saschinvoke Command : 'Execution Error: [nQSError: 12002] Socket communication error at call=Connect: (Number=134) Transport endpoint is not connected' (Doc ID 1961901.1)

Thanks and Regards,

Baligera

Answers