DSXchange

Ok Thanks. Raised with support. Lets see what they have to say.

Bump! Anyone here! Please can I get any answer \ direction.

Hi, We have stood up a new Engine server and one of our very first jobs using PIVOT Enterprise stage is getting the following error - "Could not locate operator definition, wrapper, or Unix command for "pivot"; please check that all needed libraries are preloaded, and check the PATH f...

OK. Found the problem I was marking the wrong item as "Key". I changed my key to code which really is my repeating element that I want, it worked like magic.

Craig, sorry for overlooking that bit.

Any ideas about the actual problem, anyone!

Hi All, Trying to read a XML files and capture the output in a table. Got the basic part working as but getting the repeating elements working has become a challenge, hence shouting for help (have seen other threads along the same lines but not quite the same). Anyway, here is the format of the XML ...

That will be the same question I want to ask. But I know it was not changed as I can see the prod version of the job has the same design and it is running

Craig\Ray\Mike thanks for the all the info anyway.

Sorry for not being clear - lets take you to the code \ design fragment above - you will see I have Tfm_Latest_Batch_Validation <---- Latest_Batch In this the Latest_Batch is an ODBC connection and the Tfm_Latest_Batch_Validation is the transformer \ lookup. As you may notice that the only link lead...

Ok so I have found what was causing the problem of this infinite loop or whatever it was. The primary feed into the transformer \ lookup following the hashed file was coming from another transformer which had only one link leading into it and that was a reference link from an ODBC stage :roll:. I do...

Right. So I unraveled from where the type 30 was coming - didn't pay attention properly, my bad. One of the hashed file is taking two streams in - for the second link I hadn't changed the type to 2 from 30. Anyway, changing that hasn't solved anything either. For all hashed file stages I have \ the ...

Craig \ Ray, I have tried both the options you have suggested - deleting the files directories and changing those options as well. But none seems to have make any difference to the actual problem I'm getting. However, a bit more information for you and that might help me to understand this issue bet...

Oops. Sorry Craig. The design is to create a reconciliation starting point for the overall batch where I'm checking the last batch details batch id, status, count etc (coming from a SQL conection) that goes in to the hashed file (causing the problem). This is then being referenced in a transformer b...

Recently I started getting this odd problem with hashed files in one of my existing jobs (used to run fine without any issues) - where the hashed file is being populated from a SQL \ ODBC connection and then being looked up by a transformer. The SQL only fetches 1 row from the DB - however the hashe...

Hi Editor\Admin, We have a group premium account for user code " ami ". I recently started getting account inactive message while logging on and it's not letting me to logon \ follow forgot password etc. Have sent email twice to the webmaster and also to membership.director - no responses ...

Can you see all the keys correctly specified in the 8.7 version of the job? Can you swap with a copy stage for the sort and do the sort in the copy?