Further Weirdness with DB2 Transactional Save


Author
Message
PeterA
PeterA
StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)StrataFrame Novice (74 reputation)
Group: Forum Members
Posts: 72, Visits: 235
I don't know how I do it, but I think I can find the strangest bugs and always at the last minute. Smile



I had everything built and had completed my QA testing. Everything functioned great, the BrokenRule issue was resolved. So, I moved all my files into the staging area. It's just a different directory on the same server, same hard drive. I set up a second QC/staging Web site and started clicking through to make sure permissions were all set up and working the way they did on the development site and I had some more issues.



As I said, this is on the same server and the same hard drive, just a different file path. I made sure all my config values were updated to use the new path for logging and database login information (still connects to the same database, but accesses a file in a different path location). It logs in, gets me data and works fine. When I try to save something, for example, modified application permissions for a role, it blows up.



I finally tracked it down to it claiming the transaction key didn't exist. I double checked and it starts the transaction. I added some code to conditionally use the transaction if it exists. So I check the Transactions collection for the key and if it exists, I tell the business object to save using the transaction. If it doesn't, I have it save without a transaction. It detects that there is a transaction and then throws an exception that the key does not exist. Here's the stack trace:



at MicroFour.StrataFrame.Business.BusinessLayer.Save(Boolean Transactional, String TransactionKey)

at Payless.Sourcing.MaterialsManagement.Admin.Permissions.cmdSave_Click(Object sender, ImageClickEventArgs e) in I:\PSS Design\Visual Studio\Materials Management\MM_UI\Administration\permissions.aspx.cs:line 218




And here's the Exception and Inner Exception that get thrown:



EXCEPTION: An error occurred while saving the data to the server.

INNER EXCEPTION: Save cannot continue because a transaction with the key [PermissionsUpdate] has not been started.




I'm thoroughly confused about this one since it all works fine and lets me save in the development area, but not in the QC area. They reference the same Strataframe assemblies and the same IBM.Data.DB2 assembly. It was just a straight copy of the files from one directory (D:\Dev\Application\) to another (D:\QC\Application).



Any ideas what could be causing this?



Thanks!
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
PeterA - 17 Years Ago
PeterA - 17 Years Ago
PeterA - 17 Years Ago
StrataFrame Team - 17 Years Ago
PeterA - 17 Years Ago
                         Aha, that's the problem... the transaction is owned by the data...
StrataFrame Team - 17 Years Ago
                             [quote][b]Ben Chase (11/06/2007)[/b][hr]Aha, that's the problem... the...
PeterA - 17 Years Ago
                                 Yep, that about sums it up :) Glad you got it working.
StrataFrame Team - 17 Years Ago
                                     [quote][b]Ben Chase (11/07/2007)[/b][hr]Yep, that about sums it up :)...
PeterA - 17 Years Ago
                                         I should probably qualify that question. What events are fired off...
PeterA - 17 Years Ago
                                             When it is created, it is just going to fire the normal component...
Trent L. Taylor - 17 Years Ago
                                                 [quote][b]Trent L. Taylor (11/07/2007)[/b][hr]When it is created, it...
PeterA - 17 Years Ago
                                                     Good deal :)
Trent L. Taylor - 17 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search