Hi,
I am having a really strange situation in my database, where a table
seems "clogged" until I manually insert a row to that table using
Enterprise Manager.
I have MSMQ set up so that it receives transactions pending for
insertion. When someone complains that is not seeing data in the apps, i
see that the MSMQ is loaded with data. As part of the troubleshooting, i
start testing connnections and test queries to diagnose the problem.
However, as soon as I insert a row to the problematic table, the MSMQ
empties agaig
Can you please give me some light regarding this problem'
Thanks, and Happy Thanksgiving.
--eval
Until then The database starts timing outHave you looked to see if someone is blocking the table? It's possable you
began a transaction with EM some how and didn't commit it. I have seen
similiar issues when people use EM to view the rows and if you touch any of
the data it can put a lock that you are not aware of.
Andrew J. Kelly SQL MVP
"eval" <eval@.eval.com> wrote in message
news:%23wL3JUj0EHA.3840@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having a really strange situation in my database, where a table seems
> "clogged" until I manually insert a row to that table using Enterprise
> Manager.
> I have MSMQ set up so that it receives transactions pending for insertion.
> When someone complains that is not seeing data in the apps, i see that the
> MSMQ is loaded with data. As part of the troubleshooting, i start testing
> connnections and test queries to diagnose the problem. However, as soon as
> I insert a row to the problematic table, the MSMQ empties agaig
> Can you please give me some light regarding this problem'
> Thanks, and Happy Thanksgiving.
> --eval
> Until then The database starts timing out|||Actually it has happened sporadically in the past several weeks, and
happens when no one is connected to the database (usually very early in
the morning).
Andrew J. Kelly wrote:
> Have you looked to see if someone is blocking the table? It's possable yo
u
> began a transaction with EM some how and didn't commit it. I have seen
> similiar issues when people use EM to view the rows and if you touch any o
f
> the data it can put a lock that you are not aware of.
>|||"eval" <eval@.eval.com> wrote in message
news:elZKNlj0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Actually it has happened sporadically in the past several weeks, and
> happens when no one is connected to the database (usually very early in
> the morning).
>
Next time it happens, before you do your "fix" check for blocking.
At the very least a sp_who2 may give you some useful info.
[vbcol=seagreen]
> Andrew J. Kelly wrote:
you[vbcol=seagreen]
of[vbcol=seagreen]
Saturday, February 25, 2012
Clogged Database?
Hi,
I am having a really strange situation in my database, where a table
seems "clogged" until I manually insert a row to that table using
Enterprise Manager.
I have MSMQ set up so that it receives transactions pending for
insertion. When someone complains that is not seeing data in the apps, i
see that the MSMQ is loaded with data. As part of the troubleshooting, i
start testing connnections and test queries to diagnose the problem.
However, as soon as I insert a row to the problematic table, the MSMQ
empties agaig
Can you please give me some light regarding this problem?
Thanks, and Happy Thanksgiving.
--eval
Until then The database starts timing out
Have you looked to see if someone is blocking the table? It's possable you
began a transaction with EM some how and didn't commit it. I have seen
similiar issues when people use EM to view the rows and if you touch any of
the data it can put a lock that you are not aware of.
Andrew J. Kelly SQL MVP
"eval" <eval@.eval.com> wrote in message
news:%23wL3JUj0EHA.3840@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having a really strange situation in my database, where a table seems
> "clogged" until I manually insert a row to that table using Enterprise
> Manager.
> I have MSMQ set up so that it receives transactions pending for insertion.
> When someone complains that is not seeing data in the apps, i see that the
> MSMQ is loaded with data. As part of the troubleshooting, i start testing
> connnections and test queries to diagnose the problem. However, as soon as
> I insert a row to the problematic table, the MSMQ empties agaig
> Can you please give me some light regarding this problem?
> Thanks, and Happy Thanksgiving.
> --eval
> Until then The database starts timing out
|||Actually it has happened sporadically in the past several weeks, and
happens when no one is connected to the database (usually very early in
the morning).
Andrew J. Kelly wrote:
> Have you looked to see if someone is blocking the table? It's possable you
> began a transaction with EM some how and didn't commit it. I have seen
> similiar issues when people use EM to view the rows and if you touch any of
> the data it can put a lock that you are not aware of.
>
|||"eval" <eval@.eval.com> wrote in message
news:elZKNlj0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Actually it has happened sporadically in the past several weeks, and
> happens when no one is connected to the database (usually very early in
> the morning).
>
Next time it happens, before you do your "fix" check for blocking.
At the very least a sp_who2 may give you some useful info.
[vbcol=seagreen]
> Andrew J. Kelly wrote:
you[vbcol=seagreen]
of[vbcol=seagreen]
I am having a really strange situation in my database, where a table
seems "clogged" until I manually insert a row to that table using
Enterprise Manager.
I have MSMQ set up so that it receives transactions pending for
insertion. When someone complains that is not seeing data in the apps, i
see that the MSMQ is loaded with data. As part of the troubleshooting, i
start testing connnections and test queries to diagnose the problem.
However, as soon as I insert a row to the problematic table, the MSMQ
empties agaig
Can you please give me some light regarding this problem?
Thanks, and Happy Thanksgiving.
--eval
Until then The database starts timing out
Have you looked to see if someone is blocking the table? It's possable you
began a transaction with EM some how and didn't commit it. I have seen
similiar issues when people use EM to view the rows and if you touch any of
the data it can put a lock that you are not aware of.
Andrew J. Kelly SQL MVP
"eval" <eval@.eval.com> wrote in message
news:%23wL3JUj0EHA.3840@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having a really strange situation in my database, where a table seems
> "clogged" until I manually insert a row to that table using Enterprise
> Manager.
> I have MSMQ set up so that it receives transactions pending for insertion.
> When someone complains that is not seeing data in the apps, i see that the
> MSMQ is loaded with data. As part of the troubleshooting, i start testing
> connnections and test queries to diagnose the problem. However, as soon as
> I insert a row to the problematic table, the MSMQ empties agaig
> Can you please give me some light regarding this problem?
> Thanks, and Happy Thanksgiving.
> --eval
> Until then The database starts timing out
|||Actually it has happened sporadically in the past several weeks, and
happens when no one is connected to the database (usually very early in
the morning).
Andrew J. Kelly wrote:
> Have you looked to see if someone is blocking the table? It's possable you
> began a transaction with EM some how and didn't commit it. I have seen
> similiar issues when people use EM to view the rows and if you touch any of
> the data it can put a lock that you are not aware of.
>
|||"eval" <eval@.eval.com> wrote in message
news:elZKNlj0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Actually it has happened sporadically in the past several weeks, and
> happens when no one is connected to the database (usually very early in
> the morning).
>
Next time it happens, before you do your "fix" check for blocking.
At the very least a sp_who2 may give you some useful info.
[vbcol=seagreen]
> Andrew J. Kelly wrote:
you[vbcol=seagreen]
of[vbcol=seagreen]
Clogged Database?
Hi,
I am having a really strange situation in my database, where a table
seems "clogged" until I manually insert a row to that table using
Enterprise Manager.
I have MSMQ set up so that it receives transactions pending for
insertion. When someone complains that is not seeing data in the apps, i
see that the MSMQ is loaded with data. As part of the troubleshooting, i
start testing connnections and test queries to diagnose the problem.
However, as soon as I insert a row to the problematic table, the MSMQ
empties agaig
Can you please give me some light regarding this problem'
Thanks, and Happy Thanksgiving.
--eval
Until then The database starts timing outHave you looked to see if someone is blocking the table? It's possable you
began a transaction with EM some how and didn't commit it. I have seen
similiar issues when people use EM to view the rows and if you touch any of
the data it can put a lock that you are not aware of.
--
Andrew J. Kelly SQL MVP
"eval" <eval@.eval.com> wrote in message
news:%23wL3JUj0EHA.3840@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having a really strange situation in my database, where a table seems
> "clogged" until I manually insert a row to that table using Enterprise
> Manager.
> I have MSMQ set up so that it receives transactions pending for insertion.
> When someone complains that is not seeing data in the apps, i see that the
> MSMQ is loaded with data. As part of the troubleshooting, i start testing
> connnections and test queries to diagnose the problem. However, as soon as
> I insert a row to the problematic table, the MSMQ empties agaig
> Can you please give me some light regarding this problem'
> Thanks, and Happy Thanksgiving.
> --eval
> Until then The database starts timing out|||Actually it has happened sporadically in the past several weeks, and
happens when no one is connected to the database (usually very early in
the morning).
Andrew J. Kelly wrote:
> Have you looked to see if someone is blocking the table? It's possable you
> began a transaction with EM some how and didn't commit it. I have seen
> similiar issues when people use EM to view the rows and if you touch any of
> the data it can put a lock that you are not aware of.
>|||"eval" <eval@.eval.com> wrote in message
news:elZKNlj0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Actually it has happened sporadically in the past several weeks, and
> happens when no one is connected to the database (usually very early in
> the morning).
>
Next time it happens, before you do your "fix" check for blocking.
At the very least a sp_who2 may give you some useful info.
> Andrew J. Kelly wrote:
> > Have you looked to see if someone is blocking the table? It's possable
you
> > began a transaction with EM some how and didn't commit it. I have seen
> > similiar issues when people use EM to view the rows and if you touch any
of
> > the data it can put a lock that you are not aware of.
> >
I am having a really strange situation in my database, where a table
seems "clogged" until I manually insert a row to that table using
Enterprise Manager.
I have MSMQ set up so that it receives transactions pending for
insertion. When someone complains that is not seeing data in the apps, i
see that the MSMQ is loaded with data. As part of the troubleshooting, i
start testing connnections and test queries to diagnose the problem.
However, as soon as I insert a row to the problematic table, the MSMQ
empties agaig
Can you please give me some light regarding this problem'
Thanks, and Happy Thanksgiving.
--eval
Until then The database starts timing outHave you looked to see if someone is blocking the table? It's possable you
began a transaction with EM some how and didn't commit it. I have seen
similiar issues when people use EM to view the rows and if you touch any of
the data it can put a lock that you are not aware of.
--
Andrew J. Kelly SQL MVP
"eval" <eval@.eval.com> wrote in message
news:%23wL3JUj0EHA.3840@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I am having a really strange situation in my database, where a table seems
> "clogged" until I manually insert a row to that table using Enterprise
> Manager.
> I have MSMQ set up so that it receives transactions pending for insertion.
> When someone complains that is not seeing data in the apps, i see that the
> MSMQ is loaded with data. As part of the troubleshooting, i start testing
> connnections and test queries to diagnose the problem. However, as soon as
> I insert a row to the problematic table, the MSMQ empties agaig
> Can you please give me some light regarding this problem'
> Thanks, and Happy Thanksgiving.
> --eval
> Until then The database starts timing out|||Actually it has happened sporadically in the past several weeks, and
happens when no one is connected to the database (usually very early in
the morning).
Andrew J. Kelly wrote:
> Have you looked to see if someone is blocking the table? It's possable you
> began a transaction with EM some how and didn't commit it. I have seen
> similiar issues when people use EM to view the rows and if you touch any of
> the data it can put a lock that you are not aware of.
>|||"eval" <eval@.eval.com> wrote in message
news:elZKNlj0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> Actually it has happened sporadically in the past several weeks, and
> happens when no one is connected to the database (usually very early in
> the morning).
>
Next time it happens, before you do your "fix" check for blocking.
At the very least a sp_who2 may give you some useful info.
> Andrew J. Kelly wrote:
> > Have you looked to see if someone is blocking the table? It's possable
you
> > began a transaction with EM some how and didn't commit it. I have seen
> > similiar issues when people use EM to view the rows and if you touch any
of
> > the data it can put a lock that you are not aware of.
> >
Clocking Report
Hi,
I have to report the clocking for our company employees. The main clocking table is just employee number & Date/Time clocked. An employee can have any number of clockings per day.
Would it be possible to create a select statement so that there is just 1 row per day for each employee?
[Table Rows]
piet, 2007-02-23 07:59
piet, 2007-02-23 13:01
piet, 2007-02-23 13:55
piet, 2007-02-23 16:35
[Result for SQL statment]
Piet, 2007-02-23, 07:59, 13:01, 13:55, 16:35
Any help will appreciated.
Thanks
Search for Dynamic Pivot and you will find solutions for problems similiar to your post.Clob fields
Hi folks,
I try to fetch some data which contains a clob field, nut
infortnatly I always get this error message:
[Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data
conversion
Anyone got an idea why and what I could do?
Storing data with my program and creating some clob data
works fine
Thx mates
- MAXX
| Content-Class: urn:content-classes:message
| From: "MAXX" <anonymous@.discussions.microsoft.com>
| Sender: "MAXX" <anonymous@.discussions.microsoft.com>
| Subject: Clob fields
| Date: Wed, 16 Jun 2004 00:46:09 -0700
| Lines: 15
| Message-ID: <1cce401c45375$fd39d000$a601280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcRTdf05/QBYPISzRweeDMzhVrkd7g==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6108
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi folks,
|
| I try to fetch some data which contains a clob field, nut
| infortnatly I always get this error message:
| [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data
| conversion
|
| Anyone got an idea why and what I could do?
|
| Storing data with my program and creating some clob data
| works fine
|
| Thx mates
|
| - MAXX
|
Hello,
The Microsoft JDBC driver does not support getBlob/getClob. Unfortunately,
the error message does not accurately reflect this point. We are aware of
this problem and plan to address this sometime in the future. You will
have to use a different JDBC driver in order to retrieve BLOB/CLOB data.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
I try to fetch some data which contains a clob field, nut
infortnatly I always get this error message:
[Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data
conversion
Anyone got an idea why and what I could do?
Storing data with my program and creating some clob data
works fine
Thx mates
- MAXX
| Content-Class: urn:content-classes:message
| From: "MAXX" <anonymous@.discussions.microsoft.com>
| Sender: "MAXX" <anonymous@.discussions.microsoft.com>
| Subject: Clob fields
| Date: Wed, 16 Jun 2004 00:46:09 -0700
| Lines: 15
| Message-ID: <1cce401c45375$fd39d000$a601280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| thread-index: AcRTdf05/QBYPISzRweeDMzhVrkd7g==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.jdbcdriver:6108
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.sqlserver.jdbcdriver
|
| Hi folks,
|
| I try to fetch some data which contains a clob field, nut
| infortnatly I always get this error message:
| [Microsoft][SQLServer 2000 Driver for JDBC]Unsupported data
| conversion
|
| Anyone got an idea why and what I could do?
|
| Storing data with my program and creating some clob data
| works fine
|
| Thx mates
|
| - MAXX
|
Hello,
The Microsoft JDBC driver does not support getBlob/getClob. Unfortunately,
the error message does not accurately reflect this point. We are aware of
this problem and plan to address this sometime in the future. You will
have to use a different JDBC driver in order to retrieve BLOB/CLOB data.
Carb Simien, MCSE MCDBA MCAD
Microsoft Developer Support - Web Data
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
CLOB & BLOB with microsoft JDBC driver ?
The microsoft JDBC driver doesn't accept CLOB & BLOB field.
Does anyone know about this problem ?
Is it possible to found another driver that works correctly and that is free ?
Thank'swhich driver u r using ?
is it jdbc-odbc.|||Sorry, I'm talking about TEXT object, and if i use the term BLOB it is for large binary object.
Do you know about my problem ?
Does anyone know about this problem ?
Is it possible to found another driver that works correctly and that is free ?
Thank'swhich driver u r using ?
is it jdbc-odbc.|||Sorry, I'm talking about TEXT object, and if i use the term BLOB it is for large binary object.
Do you know about my problem ?
CLM
Can someone send me the link to the primary Sql Server (2000 preferably) MS forum? Or is this it?You can certainly post your SQL Server 2000 questions here. You might also take a look at this site http://www.microsoft.com/technet/community/newsgroups/server/sql.mspx for additional newsgroup resources.
Subscribe to:
Posts (Atom)