Error raising with DRS stage......

Shri · Post by **Shri** » Sat Mar 12, 2005 2:48 am

Hi all,

'Error calling subroutine: DSD.Browse (Action=3); check Datastage is set up correctly in project TEST'

this is wht the error i get if i try to open DRS stage view list or if i run the job. DRS stage is my source here. previsiouly it was working fine, but suddenly now its throwing this error. can any one help me in solving this error....

thnx in advance..

Shri.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Sat Mar 12, 2005 3:39 am

Check whether there are any junk characters in the records you try to browse.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 12, 2005 10:42 pm

Check also whether there are any unsupported data types.
For example, an Oracle CLOB column is not handled. Changing the column derivation to CAST (columnname AS VARCHAR2(4000)) and the SQL data type to VarChar and precision to 4000 solved this particular case.