DSXchange

Any thoughts? Thanks a ton![/quote] The obvious question: What has changed? ("Nothing" is not the correct answer.)[/quote] --> Well, I know Nothing is the correct answer (thanks for the reminder :-) ) You might find this interesting - if you log into Datastage using the Windows "Omit&...

All, I have been running into issues with my job migration from QA to Prod and i have posted this earlier today - http://www.dsxchange.com/viewtopic.php?t=108958 I could finally isolate the problem. Seems like it has got nothing to do with the repository indices/import/export. For some weird reason,...

weird...i create a new job <jobname_new> (it is actually a sequence job) and copy the server jobs from the previous sequence...i get the same error.. so something is wrong with the job then? how can i get the same error again!! Error calling subroutine: DSR_NLS (Action=22); check DataStage is set up...

yup. But I cannot compile it..

Error - Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project dev1
(Internal Error (81021))

I tried what you suggested - exporting both job source and the executable. The same problem. The problem is occuring when the job is being imported itself - with the DSR_RECORD error. This is even before "No design time found" error. it is not like the import is done cleanly and the only i...

--> Thanks Ray But how do we explain the fact that the job is not getting compiled in QA environment anymore (infact not even in Dev) - same job. Whatever you suggested is in the target (production side) - I will try this now BTW... It can occur when the job executables are exported/imported and the...

hello, I am running into a weird problem. The jobs have been working fine in Dev and QA projects (on the same server). We are migrating to Production this weekend and tried to export and import a set of jobs into Production. I ran into an error while doing this - "Error calling subroutine: DSR_...

YES!

DSguru2B wrote:In comparisons the order of stage variables is very important as they get executed in the order they are defined. I believe the order thats going to work for you is
svFinalDept
svPreviousDept
svDept

Hi, I using stage variable to look up a previous row information to compare current row information.. This is what I have in the source: Order_NB Dept Date 4839722 245 1/2/2007 4860136 260 1/2/2007 4860136 270 1/4/2007 4863059 270 1/2/2007 4863068 270 1/2/2007 4963189 249 1/24/2007 4963189 245 1/24/...

Ok, if your issue is that you cannot move a file into production, break your insert script into two, and run your job twice. If breaking the insert statements into 2 does not help break them further and run them that many number of times.... I feel your 'Admin' should be more flexible with such thi...

Everything has to have a limit, looks like you have reached the limit on the number of characters allowed in that particular stage. You could have wrapped the sql scripts into a file and run it as an after/before script, but it is ruled out in your case, right? Is loading the scrips into a file and...

Krazykoolrohit wrote:600 lines of SQL.
wonder why they cant be implmented using a job

---

Hi, what do you mean by implemented using a job?

Hi, is there a number of lines restriction for Before/After SQL or User-defined SQL? I have a 600 lines SQL that I need to put it in either Before, After or user-defined SQL section. The reason why I need to put it in an ETL is because we cannot promote an SQL Script (political issues). When I put t...

Thanks. I've always thought it was the target table. Let me check the hash files and rerun it again...

DSguru2B wrote:The message indicates that you are attempting to populate NULL in the key field of a hashed file, which is not allowed and hence the warning.

Hi all, I am getting these warnings..Anyway to fix this? I've tried reset the job and rerun it. DataStage Job 765 Phantom 6982 Program "DSD.UVClose": Line 56, Attempted WRITE with NULL record ID DataStage Phantom Finished DataStage Job 765 Phantom 6983 Program "DSD.StageRun": Lin...