DSXchange

There are around 12 union all's and when I use 6 union all they work fine but anything more than that returns the error which leads me to think that the issue revolves around the union all's.

Hi All, We are using the Sybase Enterprise Stage to Extract Data, we have a problem when we use more than 4 or 5 union all in the extraction query. Has anyone faced similar problem, is there any limitation in the sybase enterprise stage editor. This is the error message that we see. ( The name suppl...

Hi,


Thanks for the reply,

When I use a ODBC connector Stage this close command works fine but the problem is with the Oracle Enterprise Stage.





Thanks

Hi All, I am trying to execute this stored procedure after the load in the close command in the Oracle Enterprise Stage and this is what I see, has someone faced something similar please reply. Fatal Error: Invalid close command : BEGIN MISSING_SCENARIOS(); END; Message: ORA-00955: name is already u...

##I IIS-DSEE-TFCN-00006 01:45:24(001) <main_program> conductor uname: -s=Linux; -r=2.6.9-67.ELsmp; -v=#1 SMP Wed Nov 7 13:56:44 EST 2007; -n=dbdevdst; -m=x86_64 ##I IIS-DSEE-TCOA-00067 01:45:24(002) <main_program> OS charset: ISO-8859-1. ##I IIS-DSEE-TCOA-00068 01:45:24(003) <main_program> Input cha...

Hi Everyone, I get this Fatal Error when I run this job which extracts from Sybase to Oracle DB. Has anyone seen this before. main_program: The TCP port being used for startup is 239478040; the associated socket number is 135924816. main_program: unanticipated failure; please save output and contact...

HI,

PX_DEBUG , If we set this variable..where exactly the files(logs) get created ?

First

run /dsenv and bin/uvsh

SET.FILE UV VOC UV.VOC
COPY FROM UV.VOC TO VOC UNLOCK


LIST.READU EVERY
UNLOCK USER < ID> ALL


Should work fine.

Hi Ray,


The Job runs fine but with warnings is what I meant and I am sure that it can pose problems during update. So wanna get rid of them.





Thanks in Advance
Suresh Nair

Hi All,

My job run fine but end up with this error. Any help is appreciated.



APT_CombinedOperatorController(10),0: A numeric string was expected, got "HOUSKP05"; using UString, the default value.



Regards
Suresh

The error is as follows: Fatal: Oracle OCI_1,0:Failure durng execution of operator logic. Fatal: APT_CombinedOperatorController,0:Fatal Error:Fatal:Plugin stage property(TRANSSIZE) is not defined for stages. Fatal: node_node1: Player1 terminated unexpectedly. I just tried to write a Oracle file to a...

Hi All, When I use a OCI stage I can view the data but when I write this to a sequential file the following error throws up (In Windows platform). APT_CombinedOperatorController,0 caught Unknown exception from run locally().....(.......). Fatal: Oracle OCI_1,0:Failure durng execution of operator log...

Hi All,

This can be resolved by installing the plugins with the help of package installer and install the oraoci plugin.


Thanks
Suresh

Hi All, I have installed 7.5.2 on windows 2003 server and px just runs fine except for Oracle OCI Stage which throws up some Plugin Error as I am not able to view any data DSBrowser..Oracle_OCI_0: Pin 1 not intialized. DSBrowser..Oracle_OCI_0.DSLink1:DSP.Close Error-100 in $DSP.Close. Any help is ap...

Hi Ray,

Please let me know how does your datastage material cost?