DSXchange

Hi, When we are trying to put a message on the quue we are getting the following error . WebSphere_MQ_2,0: Fatal Error: Fatal: Failed to open queue. Reason code 2035. The UNIX user used to run the Datastage jobs is also part of the MQ series group who has permissions to write messages on to the Loca...

Thank Ray.

I thought MQ series was all abt real-time and all so thought we have some Event based triggering in Datastage based upon the message being there or not in the queue something like an Event based trigger for a file in a particular folder

Any

Thanks in advance

Hi, After going through the Documentation i have understood that for DS to work with MQ we need to have on DS Server an MQ Series Server which can later connect to any other remote MQ Series server . What I wanted to know was : 1) How can we trigger a DataStage job as soon as a we have a particular ...

I found a way out while pulling this data from the source i have given the datatype at the source as VarBinary 100000 and extracting the data and Loading the data as Longvarchar Field . The job ran without any warnings and the data looks good. I tried using the CAST operator on the Long Data Type bu...

I tried using the CAST operator on the Long Data Type but it is giving inconsistent data type error . So should I be first converting the LONG to a CLOB object and then use the CAST command in Oracle to acheive the results ? Example: SELECT CAST(CLOB_column AS VARCHAR2(4000)) FROM Table; Declare the...

Does Ascential now support the LONG,CLOB,BLOB Character fields ??

If no then is there any work around available for this ...

Thanks
Ravi

1stpoint wrote:Ascential support has entered an enhancement request for the ORAOCI9 plugin to support long datatypes.

Try Putting this variable in User-Defined Environment Variables in Datastage Administrator to true APT_ORACLE_NO_OPS Default Value - True.. See if it works... HTH when i am using ORACI9 stage in server job then i am able to read the source system, but when i am using PX then i am getting error. Plea...

Hi, We are getting the Following error when we are running our job : buffer(5),3: APT_BufferOperator: Add block to queue failed. This means that your buffer filesystems all ran out of file space, or that some other system error occurred. Please ensure that you have sufficient scratchdisks in either ...

Hi, Hi we are also getting the same error ... We monitored the Df- k we are not hitting 100% ..Also This is the output of ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) 1048576 stack(kbytes) 392192 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 Ple...

I tried the Options stated below You can start by making the 'Execution Mode' for the lookup stage as 'Sequential' in your design. This will force PX not to run it in parallel and work similar to Server job. Also you need to declare the 'Lookup Type = Sparse' in case of Oracle. but it is giving me a...

Hi all, I want to get the next sequence for x records coming from the I/P source . I need to get X new Sequence values from oracle. But for a given record I have to Put in two tables,same set of records with the same sequence number. this is easily possible in Server by using oracle as refernce link...

Hi, Do you have any transformer stages in your job? If yes are you calling user defined functions in it? Yes I have it and I have 2 Columns which are string and need to convert into the numeric format so using the STRINGTODECIMAL function.... The two cols are declared as VARCHAR2(10) in the source ...

I am getting the following error APT_CombinedOperatorController,1: Operator terminated abnormally: received signal SIGSEGV When I am trying to load the Oracle table , the source is also an oracle table. I am performing 2 Lookups in b/w using the Oracle stage. The data also is very small only around ...

Hi,

While tring to save the Job I am getting an error
Unable to write Record <Job Name> to file RT_CONFIG622.

Any Suggestions, while trying to rClear the status also I get an error.