473,322 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Problem after Restore

I received a few cd's from a client, with a .bak MS-SQL database
backup, installs for tomcat, and java. Everything was provided via an
altered webapps folder tomcat, which holds an almost all JSP setup.

I figured out the login issue I was having, was able to correct, and
properly view the tables in SQL Management Studio. For a long time
when trying to run the DB, we received countless HTTP 500 exception
reports. When checking the logs one things stands out
"net.sf.hibernate.exception.SQLGrammarExceptio n: could not load:
[com.micropact.product.brac.bo.State#11] & Caused by:
java.sql.SQLException: Invalid object name 'State'."
State is a field in one of the tables. and value #11 denotes a valid
state, GA.... we went on like this for hours, until I decided to clear
out an entry in a table that made reference to GA. At this point all
the bells and whistles started working(the page came up right) Clicked
on one of the links and got a " [ServletException
in:/fieldOffice/view/content.jsp] Failed to lazily initialize a
collection' "

The point of this database is to be a record of addresses, and
installations, when I add a new address it takes it properly, except
that the drop down for state does not work at all, there are no drop
down entries, and nothing can be manually typed. which is where I think
all our problems are.

If anyone would like to take a stab here, let me know and we can figure
where the issue is. I'm sorry if I sound a little scatterbrained , but
I have been trying to get this to properly work for 2 days.

-GLW

Dec 12 '06 #1
1 1181
(sm*****@gmail.com) writes:
I figured out the login issue I was having, was able to correct, and
properly view the tables in SQL Management Studio. For a long time
when trying to run the DB, we received countless HTTP 500 exception
reports. When checking the logs one things stands out
"net.sf.hibernate.exception.SQLGrammarExceptio n: could not load:
[com.micropact.product.brac.bo.State#11] & Caused by:
java.sql.SQLException: Invalid object name 'State'."
State is a field in one of the tables.
But this error would indicate the application submits a query for the
table State.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 14 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: butatista | last post by:
Please help SQL Server 2000 Standard I am trying to restore databases on my server and am unable to get them to restore using the database option. For example, the location of my backup...
1
by: CPNZ | last post by:
I have a database i am m oving to another server, during the process I am moving the data and log files to another drive.(Which I have done countless times before with no problems) The problem I...
9
by: GL | last post by:
I am running DB2 8.1.1 on AIX 5.1 Having a problem with a redirected restore. Once into the restore continue phase, I immediately get the following “SQL2059W A device full warning was...
13
by: Andy K | last post by:
Hi , I'm wondering what's going on with a restore I'm trying to do . My DB2 version is a 7.2 on a Linux RH ES 2.1 . I've copy a recent backup that was on NAS for a test on my machine . I...
11
by: Chris | last post by:
I have searched this group for answers and tried the responses. I am trying to Use an full online backup from our production server and apply it to our test server. The Tablespaces in the...
1
by: David Greenberg | last post by:
Hi When trying to create an SqlServer job, clicking OK' I got the message "Error 823: I/O error (torn page) detected during read at offset..... in file 'd:\sqlserver\MSSQL\data\msdata.mdf'. The...
0
by: prerak_v_shah | last post by:
Hi All, These days I was working on IBM DB2 database for windows with my .Net Application. Now, it was required to backup database created on one machine to the other machine. I was also able...
1
by: Robbert van Geldrop | last post by:
Hello, I have a problem restoring Exchange 2000 files. Our software has an interface to ESEBCLI2.dll for online backup and restore features. Everything works fine with Exchange 2003 and also...
3
by: Okonita | last post by:
Hi all, I am having problem completing this restore operation. "db2 restore database AAMI01 from /pap/data/backups taken at 20071002130554 to /pap/data/db01 into AAMI01 NEWLOGPATH /pap/data/new/...
2
by: modeler | last post by:
Hello, I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows. C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2 UPDATE COMMAND OPTIONS...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.