Datastage 9.1.2 Connector Stage Issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Thu May 08, 2014 10:54 am
Datastage 9.1.2 Connector Stage Issue
We are using below Sql in a connector stage:
SELECT user_identifier FROM user_table WHERE (user_identifier = ? );
It gives following warnings and errors:
- Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
- Fatal error -- Exception thrown from CC_OdbcDBStatement::executeSelect, file CC_OdbcDBStatement.cpp, line 1554: ODBC function "SQLExecute" reported: SQLSTATE = 07002: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver]COUNT field incorrect
Any Suggestions
SELECT user_identifier FROM user_table WHERE (user_identifier = ? );
It gives following warnings and errors:
- Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
- Fatal error -- Exception thrown from CC_OdbcDBStatement::executeSelect, file CC_OdbcDBStatement.cpp, line 1554: ODBC function "SQLExecute" reported: SQLSTATE = 07002: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver]COUNT field incorrect
Any Suggestions
Details please. Which connector stage is this? Is this actually a Server job or is it a Parallel job? I can make an educated guess from the error message but always best to post specifics.
Also, that SQL doesn't make much sense to me at first glance as you seem to be selecting the same value you already have in the parameter you are binding in... are you sure that is correct?
Also, that SQL doesn't make much sense to me at first glance as you seem to be selecting the same value you already have in the parameter you are binding in... are you sure that is correct?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 8
- Joined: Thu May 08, 2014 10:54 am
Thanks for responding... Below are some details:
Recently we migrated from 7.5 to 9.1.2 version. We were testing to convert the ODBC stages that we have used in 7.5 to ODBC connector Stage in 9.1.2. So we have migrated and converted using connector migration tool.Now the current serverjob has ODBC connector stage instead of ODBC stage that we have used in 7.5. It is a server job.The sql that we have used in ODBC stage in 7.5 before migration was:
SELECT SM.user_identifier FROM user_table SM WHERE (SM.user_identifier = ?);
After migration to ODBC connector Stage --- it is :
SELECT SM.user_identifier FROM user_table SM WHERE (SM.user_identifier = orchestrate.user_identifier);
Thanks
Maya
Recently we migrated from 7.5 to 9.1.2 version. We were testing to convert the ODBC stages that we have used in 7.5 to ODBC connector Stage in 9.1.2. So we have migrated and converted using connector migration tool.Now the current serverjob has ODBC connector stage instead of ODBC stage that we have used in 7.5. It is a server job.The sql that we have used in ODBC stage in 7.5 before migration was:
SELECT SM.user_identifier FROM user_table SM WHERE (SM.user_identifier = ?);
After migration to ODBC connector Stage --- it is :
SELECT SM.user_identifier FROM user_table SM WHERE (SM.user_identifier = orchestrate.user_identifier);
Thanks
Maya
It's not a very common error. You can tell that by searching.
Does the stage have a corresponding column defined?
A wild guess would be that the newer 9.1.2 version ships with newer ODBC drivers. Do the newer drivers still support the database?
Here's a similar error but not much else in common:
viewtopic.php?t=145317
Does the stage have a corresponding column defined?
A wild guess would be that the newer 9.1.2 version ships with newer ODBC drivers. Do the newer drivers still support the database?
Here's a similar error but not much else in common:
viewtopic.php?t=145317
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 8
- Joined: Thu May 08, 2014 10:54 am
Thanks for responding. I am sure it is not a common error. The thing is I am getting this arror in all the jobs that are using transformer stage.The one that are simply extracting records from database and writing on a sequential file , is running fine. Currently I am working on the jobs that are using transformer stage to write data from database to the sequential file and this error is showing up in all the server jobs.
-
- Participant
- Posts: 8
- Joined: Thu May 08, 2014 10:54 am
RowGen->Transformer->Peek
dummy up a job with the above.
That will tell you if your statement of "Only jobs with transformers are failing" is true.
If the above is true (failing), then it also has nothing to do with your odbc drivers.
I would check compiler settings in Administrator.
Does it fail on compile?
In your existing environment...
Did you import jobs with executables or did you compile them in that environment?
Does a "View Data" work against that table via the connector stage?
How did you load the column types for this job? Imported or manually entered?
dummy up a job with the above.
That will tell you if your statement of "Only jobs with transformers are failing" is true.
If the above is true (failing), then it also has nothing to do with your odbc drivers.
I would check compiler settings in Administrator.
Does it fail on compile?
In your existing environment...
Did you import jobs with executables or did you compile them in that environment?
Does a "View Data" work against that table via the connector stage?
How did you load the column types for this job? Imported or manually entered?
-
- Participant
- Posts: 8
- Joined: Thu May 08, 2014 10:54 am
Thanks for responding.
- I will test and try as said.
- No the job does not fail on compilation.
- Regarding the view data - I am able to view data but there is one issue there in some jobs which I will describe with an example.
- I have imported the column types by loading them (NOT Manually)
Thanks!
- I will test and try as said.
- No the job does not fail on compilation.
- Regarding the view data - I am able to view data but there is one issue there in some jobs which I will describe with an example.
- I have imported the column types by loading them (NOT Manually)
Thanks!
-
- Participant
- Posts: 8
- Joined: Thu May 08, 2014 10:54 am
-
- Participant
- Posts: 8
- Joined: Thu May 08, 2014 10:54 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can use a Transformer stage in a server job as a row generator. Make sure it has something to do (e.g. evaluate a stage variable), and constrain the output link with something like @OUTROWNUM <= 10000.
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: 8
- Joined: Thu May 08, 2014 10:54 am