DSXchange

Thanks a lot for the fast reply! Change this behaviour by creating a trigger that allows any positive value. I do not understand what kind of trigger in that context would then allow me to get rid of the warning if I use the UTILITYHASHLOOKUP routine. You can neglect the warning as it is not fatal I...

Hi all, I'm using the routine 'UTILITYHASHLOOKUP' to get a value from a hashed file. I'm using the 'Routine Activity' for calling the routine. Everything works fine except that the routine always finishes with a message 'did not finish OK' and that causes a warning in the log. I want to get rid of t...

The "=+=+=+=" problem is solved because I have deleted the routine with the special character in it but my original problem (the non compileable job) still exists. Can I do a similar check like "BASIC RT_BP{JobNo}" for other stages in the job to find the reason for not being able...

After deleted the routine which has caused the DSU_BP.O error message I have made full project export again and imported it into a newly created projet. If I try to compile the same error message still appears. For today I have enough tried, thanks a lot Arnd for your support, I have learned much an...

I have now exchanged all oracle stages manually but the error does still not disappear. Is it poissible to install two instances of datastage on the same server? I would like to re-install datastage on the dev server again but I would like to keep the current installation until I have setup everythi...

The plugin installation doesn't affect the jobs as far as I have experienced I thought they do update the jobs because when I install I have to choose which projects should be updated (but perhaps they only update project related things like DS_STAGETYPES). Question: After I have created a new proj...

What came to my mind now is a difference between the two DS instances we have (Dev and Test): On the Test system we have all plugins installed (the place where everything works). On the Dev System some plugins are not installed and after the import I had to install the plugins again (package install...

I think you will be best off doing a complete export of that project, delete the project, re-create a new one of the same name and then import your backup. It will be faster to do this than to try to analyze what is wrong with the current one and then repair it. I have created a new project and jus...

I have now removed all this lkp from the job. Now all transformers are compileable (over BASIC RT_BP{JobNo}) but the job itself has still the same error if I try to compile in Designer.

I can provide some additonal information because this kind of dummy_lkp is perfomed in many stages and I have now copied parts of Transformer file which is compilable: (From compilable file) * GET.Pin%%V0S160P2 <= GET.dummy_lkp ------------------------------------------------------------------------...

Here the first 16 line: * Tokens were replaced below as follows: * JobParam%%1 <= $cUpdate * JobParam%%2 <= $cInsert * JobParam%%3 <= $cDelete * JobParam%%4 <= $cDeleted * JobParam%%5 <= CHILD2PARENT_STRING * JobParam%%6 <= $cORA_SID * JobParam%%7 <= $cORA_DWH_UID * JobParam%%8 <= $cORA_DWH_PW * Job...

First thanks for the quick reply! @Ray I have build copies but the behaviour is the same. @Arnd It seems that we have found something ;-) The following error occurs two times: Compiling: Source = 'RT_BP1043/JOB.368399344.DT.1427061638.TRANS11', Object = 'RT_BP1043.0/JOB.368399344.DT.1427061638.TRANS...

Hi all, General information: - We currently have two DS instances (dev & test) - Job does not compile on DS Instance_01 and aborts with error message: Error calling subroutine: DSR_JOB (Action=5); check DataStage is set up correctly in project <project_name> (Subroutine failed to complete succes...

I have now re-created the job (some strange compile errors occured when I just renamed a linkname) and I have now processed the output from the oracle stage first into a sequential file and afterwards through the transformer for the insert (before the oracle stage was directly connected with the tra...

Thx Kduke, now the topic is resolved for me.