DSXchange

I dont think lookup stage is anything to do with this,correct me if i am wrong. actually i executed this job successfully many times ,from past few days i am facing this fork failed() issue. the same job design has worked fine before,now i am not to do further,its giving same error for all jobs. Tha...

Sorry for delayed response. I am trying to picturise here my dataflow structure.Hope you guyz understand this flow,bcoz i am unable to picturise it here clearly.In this flow i am capturing rejections from Middle transfomer and Oracle enteprise stage and then i am collecting all the rejections form b...

i did it too. but unable to find anything new.its not specifying the exact stage,where its going wrong.

1.Oracle Enterprise stage 2. Lookup Stage 3.RDBMS Stage I am using Oracle Enterpise stage as target database stage to catch the rejected records out of it.And it rejects the records firmly,no isuue in that.Otherthan this I am using lookup stage to lookup source data again. Its not specifying any par...

Hi all, I am encountering with this Fork failed issue.This error occurs only when the duplicate entries are in the source file.If file is clean without having duplicates entries, then everything goes fine.I have gone through the posts,but i didn,t get the reason. is there any exception handling i le...

sai, actually i need to supply the IN parameter into the procedure and then need to execute it.Your code matches pretty same with mine but you are calling script from a location, but in my case i need to execute it with the IN parameter supplied from DB as you see in my procedure syntax above. Thanks,

Hi all, I am trying to execute the stored procedure from the Jobcontrol code. Currently i am using following DSExecute Command. Cmd1 = 'sqlplus ':parmDBSchemaName:'/':parmDBPass:'@':parmDBName:' << EOF' Cmd2 = 'EXECUTE ':Procedure_name :'(':'TABLE_Name_Value':')':';' Cmd3 = 'Exit ;' Cmd4 = 'EOF' Cmd...

Check your queue manager, port, or channel of your test environment using either MQ Explorer or from the command line. Your development environment is working fine doesn't mean the MQ in your test environment is going to work the same as development. When i execute my jobs from the test environment...

Ray,

I am working with Version 7.5.1.A.
And you are right ,Both servers should be Co-resident.
and i am having my servers Co-residing.
Then what are all would be the possible solutions otherthan this.

Aquilis.

Hello all,

I was successful to configure/register the MQ PlugIn,but the problem i am facing is ,its not pulling the message from the MQ.So what would be the issue. But in development environment its still working fine.
advise please ,whether i left something undone still.

Thanks....

Hi all,
Sorry that I didn't go through this post previously.
Needs Plug-in to be registered.
For better understanding:
viewtopic.php?t=96264&highlight=MQ+Plug-in

sorry... Actually that was configured by our DBA previously,but currently i am unable to connect him.thats why? The error i am facing here is: 'The MQSeries in D_DSSTAGETYPES is not existing.' In previous project I can see the MQ Plug-in stage in the 'Stage types' Tree in Palette. But for the New pr...

Hi all, Thanks for kind response. I have gone through the Most of the documents but endup with the gul thing. If anybody has come across with configuration Or installation of the MQ plug-in,do reply me.all the inputs will be greatly appreciated. MQ Plugin is already installed and working fine with o...

Hi all, can anybody send me across 'plug-in installation & configuration guide'.Previously MQ plugin was configured for the development project.Now i need to configure it for Test Environment project(Just a new Project).So anybody has any idea regarding configration,please do share with me. Than...

all, i'm using two stagevariables as mentioned below. Stagvar1: If ((IsNotNull(Column1)) or (IsNotNull(Column2)) Then '0' Else '-100' Stagvar2: If (IsNull(Column3)) Then '-Z' Else (If (IsValid('Date', StringToDate(Column3,"%yyyy%mm%dd"))) Then '0' Else '-200') stagvar3: If stagvar1<>0 Then...