Hi All,
We are having a parallel job which gets data from a DataSet and loads into oracle table.
Dset --> Tr --> Oracle connector
The job was running fine. We had a change in a filed length from NVarchar(100) to NVarchar(525). After we had this change in DB for varchar filed we are having the issue.
ODBC function "SQLExecute" reported: SQLSTATE = HY104: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver]Invalid precision value. Error in parameter 22. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 786).
Parameter 22 is the particular field, in auto generated insert query for which we had done the changes.
I had searched for this is most of the post deals with integer or decimal fields. For my case it is Varchar.
Please help me on this. TIA.
Invalid precision value. Error in parameter @
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 39
- Joined: Tue Feb 28, 2012 12:59 pm
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you're using an Oracle Connector stage you might be able to change the Error in Size Mismatch property from Yes to No (you'll get a warning instead).
Make sure that the metadata in the job matches the metadata in the table. Ideally re-import the table definition (use the Connector Import Wizard) and re-load into any job that touches this job, which you can determine using a Where Used analysis.
Make sure that the metadata in the job matches the metadata in the table. Ideally re-import the table definition (use the Connector Import Wizard) and re-load into any job that touches this job, which you can determine using a Where Used analysis.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 39
- Joined: Tue Feb 28, 2012 12:59 pm
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 39
- Joined: Tue Feb 28, 2012 12:59 pm
- Location: Chennai
Scale of the column is actually set to blank. Not sure on how/what to set it, as only the length of the column as been changed.
We also tried with odbc connector instead of oracle connector and recieving the same error.
Job is finishing successfully in Development, but failing in Certification environment.
Oracle DB is owned by Siperian, and they can only increase the length of the column, roll back is not possible. So we are muted on how to bring this error in development and proceed further
We also tried with odbc connector instead of oracle connector and recieving the same error.
Job is finishing successfully in Development, but failing in Certification environment.
Oracle DB is owned by Siperian, and they can only increase the length of the column, roll back is not possible. So we are muted on how to bring this error in development and proceed further
Thanks!
Xavi
Xavi