We did an upgrade and now The page or resource that you are accessing is unavailable or an error has occurred.
Problem reported by Sebastian Putnam - November 3, 2014 at 1:56 PM
Submitted
We did an upgrade to the latest version.  Now we are getting a message of: The page or resource that you are accessing is unavailable or an error has occurred. with any page that we access within the portal.
 
When checking the events error log I am getting this message:
=====================
[2014-11-03 3:49:29 PM]
Agent: N/A
Problem in Application_Start
Cannot delete or update a parent row: a foreign key constraint fails (`smatertools`.`st_ticketlinks`, CONSTRAINT `FK_st_TicketLinks_st_Tickets2` FOREIGN KEY (`TicketID_Secondary`) REFERENCES `st_tickets` (`TicketID`) ON DELETE NO ACTION ON UPDATE NO ACTION)
Cannot delete or update a parent row: a foreign key constraint fails (`smatertools`.`st_ticketlinks`, CONSTRAINT `FK_st_TicketLinks_st_Tickets2` FOREIGN KEY (`TicketID_Secondary`) REFERENCES `st_tickets` (`TicketID`) ON DELETE NO ACTION ON UPDATE NO ACTION)
 
Also I have tried deleting the Config folder and restarting the IIS.  I get the connect to database screen, but once I enter the information it submits and then comes back to the error message of: The page or resource that you are accessing is unavailable or an error has occurred.
 
Any help would be great as I have tried to read about this issue and nothing is working.
 
Regards,
Sebastian

6 Replies

Reply to Thread
0
Sebastian Putnam Replied
We are running Windows 2008 Server With IIS FYI
1
Rod Lasky Replied
Employee Post
Hi Sebastian.  I would suggest opening a support on this so that we can take a look.  If this is found to be a bug, we'll certainly refund this ticket back to you.
Rod Lasky
Technical Support Specialist
SmarterTools Inc.
(877) 357-6278
www.smartertools.com
0
Dustin Jurman Replied
We're having a similar issue after an upgrade as well. I've got a ticket open already.

[2014-11-05 1:44:23 AM]
Agent: N/A

Problem in Application_Start
The DELETE statement conflicted with the REFERENCE constraint "FK_st_TicketAttachments_st_Tickets". The conflict occurred in database "SmarterTrack", table "dbo.st_TicketAttachments", column 'TicketID'.
The statement has been terminated.
System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_st_TicketAttachments_st_Tickets". The conflict occurred in database "SmarterTrack", table "dbo.st_TicketAttachments", column 'TicketID'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at SmarterTrack.Data.SqlHelperInternal.ExecuteNonQuery(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters)
at SmarterTrack.Data.DataLayerShortcut.ExecuteNonQuery(IDbConnection& conn, String query, SqlParameter[] parameters)
at SmarterTrack.Data.DataLayerShortcut.ExecuteNonQuery(String query, SqlParameter[] parameters)
at SmarterTrack.Data.DatabaseUpgrade.EnsureCommonObjectsLoaded()
at SmarterTrack.MRS.Global.RunStartupStep2()
ClientConnectionId:10ca4914-18b7-4f70-bba2-f3e1629acfcc
0
Sebastian Putnam Replied
We are on the free version with possible upgrade (or other solution if this one does not work) in December if we see a fix to this. We moved back to the previous version and it worked fine again.
1
Sebastian Putnam Replied
FYI Due to this error that others are having we purchased another Solution.  We can not have this type of issue and have to pay to have you look at it.  I would suggest making your product a little less problematic when it should be a simple upgrade.  Every time there is an upgrade there is a problem with other little releases to fix it.   Thank you for the chance to see this with the free version before we went ahead and purchased it. 
0
Paul Blank Replied
It seems to me that SM should include its own robust web server (as opposed to their included - and not recommended by them - rudimentary web server, or IIS), instead of constantly tweaking their code for IIS, which is certainly not the web server of choice, with good reason, for many mainstream web sites.

Reply to Thread