DSXchange

Hi

We are unable to connect to a project X. All other projects are working fine.

Below is the error message:

Failed to connect to the Information Server Engine:DSENGINEDEVVM, project:X
(Internal Error (1314013527))

can anyone please help us here.

Thank You! It worked when i sort the files and do a diff.

Hi I'm converting a job which uses DRS stage to read from Oracle DB to Oracle Connector stage. It has a user defined complex SQL Query. Job structure: DRS---->Transformer--->SEQ File converted to Oracle COnnector--->Tranforme--->SEQ File. when i ran the jobs they read same number of records and even...

The next thing is to understand exactly how you are implementing the 8.5 xml stage...What method, in your 1k working example, are you using to pass the document or name of the document to the xml ... Hi Ernie, we have used External source stage to pass the xml document to the xml stage. Here is the...

I have tried this and it even shows the file size as UNLIMITED.

Please let me know what can i try next

Thanks..

Here is the file size: 2295161299

And am not sure of how to run the command in sub routine. can you please help me in where do i exactly need to use the command.

Thanks

Any time I see "2 GB" I get suspicious because a lot of operating systems, by default, impose 2 GB limitations on file size and those can cause errors or hangs. Check your OS (ulimit -a) or check with your DataStage and/or Unix administrator to make sure that the right ulimit file size se...

eostic wrote:First thing is the most critical --- does the job read the file perfectly with a test document that is 1k?

Ernie ...

Yes Ernie. The job reads the 1k file without any issues.

please advise what has to be done.

I increased the heap size to 4096 and tried, it didn't work.

Hi Craig,

I waited for 6 hours and it kept on running and there was no log created after 3 minutes the job has been launched.

HI DS Guru's,

I'm trying to read a 2gb xml file using xml stage in 8.5. I have given Heap size as 2000 and stack size as 500.

The problem is the job is hanging, it reads only 1 row and then the job hangs. can anyone help me out in solving the issue.

Thanks...

Ok..there are multiple approaches, 100's of entries in this forum, and some very good documentation....(places you should also start reading and looking into)...and also, various choices you can make ... Thanks for you quick response. I have used oxygen genrator for getting the schema files. Now I ...

Hi All, Can any one please explain me how to use the XML Stage. I have a requirement where in I need to read xml files, and do some transformations and load it into Database. I used schema library manager, but i'm not knowing how to exactly import the metadata. Also, i need to put a reject link at X...

Hi All, I'm reading a copybook in which it has OCCURS Class for a column. so I imported this table definition using the option Flatten all In complex flat File. when I view the data I get the following warnings: Complex_Flat_File_7,0: Field "FILLER_2.EE_EOQ_QUANTITY" has import error and n...

so shall i use a stage variable first and check if it is valid value or not and if it so, then shall i convert to the date format.

Please let me know if i'm correct.

Thanks,
Alekhya

Not all of your source data are in valid YYYYMMDD format. ... There is data in the source where i get '00000000' as the date for 2 fields. for one of the field, the business want to send it as Null value to the target table and for other field this invalid date should be rejected. Constraint: (IsVa...