General script error

[#1]

Hi Community,

MAP_SINGLE_TAB

Mapping

Load Distinct Tracking_Num,

COUNT(DISTINCT Tracking_NUM_Key)  as NB_TRK_NUM_KEY

Resident Trace_Table1

GROUP BY Tracking_Case_NUM;

This is the error i have been facing with app.

General Script Error

Execution Failed

Execution finished.

But the app is working properly in local machine .

I have tested this app by Setting Errormode=0.. Even then i felt the same issue and getting the same prob.

Please suggest anyone on this

Thanks

Satti

[rbecher]

However, you should omit DISTINCT. It is not needed nor makes sense here..

- Ralf

[Anonymous]

There should be something else.  Single line or multi-line makes no difference (unless you break the words of course).  That is,

MAPPING LOAD DISTINCT

and

MAPPING

LOAD

DISTINCT

are exactly the same...

Regards,

Michael

[#4]

Hi Michael

You are right it will keep both are meaning less it will degrade the load performance of the script

Thanks & Regards,

Radha krishna