DSXchange

Ansul29 wrote:I have one concern related to SQL.

It may be your personal concern related to sql, but to achieve this, you need to write a SP.

Thanks craig. But i am 100% sure there is no changes in the file, because that same file is sitting in the project folder (in my PC) which i have used before. I was doing the end to end testing and I didn't used the large file to minimize the load time. Hence my testing is done, I tried to use the s...

Sorry guys I can't believe , all of the sudden, the same job failing again. This time i am getting the below error. SRC_TRANS,0: Error reading on import. SRC_TRANS,0: Consumed more than 100000 bytes looking for record delimiter; aborting Any changes? No changes to the Server, Job, OS... Then how thi...

I don't remember the option in the Oracle stage, but in SQL Server native stage there is an option to change it to Sequential, not the Node.

We had the similar situation when we use SQL Server and i know there is a bug in the tsort which IBM aware.

I am not sure is it the same case here, but the workaround is to change the target load to sequential resolve the issue.

Have you tried this? http://www-01.ibm.com/support/docview.wss?uid=swg21622965 Technote (troubleshooting) Problem(Abstract) Errors related to this issue: unable to connect to port 10000 on conductor; socket = 0, Unknown error APT_Communicator::connectTo: connect() failed due to Unix error = 10,061 (...

It is worth to check the settings again. Make sure host file has two entries and ping it. http://www-01.ibm.com/support/docview.wss?uid=swg21961605 Same information, in case if the link didn't work. 1. Set APT_CONFIG_FILE to your configuration file For example: set APT_CONFIG_FILE=C:\IBM\Information...

Use oracle tool to export the data into a text file and apply od command.

Try to get better hold of the data and then handle it.

Thanks Mike.

It could be the ODBC limit, as suggested, the job with copy stage pulled all the rows.


Thanks Ray

You are 100% right, when i increased the readers as suggested, solved the problem.

Thank you so much guys for your valuable input.

Another good lesson for me. :D

It seems like a critical error.

Hence you are in Windows OS, check for the NuTcracker Error in the event log (OS level).

If you are getting more errors then that could also cause the Datastage badly.

If you haven't restart the OS Server, its worth to bounce the Server and try it again!

Thanks Mike

I will check this too.

Haven't think that one Ray.

Thank you so much for your direction; let me try it and get back to you.

Issue in the Parameter set files could also create the compiling issue.

Try to compile the job without parameter set(s).

Hello All I would like to understand the reason why the Datastage Sequential file stage is not able read the file which more the xGB? Several link shows the limit is in the OS level and not with the Datastage, but my interest is slightly differ. I have 6GB text file / 18 million records. OS Windows ...

Now, I wanted to execute the same procedure in DataStage using ODBC Connector

Don't you have SP stage?