Page 1 of 1
Using ODBC Enterprise stage getting this error
Posted: Fri Sep 12, 2008 1:30 am
by 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
Posted: Fri Sep 12, 2008 2:26 am
by 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.
Please help me Where do diasable
Posted: Fri Sep 12, 2008 2:39 am
by jammala.ds
Please help me where did disable....
"Disable operator combination "
Thank you
kriss
Posted: Fri Sep 12, 2008 3:49 am
by 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.
again same error
Posted: Fri Sep 12, 2008 4:25 am
by 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
Posted: Fri Sep 12, 2008 4:41 am
by 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.
I am getting some info
Posted: Fri Sep 12, 2008 6:39 am
by 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
Getting error in odbc stage
Posted: Tue Sep 16, 2008 8:14 am
by 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