Locating the error in the data

clarcombe · Post by **clarcombe** » Mon Aug 22, 2005 9:59 am

I am getting the following error in one of my flows

Message: jb000SALPAIE_TransCollaborateur..TR_Coll_XpertHRM: DSD.StageRun Active stage finishing.
25 rows read from L_Collaborateurs
5 rows read from LR_PayInter
25 rows read from LR_Pays
25 rows read from LR_Contrat
0 rows read from LR_CaisseComp
25 rows written to L_XpertColl
0 rows written to L_RejectPays
0 rows written to L_RejetContrat
0.110 CPU seconds used, 1.500 seconds elapsed.

Item #: 13
Event ID: 5023
Timestamp: 2005-08-22 17:52:14
Type: Warning
User Name: FSP|larcombe
Message: DataStage Job 47 Phantom 2544
Program "JOB.169454777.DT.1373252191.TRANS1": Line 484, Nonnumeric data when numeric required. Zero used.

Bearing in mind that I have NO access to the DS server, how can I identify where the error is.
What does line 484 correspond to , the data or the program ?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Aug 22, 2005 10:09 am

First check will be with stage variables.

elavenil · Post by **elavenil** » Mon Aug 22, 2005 10:12 am

In the input, nonnumeric data was found for numeric column. Suspecting that there might be a space or invalid characters in the input. One way is to find out what you are doing in the 484 line. RT_BP47 folder can be found in the project folder and under that folder you can find 'JOB.169454777.DT.1373252191.TRANS1' and lookat 484th line then convert/transform the column into numeric using OConv/IConv functions.

HTWH.

Regards
Saravanan

ray.wurlod · Post by **ray.wurlod** » Mon Aug 22, 2005 5:38 pm

You may be able to retrieve RT_BP47/JOB.169454777.DT.1373252191.TRANS1 from the server machine using FTP.

Somewhere an attempt is made to perform arithmetic. This is the only situation where this message can arise. That should narrow your search more than somewhat.

Expressions in a Transformer stage may occur in:

stage variable initialization
reference lookup key expressions
stage variable derivations
output link constraints
output column derivations
Routines called from the Transformer stage
Transforms used in the Transformer stage (which will be inline code in the retrieved BASIC code)

clarcombe · Post by **clarcombe** » Tue Aug 23, 2005 12:47 am

I pleaded with the DS administrator and got read only access to the drive.

I checked the file as suggested and looked at line 484 and it was where I was adding 1000 to a company number however the company number can occassionally be ZZZ , hence the error.

Thanks for your assistance

ray.wurlod · Post by **ray.wurlod** » Tue Aug 23, 2005 1:36 am

A quick "if .. then .. else", then?