DSXchange

What do you mean by "facts" of a job? If you mean the variables then it depends on a host of things that you set or do not set. The first few entries of the job run log should be a starting point.

Try this : In the Information server console go to Administration ->Domain Management ->Datastage Credentials. Select your server and click on Open configuration. You will get a "Share User Registry between IBM Information Server and Datastage Server" check that box. Do let us know if it w...

Thanks everyone for your suggestions, Here is a new twist to the tale. The sequence runs fine once in a while ( meaning majorly it fails but it had worked properly in a couple of occations). I have done a comparison of parameters between a successful run and an unsuccessful one(In the main sequence'...

Hi, I have migrated from version 7.1(Unix platform) to 7.5.3(Windows Platform) and I am facing a peculiar error. One of the jobs is running fine if run by itself but when run in a sequence it is throwing up the following error : DSD.BCIConnect connecting to <server name>, call to SQLConnect failed. ...

Hi, I am trying to create a new project with a Admin account (confirmed by running the following command SELECT NAME FROM UV_USERS WHERE DBAUTH = 'YES') However I get the following error : DSR.ADMIN: Error calling a SchemaDatastage/SQL: :<username>" is not a SQL user. Version 7.x2 OS : Windows ...

Hi,

If this might help..I tried load the data to a sequential file and it loaded perfectly and I can see al the data. Just when I am trying to load it to Oracle I cant see it. Although the load is fine.

Hi oacvb, Yes thats the problem. There is data in the sequential file. When I check the data in the Oracle OCI stage view data I can view some of the rows partially(only 4 characters are showing while the length is 16) not all. If I try to view the data in SQL promt then I see the data exactly as I ...

No actually there is no null handling thats happening. Its just a direct column mapping. The database has a NLS setting of American_America.WE8MSWIN1252. I have tried this a an environment variable setting for the Job and its not working. There are no warnings. The only problem is that the data cann...

Its quite a simple job with one sequential stage one tranformer and an Oracle OCI. there are 201 columns that are being mapped and there are no derivations for the columns.

Hi all, I am trying to load data into Oracle data base from a sequential file. However the particular column is showing no values when I am trying to view in TOAD. All the other columns are loaded Properly. But the particular problem is when i do a length(missing column name) it shows the correct va...

Hi Craig, This was the toal error message that I got: DSD.UVOpen rm: Unable to remove directory <Filename>: File exists Unable to DELETE file "<Filename>". "LocalRefs" is already in your VOC file as a file definition record. File name = File not created. There was no mention abou...

Hi Craig Thanks for your reply.There were no specific changes to the Datastage Environment that was carried out. I am not very sure of the process the database migration was conducted. However there are a few more observations: 1. the hash files are being deleted and recreated evertime the job is ru...

Hi DSGurus, I am facing this unusual problem. My source and target databases have been migrated from Oracle 9i to Oracle 10g. The datastage jobs used to write/read data from dynamic hash files.However when I run the jobs which are creating these hash files(the files are being deleted every time and ...