DSXchange

I can confirm that timestamp_from_string in a Modify stage in version 11.3 works exactly as expected with microseconds for me. Perhaps a version 8 bug?

Mike

Consider that rejecting a row and logging a warning message are not the same thing.

What warning limit did your job run with and how many warning messages were logged when the abort was triggered?

Mike

DS Job Reports have been around forever. I doubt that there is an "official" XSD.

Your best bet may be to use one of the open source tools to generate an XSD from some sample XML documents.

Mike

Verify that the inputs to your join stage are properly partitioned and sorted (usually by all of your join keys) and that you have the proper input link order. Either mistake could result in a silent failure.

Mike

As usual, Craig's memory is infallible. Do a quick find in the Designer client with your routine name and it'll jump right to it. Go to its properties and you can examine the source code on the Code tab. In my 11.3 version the routine is read-only by default, so you may have to remove the read-only ...

DateTimeStampToOraOCI is not a built-in routine that I ever recall seeing.

If it is a user written routine, then you will need to track down the author/source code at your site.

Mike

Check with your support provider to determine if there are any known issues with partitioned read in the JDBC Connector. Add $CC_MSG_LVL to your job parameters and set it to 1, 2, or 3 to enable some connector tracing to be recorded in the job log. I usually start with a setting of 2. You may have t...

In addition to answering the multiple questions about how you are partitioning the data (by primary key?), how many rows are in your target table? Updates are an expensive DML operation, so 6 million updates have a performance cost. If your table size is 10 million, then you might benefit (as an exa...

I haven't touched an Oracle database in years, so don't know if my comments would apply. When I see a high-volume update statement (what percentage of the FACT table are you updating and what is the total volume?), I would also be concerned about how many indexes exist on the table. You normally wou...

I use RCP within shared containers frequently. I have noticed an inconsistent bug in version 11.3 that results in an error like what you are seeing. When the bug occurs it has always been when the first stage inside the shared container was a transformer stage. But sometimes they work fine with the ...

The use of a BASIC transformer in a parallel job should be very rare. If I ever use one (or one of my developers were to use one), I require an annotation on the canvas surrounding the BASIC transformer denoting it as such.

Mike

This is a nasty one. I ran into it a couple of times on a single job. Seemed like a corruption of the job metadata somewhere in the repository. Like you, the only way I found to fix it was to manually rebuild the affected stages/links. I suspected that I triggered a bug when I copied a local contain...

Not with the job activity stage unfortunately. It limits you to choosing a value file name from a drop down list. It's not possible to specify a parameter. As a workaround, you can use the execute command activity to run the dsjob command where you should be able to use $Counter in setting the value...

All of our invocation ids are normally reused. Even the small percentage where I've noticed an invocation in Director with no log entries would have been reused (or will be reused again). We've had our project-level auto purge on since day 1. I don't have any reason to believe that any of our develo...

Just wanted to add a comment to the post by PaulVL... My current project is on 11.3 FP2 as well. Auto-purge of multi-instance jobs always clears our job log entries as expected. In the vast majority of cases, it also removes the instance so that it no longer appears in the Director client. The stran...