Good afternoon, all. Whenever I try to use Query | Display Estimated
Execution Plan in SQL Studio on any non-trivial query, I get this unhelpful
message:
Error processing execution plan results. The error message is:
There is an error in XML document (1, 501).
There is an unclosed literal string. Line 1, position 501.
The only suggestion I've heard of is to instal SQL SPs, but that didn't
help. This is SQL 2K5 running on Win2K3. I don't believe there's any
strangeness like odd characters in instance names, and all language settings
are default. I've seen this before on another server, but Google has nothing.
Any ideas? Thanks!
I think I heard that the XML used for this can not handle some unusual
object names, but at best that is a long shot.
Roy Harvey
Beacon Falls, CT
On Mon, 6 Aug 2007 13:32:02 -0700, JonOfAllTrades
<JonOfAllTrades@.discussions.microsoft.com> wrote:
> Good afternoon, all. Whenever I try to use Query | Display Estimated
>Execution Plan in SQL Studio on any non-trivial query, I get this unhelpful
>message:
>Error processing execution plan results. The error message is:
>There is an error in XML document (1, 501).
>There is an unclosed literal string. Line 1, position 501.
> The only suggestion I've heard of is to instal SQL SPs, but that didn't
>help. This is SQL 2K5 running on Win2K3. I don't believe there's any
>strangeness like odd characters in instance names, and all language settings
>are default. I've seen this before on another server, but Google has nothing.
> Any ideas? Thanks!
Showing posts with label fails. Show all posts
Showing posts with label fails. Show all posts
Tuesday, March 27, 2012
Monday, March 26, 2012
Establishing connection from SQL MMC fails
Hi,
I have Win2003 and SQL server 2000 installed. I have restarted SQL services
and the services crashed and could not be killed. I have killed the
processes manually but when I open SQL Server Enterprise Manager, expand SQL
Server group and click on the desired SQL Server group it is failing and the
MMC becomes not responding.
It fails on 'Establing connection to SQL Server and checking Windows
security'
I have tried to telnet on the respective SQL Server port and the port
responds ok. I have also done a netstat and the server is listening on the
respective port.
From the sql error logs, the following information is being logged
2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in database
'msdb' (4)
2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for buffer
latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID 4:2073058421:0,
EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
0x10000a, current owning EC 0x42CAC3F0.
Your suggetions will be highly appreciated.Dear Quintin,
Thank you for posting here.
From the problem description, I understand that the error message
"Establish connection to SQL Server and checking Windows security" is
encountered when trying to connect to the SQL Server 2000 via the
Enterprise Manage. If I have misunderstood about your concern, feel free to
let me know.
Before moving on, I suggest that you try the following method to check if
you could connect via osql.exe
1. Click Start, click Run, type cmd, and then click OK
2. At the command prompt, type the following command, and then press ENTER.
OSQL -E -S <server name>\<instance name>
OSQL -E -S tcp:<computer name>,<port number>
Also, you could try SQL authentication by using sa
OSQL -S <server name>\<instance name> -Usa -P<password>
3. Please check if we can successfully connect to the instance of SQL
Server 2000 by using osql.exe.
If any error message appears, please let me know the extract error message
we received.
Please also help me gather the following information for the further
research:
Information One: SQL MPS Report
=====================Please help create a MPSReport on the problematic machine, which will
collect ERRORLOG, Windows event log and other helpful information about the
SQL Server. To create a MPSReport, please visit the following web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
88B7-F9C79B7306C0&displaylang=en
And look for MPSRPT_SQL.EXE. Download it and run it on the machine. Dismiss
the prompted dialog boxes and the readme window (usually a Notepad) after
you read them. After the Command Prompt window closes itself, collect the
cab file the tool has generated and sent it to me.
Information Two: Screenshot
=====================Please also help me to capture a screenshot when the error message
"Establish connection to SQL Server and checking Windows security" appears.
1. When the error appears, please press the Print Screen key (PrtScn) on
your keyboard.
2. Click Start, click Run, type MSPAINT, and click OK.
3. In Paint, click Paste under the Edit Menu, click Save under the File
menu, type a file name for the snap shot, choose JPEG as "Save as type",
click "Desktop" on the left pane, and click Save.
Please send above files to me at v-adamqu@.microsoft.com
If anything is unclear in my post, please don't hesitate to let me know and
I will be glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
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.
--
| From: "Quintin Zammit" <qztarantino@.newsgroup.nospam>
| Subject: Establishing connection from SQL MMC fails
| Date: Wed, 26 Sep 2007 19:27:40 +0200
| Lines: 30
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 80.85.100.38
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26395
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
|
| I have Win2003 and SQL server 2000 installed. I have restarted SQL
services
| and the services crashed and could not be killed. I have killed the
| processes manually but when I open SQL Server Enterprise Manager, expand
SQL
| Server group and click on the desired SQL Server group it is failing and
the
| MMC becomes not responding.
|
| It fails on 'Establing connection to SQL Server and checking Windows
| security'
|
| I have tried to telnet on the respective SQL Server port and the port
| responds ok. I have also done a netstat and the server is listening on
the
| respective port.
|
| From the sql error logs, the following information is being logged
|
| 2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in
database
| 'msdb' (4)
| 2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
| 2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for
buffer
| latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID
4:2073058421:0,
| EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
| 2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
| 0x10000a, current owning EC 0x42CAC3F0.
|
| Your suggetions will be highly appreciated.
|
|
|
||||Dear Quintin,
I am just writing to see if you have had the opportunity to try the
troubleshooting steps or collect the requested information. If you have any
questions with the previous information I've provided, please don't
hesitate to let me know.
I appreciate your time and look forward to hearing from you.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
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.
| X-Tomcat-ID: 141089102
| References: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Thu, 27 Sep 2007 09:48:43 GMT
| Subject: RE: Establishing connection from SQL MMC fails
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <TcGwYuOAIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 126
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26437
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Quintin,
|
| Thank you for posting here.
|
| From the problem description, I understand that the error message
| "Establish connection to SQL Server and checking Windows security" is
| encountered when trying to connect to the SQL Server 2000 via the
| Enterprise Manage. If I have misunderstood about your concern, feel free
to
| let me know.
|
| Before moving on, I suggest that you try the following method to check if
| you could connect via osql.exe
|
| 1. Click Start, click Run, type cmd, and then click OK
| 2. At the command prompt, type the following command, and then press
ENTER.
|
|
| OSQL -E -S <server name>\<instance name>
| OSQL -E -S tcp:<computer name>,<port number>
|
| Also, you could try SQL authentication by using sa
|
| OSQL -S <server name>\<instance name> -Usa -P<password>
|
| 3. Please check if we can successfully connect to the instance of SQL
| Server 2000 by using osql.exe.
|
| If any error message appears, please let me know the extract error
message
| we received.
|
| Please also help me gather the following information for the further
| research:
|
| Information One: SQL MPS Report
| =====================| Please help create a MPSReport on the problematic machine, which will
| collect ERRORLOG, Windows event log and other helpful information about
the
| SQL Server. To create a MPSReport, please visit the following web site:
|
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
| 88B7-F9C79B7306C0&displaylang=en
|
| And look for MPSRPT_SQL.EXE. Download it and run it on the machine.
Dismiss
| the prompted dialog boxes and the readme window (usually a Notepad) after
| you read them. After the Command Prompt window closes itself, collect the
| cab file the tool has generated and sent it to me.
|
| Information Two: Screenshot
| =====================| Please also help me to capture a screenshot when the error message
| "Establish connection to SQL Server and checking Windows security"
appears.
|
| 1. When the error appears, please press the Print Screen key (PrtScn) on
| your keyboard.
| 2. Click Start, click Run, type MSPAINT, and click OK.
| 3. In Paint, click Paste under the Edit Menu, click Save under the File
| menu, type a file name for the snap shot, choose JPEG as "Save as type",
| click "Desktop" on the left pane, and click Save.
|
| Please send above files to me at v-adamqu@.microsoft.com
|
| If anything is unclear in my post, please don't hesitate to let me know
and
| I will be glad to help. Thank you for your efforts and time.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| 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.
|
| --
| | From: "Quintin Zammit" <qztarantino@.newsgroup.nospam>
| | Subject: Establishing connection from SQL MMC fails
| | Date: Wed, 26 Sep 2007 19:27:40 +0200
| | Lines: 30
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | X-RFC2646: Format=Flowed; Original
| | Message-ID: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: 80.85.100.38
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26395
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Hi,
| |
| | I have Win2003 and SQL server 2000 installed. I have restarted SQL
| services
| | and the services crashed and could not be killed. I have killed the
| | processes manually but when I open SQL Server Enterprise Manager,
expand
| SQL
| | Server group and click on the desired SQL Server group it is failing
and
| the
| | MMC becomes not responding.
| |
| | It fails on 'Establing connection to SQL Server and checking Windows
| | security'
| |
| | I have tried to telnet on the respective SQL Server port and the port
| | responds ok. I have also done a netstat and the server is listening on
| the
| | respective port.
| |
| | From the sql error logs, the following information is being logged
| |
| | 2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in
| database
| | 'msdb' (4)
| | 2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
| | 2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for
| buffer
| | latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID
| 4:2073058421:0,
| | EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
| | 2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
| | 0x10000a, current owning EC 0x42CAC3F0.
| |
| | Your suggetions will be highly appreciated.
| |
| |
| |
| |
|
|
I have Win2003 and SQL server 2000 installed. I have restarted SQL services
and the services crashed and could not be killed. I have killed the
processes manually but when I open SQL Server Enterprise Manager, expand SQL
Server group and click on the desired SQL Server group it is failing and the
MMC becomes not responding.
It fails on 'Establing connection to SQL Server and checking Windows
security'
I have tried to telnet on the respective SQL Server port and the port
responds ok. I have also done a netstat and the server is listening on the
respective port.
From the sql error logs, the following information is being logged
2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in database
'msdb' (4)
2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for buffer
latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID 4:2073058421:0,
EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
0x10000a, current owning EC 0x42CAC3F0.
Your suggetions will be highly appreciated.Dear Quintin,
Thank you for posting here.
From the problem description, I understand that the error message
"Establish connection to SQL Server and checking Windows security" is
encountered when trying to connect to the SQL Server 2000 via the
Enterprise Manage. If I have misunderstood about your concern, feel free to
let me know.
Before moving on, I suggest that you try the following method to check if
you could connect via osql.exe
1. Click Start, click Run, type cmd, and then click OK
2. At the command prompt, type the following command, and then press ENTER.
OSQL -E -S <server name>\<instance name>
OSQL -E -S tcp:<computer name>,<port number>
Also, you could try SQL authentication by using sa
OSQL -S <server name>\<instance name> -Usa -P<password>
3. Please check if we can successfully connect to the instance of SQL
Server 2000 by using osql.exe.
If any error message appears, please let me know the extract error message
we received.
Please also help me gather the following information for the further
research:
Information One: SQL MPS Report
=====================Please help create a MPSReport on the problematic machine, which will
collect ERRORLOG, Windows event log and other helpful information about the
SQL Server. To create a MPSReport, please visit the following web site:
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
88B7-F9C79B7306C0&displaylang=en
And look for MPSRPT_SQL.EXE. Download it and run it on the machine. Dismiss
the prompted dialog boxes and the readme window (usually a Notepad) after
you read them. After the Command Prompt window closes itself, collect the
cab file the tool has generated and sent it to me.
Information Two: Screenshot
=====================Please also help me to capture a screenshot when the error message
"Establish connection to SQL Server and checking Windows security" appears.
1. When the error appears, please press the Print Screen key (PrtScn) on
your keyboard.
2. Click Start, click Run, type MSPAINT, and click OK.
3. In Paint, click Paste under the Edit Menu, click Save under the File
menu, type a file name for the snap shot, choose JPEG as "Save as type",
click "Desktop" on the left pane, and click Save.
Please send above files to me at v-adamqu@.microsoft.com
If anything is unclear in my post, please don't hesitate to let me know and
I will be glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
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.
--
| From: "Quintin Zammit" <qztarantino@.newsgroup.nospam>
| Subject: Establishing connection from SQL MMC fails
| Date: Wed, 26 Sep 2007 19:27:40 +0200
| Lines: 30
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| X-RFC2646: Format=Flowed; Original
| Message-ID: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 80.85.100.38
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26395
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi,
|
| I have Win2003 and SQL server 2000 installed. I have restarted SQL
services
| and the services crashed and could not be killed. I have killed the
| processes manually but when I open SQL Server Enterprise Manager, expand
SQL
| Server group and click on the desired SQL Server group it is failing and
the
| MMC becomes not responding.
|
| It fails on 'Establing connection to SQL Server and checking Windows
| security'
|
| I have tried to telnet on the respective SQL Server port and the port
| responds ok. I have also done a netstat and the server is listening on
the
| respective port.
|
| From the sql error logs, the following information is being logged
|
| 2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in
database
| 'msdb' (4)
| 2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
| 2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for
buffer
| latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID
4:2073058421:0,
| EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
| 2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
| 0x10000a, current owning EC 0x42CAC3F0.
|
| Your suggetions will be highly appreciated.
|
|
|
||||Dear Quintin,
I am just writing to see if you have had the opportunity to try the
troubleshooting steps or collect the requested information. If you have any
questions with the previous information I've provided, please don't
hesitate to let me know.
I appreciate your time and look forward to hearing from you.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
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.
| X-Tomcat-ID: 141089102
| References: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Thu, 27 Sep 2007 09:48:43 GMT
| Subject: RE: Establishing connection from SQL MMC fails
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <TcGwYuOAIHA.5204@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 126
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26437
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Quintin,
|
| Thank you for posting here.
|
| From the problem description, I understand that the error message
| "Establish connection to SQL Server and checking Windows security" is
| encountered when trying to connect to the SQL Server 2000 via the
| Enterprise Manage. If I have misunderstood about your concern, feel free
to
| let me know.
|
| Before moving on, I suggest that you try the following method to check if
| you could connect via osql.exe
|
| 1. Click Start, click Run, type cmd, and then click OK
| 2. At the command prompt, type the following command, and then press
ENTER.
|
|
| OSQL -E -S <server name>\<instance name>
| OSQL -E -S tcp:<computer name>,<port number>
|
| Also, you could try SQL authentication by using sa
|
| OSQL -S <server name>\<instance name> -Usa -P<password>
|
| 3. Please check if we can successfully connect to the instance of SQL
| Server 2000 by using osql.exe.
|
| If any error message appears, please let me know the extract error
message
| we received.
|
| Please also help me gather the following information for the further
| research:
|
| Information One: SQL MPS Report
| =====================| Please help create a MPSReport on the problematic machine, which will
| collect ERRORLOG, Windows event log and other helpful information about
the
| SQL Server. To create a MPSReport, please visit the following web site:
|
http://www.microsoft.com/downloads/details.aspx?FamilyId=CEBF3C7C-7CA5-408F-
| 88B7-F9C79B7306C0&displaylang=en
|
| And look for MPSRPT_SQL.EXE. Download it and run it on the machine.
Dismiss
| the prompted dialog boxes and the readme window (usually a Notepad) after
| you read them. After the Command Prompt window closes itself, collect the
| cab file the tool has generated and sent it to me.
|
| Information Two: Screenshot
| =====================| Please also help me to capture a screenshot when the error message
| "Establish connection to SQL Server and checking Windows security"
appears.
|
| 1. When the error appears, please press the Print Screen key (PrtScn) on
| your keyboard.
| 2. Click Start, click Run, type MSPAINT, and click OK.
| 3. In Paint, click Paste under the Edit Menu, click Save under the File
| menu, type a file name for the snap shot, choose JPEG as "Save as type",
| click "Desktop" on the left pane, and click Save.
|
| Please send above files to me at v-adamqu@.microsoft.com
|
| If anything is unclear in my post, please don't hesitate to let me know
and
| I will be glad to help. Thank you for your efforts and time.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| 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.
|
| --
| | From: "Quintin Zammit" <qztarantino@.newsgroup.nospam>
| | Subject: Establishing connection from SQL MMC fails
| | Date: Wed, 26 Sep 2007 19:27:40 +0200
| | Lines: 30
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | X-RFC2646: Format=Flowed; Original
| | Message-ID: <eNQDMKGAIHA.4880@.TK2MSFTNGP03.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: 80.85.100.38
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:26395
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Hi,
| |
| | I have Win2003 and SQL server 2000 installed. I have restarted SQL
| services
| | and the services crashed and could not be killed. I have killed the
| | processes manually but when I open SQL Server Enterprise Manager,
expand
| SQL
| | Server group and click on the desired SQL Server group it is failing
and
| the
| | MMC becomes not responding.
| |
| | It fails on 'Establing connection to SQL Server and checking Windows
| | security'
| |
| | I have tried to telnet on the respective SQL Server port and the port
| | responds ok. I have also done a netstat and the server is listening on
| the
| | respective port.
| |
| | From the sql error logs, the following information is being logged
| |
| | 2007-09-26 16:45:04.32 spid8 63 transactions rolled forward in
| database
| | 'msdb' (4)
| | 2007-09-26 16:45:34.04 spid5 Starting up database 'tempdb'
| | 2007-09-26 16:50:33.06 spid8 Time out occurred while waiting for
| buffer
| | latch type 4,bp 0xf97e40, page 1:1508), stat 0x9, object ID
| 4:2073058421:0,
| | EC 0x42CAC3F0 : 0, waittime 3000. Continuing to wait.
| | 2007-09-26 16:50:33.06 spid8 Waiting for type 0x4, current count
| | 0x10000a, current owning EC 0x42CAC3F0.
| |
| | Your suggetions will be highly appreciated.
| |
| |
| |
| |
|
|
Monday, March 19, 2012
Errors on importing a text file
When a DTS fails on a Text Source input with an error like "DTS_Transformation encountered an invalid data value for 'Column1' destination"
Is there a way to get the line number of the textfile where the import failed? It is hard to determine where in my 40,000-line file it found the invalid value for my column.
Thanks,
AndrewSpecify the LOG file in Package Properties/Logging.|||WHere does it store the logs on the server?|||Wherever you would like it to be.|||I set the error log file to a text file on my esktop - it seems to repeat the same error message (without the line number) - am i missing something?
Is there a way to get the line number of the textfile where the import failed? It is hard to determine where in my 40,000-line file it found the invalid value for my column.
Thanks,
AndrewSpecify the LOG file in Package Properties/Logging.|||WHere does it store the logs on the server?|||Wherever you would like it to be.|||I set the error log file to a text file on my esktop - it seems to repeat the same error message (without the line number) - am i missing something?
Sunday, March 11, 2012
Errors in High-level Relational Engine and OLAP storage Engine
Hi all,,
Could someone help me out and explain to me why my two fact tables process successfully but the process still fails when i try to process the cube.
This is the detailed error message.
Ronald
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>FirstCube</DatabaseID>
<CubeID>MSCPROJECT</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Cube 'MSCPROJECT' completed successfully.
Start time: 6/20/2006 1:52:34 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:01
Processing Measure Group 'Patient Diagnosis' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Processing Partition 'Patient Diagnosis' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Processing Measure Group 'Prescription' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Processing Partition 'Prescription' completed successfully.
Start time: 6/20/2006 1:52:35 PM; End time: 6/20/2006 1:52:35 PM; Duration: 0:00:00
Errors and Warnings from Response
Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_Prescription' table or view. The Source property may not have been set.
Errors in the OLAP storage engine: An error occurred while processing the 'Prescription' partition of the 'Prescription' measure group for the 'MSCPROJECT' cube from the FirstCube database.
Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
Errors in the OLAP storage engine: An error occurred while processing the 'Patient Diagnosis' partition of the 'Patient Diagnosis' measure group for the 'MSCPROJECT' cube from the FirstCube database.
Check your DSV - data source view.
Looks like your DSV is missing 'dbo_Prescription' table.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi Edward,
It looks like as if I have dbo_Prescription table in my data source View.
I will check it out tomorrow morning and i will get back to you.
Thank you for your time.
Ronald
|||Hi Edward, In my data source view i have the dbo.Prescription table not dbo_Prescription.
Do these namings really matter.
Ronald
|||The naming is really important. Without you specifying names correctly Analysis Server has no idea how to construct a valid SQL query.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Edward,
In My data source view, I have the dbo.Prescription table. You know dbo.Prescription and dbo.PatientDiagnosis are my fact tables. I have failed to understand this since i have these two tables in my data source view.
Please help out.
Is this connected with SQL SERVER 2005 service pack1.
Ronald
Below is the same error i get when i process the cube.
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Parallel>
<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Object>
<DatabaseID>Analysis Services Project1</DatabaseID>
<CubeID>MSCPROJECT</CubeID>
</Object>
<Type>ProcessFull</Type>
<WriteBackTableCreation>UseExisting</WriteBackTableCreation>
</Process>
</Parallel>
</Batch>
Processing Dimension 'Initial Visit' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'Physician Id' completed successfully. 8 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_InitialVisit].[PhysicianId] AS [dbo_InitialVisitPhysicianId0_0]
FROM [dbo].[InitialVisit] AS [dbo_InitialVisit]
Processing Dimension Attribute 'Nurse ID' completed successfully. 7 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_InitialVisit].[NurseID] AS [dbo_InitialVisitNurseID0_0]
FROM [dbo].[InitialVisit] AS [dbo_InitialVisit]
Processing Dimension Attribute 'Initial Visit' completed successfully. 51 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_InitialVisit].[PatientId] AS [dbo_InitialVisitPatientId0_0],[dbo_InitialVisit].[Date] AS [dbo_InitialVisitDate0_1],[dbo_InitialVisit].[PhysicianId] AS [dbo_InitialVisitPhysicianId0_2],[dbo_InitialVisit].[NurseID] AS [dbo_InitialVisitNurseID0_3]
FROM [dbo].[InitialVisit] AS [dbo_InitialVisit]
Processing Dimension 'Project' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'Project Name' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Project].[ProjectName] AS [dbo_ProjectProjectName0_0]
FROM [dbo].[Project] AS [dbo_Project]
Processing Dimension Attribute 'Project' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Project].[ProjectId] AS [dbo_ProjectProjectId0_0],[dbo_Project].[ProjectName] AS [dbo_ProjectProjectName0_1]
FROM [dbo].[Project] AS [dbo_Project]
Processing Dimension 'Medicine Type' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'Name' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicineType].[Name] AS [dbo_MedicineTypeName0_0]
FROM [dbo].[MedicineType] AS [dbo_MedicineType]
Processing Dimension Attribute 'Medicine Type' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicineType].[MedicineTypeCode] AS [dbo_MedicineTypeMedicineTypeCode0_0],[dbo_MedicineType].[Name] AS [dbo_MedicineTypeName0_1]
FROM [dbo].[MedicineType] AS [dbo_MedicineType]
Processing Dimension 'Patient' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:20 AM; End time: 6/21/2006 11:59:20 AM; Duration: 0:00:00
Processing Dimension Attribute 'DateOfBirth' completed successfully. 49 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Patient].[DateOfBirth] AS [dbo_PatientDateOfBirth0_0]
FROM [dbo].[Patient] AS [dbo_Patient]
Processing Dimension Attribute 'Gender' completed successfully. 3 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Patient].[Gender] AS [dbo_PatientGender0_0]
FROM [dbo].[Patient] AS [dbo_Patient]
Processing Dimension Attribute 'PatientId' completed successfully. 50 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Patient].[PatientId] AS [dbo_PatientPatientId0_0],[dbo_Patient].[DateOfBirth] AS [dbo_PatientDateOfBirth0_1],[dbo_Patient].[Gender] AS [dbo_PatientGender0_2]
FROM [dbo].[Patient] AS [dbo_Patient]
Processing Hierarchy 'PatientId - DateOfBirth - Gender' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension 'Diagnosis' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Diagnosis Name' completed successfully. 5 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Diagnosis].[Diagnosis name] AS [dbo_DiagnosisDiagnosis_x0020_name0_0]
FROM [dbo].[Diagnosis] AS [dbo_Diagnosis]
Processing Dimension Attribute 'Description' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Diagnosis].[Description] AS [dbo_DiagnosisDescription0_0]
FROM [dbo].[Diagnosis] AS [dbo_Diagnosis]
Processing Dimension Attribute 'Diagnosis' completed successfully. 5 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Diagnosis].[DiagnosisCode] AS [dbo_DiagnosisDiagnosisCode0_0],[dbo_Diagnosis].[Diagnosis name] AS [dbo_DiagnosisDiagnosis_x0020_name0_1],[dbo_Diagnosis].[Description] AS [dbo_DiagnosisDescription0_2]
FROM [dbo].[Diagnosis] AS [dbo_Diagnosis]
Processing Dimension 'Medical Provider' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Name' completed successfully. 15 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[Name] AS [dbo_MedicalProviderName0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Gender' completed successfully. 3 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[Gender] AS [dbo_MedicalProviderGender0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Indicator Nurseor Physician' completed successfully. 4 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[IndicatorNurseorPhysician] AS [dbo_MedicalProviderIndicatorNurseorPhysician0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Physician Id' completed successfully. 9 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[PhysicianId] AS [dbo_MedicalProviderPhysicianId0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Nurse Id' completed successfully. 9 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[NurseId] AS [dbo_MedicalProviderNurseId0_0]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension Attribute 'Medical Provider' completed successfully. 15 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_MedicalProvider].[MedicalProviderId] AS [dbo_MedicalProviderMedicalProviderId0_0],[dbo_MedicalProvider].[Name] AS [dbo_MedicalProviderName0_1],[dbo_MedicalProvider].[Gender] AS [dbo_MedicalProviderGender0_2],[dbo_MedicalProvider].[IndicatorNurseorPhysician] AS [dbo_MedicalProviderIndicatorNurseorPhysician0_3],[dbo_MedicalProvider].[PhysicianId] AS [dbo_MedicalProviderPhysicianId0_4],[dbo_MedicalProvider].[NurseId] AS [dbo_MedicalProviderNurseId0_5]
FROM [dbo].[MedicalProvider] AS [dbo_MedicalProvider]
Processing Dimension 'Allergy' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Allergy Name' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Allergy].[AllergyName] AS [dbo_AllergyAllergyName0_0]
FROM [dbo].[Allergy] AS [dbo_Allergy]
Processing Dimension Attribute 'Allergy' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Allergy].[AllergyCode] AS [dbo_AllergyAllergyCode0_0],[dbo_Allergy].[AllergyName] AS [dbo_AllergyAllergyName0_1]
FROM [dbo].[Allergy] AS [dbo_Allergy]
Processing Dimension 'Medicine' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:21 AM; Duration: 0:00:00
Processing Dimension Attribute 'Name' completed successfully. 19 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Medicine].[Name] AS [dbo_MedicineName0_0]
FROM [dbo].[Medicine] AS [dbo_Medicine]
Processing Dimension Attribute 'Medicine' completed successfully. 20 rows have been read.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Medicine].[MedicineCode] AS [dbo_MedicineMedicineCode0_0],[dbo_Medicine].[Name] AS [dbo_MedicineName0_1]
FROM [dbo].[Medicine] AS [dbo_Medicine]
Processing Dimension 'Services' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:21 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:01
Processing Dimension Attribute 'Service Title' completed successfully. 36 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Services].[Service_Title] AS [dbo_ServicesService_Title0_0]
FROM [dbo].[Services] AS [dbo_Services]
Processing Dimension Attribute 'Service Order' completed successfully. 18 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Services].[Service_Order] AS [dbo_ServicesService_Order0_0]
FROM [dbo].[Services] AS [dbo_Services]
Processing Dimension Attribute 'Services' completed successfully. 36 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_Services].[ServiceId] AS [dbo_ServicesServiceId0_0],[dbo_Services].[Service_Title] AS [dbo_ServicesService_Title0_1],[dbo_Services].[Service_Order] AS [dbo_ServicesService_Order0_2]
FROM [dbo].[Services] AS [dbo_Services]
Processing Dimension 'Return Visit' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
Processing Dimension Attribute 'Physician Id' completed successfully. 8 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[PhysicianId] AS [dbo_ReturnVisitPhysicianId0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Nurse Id' completed successfully. 9 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[NurseId] AS [dbo_ReturnVisitNurseId0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Time Start' completed successfully. 11 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[TimeStart] AS [dbo_ReturnVisitTimeStart0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Time End' completed successfully. 22 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[TimeEnd] AS [dbo_ReturnVisitTimeEnd0_0]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension Attribute 'Return Visit' completed successfully. 50 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
SQL queries 1
SELECT
DISTINCT
[dbo_ReturnVisit].[PatientId] AS [dbo_ReturnVisitPatientId0_0],[dbo_ReturnVisit].[Date] AS [dbo_ReturnVisitDate0_1],[dbo_ReturnVisit].[PhysicianId] AS [dbo_ReturnVisitPhysicianId0_2],[dbo_ReturnVisit].[NurseId] AS [dbo_ReturnVisitNurseId0_3],[dbo_ReturnVisit].[TimeStart] AS [dbo_ReturnVisitTimeStart0_4],[dbo_ReturnVisit].[TimeEnd] AS [dbo_ReturnVisitTimeEnd0_5]
FROM [dbo].[ReturnVisit] AS [dbo_ReturnVisit]
Processing Dimension 'Severity' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
Processing Dimension Attribute '(All)' completed successfully.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:22 AM; Duration: 0:00:00
Processing Dimension Attribute 'Severity Name' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Severity].[SeverityName] AS [dbo_SeveritySeverityName0_0]
FROM [dbo].[Severity] AS [dbo_Severity]
Processing Dimension Attribute 'Severity' completed successfully. 6 rows have been read.
Start time: 6/21/2006 11:59:22 AM; End time: 6/21/2006 11:59:23 AM; Duration: 0:00:01
SQL queries 1
SELECT
DISTINCT
[dbo_Severity].[SeverityCode] AS [dbo_SeveritySeverityCode0_0],[dbo_Severity].[SeverityName] AS [dbo_SeveritySeverityName0_1]
FROM [dbo].[Severity] AS [dbo_Severity]
Processing Cube 'MSCPROJECT' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Measure Group 'Patient Diagnosis' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Partition 'Patient Diagnosis' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Measure Group 'Prescription' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Processing Partition 'Prescription' completed successfully.
Start time: 6/21/2006 11:59:23 AM; End time: 6/21/2006 11:59:24 AM; Duration: 0:00:01
Errors and Warnings from Response
Errors in the high-level relational engine. The data source view does not contain a definition for the 'dbo_Prescription' table or view. The Source property may not have been set.
Errors in the OLAP storage engine: An error occurred while processing the 'Prescription' partition of the 'Prescription' measure group for the 'MSCPROJECT' cube from the Analysis Services Project1 database.
Errors in the high-level relational engine. The database operation was cancelled because of an earlier failure.
Errors in the OLAP storage engine: An error occurred while processing the 'Patient Diagnosis' partition of the 'Patient Diagnosis' measure group for the 'MSCPROJECT' cube from the Analysis Services Project1 database.
Errors in connecting Visual Fox Pro as linked server in 2005 - HEL
I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when
trying to set up the linked server in 2005. I know the MS site says something
about leaking memory with the linked server but I don't even get a link that
works.
Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB from
MS site environment.
1) If I try to create a linked server from the management studio, it says:
'(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
There are only three fields to fill out and product name is not required when
I try to make the linked server in 2000.
2) If I use a SQL command to create the linked server, I can make it without
the product name but it does not work in 2005 but does in 2000.
sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
Looking for thoughts on how to troubleshoot this!!
Doug Hoogervorst
Think I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server 2003
is not showing VFPOLEDB as a component when I run the component checker. I
have tried regsvr32 to register the dll but no luck. Thoughts on how to get
MDAC to recognize this OLE DB provider?
"djh" wrote:
> I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when
> trying to set up the linked server in 2005. I know the MS site says something
> about leaking memory with the linked server but I don't even get a link that
> works.
> Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB from
> MS site environment.
> 1) If I try to create a linked server from the management studio, it says:
> '(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
> There are only three fields to fill out and product name is not required when
> I try to make the linked server in 2000.
> 2) If I use a SQL command to create the linked server, I can make it without
> the product name but it does not work in 2005 but does in 2000.
> sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
> Looking for thoughts on how to troubleshoot this!!
> Doug Hoogervorst
|||Hi Doug,
As you know, the FoxPro and Visual FoxPro OLE DB data provider is not
installed with MDAC. For the record, it's downloadable from
msdn.microsoft.com/downloads/updates. If you already have it you might want
to verify that you've got the latest version.
Here's what works for me in SQL 2005 using the Linked Server dialog:
Providers list: VFPOLEDB shows as an entry
Linked Servers > New Linked Server ...
Linked Server: MyLinkedServer
Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro
Product name: Visual FoxPro (I think this is optional)
Data source: "C:\Program Files\Microsoft Visual
FoxPro9\Samples\Northwind\Northwind.dbc" (Include quotes since there's
spaces in the string.)
Provider string: VFPOLEDB.1
Location: (blank)
Catalog: (blank)
Security page and Server Options page take defaults.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"djh" <djh@.discussions.microsoft.com> wrote in message
news:F93EBC44-2A78-4801-8DB0-C35F13CE876B@.microsoft.com...[vbcol=seagreen]
> Think I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server
> 2003
> is not showing VFPOLEDB as a component when I run the component checker. I
> have tried regsvr32 to register the dll but no luck. Thoughts on how to
> get
> MDAC to recognize this OLE DB provider?
>
> "djh" wrote:
trying to set up the linked server in 2005. I know the MS site says something
about leaking memory with the linked server but I don't even get a link that
works.
Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB from
MS site environment.
1) If I try to create a linked server from the management studio, it says:
'(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
There are only three fields to fill out and product name is not required when
I try to make the linked server in 2000.
2) If I use a SQL command to create the linked server, I can make it without
the product name but it does not work in 2005 but does in 2000.
sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
Looking for thoughts on how to troubleshoot this!!
Doug Hoogervorst
Think I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server 2003
is not showing VFPOLEDB as a component when I run the component checker. I
have tried regsvr32 to register the dll but no luck. Thoughts on how to get
MDAC to recognize this OLE DB provider?
"djh" wrote:
> I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when
> trying to set up the linked server in 2005. I know the MS site says something
> about leaking memory with the linked server but I don't even get a link that
> works.
> Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB from
> MS site environment.
> 1) If I try to create a linked server from the management studio, it says:
> '(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
> There are only three fields to fill out and product name is not required when
> I try to make the linked server in 2000.
> 2) If I use a SQL command to create the linked server, I can make it without
> the product name but it does not work in 2005 but does in 2000.
> sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
> Looking for thoughts on how to troubleshoot this!!
> Doug Hoogervorst
|||Hi Doug,
As you know, the FoxPro and Visual FoxPro OLE DB data provider is not
installed with MDAC. For the record, it's downloadable from
msdn.microsoft.com/downloads/updates. If you already have it you might want
to verify that you've got the latest version.
Here's what works for me in SQL 2005 using the Linked Server dialog:
Providers list: VFPOLEDB shows as an entry
Linked Servers > New Linked Server ...
Linked Server: MyLinkedServer
Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro
Product name: Visual FoxPro (I think this is optional)
Data source: "C:\Program Files\Microsoft Visual
FoxPro9\Samples\Northwind\Northwind.dbc" (Include quotes since there's
spaces in the string.)
Provider string: VFPOLEDB.1
Location: (blank)
Catalog: (blank)
Security page and Server Options page take defaults.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"djh" <djh@.discussions.microsoft.com> wrote in message
news:F93EBC44-2A78-4801-8DB0-C35F13CE876B@.microsoft.com...[vbcol=seagreen]
> Think I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server
> 2003
> is not showing VFPOLEDB as a component when I run the component checker. I
> have tried regsvr32 to register the dll but no luck. Thoughts on how to
> get
> MDAC to recognize this OLE DB provider?
>
> "djh" wrote:
Errors in connecting Visual Fox Pro as linked server in 2005 - HEL
I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when
trying to set up the linked server in 2005. I know the MS site says somethin
g
about leaking memory with the linked server but I don't even get a link that
works.
Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB from
MS site environment.
1) If I try to create a linked server from the management studio, it says:
'(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
There are only three fields to fill out and product name is not required whe
n
I try to make the linked server in 2000.
2) If I use a SQL command to create the linked server, I can make it without
the product name but it does not work in 2005 but does in 2000.
sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
Looking for thoughts on how to troubleshoot this!!
Doug HoogervorstThink I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server 200
3
is not showing VFPOLEDB as a component when I run the component checker. I
have tried regsvr32 to register the dll but no luck. Thoughts on how to get
MDAC to recognize this OLE DB provider?
"djh" wrote:
> I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when
> trying to set up the linked server in 2005. I know the MS site says someth
ing
> about leaking memory with the linked server but I don't even get a link th
at
> works.
> Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB fr
om
> MS site environment.
> 1) If I try to create a linked server from the management studio, it says:
> '(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
> There are only three fields to fill out and product name is not required w
hen
> I try to make the linked server in 2000.
> 2) If I use a SQL command to create the linked server, I can make it witho
ut
> the product name but it does not work in 2005 but does in 2000.
> sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
> Looking for thoughts on how to troubleshoot this!!
> Doug Hoogervorst|||Hi Doug,
As you know, the FoxPro and Visual FoxPro OLE DB data provider is not
installed with MDAC. For the record, it's downloadable from
msdn.microsoft.com/downloads/updates. If you already have it you might want
to verify that you've got the latest version.
Here's what works for me in SQL 2005 using the Linked Server dialog:
Providers list: VFPOLEDB shows as an entry
Linked Servers > New Linked Server ...
Linked Server: MyLinkedServer
Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro
Product name: Visual FoxPro (I think this is optional)
Data source: "C:\Program Files\Microsoft Visual
FoxPro9\Samples\Northwind\Northwind.dbc" (Include quotes since there's
spaces in the string.)
Provider string: VFPOLEDB.1
Location: (blank)
Catalog: (blank)
Security page and Server Options page take defaults.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"djh" <djh@.discussions.microsoft.com> wrote in message
news:F93EBC44-2A78-4801-8DB0-C35F13CE876B@.microsoft.com...[vbcol=seagreen]
> Think I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server
> 2003
> is not showing VFPOLEDB as a component when I run the component checker. I
> have tried regsvr32 to register the dll but no luck. Thoughts on how to
> get
> MDAC to recognize this OLE DB provider?
>
> "djh" wrote:
>
trying to set up the linked server in 2005. I know the MS site says somethin
g
about leaking memory with the linked server but I don't even get a link that
works.
Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB from
MS site environment.
1) If I try to create a linked server from the management studio, it says:
'(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
There are only three fields to fill out and product name is not required whe
n
I try to make the linked server in 2000.
2) If I use a SQL command to create the linked server, I can make it without
the product name but it does not work in 2005 but does in 2000.
sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
Looking for thoughts on how to troubleshoot this!!
Doug HoogervorstThink I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server 200
3
is not showing VFPOLEDB as a component when I run the component checker. I
have tried regsvr32 to register the dll but no luck. Thoughts on how to get
MDAC to recognize this OLE DB provider?
"djh" wrote:
> I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when
> trying to set up the linked server in 2005. I know the MS site says someth
ing
> about leaking memory with the linked server but I don't even get a link th
at
> works.
> Here is what happens in a Win2003Server, SQLServer2005, latest VFPOLEDB fr
om
> MS site environment.
> 1) If I try to create a linked server from the management studio, it says:
> '(null)' is an invalid product name. (Microsoft SQL Server, Error: 15429).
> There are only three fields to fill out and product name is not required w
hen
> I try to make the linked server in 2000.
> 2) If I use a SQL command to create the linked server, I can make it witho
ut
> the product name but it does not work in 2005 but does in 2000.
> sp_addlinkedserver 'SERVER1', '', 'VFPOLEDB', 'c:\company.dbc'
> Looking for thoughts on how to troubleshoot this!!
> Doug Hoogervorst|||Hi Doug,
As you know, the FoxPro and Visual FoxPro OLE DB data provider is not
installed with MDAC. For the record, it's downloadable from
msdn.microsoft.com/downloads/updates. If you already have it you might want
to verify that you've got the latest version.
Here's what works for me in SQL 2005 using the Linked Server dialog:
Providers list: VFPOLEDB shows as an entry
Linked Servers > New Linked Server ...
Linked Server: MyLinkedServer
Provider: Choose "Microsoft OLE DB Provider for Visual FoxPro
Product name: Visual FoxPro (I think this is optional)
Data source: "C:\Program Files\Microsoft Visual
FoxPro9\Samples\Northwind\Northwind.dbc" (Include quotes since there's
spaces in the string.)
Provider string: VFPOLEDB.1
Location: (blank)
Catalog: (blank)
Security page and Server Options page take defaults.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
"djh" <djh@.discussions.microsoft.com> wrote in message
news:F93EBC44-2A78-4801-8DB0-C35F13CE876B@.microsoft.com...[vbcol=seagreen]
> Think I am closer now. It turns out that MDAC 2.8 SP2 for Windows Server
> 2003
> is not showing VFPOLEDB as a component when I run the component checker. I
> have tried regsvr32 to register the dll but no luck. Thoughts on how to
> get
> MDAC to recognize this OLE DB provider?
>
> "djh" wrote:
>
Subscribe to:
Posts (Atom)