DSXchange

Hi ,


I have a routine activity which picks up a date from a dataset and passes the same to the next job as a parameter.Both my job and routine are added sequentially in the same sequence job.I am calling the routine through a routine activity stage in a sequence job.please find below the routine code(in Basic)

/******************************************************
Sources=' '
FNAME=ARG1
OpenSeq FNAME To SourceVar Then
End
ReadSeq SourceLine from SourceVar
Then
Sources=SourceLine
end
close SourceVar

Ans=Sources
**************************************************/
Note :FName is file path that we pass through sequence parameters

Routine is returning the exact value what i require and is passing it on to the next job.But the problem i face here is ,even though my routine returns a correct value the director shows me the following error messages

"JobControl (@rtGetPartition_Date): Routine DSU.rtGetPartitionDateKey did not finish OK, return code = '2009-02-18' "

" JobControl (@rtGetPartition_Date): Controller problem: Unhandled failure (2009-02-18) encountered calling routine DSU.rtGetPartitionDateKey."


In the sequence properties ,If i check the check box against "Automatically handle activities that fail" the sequence gets aborted due to this routine error
.
please let me know how i can rectify the error that i am getting because of this routine activity.


Please help


Regards
Althaf

How, precisely, is this an Information Analyzer problem?

Apologies Ray, I have reposted it in the right forum.

please help

Althaf6553 wrote:Hi ,


I have a routine activity which picks up a date from a dataset and passes the same to the next job as a parameter.Both my job and routine are added sequentially in the same sequence job.I am calling the routine through a routine activity stage in a sequence job.please find below the routine code(in Basic)

/******************************************************
Sources=' '
FNAME=ARG1
OpenSeq FNAME To SourceVar Then
End
ReadSeq SourceLine from SourceVar
Then
Sources=SourceLine
end
close SourceVar

Ans=Sources
**************************************************/
Note :FName is file path that we pass through sequence parameters

Routine is returning the exact value what i require and is passing it on to the next job.But the problem i face here is ,even though my routine returns a correct value the director shows me the following error messages

"JobControl (@rtGetPartition_Date): Routine DSU.rtGetPartitionDateKey did not finish OK, return code = '2009-02-18' "

" JobControl (@rtGetPartition_Date): Controller problem: Unhandled failure (2009-02-18) encountered calling routine DSU.rtGetPartitionDateKey."


In the sequence properties ,If i check the check box against "Automatically handle activities that fail" the sequence gets aborted due to this routine error
.
please let me know how i can rectify the error that i am getting because of this routine activity.


Please help


Regards
Althaf

Hi, did you get any answer for this.
I got the same problem when I used "Routine Activity". When I changed it to
"User Variables Activity" the warning disappered.
The work went well no matter what was used, only the warning was the difference.
Why, still mystery to me, do You know by now..?
BR esa.salminen@if.fi

You are still in the wrong place for this. Go here instead, the "reposted in the right forum" version.