DSXchange

The Basis team told me that the sequential files are created with SAP code page 1100, which is actually ISO-8859-1 and not DEC-MCS after all. Now that I have finally received some files for testing, I have been able to load them using ISO-8859-1 map without any conversion errors. So, there never was...

I need to load a sequential file that is encoded with character set WE8DEC, but I don't see that listed in the available maps on the NLS tab of the sequential stage properties. I've found out that WE8DEC is the same as DEC-MCS. I did some research and found that ISO-8859-1 is very similar, but diffe...

I know this message is a year old, but it is still relevant and I didn't find any similar solutions posted here. I'm running DataStage Enterprise 8.5 FP2 with SAP R/3 pack 6.5.0.1 on HP-UX IA64. You can't join cluster tables in SAP using direct SQL "WHERE" clauses, so "Build SQL Query...

I also was experiencing the same problem with 8.5 FP2. I resolved the issue with the following IBM tech note: http://www-01.ibm.com/support/docview.w ... wg21450055

I only did options 3a & 3b because my client machine is XP and not Vista or Win 7.

I'm using SAP R/3 pack 6.5.0.1 with InformationServer 8.5 on HPUX IA64. I've had many problems with this pack and the fastest way to fix your problem is probably opening a PMR with IBM or whomever you support provider is. Based on my experience, here's some things to check: Make sure the destination...

I found this message while I was searching for a solution to the same error. I have since found a solution. The problem for me was file permissions .../Server/DSSAPConnections directory and the files in contained. The group permissions we set to read-only and, since our admins have their own login c...

Yes, when you run manually is what I meant. Craig, thanks for clarifying.

Look into creating a parameter set. You can group the 10 parameters into a single set. Then save frequently used value combinations with a descriptive "Value File Name". When you run the job, you will be prompted for the param set name and it will fill in the 10 params with the saved values.

Unfortunately $ErrSource gives me the name of the activity within the sequencem, rather then the name of the job. But I have created a routine that interrogates the sequence log and extracts the actual name of the failed job. It then goes to the log of this job and extracts the last DSJ.LOGFATAL en...

I found this topic while I was trying to do the same thing. I know this is old, but I found a solution and thought I'd share it to help the next guy. We have DS 8.5 Enterprise and R/3 pack 6.5.1. We use ABAP RFC, but I believe it will work for other SAP stages. -------- The SAP stage does allow you ...

Thanks for the feedback.

We have researched datasets and will be using them extensively in our ETL designs.

The file dump od -xc shows the delimiter in octal format. The value 272 translates to Hex BA or Decimal 186. Specifying this delimiter in a Server sequential stage is obvious; you just enter the decimal 186 or &hBA in the delimiter field. This is readily available in the Help. It is also possibl...

I some concerns over this job design. The job has 6 concurrent ABAP/RFC stages that will hit the SAP system and then does merges the data into a sequential file. A subsequent job will load it into our BI database The concerns I have are: 1) This may overload my network/SAP connections. Since this jo...

I had the same error and found this thread. I'm posting my findings to help the next guy. We got this error doing column analysis in Information Analyzer. It happend shortly after we changed the credentials in the "Analysis Settings->Analysis Engine". The new user did not have the same sam...

You will need to delete all references to DS_JOBS.cleanup (including the VOC entry if any) before proceeding with DS.CHECKER. Thanks! It worked and I was able to run DS.CHECKER. However, it did not find any errors. I also reindexed the project and cleared the &PH&. The Oracle admin is resta...