DSXchange

Hi, I have some 80 to 90 Datastage jobs. Each jobs creates a set of error files all with the same file structure across all 90 jobs. If you are very sure that your file structure is same across all Jobs then the warning issue is from every file... so check what datatypes you have in your table and ...

Just wonder which way you implemented the solution? Mike, Apologies for the delay.. In the sequencer, after the Job activity (for reject file creation)we have the Exec command activity. Which will execute the wc -l and the trigger expression will have Field(trim( Execute_Command_4.$CommandOutput) ,...

Thanks very much Mike,Bob ,chulett,ray for stopping by..its truly appreciated.
I am marking this as Resolved.

Here is an example of getting the row count without calling a UNIX command: ACCTREJcount = DSGetLinkInfo( JobHandle, "LKP_Acct", "LINKAcctRejects", DSJ.LINKROWCOUNT ) Mike, We are trying to test the scenario with your above suggestion.In the Job sequence, inside the Job activity...

..... I turn off the "Automatically handle job runs that fail" and control the graceful exit of the program myself. There you go... :) That is the Point..I got it...Thanks Mike....Now...It goes well for both the situation.(Data/No data) Just getting a warning below if there is any data......

I normally do this in the sequence job using an exec command utility. Command ! test -s Parameter #$DATA_DIR#/outbound/#USVAR_SETUPPARMS.REJECTFILE# I use the return value <> 0 to control the link to my Notification Activity. But if you were going to use a routine, I would use the utilities to get ...

Hi, For the same design, I have developed a routine, which will take the rejected file name and path as arguments. ... .. Thanks Bob Bob Thanks very much. I assumed that u have created a Transform Functions which will take more then one argument(Not before/after subroutine) ..(coz...you have FilePa...

modify the shel script, so that it will send the email only if the reject file has any records. May be you can do a count lines (wc -l) to count the number of lines in the file, and if the number of lines is more than 1 (assuming that the first line is column names) then send email else ignor it. l...

Hi All, We need to send a mail from the particular JOb if there is any reject records.we have designed like collecting allthe reject records into a sequential file then attaching that file to mail using a after Job subroutine. The situation is we need to send the mail only if there is any reject rec...

Hi All

I wanted to know if there is a reason or a situation, when one needs to snowflake instead of star.

Snowflaking looks like normalized operational design.

Please suggest.

Thanks
Dsedi

Is this the only table that contains a date/time/timestamp column? There are other tables which do have data/timestamp columns and they did fine. It is only with this one column. Does the problem happen every run, or only once? Yes, I tried running it atleast 3 times. Everytime it failed with same e...

Hi

While running column analysis on one of the tables, I am getting below error.

pxbridge,0: ?? (IIS-CONN-DAAPI-000045; Can not convert to framework type timestamp; CC_PXAccessor; setCalendar; CC_PXAccessor.cpp; 3883)

Column analysis on other tables in the same schema runs fine.

Thanks
Dsedi

Hi All I am able to run column analysis succesfully on one of the data stores. While when I try to run column analysis on the other data store, it fails with the error This input-file data set does not exist I am seeing the logs in Director and find the fatal error message. It seems it is not able t...

Hi all

I still face the same error, I am able to run column analysis on columns but somehow cant view the results on analyzed column.

Thanks

Hi When I try to view open column analysis on an analyzed column, it throws an error message as ------------------ System.InvalidOperationException: Error navigating to location: ProjectId: ec1481df.64b1b87d.611f2ea7.e7957de7-b66c-4c5f.806c.5761f8576cca, PillarId: IBM.Mozart.UI.Investigate, ItemType...