Hi,
When I execute an Insert form a select, SQL Server return the following
message
Server: Msg 8623, Level 16, State 1, Line 109
Internal Query Processor Error: The query processor could not produce a
query plan. Contact your primary support provider for more information.
I have search on TechNet and find the following article
(http://support.microsoft.com/default.aspx?scid=kb;en-us;832412). It said to
put the FLAG 9136 on SQL Server.
I have search on Internet and don't find any information about this flag.
Procurei na internet e não encontrei informações sobre este FLAG.
Does someone know any information about this error or about this flag?I found several KB's associated with that error such as this one:
http://support.microsoft.com/default.aspx?scid=kb;en-us;841404&Product=sql2k
But it depends on what your doing. In any case I feel it's a bug and you
should contact MS PSS.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly
SQL Server MVP
"Thiago Campos Pereira" <tpereira@.attps.com.br> wrote in message
news:%23sH0wnkQEHA.2716@.tk2msftngp13.phx.gbl...
> Hi,
> When I execute an Insert form a select, SQL Server return the following
> message
> Server: Msg 8623, Level 16, State 1, Line 109
> Internal Query Processor Error: The query processor could not produce a
> query plan. Contact your primary support provider for more information.
>
> I have search on TechNet and find the following article
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;832412). It said
to
> put the FLAG 9136 on SQL Server.
> I have search on Internet and don't find any information about this flag.
> Procurei na internet e não encontrei informações sobre este FLAG.
>
> Does someone know any information about this error or about this flag?
>
Showing posts with label internal. Show all posts
Showing posts with label internal. Show all posts
Tuesday, March 27, 2012
Monday, March 19, 2012
Error 7102
After installation of the SP4 on SQL Server 2000 I began to receive seldom
error in log-file:
Error 7102 Serverity 20 State 0
SQL Server Internal Error. Text manager cannot continue with current
statement.
OS: Windows 2000 Advanced Server SP4.Hi white,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You get the Error
7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
please feel free to point it out.
Error 7102 is a general error. Would you please provide some detail
information to narrow down the issue?
1. Using DBCC CHECKDB to see is there any error messages.
2. What do you get in the Application and System event log? Would your
please post it here?
3. Are you able to trace what the database is doing when you get this
error?
Please let us know the result. I look forward your reply.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lu!
1. DBCC CHECKDB is executed every night. Error messages are absent.
2. There are no error and warning messages in the Application and System
event log. To post there is nothing.
3. 7102 error messages arises seldom. Trace is now turn on.
"Wei Lu" wrote:
> Hi white,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You get the Erro
r
> 7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern
,
> please feel free to point it out.
> Error 7102 is a general error. Would you please provide some detail
> information to narrow down the issue?
> 1. Using DBCC CHECKDB to see is there any error messages.
> 2. What do you get in the Application and System event log? Would you
r
> please post it here?
> 3. Are you able to trace what the database is doing when you get this
> error?
> Please let us know the result. I look forward your reply.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi white,
Thanks for the update. Please gather the trace and to see what have you
done before these error arised.
Wei Lu
Microsoft Online Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
error in log-file:
Error 7102 Serverity 20 State 0
SQL Server Internal Error. Text manager cannot continue with current
statement.
OS: Windows 2000 Advanced Server SP4.Hi white,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You get the Error
7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
please feel free to point it out.
Error 7102 is a general error. Would you please provide some detail
information to narrow down the issue?
1. Using DBCC CHECKDB to see is there any error messages.
2. What do you get in the Application and System event log? Would your
please post it here?
3. Are you able to trace what the database is doing when you get this
error?
Please let us know the result. I look forward your reply.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lu!
1. DBCC CHECKDB is executed every night. Error messages are absent.
2. There are no error and warning messages in the Application and System
event log. To post there is nothing.
3. 7102 error messages arises seldom. Trace is now turn on.
"Wei Lu" wrote:
> Hi white,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You get the Erro
r
> 7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern
,
> please feel free to point it out.
> Error 7102 is a general error. Would you please provide some detail
> information to narrow down the issue?
> 1. Using DBCC CHECKDB to see is there any error messages.
> 2. What do you get in the Application and System event log? Would you
r
> please post it here?
> 3. Are you able to trace what the database is doing when you get this
> error?
> Please let us know the result. I look forward your reply.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>|||Hi white,
Thanks for the update. Please gather the trace and to see what have you
done before these error arised.
Wei Lu
Microsoft Online Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Error 7102
After installation of the SP4 on SQL Server 2000 I began to receive seldom
error in log-file:
Error 7102 Serverity 20 State 0
SQL Server Internal Error. Text manager cannot continue with current
statement.
OS: Windows 2000 Advanced Server SP4.Hi white,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You get the Error
7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
please feel free to point it out.
Error 7102 is a general error. Would you please provide some detail
information to narrow down the issue?
1. Using DBCC CHECKDB to see is there any error messages.
2. What do you get in the Application and System event log? Would your
please post it here?
3. Are you able to trace what the database is doing when you get this
error?
Please let us know the result. I look forward your reply.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lu!
1. DBCC CHECKDB is executed every night. Error messages are absent.
2. There are no error and warning messages in the Application and System
event log. To post there is nothing.
3. 7102 error messages arises seldom. Trace is now turn on.
"Wei Lu" wrote:
> Hi white,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You get the Error
> 7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
> please feel free to point it out.
> Error 7102 is a general error. Would you please provide some detail
> information to narrow down the issue?
> 1. Using DBCC CHECKDB to see is there any error messages.
> 2. What do you get in the Application and System event log? Would your
> please post it here?
> 3. Are you able to trace what the database is doing when you get this
> error?
> Please let us know the result. I look forward your reply.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi white,
Thanks for the update. Please gather the trace and to see what have you
done before these error arised.
Wei Lu
Microsoft Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
error in log-file:
Error 7102 Serverity 20 State 0
SQL Server Internal Error. Text manager cannot continue with current
statement.
OS: Windows 2000 Advanced Server SP4.Hi white,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You get the Error
7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
please feel free to point it out.
Error 7102 is a general error. Would you please provide some detail
information to narrow down the issue?
1. Using DBCC CHECKDB to see is there any error messages.
2. What do you get in the Application and System event log? Would your
please post it here?
3. Are you able to trace what the database is doing when you get this
error?
Please let us know the result. I look forward your reply.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lu!
1. DBCC CHECKDB is executed every night. Error messages are absent.
2. There are no error and warning messages in the Application and System
event log. To post there is nothing.
3. 7102 error messages arises seldom. Trace is now turn on.
"Wei Lu" wrote:
> Hi white,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You get the Error
> 7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
> please feel free to point it out.
> Error 7102 is a general error. Would you please provide some detail
> information to narrow down the issue?
> 1. Using DBCC CHECKDB to see is there any error messages.
> 2. What do you get in the Application and System event log? Would your
> please post it here?
> 3. Are you able to trace what the database is doing when you get this
> error?
> Please let us know the result. I look forward your reply.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi white,
Thanks for the update. Please gather the trace and to see what have you
done before these error arised.
Wei Lu
Microsoft Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
Error 7102
After installation of the SP4 on SQL Server 2000 I began to receive seldom
error in log-file:
Error 7102 Serverity 20 State 0
SQL Server Internal Error. Text manager cannot continue with current
statement.
OS: Windows 2000 Advanced Server SP4.
Hi white,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You get the Error
7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
please feel free to point it out.
Error 7102 is a general error. Would you please provide some detail
information to narrow down the issue?
1. Using DBCC CHECKDB to see is there any error messages.
2. What do you get in the Application and System event log? Would your
please post it here?
3. Are you able to trace what the database is doing when you get this
error?
Please let us know the result. I look forward your reply.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Lu!
1. DBCC CHECKDB is executed every night. Error messages are absent.
2. There are no error and warning messages in the Application and System
event log. To post there is nothing.
3. 7102 error messages arises seldom. Trace is now turn on.
"Wei Lu" wrote:
> Hi white,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You get the Error
> 7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
> please feel free to point it out.
> Error 7102 is a general error. Would you please provide some detail
> information to narrow down the issue?
> 1. Using DBCC CHECKDB to see is there any error messages.
> 2. What do you get in the Application and System event log? Would your
> please post it here?
> 3. Are you able to trace what the database is doing when you get this
> error?
> Please let us know the result. I look forward your reply.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi white,
Thanks for the update. Please gather the trace and to see what have you
done before these error arised.
Wei Lu
Microsoft Online Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
error in log-file:
Error 7102 Serverity 20 State 0
SQL Server Internal Error. Text manager cannot continue with current
statement.
OS: Windows 2000 Advanced Server SP4.
Hi white,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You get the Error
7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
please feel free to point it out.
Error 7102 is a general error. Would you please provide some detail
information to narrow down the issue?
1. Using DBCC CHECKDB to see is there any error messages.
2. What do you get in the Application and System event log? Would your
please post it here?
3. Are you able to trace what the database is doing when you get this
error?
Please let us know the result. I look forward your reply.
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Lu!
1. DBCC CHECKDB is executed every night. Error messages are absent.
2. There are no error and warning messages in the Application and System
event log. To post there is nothing.
3. 7102 error messages arises seldom. Trace is now turn on.
"Wei Lu" wrote:
> Hi white,
> Welcome to use MSDN Managed Newsgroup Support.
> From your description, my understanding of this issue is: You get the Error
> 7102 in the SQL Server 2000 SP4 Error log. If I misunderstood your concern,
> please feel free to point it out.
> Error 7102 is a general error. Would you please provide some detail
> information to narrow down the issue?
> 1. Using DBCC CHECKDB to see is there any error messages.
> 2. What do you get in the Application and System event log? Would your
> please post it here?
> 3. Are you able to trace what the database is doing when you get this
> error?
> Please let us know the result. I look forward your reply.
> Wei Lu
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
|||Hi white,
Thanks for the update. Please gather the trace and to see what have you
done before these error arised.
Wei Lu
Microsoft Online Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)