DSXchange

Hi ,
How to identify what are the patches installed in server.

This query is in oraoci8 stage.

Please find the query below. SELECT A1.PART_NUMBER, A1.DUNS_NUMBER, A1.RAR_ACTIVITY_CODE, A1.GROUP_NAME, A1.CUSTOMER_STATUS_ID, A1.CUSTOMER_STATUS_DESC, A1.SUPPLIER_UPDATE_ID, A1.SUPPLIER_UPDATE_DESC, A1.PENDING_FLAG, A1.PART_SYSTEM_ADD_FLAG, A1.QTC_OVERRIDE, A1.LCR_OVERRIDE, A1.QTC_HRS_OVERRIDE, A1...

same query, when i ran in toad, results coming without any warning/issue.

But in hashed file input and output data loading/reading happening normally without issue. only in intermediate oraci 8 stage, output view data is giving error that "CopyOfjDMSQERunRate_Test..TMP_SQE_RUN_RATE: Can not open the file that contains the SQL statement CopyOfjDMSQERunRate_Test..TMP_S...

Hi, I am trying to run one job,but job is aborting with fatal error " CopyOfjDMSQERunRate_Test..TMP_SQE_RUN_RATE: Can not open the file that contains the SQL statement ". After that i tried to view data in one ORAOCI8 stage, then i am getting the foolowing error " CopyOfjDMSQERunRate_...

Thank you for your valueble info, if i selected datastage operator option in admin console,when i log on using this user id, no jobs are visible, only folders are visible.If i selected datastage Developer option, am able to see jobs as well as folders in director. Please help me to resolve this issu...

chulett wrote:There must be more information available. Are there any other messages? What about in the jobs that the sequence runs, are they failing? ...

Hi ,

Thank you for information.
if that sequence starts and ciompleted successfully, in that sequence eaxch job running fine ,without any warning/ errors.

Look at an entry in log starting with "Summary of sequence run" and at the details in there. I am sure you can find some useful lines in there. Thanks for your info. Please find the log info which starts Summary of sequence run step "REPORTSEQUENCEOthersDailySERVERJOB..JobControl (@C...

Hi, Daily we will run some same sequences. Till last friday it ran fine without any warning/errors. But from 3 runs, one sequence is failing with the error that " JobControl (fatal error from @Coordinator): Sequence job will abort due to previous unrecoverable errors ". If we compile all j...

Hi ,
I had given 755 permissions to all folders which are in dsenv file,After that restarted datastage services.
Now i am able to logon using my personnel user id instead of using ds administrator dsadm user id.

Hi,

drwx------ 10 dsadm gdstage 512 Oct 14 2011 dsadm
is this causing problem to access dsengine and sub directories,using my personel user id to logon access to datastage clients?
Please let me know if you need any other details.
Thanks in advance for all your support.

Hi , Thank you for your information. in our dsenv file we have following directy paths " UDTHOME=/vol01/dsadm/Ascential/DataStage/ud41; export UDTHOME UDTBIN=/vol01/dsadm/Ascential/DataStage/ud41/bin; export UDTBIN LD_LIBRARY_PATH=$DSHOME/java/jre/lib/sparc/client:$DSHOME/java/jre/lib/sparc:`di...

Hi,
As you said you installed Information Server, in that case you need to delete xmeta db all objects and delete related folders/files including temp folder in aix box, then start fresh installation.
it may work and installation witll complete.

Hi, In the same server you have 7 version or previous version installation? If you installing 8 version on same server some other versions exist,while installing 8 version give other than 31538 and itag name diffirent as existing one.whatever you are giving port number,that port need to enabled for ...