| Author |
Topic |
|
eem_2055
Yak Posting Veteran
69 Posts |
 Posted - 2007-09-12 : 05:54:02
|
| Guys I have a big problem now. My company is using manual now. since our system failed to update our database. during validation our application gives a message which is successfully save but there's no changes happened. OUr program is working for 1 year and 5 months. Our database size is 4.72 GB and our memory is 1GB. Do you think our problem is inline with memory or the software we used? |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-12 : 05:57:15
|
| nope...1. check if there are explict permission denies on insert or update or people have permission to do so since the apps handled it before2. check if the database files are set to limited growth3. check if the database files are fullwill post more once you give us more information--------------------keeping it simple... |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-12 : 05:58:45
|
| opps software? like 3rd party tool? maybe... licensing renewal? but if you do it directly permissions is the likely problem--------------------keeping it simple... |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-09-12 : 06:06:18
|
| It's really my problem since I am a new system admin of this company and our system was outsourced. Then the support has been broken until now. So, all the users here used manual. Runtime error is our major problem before. I thought that the querying they did was poor, that's why thousands of records cannot be updated. |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-09-12 : 06:07:48
|
| Jen are you online now? Can we chat using YM? |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-09-12 : 06:11:09
|
| 1. check if there are explict permission denies on insert or update or people have permission to do so since the apps handled it before2. check if the database files are set to limited growth3. check if the database files are fullI don't know this can you elaborate more? |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-09-12 : 06:18:00
|
| Jen database file is not full and not limited to growth. As a matter of fact batch transactions are done but our proble is very slow. 28 records has been successfully save after 45 mins. Before it's just 5 minutes. Then some other process are not working. Is there anything that I must do? We have 460 tables in our software using SQL server 2000 and our application is using VB 6.0 |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-12 : 06:31:12
|
| I see... your problem is the work flow of the 3rd party softwareand usually for ready-made solutions, this flow is abstracted from the users... so there might be some referencing tables that are not updated and some just don't get committed due to missing conditionsBut if you have that documentation on how things are done, atleast basic transactions, that would really help you a lotdon't you have any support from the company where you brought the software?--------------------keeping it simple... |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-09-12 : 06:40:33
|
| We do not have any support now! almost 9 months. According to the users, they used the system with errors and the provider said that they can fix the error. our application now is not up to date. |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-12 : 06:44:17
|
| well you really can't expect us to reverse engineer the application?in any case, others might be able to help you... good luckoh, btw no use in posting new threads for the same topic, it'll get locked down eventuallygood luck--------------------keeping it simple... |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-09-12 : 07:31:26
|
| Okay thanks for your time! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 22:28:32
|
| Do you have specific error message? Is it sql2k? |
|
|
|
|
SQL cannot update database