DSXchange

Can you give the sample input (Mainframe)/output(DataStage) values that you are getting after using the function.

Hi All, I am loading data into SAP BW using (Load Pack For SAP BW) stage. Source is a sequential file. Problem: My source sequential file has 197 records i process the records and all the 197 records get rejected, so 0 records are loaded into SAP BW. Now the next time i run the same job i get the er...

The problem got resolved when changed the NLS map to none at the job level.

Hi All, I am getting the following error: DataStage Job 222 Phantom 26691 Record 4242 contains characters which are not defined in the file's NLS map. Attempting to Cleanup after ABORT raised in stage GNSEventPromoteAndValidate.0.PromoteAndValidate DataStage Phantom Aborting with @ABORT.CODE = 3 Can...

Hi, We had exported one of our running job from one project p1 to project p2 on the same datastage server. Now while running the job in project p2 we are getting the following error: Transformer_LA_CUSTOMER_Reject_Records: Failed to load the library "V0S2_CTCTReject0005AirCustomer_Transformer_L...

Hi, We are doing calculation(Division) on decimal fields. We are getting the following error APT_CombinedOperatorController(1),0: Fatal Error: APT_Decimal::assignFromDFloat: src (NaNS) is not a usable floating point value The precision for both the fields is 18,4. Please suggest the solution for thi...

Hi, We have DS 7.0 as our development server and till date it was running fine. Now all of a sudden we are facing a serious problem. The problem is now we are not able to run jobs on the Server Engine. We are able to create, save and do other functions on the server except running the jobs. When we ...

Hi,
This error is mainly due to unavailability of memory while the process is running. Depending on your system configuration you should use the config file. If you use default configuration file i.e. with one node your job might run.



Regards,
Pravesh

Hi,
I want to know how can i use routines in a build stage.
I want to use UtilityMessageToLog routine in my build stage.

This problem has been resolved. this problem was due to incorrect permissions settings. Following correct settings were done to solve the problem: -rwsr-x--x 1 root dstage 1519616 Nov 13 2003 dsdlockd -rwsr-x--x 1 root dstage 1499136 Nov 13 2003 dslictool -rwsr-x--x 1 root dstage 3678208 Nov 13 2003...

Consider the Example below.

${DSHOME}/bin/dsjob -run -param "OUTPUT_DIR=${STAGE_DIR}" -warn "nolimits" -jobstatus ${DS_PROJ} TASMparamBegDttm

Here ${STAGE_DIR} -> is unix variable
TASMparamBegDttm -> Job Name
${DS_PROJ} -> Project Name again a variable

Thanks ray.world.

When i executed command DEADLOCK.MENU it gives error command not found.

I have tried all the commands by logging as root as well as dsadm.

How can we check whether user is having the required permissions to do these tasks of unlocking or killing processes.

Can anyone tell more about these privileges.

Hi Denzilsyb, Thanks for providing that info, but the DS.TOOLS utility is not listing neither any processes nor any locks if we use the options available. The options are not working. You have gone through the mine other post at DSXCHANGE in which i have said that clean up resources is not working. ...

Yes i had selected the Show All button but still it did not return any process_id.

User dsadm is having administrative privileges for DataStage and not Unix Server.

I am getting this error for all kind of jobs.