Unable to run a Scheduled report in SAP BI Launchpad

[former_member223578]

Hi Experts,

We are getting an issue while scheduling report using BI launchpad.

It worked well until two days back, but we are facing the below issue now.

We have configured 3rd party tool STUNNEL for Email configuration, and it is working fine.

Any resolution to move forward will be greatly helpful.

Regards,

Krishna.M

[former_member223578 · Accepted solution]

Hi All,

We have resolved the issue by installing the 3rd party tool STUNNEL again in our Server.

Thank you all for your valuable suggestions.

Regards,

Krishna.M

[Former Member]

Krishna,

Check the error logs, what is entire error message?

I see that you are scheduling in PDF format to mail address, instead can you try scheduling to default location and check if the schedule is fine?

If it fails with other locations also then you need to loon into the job_servers.

Besides, try rebooting the server ones as you've implemented 3rd party tools with BO?

Reg,

NK

[former_member223578]

Hi Nikhil,

Thanks for the reply..

As per your suggestion we have tried scheduling to default location also we have rebooted our server in which we have configured 3rd party tool but still issue exists.

Can you please let me know how to move forward.

Regards,

Krishna.M

[Former Member]

Hi,

1. What is the complete error message? when scheduled to default location.

2. Have you checked the logs? Any error found in those.

3. Is the issue started happening after implementation of 3rd party or it was observed earlier as well?

4. Any changes made in the server command line while integrating the 3rd party plug-in?

Reg,

NK

[former_member223578]

Hi Nikhil,

Below is the error message..

trc file: "jobserver_hostname.AdaptiveJobServer_WebIJavaSchedulingService_CHILD0_ncs.trc", trc level: 1, release: "720"

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

[Thr 14716] Tue Sep 08 11:41:11 2015

[Thr 14716] ***LOG Q0I=> NiPGetHostByName: '$SMDAgentHost' not found: getaddrinfo [ninti.c 897]

[Thr 14716] *** ERROR => Main agent failed to be initilized due to incorrect host setting! [ncsmtdatasen 20]

[Thr 14716] *** ERROR => Main agent failed to be initilized due to incorrect host setting! [ncsmtdatasen 20]

[Thr 14716] NCS trace timer is disabled since the interval is set to 0

[Thr 14716] NCS data timer is disabled since the interval is set to 0

[Thr 14716] NCS library version 2.3.12 (unicode) loaded

[Thr 14716] NCS_ProcInit API invoked

[Thr 14716] NCS configuration info begin----------------

[Thr 14716] NCS configuration loaded from file C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/conf/PISERVER1/

[Thr 14716] Current NCS Configuration:

[Thr 14716] _socket_recv_timeout=1000;

[Thr 14716] _socket_send_timeout=500;

[Thr 14716] agent_host=$SMDAgentHost;

[Thr 14716] agent_port=$SMDAgentPort;

[Thr 14716] agent_type=2;

[Thr 14716] auto_transaction_trace_threshold=600;

[Thr 14716] cache_section_count=2;

[Thr 14716] context_map_bucket=13;

[Thr 14716] datasending_interval=0;

[Thr 14716] datasending_method=socket;

[Thr 14716] empty_timeout=300;

[Thr 14716] instrument_level_threshold=0;

[Thr 14716] lib_trace_level=1;

[Thr 14716] logdir=C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/;

[Thr 14716] max_components_per_promotedstack=50;

[Thr 14716] max_components_per_transaction=5000;

[Thr 14716] perf_metric_scope=0;

[Thr 14716] skip_times_below_threshold=500;

[Thr 14716] system_name=SBOP ENTERPRISE\hostname.company.net_6400;

[Thr 14716] trace_enabled_via_e2e=1;

[Thr 14716] trace_enabled_via_em=0;

[Thr 14716] trace_preview_timeout=120;

[Thr 14716] tracecheck_interval=0;

[Thr 14716] tracesize_threshold=1000000;

[Thr 14716] zombie_check_interval=300;

[Thr 14716] zombie_timeout=86400;

[Thr 14716] NCS configuration info end----------------

We are facing the issue since from the past 2 days itself, before that it worked well.

We didn't make any changes in the 3rd party tool and from our BO side.

Regards,

Krishna.M

[Former Member]

Hi Krishna.M,

Can you please check the following SCN article?

Adaptive Job Server is not getting enabled | SCN

"Hi Murtaza,

I am suspecting the SIA and the AJS could have lost its references.

We could check this by few tests

1. Now would have to run the below command line in Command prompt( running with Admin privileges)

Make the necessary changes such as the directory of the installation and its absolute paths, SIANAME , FQDN.

"C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\JobServer.exe" -javaargs "Dbusinessobjects.connectivity.directory=C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0//dataAccess/connectionServer,Dcom.businessobjects.mds.cs.ImplementationID=csEX,Djava.awt.headless=true,XX:MaxPermSize=192m" -loggingPath "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/logging/" -maxDesktops 0 -jsTypeDescription "Crystal Reports Job Server" -objectType CrystalEnterprise.Report -fg -restart -name SIANAME.AdaptiveJobServer -pidfile "C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/serverpids/SIANAME_SIANAME.AdaptiveJobServer.pid" -ns <FQDN>:6400\

If this executes then it is a clear indication that the process is functional but the SIA is not able to start the Service.

2. After this you can now create a new SIA pointing to a blank DB and check if the AJS works there.

If the AJS work in both the scenario then you can opt to recreate the original SIA which could be the possible solution here

-Guru"

Let me know if it helps.

Regards,
István

[former_member223578]

Hi Istvan,

Thank you for your response..

We have gone through the link you have provided but in our case Adaptive Job Server is enabled, though still we are facing issue.

Let me know how to move forward..

Regards,

Krishna.M

[former_member209323]

Hi Krishna,

-Try scheduling the report to default enterprise location and check if it still failing.

-Create a new Job servers and schedule the report.

Update with the results.

Regards,

~Shreejith

[former_member194271]

Hi Krishna ,

Please do these check in your environment.

1) Check all your job server status

2) Try scheduling same report through publication

3) Open the ports on the SMTP server and be able to TELNET the SMTP server from the machine which has Adaptive Job Server running.

Thanks,

Sasi

[former_member223578]

Hi Sasi,

Thank you for quick response.

1) Check all your job server status - All job servers are Running

2) Try scheduling same report through publication - Already we have tried through publication but no luck.

3) Open the ports on the SMTP server and be able to TELNET the SMTP server from the machine which has Adaptive Job Server running. - Able to TELNET

Please let me know where can i check the logs for the issue.

Regards,

Krishna.M