DSXchange

Guys, Hopefully, nobody ever gets this same issue because I found it impossible to resolve. Since I posted last, the scenario is completely different with respect to the environments. All of sudden (for the reasons unknown to anybody) the job is working in DEV, but is not working in SIT. So, instead...

Hi, Can you post the complete command and parameters fields from your Execute Command activity? It is a no Ray, no quote characters. This is the actual command copied from Director: ls -m /apps/etl/dev/datainput/archive/reference_data/80241_*.dsv Have you involved your SysAdmins, the ones responsibl...

Hi all, I was hoping somebody would have come accross this very strange behaviour of 'ls -m' command executed from the Execute Command stage and is able to help me. There is a list of files in DEV environment that I want to retrieve that are meant to be delimited by commas and later handled by a loo...

Spent few hours on comparing many jobs on version 8 the other day and since I referred to this post before it, I thought of adding something here for the sake of the others. Comparison of the jobs is very much possible within and across different projects (even on different servers). It takes a bit ...

Hi, This post is very old now, but as none of the others inquiring about the "VIEWDATA ROW LIMITER HIT" issue, I am attaching something that will possibly help others in future. It helped me today after a smart colleague pointed it out. It is possibly just as simple to commit the data in y...

Hi, Just with one of your replies I am close to getting this answered fully. But anyhow... What I meant was - considering just the inputs into the transformer and no stage variables used, are you always guaranteed to get the below given results in the target output field. For example again: Source T...

Hi All, If I manage to explain this right, this question will surely be answered quickly... In PX edition, are you always guaranteed to get the target field populated based on some values from another field. For example: Source Table (input to the transformer) --------------- col1 col2 a, 123 b, 456...

I know this post is quite old, but I just thought of adding something that might help somebody having the similar issue in future. I had this same problem with the Column Import yesterday. After going nuts trying to determine what causes it, I simply deleted the stage together with the following dat...

Hi, Even though this post is rather oldish, it has not been marked 'resolved' so I will add to what mr_crowley has said. Simply, for this to work, you MUST be an administrator on your PC, and if you happen not to have a password on it (like in the case of my home PC), you must create it. After havin...

No, thats not the problem. It definitely was not enabled. I tried reposting as well but it just posts the link. However, in the meantime I came across the CompileAll routines and thought of playing with that a little. If I am successfull no DELETE commands in STATUS tables will have to be used, and ...

Strange.... how do I post the image in this box?

Regards,

Novak

Thanks for that. Well, the screenshot of the partial outcome (there are 994 entries all up) of "SELECT @ID FMT '40L'..." is as: http://picasaweb.google.com.au/niko111222/MyPictures?authkey=pNdPNOGNbU8#5270156122393744082 The invocation ID I am using to get the entries from the STATUS table...

Thanks guys, After determing the job's job number though, would it just be safe to delete everything from a status table '..where number = nnnn'? Just to depict how crazy it can get, to open up a job category in Director it takes over 10 minutes at times. For a specific one, there was over 3,500 ent...

Thanks guys, After determing the job's job number though, would it just be safe to delete everything from a status table '..where number = nnnn'? Just to depict how crazy it can get, to open up a job category in Director it takes over 10 minutes at times. For a specific one, there was over 3,500 ent...

Hi, I was hoping somebody could advise with what would be the best solution for the following situation. In my project there are many mulitple-instance jobs used. For the reasons unknown to me this job has been used so that every time ExecJob routine runs this instance, the FileDateTime combination ...