| Author |
Topic |
|
rajesh1207
Starting Member
3 Posts |
 Posted - 2009-12-28 : 07:52:19
|
| We are trying to access the table in SQL server database through the JAVA program. While accessing the table, it is generating the .tmp file and it is getting increased some time. After some time process is getting killed and resulting with error as [SQLServer JDBC Driver]Usage error for UtilPagedTempBuffer: offset can not be negative.Anyone can please let us know the prob?Thanks,Rajesh |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
|
|
rajesh1207
Starting Member
3 Posts |
Posted - 2009-12-29 : 06:39:45
|
quote:
Originally posted by vijayisonly
Have a look at this link.http://support.microsoft.com/kb/817326I dont think its your exact scenario, but the problem cud be same.
Hi Vijay,Thanks for the reply. But the issue is not exactly that mentioned in the link. When we access the table with huge data, the tmp file is generating. The table contains around 4GB. After around 1.6 GB process is getting killed. Please help me out if you have any idea on this. |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-29 : 06:50:35
|
| what are you actually trying to do with the connection?Are you trying to pull back the whole table? If so then you'd be much better off using some of the bulk import / extract tools (bcp, ect).I'm geussing you are getting a timeout on your connections or a thread pool limit.Check the database with sp_who2 while making the connection. Could be a blocking job also.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
rajesh1207
Starting Member
3 Posts |
Posted - 2009-12-29 : 07:29:16
|
quote:
Originally posted by Transact Charlie
what are you actually trying to do with the connection?Are you trying to pull back the whole table? If so then you'd be much better off using some of the bulk import / extract tools (bcp, ect).I'm geussing you are getting a timeout on your connections or a thread pool limit.Check the database with sp_who2 while making the connection. Could be a blocking job also.Hi Chrlie,Thanks for the reply. Just we are trying to run a third party tool which copies the SQL schema to Oracle. We observed that in the tool it self is trying get all the table data at a time. It generates a tmp file while accessing the table. We assumed like, the problem with the buffer cache. Please help me how to resolve this.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
|
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-12-29 : 09:03:58
|
| you could mount the database somewhere with a different name from the latest backup, delete all the information from the database (or maybe this particular table if you've isolated it down to that table). Run the tool to copy the schema and then bulk export the original data into the new database.Apart from that suggestion then obviously contact the third party vendor.Don't think I can be much more help.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
behrman
Yak Posting Veteran
76 Posts |
|
|
|
Buffer Cache issue