Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.2.0
-
Fix Version/s: 1.2.0
-
Component/s: Site Generation Service
-
Labels:None
-
Environment:
QA Environment
optus-ear-1.2.3-SNAPSHOT-p2-t20120501-140620-CI.ear
Description
Method Deploy site is throwing exception related to table 'source'
[gsingh@optus-qa-smb1 ~]$ mysql -u root -ptestvalsvr -hoptus-qa-smb1
mysql> use optus ; show tables;
--------------------------
| Tables_in_optus |
--------------------------
| businessLocationIDMap |
| siteGenerationRegenFlags |
--------------------------
2 rows in set (0.00 sec)
[gsingh@optus-qa-smb1 ~]$ tail -f /usr/local/jboss-5.1.0.GA/tsa_messaging_node_server.log
11:12:40,652 DEBUG [JdbcTemplate] Executing prepared SQL query
11:12:40,652 DEBUG [JdbcTemplate] Executing prepared SQL statement [select sourceID, type, tenant from source where type = ? and tenant = ?]
11:12:40,654 ERROR [InvocationHandlerJAXWS] Method invocation failed with exception: null
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
.
.
.
Caused by: com.thesearchagency.core.smb.dao.DAOException: ERROR Could not find Source [Source [id=0, sourceType=EXTERNAL, system=ClientSystem [theName=Optus]] :: PreparedStatementCallback;
bad SQL grammar [select sourceID, type, tenant from source where type = ? and tenant = ?]; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'optus.source' doesn't exist
