DSXchange

Hi, I have been asked by our develoment team if there is an alternate/better way to serach through a dataset. I origianlly pointed them to the Data Set Management utility and they cam back with "searching through millions of rows would take hours with the limited row display". Besides dump...

Looks like the app area that was running this job ran it multiple times hardcoding the DS path on a few occasions. I was able to find all the DataSets, deleted them and the job runs fine know.
Thanks - - John

Hi, I am the DataStage Admin here. We have just installed DS version 8.7 FP 2 on Windows 2008 R2. I am trying to work around an error that this one application is getting: E:/GP_rldm/rldm/WorkFiles/RLDM_DLY_UNIVL_CUST_DIM_INIT.ds: Error when checking operator: No partitions of E:/GP_rldm/rldm/WorkFi...

Just found it: "D:\IBM\InformationServer\Server\PXEngine\bin" Serach was not working on our serevr. I will give this a try and let you know how it goes/

Would you know where the orchadmin executable resides on a WIndows installation (Version 8.7)?

My goal is to maintain the name of the Dataset since it is used in many of the downstream jobs. I can easily recreate a new Dataset but not the one I am trying to delete first.

Thank You all for your sugeestions. After I started testing the adevelopers issue it appears not to be an issue with the Cinfig file at all. I was able to test by copying the existing job and renaming the output DataSet. The developer copied all the (.ds) files from the olde server to the new and I ...

Hi Atul, I changed the back slash to a forward slash in the config file but am still getting the same error for the job: E:/GP_rldm/rldm/WorkFiles/RLDM_DLY_UNIVL_CUST_DIM_INIT.ds: Error when checking operator: No partitions of E:/GP_rldm/rldm/WorkFiles/RLDM_DLY_UNIVL_CUST_DIM_INIT.ds are accessible ...

Hi, We are beginning our migration from Version 8.0.1 to 8.7 and I just tried running a couple of jobs. The first job is reading data from a DB2 Database and writing to a DataSet: ODBC enterprise===> Transformer====> DataSet In version 8.0.1 we had the DataSet writing to the directory: D:\rldm_psdw\...

Thank You! Looks like the app team had the Prod project created as DBProject and in the DR box as DBproject

Thanks again!!

Hi Ray, That command seems to work fine remotely: dsJob.exe -domain PAERSCBBLA0681:9080 -server PAERSCBBLA0681 -user PR-PPRISMS -password ######### -lprojects AAC AB ALM BrokerageServices CFF CLR_ODS_DLY CRM CTR CostFoundation DBproject ERF FORM5500 GPVAL Genio GoalMaker IDA MyFirstProject PPR PRS P...

Hi, We are attempting to run the DSJOB command from one server kicking off a job on another. For example I run this command from our QA server and we get to run a job as expected: D:\IBM\InformationServer\Server\DSEngine\bin>dsJob.exe -domain NJROS1BBLA0681:9080 -server NJROS1BBLA0681 -user PR-PPRIS...

Hi Ernie, Looks like we have a resolution to our problem. Cliff and Marc of IBM, who I understand reached out to you as well helped us implement the ISTool generate and ISTool import utilities to successfully import the BI Reports and their corresponding fields. We were then able via an extension ma...

Hi Ernie, That piece works fine...meaning the export is what is expected. I am trying to synch this identity information to the query results I am querying from the MWB query facility. Since it appears we have an issue with our Cognos setup that is not allowing successful importing of the COGNOS dat...

Hi Ernie, What I meant by manual map was I created a single link from a Implemented Data Resource Database column to a BI Report element (within MWB). I did this for the sole purpose of being able to export this link to view the identification piece for the BI Report field. I was hoping to come up w...