DSXchange

I like to give some more error info Copy_of_Ora_JobPackage,0: The runLocally() of the operator failed. Copy_of_Ora_JobPackage,0: The runLocally() of the operator failed. Copy_of_Ora_JobPackage,0: Input 0 consumed 500 records. Copy_of_Ora_JobPackage,0: Operator terminated abnormally: runLocally() did...

Hi , we are getting the below error for a job in QA, but not in DEV and PROD. The Job design is same in all the environment. Copy_of_Ora_JobPackage,0: Unable to insert a record into the table. main_program: APT_PMsectionLeader(2, node2), player 5 - Unexpected exit status 1. APT_PMsectionLeader(2, no...

My table have sequnce no and while loading I need to increment this sequnce no for every record. Here I have to do truncate load so in OE stage, when I select Load option then i am not able to give sequnce.nextval for sequnce increment. Please help me ........

I also faced same issue. My Field datatype is Varchar and I also tried IsNull() function but costraint doesn't satisfied and the null value went to next stage from transformer stage after that I have used Len() function to achive this. But I also don't know why it's happened

We are having 500 xml in one folder when I am trying to process that xml using the below job design orastge ' ' ESS-->xml-->tras--> join -- orastage I am getting the below error 1.cs}}}(0),0: Failure during execution of operator logic. 2.cs}}}(0),0: Fatal Error: Tsort merger aborting: Scratch space ...

In windows we have used 'ls' command which was taken not even 1 min to complete 1000 xml but now in AIX environment there is some limitation for ls command so we could not use this and we have tried different command but nothing work out for me. Finally find <path> -name "*.xml" command wo...

I have tried the "find" command and it's working but I feel it's taking some extra time compare to ls command. so I am looking some other command.

Hi

I have checked what ever you given link and some other link also.

but i don't know how to use these in ESS stage since for loop and all i don't think i can able to use in ESS stage

There is no data type LongNvarchar is available in sql server. :D I believe it might be text/xml/varchar(max)/Binary data type. while importing this field into DS it will convert into LongNvarchar. let it be as it is then load this metadata using odbc connector stage and change the array size =1 . i...

Please tell me since I am not able to find out the exact solution for that.

Ok thanks Chulett, I will do the search in google also if any one knows what exactly I need to do for that please post here.

We have developed all the jobs in Windows environment after that we have moved into AIX environment. In AIX, we are facing one isue in ESS stage. In windows the below path we have all 1000 xml files. C:\IBM\InformationServer\Server\Projects\MS1_POC\Ms1\JobPackage In the ESS stage I have used the com...

I think you are right srini. I try to load both file into another sequential file using file pattern which is loaded the data perfectly. so we can't view the data using file pattern in sequential file stage. I am facing one more problem now. i am having both file have field name (header record) but ...

Can you successfully read one or both (add two 'File=' properties) using the Specific File(s) option? yes both file i can able to view if I use the ReadMethod(s) as Specific File(s). But if I use ReadMethod(s) as File Pattern and given file name as D:\Datastage\DX444\ISFiles\Temp\*.txt also not work...

There are two files are available in the below location D:\Datastage\DX444\ISFiles\Temp File name : outputA.txt,outputB.txt File Structure is same for both files. The file content also I given in my first post. I want to load this both data into another sequential file using file patern option so th...