[#OBMFULL-4017] userobm_company cannot be

[OBMFULL-4017] userobm_company cannot be found in the result set Created:
14/Aug/12 Updated: 21/Sep/12 Resolved: 16/Aug/12
Status:
Resolved
Project:
OBM
Component/s:
sync
Affects
Version/s:
2.4.1-Beta2
Fix Version/s:
Opush support backlog, Week 30 Lyon
Type:
Bug
Priority:
Major
Reporter:
Thomas HILAIRE
Assignee:
Thomas HILAIRE
Resolution:
Fixed
Votes:
0
Labels:
None
Remaining
Estimate:
Not Specified
Time Spent:
Not Specified
Original
Estimate:
Not Specified
Environment:
2.4.1~beta2+git20120813-1653-0d0e54f
Similar Issues:
Show 9 results
OBMFULL-1375
[User module] User not found with email address
OBMFULL-4461
ContactNotFoundException: Contact X not found
OBMFULL-4148
The parentId of a contact collection cannot be found
when the "contacts" folder is not synchronized
OBMFULL-5422
RESTClient log messages not appearing for
Thunderbird 3
OBMFULL-233
search filters wrong results
OBMFULL-4484
Cannot change notification settings in TB
OBMFULL-1168
[User-Global] Admin0 is not displayed in search results
OBMFULL-812
Group search results list don't show the right member
count after CSV import
OBMFULL-1694
[Event template] : some settings are not saved
Rank:
4026
Description
When TB synchronize contacts this error can appears :
2012-08-13 22:08:12,742 TransactionalInterceptor ERROR - error synchronizing contacts

org.obm.sync.auth.ServerFault: error synchronizing contacts
at
fr.aliacom.obm.common.contact.AddressBookBindingImpl.getAddressBookSync(AddressBookBindingImpl.java:154)
at
org.obm.annotations.transactional.TransactionalInterceptor.managerTransaction(TransactionalInterceptor.java:88)
at org.obm.annotations.transactional.TransactionalInterceptor.invoke(TransactionalInterceptor.java:74)
at org.obm.sync.server.handler.AddressBookHandler.getAddressBookSync(AddressBookHandler.java:300)
at org.obm.sync.server.handler.AddressBookHandler.handle(AddressBookHandler.java:118)
at org.obm.sync.server.SyncServlet.service(SyncServlet.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11NioProcessor.process(Http11NioProcessor.java:883)
at
org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:722)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:2214)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.obm.sync.auth.ServerFault: org.postgresql.util.PSQLException: Le nom de colonne userobm_company
n'a pas été trouvé dans ce ResultSet.
at fr.aliacom.obm.common.contact.AddressBookBindingImpl.getSync(AddressBookBindingImpl.java:168)
at
fr.aliacom.obm.common.contact.AddressBookBindingImpl.getAddressBookSync(AddressBookBindingImpl.java:151)
... 20 more
Caused by: org.postgresql.util.PSQLException: Le nom de colonne userobm_company n'a pas été trouvé dans ce
ResultSet.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2503)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getString(AbstractJdbc2ResultSet.java:2346)
at fr.aliacom.obm.common.contact.UserDao.loadUser(UserDao.java:146)
at fr.aliacom.obm.common.contact.UserDao.findUpdatedUsers(UserDao.java:125)
at
fr.aliacom.obm.common.contact.AddressBookBindingImpl.getContactsChanges(AddressBookBindingImpl.java:181)
at fr.aliacom.obm.common.contact.AddressBookBindingImpl.getSync(AddressBookBindingImpl.java:163)
Comments
Comment by Jenkins Continuous Integration Server [ 16/Aug/12 ]
Integrated in package-next-deb-oncommit #444
 Add contact mandatory fields to the SQL query (Revision
c9a0288e53a903896ffa3b430a9c43c0b34996cf)
Result = SUCCESS
Comment by Thomas HILAIRE [ 21/Aug/12 ]

To test it, try to synchronize complex users and contacts on iphone.
Generated at Sat Apr 15 23:51:33 CEST 2017 using JIRA 6.1.1#6155-
sha1:7188aeec9a6b57d61ea04c52f235f15f55c105e2.