IS Task Failing in CMC

[Former Member]

Hi all,

Hope I find you all in good health..and a very happy new year..

I am facing a problem in BO DS IS and I believe you people can guide me as I saw your posts.

I am a very new person to BO DS IS environment and a beginner.

Primarily I used to monitor DS IS jobs..For last few days while monitoring IS tasks in CMC I found that 2 of my main HR tasks is failing. I need to find the reason but I am not able to..like I cannot understand from where to start..I I want to know the error due to which it is failing.

Please help!

[krishnamohan_corp9 · Accepted solution]

Hi silpi,

You can get the error details in CMC also.

Open CMC-->Information steward-->data insight-->select the project on which you have created task-->you will be able to see the list of tasks passed/failed-->select task & right click on failed task -->click history-->click view data base log-->You will be able to see the detailed error description under error column [E].

If answer is helpful, mark it as helpful 🙂

Regards

krishna

[Former Member · Accepted solution]

Hi Mohan,

Yes Now i got it and now I am able to see..the logs.

But after viewing the logs I have some doubts.

as I told that 2 of my jobs are failing..and both are scheduled to run at 21 CET..among that one job ran on time..but failed with Utility failed with code 4. (COR-10020) this error in [E] column.

other job dint run on time and failed with

Error accessing repository objects: There is no subtask

Task process finished with errors. Status is set to failed. (TSK-10027)

[I] 2016-01-01 01:00:56.947 Utility processing ended.

[E] 2016-01-01 01:00:56.963 Utility failed with code 4. (COR-10020)

Is this something related to server or connection isssure???

As these jobs are failing for last three days.

[krishnamohan_corp9 · Accepted solution]

Hi silpi,

could you please share the screen shot of error.

i thnk Its a profiling issue.

regards

krishna

[Former Member · Accepted solution]

Hi Mohan,

please find the error below:-

[I] 2015-12-31 21:01:01.799 Information Steward version 14.2.4.630.

[I] 2015-12-31 21:01:01.815 Starting utility com.sap.icc.task.TaskUtility. (COR-10013)

[I] 2015-12-31 21:01:01.815 Process ID = 12057 on machine vgedq2vr.dc-ratingen.de.

[I] 2015-12-31 21:01:04.008 Connected to the Information Steward repository at jdbc:oracle:thin:@vgsap-bo-db.dc-ratingen.de:33008:BO_PROD. (COR-10017)

[I] 2015-12-31 21:01:05.625 Started execution on 2015-12-31 21:01:01. (COR-10014)

[I] 2015-12-31 21:01:05.683 Utility processing starts.

[I] 2015-12-31 21:01:05.690 Started Task process DQHR_Action_V1 [task ID=902]. (TSK-10025)

[I] 2015-12-31 21:01:05.709 Initializing Subtask queue with information from Task. (TSK-10040)

[I] 2015-12-31 21:01:40.459 The subtask process [subtask ID=2410] has been prepared to run. (TSK-10093)

[I] 2015-12-31 21:01:40.481 Started Subtask process [subtask id=869741], processing table [HR.Action]. (TSK-10037)

[I] 2015-12-31 21:01:41.891 Subtask process [subtask id=869741] was sent to the Job Server [vgedz2vr:3503, PID=29105]. (TSK-10088)

[I] 2016-01-01 00:35:45.176 Profiling engine section. (TSK-10015)

[I] 2016-01-01 00:35:45.314 Profiling engine section. (TSK-10015)

[E] 2016-01-01 00:35:48.609 No route to host

[E] 2016-01-01 00:35:48.614 java.io.IOException: No route to host

at com.acta.rw.ActaJobServerBaseInterface.getFileContents(ActaJobServerBaseInterface.java:803)

at com.sap.icc.dataservices.DSJobHelper.logFileContents(DSJobHelper.java:419)

at com.sap.icc.dataservices.api.RuntimeInfo.logErrorFile(RuntimeInfo.java:91)

at com.sap.icc.task.DataServiceEngineFacade.appendDataServicesErrorLog(DataServiceEngineFacade.java:200)

at com.sap.icc.task.DataServiceEngineFacade.monitorJob(DataServiceEngineFacade.java:291)

at com.sap.icc.task.DataServiceEngineFacade.finalizeSingleJob(DataServiceEngineFacade.java:316)

at com.sap.icc.task.DataServiceEngineFacade.finalizeJob(DataServiceEngineFacade.java:140)

at com.sap.icc.task.DataServiceDispatcherTaskStrategy$TaskMonitor.finishProcess(DataServiceDispatcherTaskStrategy.java:429)

at com.sap.icc.task.DataServiceDispatcherTaskStrategy$TaskMonitor.run(DataServiceDispatcherTaskStrategy.java:346)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

at java.lang.Thread.run(Thread.java:763)

[E] 2016-01-01 00:35:48.619 java.io.IOException: No route to host

[E] 2016-01-01 00:35:48.647 com.sap.icc.dataservices.api.DSAPIException: java.io.IOException: No route to host

at com.sap.icc.dataservices.DSJobHelper.logFileContents(DSJobHelper.java:432)

at com.sap.icc.dataservices.api.RuntimeInfo.logErrorFile(RuntimeInfo.java:91)

at com.sap.icc.task.DataServiceEngineFacade.appendDataServicesErrorLog(DataServiceEngineFacade.java:200)

at com.sap.icc.task.DataServiceEngineFacade.monitorJob(DataServiceEngineFacade.java:291)

at com.sap.icc.task.DataServiceEngineFacade.finalizeSingleJob(DataServiceEngineFacade.java:316)

at com.sap.icc.task.DataServiceEngineFacade.finalizeJob(DataServiceEngineFacade.java:140)

at com.sap.icc.task.DataServiceDispatcherTaskStrategy$TaskMonitor.finishProcess(DataServiceDispatcherTaskStrategy.java:429)

at com.sap.icc.task.DataServiceDispatcherTaskStrategy$TaskMonitor.run(DataServiceDispatcherTaskStrategy.java:346)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:439)

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

at java.util.concurrent.FutureTask.run(FutureTask.java:138)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

at java.lang.Thread.run(Thread.java:763)

Caused by: java.io.IOException: No route to host

at com.acta.rw.ActaJobServerBaseInterface.getFileContents(ActaJobServerBaseInterface.java:803)

at com.sap.icc.dataservices.DSJobHelper.logFileContents(DSJobHelper.java:419)

... 13 more

[I] 2016-01-01 00:35:48.660 The Subtask process [subtask id=869741] has completed with error: The Data Services engine could not complete the request because of an internal error. (TSK-10078). (TSK-10091)

[I] 2016-01-01 00:35:49.383 Processed [1] of [1] sub tasks. (TSK-10047)

[I] 2016-01-01 00:35:49.387 Summary of task [DQHR_Action_V1] with [1] subtask(s) executed. (TSK-10005)

[I] 2016-01-01 00:35:49.392 [1] Subtask(s) executed with errors. (TSK-10007)

[I] 2016-01-01 00:35:49.395 [0] Rules executed successfully. (TSK-10009)

[I] 2016-01-01 00:35:49.579 Subtask [run id=1] Table HR.Action: The Data Services engine could not complete the request because of an internal error. (TSK-10078) (TSK-10008)

[I] 2016-01-01 00:36:13.559 Task process finished with errors. Status is set to failed. (TSK-10027)

[I] 2016-01-01 00:36:13.620 Utility processing ended.

[E] 2016-01-01 00:36:13.653 Utility failed with code 4. (COR-10020)

[I] 2016-01-01 00:36:13.656 Completed execution on 2016-01-01 00:36:13. (COR-10015)

[I] 2016-01-01 00:36:13.660 Elapsed time is 3:35:11.881 [hrs:min:sec]. (COR-10081)

[krishnamohan_corp9 · Accepted solution]

I can see in the log "no route to host". I think it may be a network issue.

[mageshwaran_subramanian · Accepted solution]

Check if connection is working. Looking at the log , it seems to be a broken connection.

[krishnamohan_corp9]

Hi Silpi,

You can check the log files under the below location for error. (For my case DS & IS are installed on C drive, hence you can go through the below location and check for the .txt log files. arrange the .txt files as per date modified and check the error).

C:\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\logging

Regards

Krishna Mohan

[Former Member]

Hi Mohan,

Thanks for your prompt answer. Can't I get error file in CMC only?? I am not able to find it via path..