Black Magic
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Black Magic
Hello,
We have an issue that comes up from time to time and IBM has not been able to help after opening 4 different cases on each of the occasions that this problem occurs. Now, from time to time, we will all of sudden start getting the below error:
Event Id: 12701
..... Time : Mon Sep 29 02:27:08 2008
..... Type : FATAL
..... User : dsadm
..... Message :
..... APT_CombinedOperatorController,0: The runLocally() of the operator failed.
This occurs when using the ODBC stage and once it starts for a project, it will cause problems for all jobs using the ODBC stage for any datasource. That is, all jobs using the ODBC stage will get the error and fail. This will occur for a little bit and then it will just stop. What is also strange, is that once it starts, we cannot get it to stop by any action of our own. That is, we have tried slibclean and also bounce of datastage. The problem will persist until it decides to stop (as if it has a mind of its own). During timeframe, we of course have critical jobs which must run. Thus, we have to identify those jobs and immediately edit them to replace the ODBC stage with a DRS stage that uses ODBC. This works. Can anyone provide a resolution to this issue?
Thanks.
We have an issue that comes up from time to time and IBM has not been able to help after opening 4 different cases on each of the occasions that this problem occurs. Now, from time to time, we will all of sudden start getting the below error:
Event Id: 12701
..... Time : Mon Sep 29 02:27:08 2008
..... Type : FATAL
..... User : dsadm
..... Message :
..... APT_CombinedOperatorController,0: The runLocally() of the operator failed.
This occurs when using the ODBC stage and once it starts for a project, it will cause problems for all jobs using the ODBC stage for any datasource. That is, all jobs using the ODBC stage will get the error and fail. This will occur for a little bit and then it will just stop. What is also strange, is that once it starts, we cannot get it to stop by any action of our own. That is, we have tried slibclean and also bounce of datastage. The problem will persist until it decides to stop (as if it has a mind of its own). During timeframe, we of course have critical jobs which must run. Thus, we have to identify those jobs and immediately edit them to replace the ODBC stage with a DRS stage that uses ODBC. This works. Can anyone provide a resolution to this issue?
Thanks.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
We had the similar problem last year while using 5.0 with ODBC stage, and IBM suggested to use the 5.2 instead to resolve this problem. I double-checked our jobs implemented in production last year and found out all our jobs were actually using DRS stage. My co-workers who designed these jobs told me IBM at that time also suggested to use DRS stage instead of ODBC stage, and they took the advises since DRS stage indeed got more features than ODBC stage. So this issue might turn out an ODBC stage problem, and please post your findings on disable-operator-combination when you have a chance.
Pneuma Lin.
pneumalin@yahoo.com
pneumalin@yahoo.com
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
What is the license issue? This error is only sporadic and nothing about it so far conjures up any thoughts about a license issue? I hope you are right. I will mention it to IBM. However, this issue occurs only briefly, sometimes for a few hours and sometimes for a few days. The DRS stage still works during this timeframe will the ODBC stage does not. Thus, I am more inclined to think that some library or function is getting loaded that is causing it to get stuck in some code path that is causing all jobs to fail once it gets loaded. That is why I tried the slibclean and the restart of datastage. But, that to me, that still does not rule that out as a possibility. Anyways, I think that is what is going on. But, I do hope that I am wrong.keshav0307 wrote:the error is because of this .
it is because of the license issue.
i was having this issue, and the IBM support advice me about this.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia