DSXchange

Hi,

I have posted this query under a new topic: capture* files in /tmp directory.

viewtopic.php?p=204442#204442

Thanks,

Hi, I got the following error message while logging into DS : Error calling subroutine: DSR_STATIC (Action=1); check DataStage is set up correctly in project METL_DEV_R1 (Subroutine failed to complete successfully (30107)) One of the posts here suggested to do a check for disk space usage. I checked...

Hi, I got this same error message. I checked the /tmp directory on DS server. It was full(100%). DataStage had created a file as follows: capture0000012544aa1164078516 . And the size was 971776000 bytes. (close to 971 MB). I moved the file to a different directory and the above mentioned login messa...

Job Design: UserVarActivity ---------> JobActivity Scenario: 1. Calling a Routine in the UV Activity, which returns a string. 2. In JobActivity passing the value obtained in the UV. When I am running the job, the following error message is appearing. Controller problem: Error calling DSSetParam(err_...

Hi all, Thanks for the replies. Apparently the problem has ceased to occur now. The only difference being a soft mount was used for the server instead of a hard mount. After the hard mount was done the I/O problems has stopped. But the root-cause as to why the error was occuring is still unknown. Ma...

Hi all, I am running a job whose design is as follows: Seq_File ---> Transformer ---> Stored_Procedure_Stage(ORACLE) ---> Transformer2 ---> Seq_File2 The job is aborting with the following message: Item #: 2528 Event ID: 2527 Timestamp: 2006-11-09 11:55:23 Type: Warning User Name: ncsmetl Message: S...

I have a job which is accessing an external application called 'HiPortfolio' through ODBC stage . There is an issue where the DS job hangs even when the 'HiPortfolio' server is down. i.e. it tries to connect to the application even when the server is not up. This situation needs to be handled in DS ...

Where are the object codes kept in the DataStage project folder? What is the naming standard and can we delete them manually?

What does this &PH& contain? I noticed files like DSD.RUN_66475_14179 , DSD.StageRun_70976_14179, SH_46330_14172 etc.

Thanks for the reply. In case these files need to be removed what is the best way to delete them. Manually do a delete or schedule it?

Thanks,

What is the significance of core.* files? They are present in the Project directory. E.g. core.9990 , what does the number 9990 indicate?

Hi Ray/Kumar,

When there is a Close() error, the job aborts, hence the file doesnt get written.

There is enough space on the server, so there shouldnt be any space-related issue.

Thanks,

I am using a ODBC stage to connect to an External application. In Project1, I am able to connect to the application and extract the data, but in Project2 there is an issue with the connection with the following message. main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC lib]...

Thanks for the reply Ray. This is happening every 3-4 times I am running the code. And yes I am able to write the file without any issues and then all of a sudden this problem crops up. So there is no issues with the access permission to the directory.

Thanks,

durgaps wrote:I am using a SEQ FILE Stage. I am getting the following error while I am writing the output to the sequential file.

ds_seqclose: error in 'close()' - Input/output error

Any idea why this is happening.

Can this be a space-related issue?