DSXchange

hello mates, am getting the following error when i tried to do table analysis. i did my column analysis and revieved it but when i tried to do table analysis it is poppin the error message as follows. "Data sample creation not yet complete for table "tablename", Please try again later...

their are lot of posts regarding this topic search is what u need to do.



kris

thanks chulett



kris

As a datastage developer with peoplesoft you should be able to create new records in oracle (most of peoplesoft has oracle in the backend) you have to create new fields and know the delivered etl process which is given with peoplesoft package.


kris

i tried to do that but it is giving me following error


[/img]



failure: failure : error--1:15070-topic_id=105908&mark=r

Thanks chulett,DSguru2B,Sam for the quick response


kris

Thanks guys your reply,

i will change it accordingly, one more question is that if we have a user defined routine and if we use same routine in different jobs at same time does this effect the performance of the jobs? or it creates a instance and can be accessed by any number of jobs ?


kris

HI All, we have a job design in which all the jobs( we have like 75 main jobs) calls the same subjob(one subjob), it works fine now because we are running it mannually. but once it goes into production does it create problem ? because we will be running them in parallel and some jobs will access the...

i did get the same kind of error previously....
i don't have any clue why did i get but i was able to clear that phantom when i removed the parameters from the stage variable.

can you tell us what stages you are using in ur job? and are you calling any routines in the transformer?

kris

Laxmi try this,

don't make them as $projdef in ur parameters leave it as is in the admin... ex: servername: xyzabc leave it as xyzabc don't change to projdef and try to test it now...

yea splayer i was doing in both ways:
from windows to unix and from unix to windows

yes i was able to connect to unix box with my userid

i was getting same kind of problem while using ftp stage inside datastage...., so i called IT security people to check for my ftp rights from datastage, they said that i don't have rights and they created them and gave a different username and pass,other than i use for datastage login. i thought it ...

i think you are making something wrong in specifying the parameters in the admin...try this by doing one by one... i mean to say try to hardcode evrything in the ftp stage run it and c for errors, if you don't find any errors then go by parametrizing username first and leaving the rest hardcoded.......