DSXchange

Currently we are migrating from 7.5.2 to 9.1. In 7.5.2 we use the CRC32 function to detect changed data in a given record. When we run the same data in 9.1 and 7.5 we get different values from the CRC32 function so we are getting a good deal of false updates in our data warehouse. This wouldn't be a...

In our current environments Developers have access to compile in Test/Model/Production and serve as support for nightly cycles. After upgrading to EE the plan is that Developers only can compile in Dev and code will be promoted through change control with appropriate signoffs into Test/Model/Product...

In the properties for the Hashed File 'Create File' and 'Clear file before writing' are selected. From the Options button in Create file options the 'Delete file before create' option is selected. I started the job with a limit of 10 rows thinking I would let the Delete option get rid of the corrupt...

On two occasions hashed files have been 'corrupted' without any change to the program. Instead of having 3 files within the hashed file folder there is a file being created for each row of the hashed file. The names of each of these files is a series of numbers with a few value marks inserted, 0u161...

Set up a new project.

DS Admin is trying to figure out why the Notification Stage will not execute. Should this get resolved I will update.

Thanks

Update - re-indexing the project didn't help.

Will set up a new project and use a weekly backup of the project to import the jobs etc.

This is affecting only 1 project on the server. Emails from other projects run without any problem.

Started yesterday. Suspected the Notification Stage because previous logs for the same sequence that ran successful have entries like: BackupProjectsToLAN..JobControl (@EndLoop): Loop finished BackupProjectsToLAN..JobControl (DSSendMail): Sent message to BackupProjectsToLAN..JobControl (@Coordinator...

Same user id was used to start both sequences.

Compared dssendmail_template.txt from each project. They are identical. There isn't a dssendmail.txt in either project.

Thanks

Having a problem sending emails using the Notification Stage from a particular project. The Sequences run fine until they hit a Notification Stage, there they just hang. Created a sequence with only a Notification Stage and it also hangs. Was able to create a sequence and send email from a different...

Thank you. Will add triggers for Warnings and handle appropriately.

A parent sequence executes 3 child sequences with triggers of 'Okay' between them. Sequence 1 finished Okay and triggered Seq2. Seq2 finished with warnings - did not trigger Seq3, did not trigger the Exception Handler stage and the Parent sequence finished with a Status of 'Finished'. In the parent ...

Started with a command file used to start a DS job from the Zeke scheduler. If I use the following I think it will want -user and -password for access to the DataStage server. Since the users don't have access to the DS servers they would need a user/password combo that would allow them access to st...

Thanks for replies, here is the command...

call \\LMDSTAGE1T.AAMHC.LOCAL\E$\Ascential\DataStage\Engine\bin\DSJOB -server lmdstage1t -run -jobstatus -param "OODServer=DUNFIK" -param "OODUserId=etl_dunfik" PeopleSoft UNFI_Allocation_SEQUENCER_InterUnit