Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rashah
Starting Member
5 Posts |
 Posted - 2010-12-24 : 00:33:40
|
| In production Environment some records are not getting inserted in to one table when we received file from multiple sources and storing those records in to the table.But when the same file I uploaded in to the other environment like SIT,UAT the file getting uplaoded and records got insertd in to the table..I am not able to find why this kind of weird behavior between the two environment??Can any one please suggest me the way??What I should do? After All it is the question of production data which will be soon used as Live by client |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-24 : 00:40:21
|
| No one knows what kind of enviroment you are working on what is its setup.So the answer for your question is not as simple as comparing an apple with another apple.Post the exact queries you are using to upload your files.PBUH |
 |
|
|
rashah
Starting Member
5 Posts |
Posted - 2010-12-24 : 00:48:26
|
| Ya Its very difficult I also Know that..I am using same type of procedure where We insert the record in to the table. Simple procedure which insert in to the table.In other environment records got inserted but in Production environment its not.. |
|
|
|
rashah
Starting Member
5 Posts |
Posted - 2010-12-24 : 01:12:11
|
| Hey guys..I Know its very tough But..Give me at least a clue.. |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-12-24 : 03:56:48
|
| One of the possibility is schema difference.Compare the schema of table (triggers, if they exist) for both environment. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-24 : 05:04:28
|
| "In production Environment some records are not getting inserted in to one table when we received file from multiple sources and storing those records in to the table"Error Handling needs to be in place to detect the failure, and then "log it" - that will then give a clue as to the cause.If there is no error detected then ALSO log all Success so you can determine the actual flow of data.You may also want to put a TRIGGER on the table in case the row is being deleted later (i.e. INSERT was successful, but subsequent DELETE occurred). Trigger can be used to "log" all changes (INSERT / UPDATE / DELETE) to determine the Sequence that changes occurred and the exact DATE/TIME they occurred (and also the SUSER or alternative) |
|
|
|
rashah
Starting Member
5 Posts |
Posted - 2010-12-27 : 11:40:02
|
| How I can create and write into a log file in stored procedure??This is because I want to trace the error,If thier is any error while inserting records in to the table than I will always View log files to get the information of the transaction..Can anyone help me on syntax?? Its just like debugging.. |
|
|
|
|
|
|
Important..