Do I need to bounce the DataStage once I change RCP ? It goes away when I uncheck it but when I open again I see it there. Confused. Please advise.lkp_1: 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
Problem in disabling RCP...
Moderators: chulett, rschirm, roy
Problem in disabling RCP...
I am having trouble disabling RCP in a lookup ODBC Connector stage in a job. I have disabled it in Project level and also in the job level/stage level but I keep getting the following error.
Do you have RCP enable in on or more of the input links to the stage?
Turn on the $OSH_PRINT_SCHEMAS in your job parameters and see what the schemas going into the stage are.
Turn on the $OSH_PRINT_SCHEMAS in your job parameters and see what the schemas going into the stage are.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
It's ODBC Connector stage used as a reference (sparse) lookup with Lookup stage, source is a seq file and output is going via copy stage to a funnel stage and then to some other stages downstream.
I turned on the OSH_SCHEMA and did not find anything under OSH_SCRIPT which says that RCP is ON or any extra column.
I am not sure what's wrong...
I turned on the OSH_SCHEMA and did not find anything under OSH_SCRIPT which says that RCP is ON or any extra column.
I am not sure what's wrong...
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Why do you think the problem has anything to do with rcp? I typically see this problem when a user-defined query which includes a function call is executed. The stage is saying that it cannot find a correlation between your sql statement and the columns of a table.kaps wrote:lkp_1: 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
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com
You need to compare the columns in the schema shown in the log with those you defined and you will see a discrepancy.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
KWWilliams - Reason I thought the problem with RCP is that I have checked multiple times between the columns in the SQL and the columns defined in the columns tab in ODBC Connector and they look the same. Is there anything else I need to check ?
Following is the SQL in the Stage.
Arnd - I was trying to compare the schemas in the log(main_program: Schemas:) but could not find this lookup stage in there.
I have a job like this :
I can see the schema for the lookups after aggregator but not the ones before that.
Another question is I tried to remove RCP from the lookup stage but it simply does not go...
Following is the SQL in the Stage.
Code: Select all
SELECT
Table.Field1 as Field1,
Table.Field2 as Field2,
Table.Field3 as Field3,
Table.Field4 as Field4,
Table.Field5 as Field5,
Table.Field6 as Field6,
'Value' as Field7
FROM
dbo.Table AS Table
WHERE
Table.Field1 = ORCHESTRATE.Field;
I have a job like this :
Code: Select all
Seqfile -- Transformer -- lookup stage (with DB2 Conn as a ref lookup) -- copy stage -- funnel stage ---
Seqfile -- lookup stage (with ODBC Conn as a ref lookup) -- copy stage -- funnel stage ---
after funnel stage it goes to Aggregator and then 4 join stages(with 4 db2 connector ref lookups) and then to seq files.
Another question is I tried to remove RCP from the lookup stage but it simply does not go...
I have had this issue before - where you turn off RCP but it remains 'selected' on sparse lookup stages - however it never seemed to cause any problems.kaps wrote: Another question is I tried to remove RCP from the lookup stage but it simply does not go...
As for the query - I assume that if you run the query in the DB it runs successfully?
It is possible that DataStage has "tuned" the job at runtime. Set $APT_DISABLE_COMBINATION to "true" in this case to test that.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 437
- Joined: Fri Oct 21, 2005 10:00 pm
Your sql statement is where the issue is located:
'Value' as Field7
It cannot associate a column in the database dictionary to your derived field. If you want this to go away you can use a transformer to create field7 with 'Value' as its contents.
'Value' as Field7
It cannot associate a column in the database dictionary to your derived field. If you want this to go away you can use a transformer to create field7 with 'Value' as its contents.
Keith Williams
keith@peacefieldinc.com
keith@peacefieldinc.com