DSXchange

Hi Arndw, After ran the job, when we try to login into the project ..it says the error message.I have an valid permission to the project directory. Yes,i could see the files liike VOC,VOCLIB etc.. in project directory. Before that i tried with some other jobs for testing..the project is not affected...

Hi All, Here is my requirement: I have to identify the latest file for the particular source and to remove the timestamp from the file.Incoming Filename would like this FileName.Timestamp InputArg = 'new=`ls -1 #FilePath#/inbox/#Source#/#FileName#.[0-9][0-9][0-9][0-9][0-1][0-9][0-3][0-9].[0-2][0-9][...

ThankYou Ray.



Rgards,
Satheesh

Hi All, Today we rollout our parallel jobs in version v7.5.2 from v7.5A...one of the job has abort with the below DSLog: node_node1: Unrecognized module name "none" in environment variable APT_DEBUG_MODULE_NAMES main_program: ORCHESTRATE step execution terminating due to SIGINT we set the ...

Hi All, Today we moved the jobs from v7.5A to v7.5.2....One of the parallel job aborted and throw the below message.previously(7.5A) it didn't abort. DS Log: APT_LicenseOperator,0: Input 0 consumed 1 records. DMPSASubCategoryOra: APT_OracleRowid8PartTable: failed to get the block count. DMPSASubCate...

Hi All, I have a theory on this abort. I ran this as a test yesterday under v7.5.2. It leaves a file in directory /PX/Sort. I believe when we run the job in(7.5A) it is refusing the overlay that file because it was created in a later version. So stop DS version v7.5A then start DS version v7.5.2 so ...

Hi George,

Old DS version Files in the sense...what are the files i have to check..please advice.



Thanks,
Satheesh

Hi All, I have one more abort from PX job says that: Error Description from DS Log: main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_Archive::BadVersion: From: Loading memory archive. Contents of phantom output file =>DataStage Job 363 Phantom 9968 I could see the configu...

Hi All, Today we have a strange problem while running the parallel job....These jobs was almost runs from one year, today it aborts and throws the following error:in the middle of the job execution: Export complete. 1147082 records exported successfully, 0 rejected. ETLRecItemSubCatOra: connect fail...

Hi All,

In my project we have nearly 350 hashed files. How to identify or list all the hashed files are in 32BIT or 64BIT...is there any utility or command available in DS.. like usage analysis or something?




Thanks & Regards,
Satheesh

Thanks for your valuable guidance.



Thanks & Regards,
Satheesh

Hi, But the hashed job that designed by using the create option delete file before create can be converted into 64 BIT , but the above option doesn't used job are not converted into 64BIT....is this result that the jobs(using above option) took much longer time than normal....any other things can be...

Hi All, We have an SAT environment in that the hashed files are already created in 32 BIT dynamic files. Today we changed the 32-bit into 64-BIT hashed files by changing the values in uvconfig file parameter: 64BIT_FILES 1 . We have enough system space. we didn't do any other than this. But today wh...

Hi All,

How to verify/compare the development version of the code against production by exporting both jobs to a file. Is ther any utility or tool available.I am using v7.5A. or is there any method to compare the two .dsx file by manual.



Thanks & Regards,
Satheesh

Hi All,

I have a DB column name Product_long_name..it contains special characters or non printable characters.how can i eliminate the special characters other than ascii values 0--to--128...can you give me a resolution on this.


Thanks & Regards,
Satheesh.R