DSXchange

ray.wurlod wrote:The message "traversed 33 fewer bytes than present in the record buffer" means that your data do not match your metadata. The difference is 33 bytes.

but why this job can be simply re-run without any problem.

xli

Hi, All I have problem to understand how the parallel job environment varibles being set. In the same project, I find all sequence jobs have different environment varibles settings from the individual parallel jobs eg. the PATH variable setting in sequence job and parallel job are quite different. I...

ray.wurlod wrote:The message "traversed 33 fewer bytes than present in the record buffer" means that your data do not match your metadata. The difference is 33 bytes.

but why this job can be simply re-run without any problem.

xli

I have a multi-instance Parrallel job failed, along with the following error messages ; Item #: 15 Event ID: 3005 Timestamp: 2007-09-28 02:03:38 Type: Fatal User Name: isprd Message: TranData_Fnl,0: Input buffer underrun; traversed 33 fewer bytes than present in the record buffer. Item #: 16 Event I...

If you re-run the failure job, does it fail again with the same error ? I had ever got a job failed along with error message : Message: MS_APPY_MAP_DS,3: Failure during execution of operator logic. ....... Message: MS_APPY_MAP_DS,3: Fatal Error: Invalid Julian day. ....... but I found that the data ...

One of my complex datastage job finished with warning messages as below : buffer(3),0: APT_BufferOperator warning: newTime < startTime, 1180969549.709 1180969549.806 It seems there is something to do with system buffer usage, but I don't know what exactly cause produces this warning does anybody her...

We have got the EE job failed with the same issue : ExtPATY_ACCTFrmGDW..AcctIFound: MTDP: EM_DBC_CRASH_A(220): Network connection to the DBC was lost. BTW, we have 4 nodes in the configuration file. Any advice ? Thanks It is recommended to run PX on an even number of nodes. If you set the config to ...

Hi, All I try to use Teradata Enterprise Stage to insert data, I set correct user name and password in job properties, also add user defined variables in DS Administrator Environment variable. I can compile this job without any problem. but while run, it aborted along with error message below : Tera...

Hi, All I tried to delete a obsolete project test_dev, the project being deleted from project list in DS administrator with error message as below DSR.ADMIN: Failed to delete old project - files or directory remains (/app/dstage/Ascential/DataStage/Projects/test_dev) I checked UV_ACCOUNT table, it d...

xli, both values for nofiles that you have are "real". This value can be set per session and only the maximum is set at the system level. I am fairly certain that someone has changed your $DSHOME/dsenv file and inadvertantly set the ulimit nofiles restriction there. I checked file $DSHOME...

Hi, All Our machine just reboot by unix admin, hence I tried to stop / restart Datatage engine. It backed up along with waring message : Warning: could not open MFILES+8 files. The value of MFILES should be at most 8 less than the kernel's per user file limit. Change MFILES and reregen uvconfig or r...

To fixe this issue, I release all locks on job RT_SCTEMP/MSS50_FirstGroup_ProcessingJOB, then re-compile it.

Now it works fine.

xli

Hi, I have a parrellel job keep in running status for few hours. As I was not able to stop it from DS Director or dsjob -stop, I had to kill this job using Unix command. However, while I tried restart this job, I got error message as below : Error setting up internal communications (fifo RT_SCTEMP/M...

Thanks, Craig

I have supper user previlege to change the own, I just want to confirm if it is ok to simply change its owner by using "chown".

xli

Hi, Ray This problem happened in development box, while I failed to re-set the Auto-purge option in Adminstator by user dsadm. Then I checked and found the owner of file "DSParams" is not dsadm, instead, it is a individual user id. I wonder what people did to change the owner of this file ...