DSXchange

I'm trying to compose a JSON file and I'm getting this error:
I've never seen this before and I can't find anything on IBM explaining it.

I'm trying to load a table with 2 CLOB columns. If I only have one CLOB column specified, everything works. If I specify the second CLOB column I get the error. Is DataStage not able to process multiple CLOBs in a single table?? The OCI function OCILobRead2 returned status -1. Error code: 24806, Err...

This is more of an DevOps/Admin question. Background We use parameter sets to store the DB credentials for stages. We'll make a Value File for our dev/test/prod. We use a password vault application called CyberArk. CyberArk has the ability on a schedule to automatically log into our databases and ch...

When looping on a sequence canvas, is it possible to interact with a variable outside of the loop? Inside of my loop, I have Path A and Path B. If the during the execution of the loop I end up going down Path B 3 times, I want to send myself an email because going down Path B a couple of times is ok...

I'm trying to figure out the Slowly Changing Dimension stage, specifically when dealing with a TYPE II. I can't figure out which column should be checked as the key column, especially when it comes to the three links that attach to the SCD. Here's my best attempt to layout what my job looks like ===...

Whenever I go to start the services, it will hang forever (45+ mins) and then I lose paitiants and I kill it, and search for the process and kill it. Then I issue the command a second time and it starts up within a couple of minutes. Can anyone offer guidance where to start looking as to why this is...

Then just as a FYI, the OCI is deprecated and you'll want to get on the new Oracle Connector and migrate your old jobs to use this. We're experiencing some pain ourselves having delayed this code update and we're now being forced into updating before we can continue upgrading the environment.

This isn't going to help much but we started down the path of 11.3 to 11.5 and there were several issues that made stop and back out of that. It's looking now it'll be 6 months or so down the road before we'll look at this again. Hopefully by then IBM will have enough patches and rollups released to...

Occasionally I'm seeing this error being thrown: Failed to connect to JobMonApp on port 13401 main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400. No output will be sent to port 13,400 for the rest of the job. We're only seeing this occur in one job/project. It just ...

Solved it. I have multiple environments installed on my machine (11.3 and 11.5) I had used the multi-client switcher tool that IBM provides but this tool doesn't update all of the windows shortcuts as they should be. Manually navigating to the correct executable for the environment that I'm switched...

I'm attempting to use the Connector Migration Tool. When it launches and prompts me to connect to a server, I'm getting a getDefaultSpaceID error? Googling the error just returns a bunch of java errors but none that I saw that'd help with this IBM tool.

I was told that jobs designed in 11.3 will continue to run in 11.5. I've discovered that jobs designed with any of the deprecated OCI stages will not run. They compile but in the logs they throw a warning and abort. Oracle OCI has been DEPRECATED This deprecated stage is replaced by the Oracle Conne...

I'm new to the Hierarchical Stage and I'm new to JSON so I'm looking for help how to configure this stage correctly. This is the desired JSON output that I'm trying to get DataStage to make: { "properties": { "Project_Name": "test", "Job_Name": "test"...

Did you ever figure this out? I'm in a similar situation but my error message is about the 11g, and I do have the connector toggled for 11g. I can do a view and that works, but when I go to run the job is when it breaks.

Can someone help tell me what I'm doing wrong? My data is comes in in the following format YYMM and I'm trying to get the long month name. Sample Data as Integer --------------------------- 1501 1502 1503 So to translate the data this how the dates would read: Real Dates ------------ 2015-01-01 2015...