DSXchange

Hi One of the job in my project aborting with the following error : main_program: APT_PMsectionLeader(2, Node2), player 7 - Unexpected exit status 1. APT_PMsectionLeader(2, Node2), player 8 - Unexpected exit status 1. APT_PMsectionLeader(7, Node7), player 7 - Unexpected exit status 1. APT_PMsectionL...

Hi

How can I convert decimal values of say length 7,2 to length 5,2 ?

Thanks in advance

Hi I am facing following error APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal. source destination field are of length 5 with scale 2 and destination are files where field are of length 7 and scale and 1 f...

Hi

I am facing issues while converting varchar field to integer, can anyone please suggest me how can I achieve it ?

Thanx in advance

Hi

Creating multiple instance of sequence jobs means ?
I wanted to know what exactly need to be done to create 3 instances of an existing sequence jobs ? what things I need to take care while doing this.

thnks in advance

What's the row count and the approximate corresponding volume of data? What are your trying to do with these data in the job? ... we are not doing any kind of processing in the job its just pulling data from oracle tables and load it into .csv for downstream reporting applications. design of job is...

Hi

one of the job stuck while pulling data from database after certain no. of rows, have tried to run it thrice but the same result.Also not giving any error or warning its just stuck in running condition, any idea why its happening ? Is it database issue ?

ArndW wrote:Varchar datatype, but what width does that column have? ...

width of all column is 20

Can you run cat -vte <file name> on Unix Check if you are getting any ^ M or Junk Chars in the data . A wrong file transfer might have caused these after running above command there are $ signs coming in : G_QVVLBS,G_QVVIQT,G_QVVALT,G_AVV100,G_AVV450,ZZPA_M001_RKF002,ZZPA_M001_RKF003,ZZPA_M001_RKF0...

Can you run cat -vte <file name> on Unix Check if you are getting any ^ M or Junk Chars in the data . A wrong file transfer might have caused these after running above command there are $ signs coming in : G_QVVLBS,G_QVVIQT,G_QVVALT,G_AVV100,G_AVV450,ZZPA_M001_RKF002,ZZPA_M001_RKF003,ZZPA_M001_RKF0...

All field are of varchar datatype. I am also getting correct output nothing is rejected but this warning messages I need to take care of.

Delimiter definedis Comma , and no rows are getting rejected My file has total 97 fields and first row is field name and same field name are values for that column .. for eg : G_QVVLBS,G_QVVIQT,G_QVVALT,G_AVV100 G_QVVLBS,G_QVVIQT,G_QVVALT,G_AVV100 1st row is name and 2nd row is values for that field.

HI I am getting many warnings while running my job for seq. file stage Measure_code,0: Delimiter for field "ZZPA_M001_RKF008" not found; input: {G _ A V}, at offset: 153 [impexp/group_comp.C:5775] I have checked in my file delimiter is present for field value. Any suggestion how to remove ...

Hi While loading data to SAP BW using SAP BW Load stage I am getting following error : APT_CombinedOperatorController,0: Fatal Error: Fatal: ERROR: Validation Failed - Please synchronize your Transfer Structure before running the job Any clue how can I remove this error, wht is the reason for this e...

Hi In our project there are two connection for SAP BW system are defined , one with load balancing say C1 and other without load balancing say c2 While using those connection detail in BW load stage in a job passing the connection it it passed as C1(C2) like some values is passed to some function. C...