|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/20/2007 5:02:00 AM
Posts: 5,
Visits: 1
|
|
teradata db version 5.0
informatica is the etl tool that we use.
some of the connection to the terdata is with odbc - 2.8.2.5
informatica server is windows 2000
we want to upgrade the ttu version so we installed on the dev environment of informatica ttu 8.2
when we try to run insert with the new odbc driver we got the
following error:
FnName: Execute -- [NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this request.
FnName: Execute -- [Microsoft][ODBC Driver Manager] Function sequence error
ERROR 07/08/2007 10:53:32 node01_Test WRITER_1_*_1 WRT_8229 Database errors occurred:
FnName: Execute -- [NCR][ODBC Teradata Driver][Teradata Database] Insufficient memory for a Concrete Step for this request.
FnName: Execute -- [Microsoft][ODBC Driver Manager] Function sequence error
the dev server is windows 2003
the same action is succeed with the old odbc driver.
avishay hacarish
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/24/2008 2:47:14 PM
Posts: 425,
Visits: 398
|
|
That error message comes from the par$er, so the only way I can think of the new setup generating the error, but the old one working fine would be that the new one is possibly using ODBC extensions ? (similar to the queryman option) ?
As a first step can you turn on DBQL on the user id and verify if both the SQLs are same ?
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/20/2007 5:02:00 AM
Posts: 5,
Visits: 1
|
|
thank's i wil try it.
avishay hacarish
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/20/2007 5:02:00 AM
Posts: 5,
Visits: 1
|
|
hi
i found in the DBQL tables that, when i'm running from the new odbc driver the statement is :
INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;
when i'm runing from old driver has only one statement :
INSERT INTO TX705_SUB_CAMPAIGN_ACCOUNT(Campaign_Strategy_Id,Sub_Campaign_Id,Party_Agreement_Id,Rel_Start_Date,Campaign_Strategy_Type_Code) VALUES ( ?, ?, ?, ?, ?) ;
avishay hacarish
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/24/2008 2:47:14 PM
Posts: 425,
Visits: 398
|
|
It looks like in new setup, Informatica is firing an MSR (multi statement request) where as the old seems to be the plain fashioned single statement insert. The former gives better performance than the later though.
I am not familiar with Informatica., but I think the right place to start looking for, would be some where in the Informatica process if it's "packing" multiple insert statements into a single request or so (in the name of efficiency).
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/20/2007 5:02:00 AM
Posts: 5,
Visits: 1
|
|
do you think the problem is in the informatica setup or the odbc setup.
in the new odbc driver their is many new parameters like :
disable Asyc,Disable Parsing . . . are the new parameter can cause this behavior.
avishay hacarish
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 8/24/2008 2:47:14 PM
Posts: 425,
Visits: 398
|
|
|
I would put my guess on the Informatica setup. The ODBC driver should not generate an MSR on it's own unless the application does so.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 9/4/2008 1:20:38 PM
Posts: 215,
Visits: 395
|
|
Using a less ancient version of the Teradata Database might solve this problem. I believe p a r s e r memory management has been greatly improved in more recent releases.
|
|
|
| | |