Error when trying to save or write to table

Hi,
I am doing a tuning exercise on a SQL 2K5 instance, I am encountering
a problem when Profiler goes to create a table. I have profiled
Profiler and have extracted the following code
CREATE TABLE [dbo].[con1] ([RowNumber] int IDENTITY(0,1) PRIMARY KEY,
[EventClass] int NULL,[Duration] bigint NULL,,
[TextData] ntext NULL,[SPID] int NULL,[BinaryData] image NULL,[CPU]
int NULL,[Reads] bigint NULL,[Writes] bigint NULL,[ApplicationName]
nvarchar(128) NULL,[ClientProcessID] int NULL,[DatabaseID] int NULL,
[DatabaseName] nvarchar(128) NULL,[EventSequence] int NULL,
[EventSubClass] int NULL,[HostName] nvarchar(128) NULL,[IntegerData]
int NULL,[IsSystem] int NULL,[LoginName] nvarchar(128) NULL,[LoginSid]
image NULL,[NTDomainName] nvarchar(128) NULL,[NTUserName]
nvarchar(128) NULL,[RequestID] int NULL,[ServerName] nvarchar(128)
NULL,[SessionLoginName] nvarchar(128) NULL,[StartTime] datetime NULL,
[TransactionID] bigint NULL)
As you can see, after Duration (the 3rd column), there is a double
comma inserted which of course is erroring.
This occurs when defining a table to save to prior to running the
trace, and defining a table after running the trace.
I have tried the standard profiler which appears to work fine.
I also updated to SP2 CTP (this is a test server) because it appeared
to be an issue simular to this http://support.microsoft.com/?
kbid=925335.
A quick response would be appreciated as I am a contractor and I am on
tight timescales.
Cheers
Steve
Steve,
I don't know how to fix the error with profiler but I recommend you not do
that in the fist place. Tracing to a table can be a huge performance hit and
can skew your results. It is recommended that you trace directly to a file
using sp_trace_create and then use fn_trace_gettable to retrieve the data.
You can do something like this to put the trace results in a table:
SELECT * INTO YourTable FROM fn_trace_gettable(xxx)
If you already have a trace in profiler you can save it to a file and do the
same.
Andrew J. Kelly SQL MVP
"Steve L" <steve_lawrenson@.tiscali.co.uk> wrote in message
news:1170411376.241148.280690@.v33g2000cwv.googlegr oups.com...
> Hi,
> I am doing a tuning exercise on a SQL 2K5 instance, I am encountering
> a problem when Profiler goes to create a table. I have profiled
> Profiler and have extracted the following code
> CREATE TABLE [dbo].[con1] ([RowNumber] int IDENTITY(0,1) PRIMARY KEY,
> [EventClass] int NULL,[Duration] bigint NULL,,
> [TextData] ntext NULL,[SPID] int NULL,[BinaryData] image NULL,[CPU]
> int NULL,[Reads] bigint NULL,[Writes] bigint NULL,[ApplicationName]
> nvarchar(128) NULL,[ClientProcessID] int NULL,[DatabaseID] int NULL,
> [DatabaseName] nvarchar(128) NULL,[EventSequence] int NULL,
> [EventSubClass] int NULL,[HostName] nvarchar(128) NULL,[IntegerData]
> int NULL,[IsSystem] int NULL,[LoginName] nvarchar(128) NULL,[LoginSid]
> image NULL,[NTDomainName] nvarchar(128) NULL,[NTUserName]
> nvarchar(128) NULL,[RequestID] int NULL,[ServerName] nvarchar(128)
> NULL,[SessionLoginName] nvarchar(128) NULL,[StartTime] datetime NULL,
> [TransactionID] bigint NULL)
> As you can see, after Duration (the 3rd column), there is a double
> comma inserted which of course is erroring.
> This occurs when defining a table to save to prior to running the
> trace, and defining a table after running the trace.
> I have tried the standard profiler which appears to work fine.
> I also updated to SP2 CTP (this is a test server) because it appeared
> to be an issue simular to this http://support.microsoft.com/?
> kbid=925335.
> A quick response would be appreciated as I am a contractor and I am on
> tight timescales.
> Cheers
> Steve
>
|||On 2 Feb, 14:11, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Steve,
> I don't know how to fix the error with profiler but I recommend you not do
> that in the fist place. Tracing to a table can be a huge performance hit and
> can skew your results. It is recommended that you trace directly to a file
> using sp_trace_create and then use fn_trace_gettable to retrieve the data.
> You can do something like this to put the trace results in a table:
> SELECT * INTO YourTable FROM fn_trace_gettable(xxx)
> If you already have a trace in profiler you can save it to a file and do the
> same.
> --
> Andrew J. Kelly SQL MVP
> "Steve L" <steve_lawren...@.tiscali.co.uk> wrote in message
> news:1170411376.241148.280690@.v33g2000cwv.googlegr oups.com...
>
>
>
>
>
>
> - Show quoted text -
Hi Andrew
thanks for the response, I will use the method above as a workaround
and thanks for that information. It would be nice to know if this is a
recognised issue by MS and what their recommended workarounds are for
it.
Cheers
Steve L

Error when trying to run database engine tuning advisor

Hi,

I am getting "R6031- Attempt

to initialize the CRT more than once. This indicates a bug in your

application." when I am trying to database engine tuning advisor. I already followed the workaround from http://support.microsoft.com/default.aspx/kb/913395 but it did not help as I did not have any explorer.exe or any file in that registry folder.

I am using windows XP Sp2, using SQL server developer edition. I am wondering if anyone else has experienced this issue and can help me.

Thanks.

Have you tried attempted to invoke using the DTA on another machine?

I believe this could be the issue with Client tools, try to reinstall the Developer edition on this machine.

|||I will give it a try. I did try to reinstall on this machine but it did not help.

Error when running Tuning advisor

When I try to launch the tuning advisor, I get this error - Any help will be much appriciated.

===================================

Failed to connect to an IPC Port: The system cannot find the file specified.
(mscorlib)

Program Location:

Server stack trace:
at System.Runtime.Remoting.Channels.Ipc.IpcPort.Connect(String portName, Boolean secure, TokenImpersonationLevel impersonationLevel, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.ConnectionCache.GetConnection(String portName, Boolean secure, TokenImpersonationLevel level, Int32 timeout)
at System.Runtime.Remoting.Channels.Ipc.IpcClientTransportSink.ProcessMessage(IMessage msg, ITransportHeaders requestHeaders, Stream requestStream, ITransportHeaders& responseHeaders, Stream& responseStream)
at System.Runtime.Remoting.Channels.BinaryClientFormatterSink.SyncProcessMessage(IMessage msg)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.SqlServer.Management.UI.VSIntegration.ISessionController.CreateSessionFromQuery(SqlConnectionInfo connectionInfo, String sqlQuery, String batchSeparator)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.SqlScriptEditorControl.OnDatabaseTuningAdvisor(Object sender, EventArgs a)

What is the service pack level on SQL Server?

Any recent changes to the server and client machine you are using, such as automatic updates?

|||Hi,

I had got the same error when I tried to tune my query.

However after I click "OK" button of the Error message, in few seconds the "Tuning Adviser" window opens but it is not connected to the session of the query editor (in which the query was executed).

Now without closing this tuning adviser window, if I again click on Analyser button, the analyser opens fine and the query is also tunned properly.

Let me know if this works for you too.

Regards,

Shweta

Error using Db Engine Tuning Advisor

I am running SQL 2005 Standard, obtained from a recent Launch event.
I got the Database Engine Tuning Advisor to run only once. Everytime after
that I get a runtime error: "R6031 Attempt to initialize the CRT more than
once. This indicates a bug in your application."
I had the same problem with the Sept. CTP release. Re-booting the machine
does not solve this problem. Basicaly, this is a useless tool if I need to
un-install and re-install it everytime I need to use it. I have tried
deleting all the sessions and creating a new one, re-booting.
Any ideas how to solve this? Do I need to wait for a Service Pack?
We are looking at the issue currently. It has been reported by a few other
people. Please gi ve us some more detail:
- does this happen immiediately after you start DTA UI or after you connect
to the server and the connection dialog goes away?
- if this is the second case (error after connecting) does the problem occur
if you simply Cancel the connection dialog?
- have you tried command-line DTA to see if it work? Run 'dta.exe /?' to see
the options if you have not seen it yet.
- does the error message contain any more information?
- can you check if at the time you see the error there is a dtaengine90.exe
process running on your system?
Thanks,
Maciek
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>I am running SQL 2005 Standard, obtained from a recent Launch event.
> I got the Database Engine Tuning Advisor to run only once. Everytime after
> that I get a runtime error: "R6031 Attempt to initialize the CRT more than
> once. This indicates a bug in your application."
> I had the same problem with the Sept. CTP release. Re-booting the machine
> does not solve this problem. Basicaly, this is a useless tool if I need to
> un-install and re-install it everytime I need to use it. I have tried
> deleting all the sessions and creating a new one, re-booting.
> Any ideas how to solve this? Do I need to wait for a Service Pack?
|||Is this TechNet discussion forum the best place to correspond regarding tech
support and error information?
I would be happy to supply any information you need. Can you e-mail me a
valid address so that we can take this 'off-line'?
Thank you.
todd_dot_chittenden_at_morantug_dot_com
"Maciek Sarnowicz [MSFT]" wrote:

> We are looking at the issue currently. It has been reported by a few other
> people. Please gi ve us some more detail:
> - does this happen immiediately after you start DTA UI or after you connect
> to the server and the connection dialog goes away?
> - if this is the second case (error after connecting) does the problem occur
> if you simply Cancel the connection dialog?
> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to see
> the options if you have not seen it yet.
> - does the error message contain any more information?
> - can you check if at the time you see the error there is a dtaengine90.exe
> process running on your system?
> Thanks,
> Maciek
>
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>
>
|||I will take this off-line as Todd requested. We will post back to the group
once we know the root cause of the issue.
Thanks,
Maciek
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:F4881BF8-E66B-403B-9DA0-1BC4020DDF7F@.microsoft.com...[vbcol=seagreen]
> Is this TechNet discussion forum the best place to correspond regarding
> tech
> support and error information?
> I would be happy to supply any information you need. Can you e-mail me a
> valid address so that we can take this 'off-line'?
> Thank you.
> todd_dot_chittenden_at_morantug_dot_com
> "Maciek Sarnowicz [MSFT]" wrote:
|||I'm experiencing the same problem. See my answers below.
"Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
news:OnFxcW0$FHA.2392@.TK2MSFTNGP09.phx.gbl...
> We are looking at the issue currently. It has been reported by a few other
> people. Please gi ve us some more detail:
> - does this happen immiediately after you start DTA UI or after you
> connect to the server and the connection dialog goes away?
It happens after I connect to the server and the connection dialog goes
away.

> - if this is the second case (error after connecting) does the problem
> occur if you simply Cancel the connection dialog?
The problem does not occur if I press the Cancel button at the connection
dialog. But the problem does occur if I thereafter attempt to connect from
within the DTA.

> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to
> see the options if you have not seen it yet.
I tried using the command-line and had the same problem.

> - does the error message contain any more information?
It's a very vague message. Similar to Todd, I get the following:
Microsoft Visual C++ Runtime Library
Runtime Error!
Program: C:\Progr...
R6031 Attempt to initialize the CRT more than once. This indicates a bug in
your application.

> - can you check if at the time you see the error there is a
> dtaengine90.exe process running on your system?
Yes, both dtaengine90.exe and DTASHELL.EXE are loaded. My only recourse is
to kill both processes.
Chris

> Thanks,
> Maciek
>
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>
|||>> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to
> I tried using the command-line and had the same problem.
BTW, after returning to the command line, I see the following:
"Failed to initialize MSDB database for tuning (exit code: 1)."
Chris
|||Thanks Chris.
This confirms what Todd has reported. We are closing down on the issue,
please stay tuned.
Regards,
Maciek Sarnowicz
SQL Server SDE
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris" <chris@.newsgroup.nospam> wrote in message
news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
> BTW, after returning to the command line, I see the following:
> "Failed to initialize MSDB database for tuning (exit code: 1)."
> Chris
>
|||I am having the same exact problem. I de-installed everything and
re-installed to no avail. All other tools and services are working fine so
far. I have never been able to "connect to the database using DTA". If I
hit cancel at the login, there is no error. When I try to connect the same
error is thrown on my machine. What is interesting is I just did a very
clean install on my computer less than 30 days ago. The only install issue
was that I was not running IIS for reporting services as it is not needed for
me.
I am running XP Pro with all SP and updates and .Net/updates prior to SQL
2005 Developer Install.
Software would be Office 03 and misc business apps.
Hope the problem is solved soon.
Thank you,
kirk
"Maciek Sarnowicz [MSFT]" wrote:

> Thanks Chris.
> This confirms what Todd has reported. We are closing down on the issue,
> please stay tuned.
>
> Regards,
> Maciek Sarnowicz
> --
> SQL Server SDE
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Chris" <chris@.newsgroup.nospam> wrote in message
> news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
>
>
|||Anything new to report on this? Thanks.
"Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
news:OctJ8zTAGHA.3976@.TK2MSFTNGP09.phx.gbl...
> Thanks Chris.
> This confirms what Todd has reported. We are closing down on the issue,
> please stay tuned.
>
> Regards,
> Maciek Sarnowicz
> --
> SQL Server SDE
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Chris" <chris@.newsgroup.nospam> wrote in message
> news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
>
|||Hi Chris
This issue is being investigated presently and is probably a
consequence of a filed windows/appcompat bug
(issue due to appcompat shimming and nothing to do with DTA process
itself -).
1.Can you check if you have registry entries corresponding to
HKLM\Software\Microsoft\Windows
NT\CurrentVersion\AppCompatFlags\Layers?
In the past we have seen "explorer.exe " as an entry and removing that
fixed the problem
2.Also please check if an environment variable __COMPAT_LAYER is set?
"set __COMPAT_LAYER=" , basically disabled the compat layer and dta
ran OK
Please note that none of these are set by the tuning advisor exe - At
this point i am not sure what app does this
Manoj
Chris wrote:[vbcol=seagreen]
> Anything new to report on this? Thanks.
> "Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
> news:OctJ8zTAGHA.3976@.TK2MSFTNGP09.phx.gbl...

Error starting Tuning Advisor

When I try to run the database engine tuning advisor from SQLServer2005 I get a messagebox with the following dialog:

RuntimeError!

Program: C:\Progr...

R6031

-Attempt to initialize the CRT more than once.

This indicates a bug in your application

I have read the MS KB that says the solution is to delete a registry value. I dont however have the key in the registry that the KB article refers to. (HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers)

I am missing the AppCompatFlags key. Any suggestions?

Is this the right forum for this?|||Check in HKEY_LOCAL_MACHINE as well, using the same path. I've found this flag in both.
|||The key does not exist there either. Thanks for the suggestion though.

Error starting Tuning Advisor

When I try to run the database engine tuning advisor from SQLServer2005 I get a messagebox with the following dialog:

RuntimeError!

Program: C:\Progr...

R6031

-Attempt to initialize the CRT more than once.

This indicates a bug in your application

I have read the MS KB that says the solution is to delete a registry value. I dont however have the key in the registry that the KB article refers to. (HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers)

I am missing the AppCompatFlags key. Any suggestions?

Is this the right forum for this?|||Check in HKEY_LOCAL_MACHINE as well, using the same path. I've found this flag in both.|||The key does not exist there either. Thanks for the suggestion though.|||Did you find a solution, I have the same problem with no registry entry either.

Error starting Tuning Advisor

When I try to run the database engine tuning advisor from SQLServer2005 I get a messagebox with the following dialog:

RuntimeError!

Program: C:\Progr...

R6031

-Attempt to initialize the CRT more than once.

This indicates a bug in your application

I have read the MS KB that says the solution is to delete a registry value. I dont however have the key in the registry that the KB article refers to. (HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers)

I am missing the AppCompatFlags key. Any suggestions?

Is this the right forum for this?|||Check in HKEY_LOCAL_MACHINE as well, using the same path. I've found this flag in both.|||The key does not exist there either. Thanks for the suggestion though.