Using ODBC Enterprise stage getting this error

[jammala.ds]

Hi All,

Using ODBC enterprise stage is Target . I am getting below fatal error.
Please tell me the details...

APT_CombinedOperatorController,0: [DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 1.
[DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 2.

Regards
krisss

[ray.wurlod]

We just don't do APT_CombinedOperatorController errors. They could come from any of the combined operators. Disable operator combination and try again. That's the only way you'll know for sure which stage is generating the error.

Certainly the fact that the error message implicates the ODBC driver increases the likelihood that that's where the error is, but it's a good idea to get into the habit of disabling operator combination - at least temporarily - when performing diagnoses.

[jammala.ds]

Please help me where did disable....



"Disable operator combination "

Thank you
kriss

[mahadev.v]

Add the environment variable "APT_DISABLE_COMBINATION" and set the value to "TRUE" in your job. Run the job and copy paste the error message here.

[jammala.ds]

comming same error


APT_CombinedOperatorController,0: [DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 1.
[DataDirect][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 2.


Thank you
kriss

[ray.wurlod]

The environment variable must not just be included, it must be "set" (have a true value).

You can also disable combination in most stage types, on the Advanced tab of stage properties.

[jammala.ds]

Hi all,
I am getting below info...Please tell me the detailed about this..



ODBC_Enterprise_1: Process meta data not available in database


Thank you in advance,
krisss

[jammala.ds]

Hi all,
Job design like
Xmlinputstage----->transformerstage---->Odbc enterprise stage

When did you use minimum syntax,core and extend odbc?

I have to update one clomn like(medium_text)

in odbc stage generated sql builder odbc core,

how to set properties,update Value,Predicates, filter expression(where clause)

Please tell me the details...

thanks&Advance

Krisss