March 18, 2014 at 5:51 am
Hi All,
I am using Script task component for creating query (Can not handled due to 4000 Character issue) and running this query later in the package on Sybase Database using ADO.net connection and giving me (while running the above query on Sybase DB) below error while doing the same. Error description below:
"[Script Component Extract ICTS-FAMM MTM [3590]] Error: System.Data.Odbc.OdbcException: ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Unable to allocate work table for processing group by or distinct clause during query optimization. Maximum limit (14) of work tables is exceeded. Simplify the query and retry.
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Unable to allocate ancillary table for query optimization. Maximum number of tables in a query (14) exceeded.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)".
Not able to get any answer from Google.
Please Help !!!!!!
March 18, 2014 at 6:32 am
dattatreysurendra (3/18/2014)
Hi All,I am using Script task component for creating query (Can not handled due to 4000 Character issue) and running this query later in the package on Sybase Database using ADO.net connection and giving me (while running the above query on Sybase DB) below error while doing the same. Error description below:
"[Script Component Extract ICTS-FAMM MTM [3590]] Error: System.Data.Odbc.OdbcException: ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Unable to allocate work table for processing group by or distinct clause during query optimization. Maximum limit (14) of work tables is exceeded. Simplify the query and retry.
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Unable to allocate ancillary table for query optimization. Maximum number of tables in a query (14) exceeded.
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.HandleUserException(Exception e)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute()
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPreExecute(IDTSManagedComponentWrapper100 wrapper)".
Not able to get any answer from Google.
Please Help !!!!!!
That looks like a Script Component, not a Script Task.
It also looks like the error is being generated by Sybase rather than SQL Server.
Without seeing your code, it's difficult to guess - but perhaps you are calling a routine which is executing over and over again (once per row of input data) on the Sybase side and that is causing the problem?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 18, 2014 at 8:02 am
Yes that is script component. But we are concatenating queries by using variables in Script Task. In that script task we are using same variable in multiple queries as we need to get the same text in that query and passing that value to Script Component and that is getting failed.
one question - If I creates a different variable for each part of query (I mean to say that not reusing the same variable multiple times in script component) then i would not get this issue. which i am getting right now.
March 18, 2014 at 9:31 am
dattatreysurendra (3/18/2014)
Yes that is script component. But we are concatenating queries by using variables in Script Task. In that script task we are using same variable in multiple queries as we need to get the same text in that query and passing that value to Script Component and that is getting failed.one question - If I creates a different variable for each part of query (I mean to say that not reusing the same variable multiple times in script component) then i would not get this issue. which i am getting right now.
I cannot think of any way that a single variable can be used to pass multiple strings to a script component - the two are disconnected.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply