DSXchange

Hi, The parallel job consists of a DRS connector stage and the o/p link fom this stage goes to a copy stage. The DRS stage executes a before SQL and a dummy main SQL (Select 'Dummy' as zzz). Noramally this job executes with in 30 minutes. But sometimes it executes long time (around 6 Hrs) even with ...

Hi, I am trying to read a json file with a repeating element . I could read the data using the Heirarchical Data stage (1) and passing the repeating element as it is into the next Heirarchical Data stage (2) by defining it as a key. In Heirarchical Data stage (2) I have used the schema specific for ...

I tried by passing currentdate() function in all the date fields in the target table. But the same issue appears

Hi , Our DS environment is upgrading to 11.3 version from 8.5 . One of the jobs is aborting in the new version which was executing fine in 8.5 The job extracts data from the source DB (vertica) and loads data to SQL server DB. A transformer stage is used in between the source and target DB stages. T...

Hi, I am developing a job for connecting to flurry API web service. I trying to import the table definition for this , using the option import>table definitions>web services WSDL definition . I have provided the url for the web service in the web service metadata importer window. Then the login wind...

I have developed a parallel job to load data from a file to the target table . The transformation includes lookup on a table with 29604 records. This job will be executed many times a day. During some execution , the job aborts stating the below error message in the reference DB stage: ODBC_align_di...

From what I see in your sample XML, it seems you're not just creating this XML in one step. If you are creating your repeating XML tags in a separate step and appending that XML chunk in some columns like <store>. If so, don't define XPath for those tags, just put a '/' and specify it as XML in dat...

The DS version that we use is DS 8.5

I have a requirement where an XML of the below format need to be generated. <demands> <demand> <brand>ABC</brand> <submittedby>KZK4164</submittedby> <senddate>2013-08-14 09:42:44.353000</senddate> <tasklistname>CONFIG_SEND</tasklistname> <srcfilename>CONFIG-13859</srcfilename> <uid>13859</uid> <stor...

Tried that also. But the same result

Hi, When tried to execute jobs using my DS log in ID (Both parallel jobs and sequencer jobs) a warning appears: Attempting to Cleanup after ABORT raised in job <Job Name> There is no other log entry for this execution and the jobs are not getting triggered. The job status shows 'finished' (this is t...

Hi, My job is fetching data from netezza database , doing transformations in transformer stage and writing to netezza daatbase. In the transformer I am using the transformation len(trim(column1)) where column1 is having datatype char2 . I can see all the input value for column1 is '5' , but the tran...

I provided the dsjob path corresponding to 8.5 environment in the command:

/apps/dtstgdev/IbmIIS85/Server/DSEngine/bin/dsjob

please tell me where I have to specify the dsenv file path in this command?

I tried by using the correct domain as well instead of 'none'

The domain name I entered is the 'host name of the services tier' that I enter while logging in to DS8.5 designer (first box in the loggin window)

But still getting the error

Now getting the error:

ERROR: Failed to open project

Status code = -1003