Dylan, I had something similar happen earlier in the summer with Oracle on our production server.. I was in the process of deleting a field from a form late at night when we ran into a temp space issue. Didn't see any Oracle errors but the process would error when it tried to create the new tables and associated view for the form as it does with a delete of a field.. The DBA's didn't see it when they were looking around at space as it looked like there was room. The copy of the table was just a little bit bigger than than the space available and the process would bail before it was complete.
I could see the form in the admin tool but couldn't do anything with it because it really wasn't the T151 table I had been dealing with but the renamed temporary T151A table. I shut down the admin tool and had the DBA's rename the table back to the appropriate table number. Of course this was after being up all night attempting to figure out the little clues. Once we did the rename then we got back to business and everything back to normal and I was able to crash much later in the day. I know long story but it does ring very similar. Dave -------------------------- [EMAIL PROTECTED] (Wireless) ----- Original Message ----- From: Action Request System discussion list(ARSList) <[email protected]> To: [email protected] <[email protected]> Sent: Fri Aug 31 15:15:58 2007 Subject: Re: Server crashed now Invalid Object Name errors It has the same network name. I just had to change the db password because I never had the db password for the original dev box heh. Something else I've tried. I opened the join form that corresponds to T378 in the admin tool. Moved a field and saved it. Opened the support console in the user tool and no more error. This only works for join forms I guess though, I try and do it on a regular data form and get the error. Creation of one of the SQL views for the form failed within the SQL database. Operation completed successfully, but the SQL view is not in place. (ARERR 69). -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Friday, August 31, 2007 12:04 PM To: [email protected] Subject: Re: Server crashed now Invalid Object Name errors If the SQL server was brought up on another server, does that new server have the same network name as the old server? Or is it named differently? If it has a different name, you should use the stored procedure to rename the SQL database...if you haven't already. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Wheeler, Dylan Sent: Friday, August 31, 2007 1:47 PM To: [email protected] Subject: Server crashed now Invalid Object Name errors ** Our database server took a nose dive yesterday. The data was stored on a SAN so they brought our database up on another server. I set our conf file to point to the new server and thought everything was good to go. Until I logged in :( ARERR [552] Failure during SQL operation to the database : Invalid object name 'T378'. (SQL Server 208) I get this error with every form I open up in the user tool. This error in particular is when I open the support console, the T378 is a join form. Any ideas where I need to start looking to find the problem? ARS 6.3 MS-SQL 2K ------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
