DSXchange

Would there be always be only two levels or it can be dynamic?

Can you pass on few more details like What is the source & target you are using and also the NLS character set defined in Database & DataStage job, datatype of the column having issue with?

Are you seeing '?' when you view the data in ODBC stage too along with target ?

chulett wrote:I have no clue and no SAP experience, but an exact search here for "process chain" found 16 other matches, perhaps one of them can help?

Thanks But that doesnt help that is the reason why i have started a new post

Hi , I am facing problem while loading the data to BI buy using PULL method and Using Process chain The error is as follows BW_Load_Stage_421_21,0: Fatal Error: Fatal: ERROR: RfcRecieve rc=2 (starting process chain): FAILED Once the job ran successfully and then after that that gets aborted by givin...

Hi , I am facing a problem in OPEN HUB EXTRACT stage for BW , This is the first time i am using this stage. I have added all the connections and the respective source system and Infospoke but in the columns tab the columns are not displayed. I donot understand why, Is it any connection issue or the ...

Divine, if nobody has answered your question they either don't know the answer or don't want to respond to it. Continually asking for updates or demanding answers won't work in this forum. I th ... I am having the same problem pushing the data i have enabled the timeout envorinment variable which i...

Hi All ,

I am getting following compilation error

Internal Error: (nullFieldEntry): transform/evalexp.C: 5898


i checked all my logic it looks fine but i couldnt compile the job

Thanks
Rajesh

THANK YOU IT WORKED

Hi, I have the data as follows First line as columns Scenario , FiscalYear ,CompanyCode ,001 ,002 ,003 Goal , 2009 ,003 ,8 ,7 ,9 I need the data as Scenario , FiscalYear ,CompanyCode ,Fiscalperiod,AggrBal Goal , 2009 ,003 , 001, 8 Goal ,2009 ,003 , 002, 7 Goal ,2009 ,003 ,003 , 9 I know that we can ...

I understand that the rejected data will go and sit in PSA. In my case before loading into SAPBW i have some validation errors, and while loading even there might be some SAP rejects as you said they will be dropped in PSA. If i want to append these SAP rejects to the error files that i have while v...

Hi, I have an issue regarding SAP reject handling while loading to BW. Data flow for my job is Essbase files to SAP BW, business requirement is i have to drop the error file in the staging area. How is reject handling done in SAP load stage. how will datastage know that there are some records which ...

Database type property is set as a "MSSQLSERVER"
I am facing this problem only for one table out of 80 tables in the same schema... Rest of the tables are working are fine with DRS stage.

Hi Ray, Thanks for the response... I checked it and increased Length of the numeric fields of also... Regarding the metadata mismatch I am able extract it using ODBC stage without any issue.. For odbc i have not changed anything .. wht ever the metadta i imported i am using that ... It is working fi...

Hi folks, I am getting an error , When i am trying to Extract sqlserver table using DRS stage...Especially for one tables rest of the tables are working fine. Error Message:- xyz..xyz: [DataDirect][ODBC SQL Server Driver]Numeric value out of range xyz..xyz: SQLFetch: Error retrieving results from se...

Also the generated pathname contains a double slash. Not all UNIXes can manage this. I have modified the double slash thing but then also i have the same error and as i have said above to mike i can run the job byu hardcoding the path and file name but if i am parameterizing i am not able to run it...