Users - Find party main screen is not working
Posted by
Ashish Vijaywargiya-2 on
URL: http://ofbiz.116.s1.nabble.com/Users-Find-party-main-screen-is-not-working-tp138808.html
Hello Everybody,
Any body of you noted that Find Party Search main screen is not working on searching particular field basis.
I m getting the following error :
org.ofbiz.base.util.GeneralException: Error rendering screen [component://party/widget/partymgr/PartyScreens.xml#findparty]: org.ofbiz.base.util.GeneralException: Error rendering screen [component://party/widget/partymgr/CommonScreens.xml#main-decorator]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service Error [findParty]: Failure in party find operation, rolling back transaction: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PT.PARTY_ID AS PARTY_ID, PT.PARTY_TYPE_ID AS PARTY_TYPE_ID FROM PARTY PT WHERE
(UPPER(PT.PARTY_ID) LIKE UPPER('%admin%')) (Illegal mix of collations (latin1_general_cs,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like') (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service Error [findParty]: Failure in party find operation, rolling back transaction: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PT.PARTY_ID AS PARTY_ID, PT.PARTY_TYPE_ID AS PARTY_TYPE_ID FROM PARTY PT WHERE (UPPER(PT.PARTY_ID) LIKE UPPER('%admin%')) (Illegal mix of collations (latin1_general_cs,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like')) (Error rendering screen [component://party/widget/partymgr/CommonScreens.xml#main-decorator]: org.ofbiz.entity.transaction.GenericTransactionException: The current transaction is marked for rollback, not beginning a new transaction and aborting current operation;
the rollbackOnly was caused by: Service Error [findParty]: Failure in party find operation, rolling back transaction: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PT.PARTY_ID AS PARTY_ID, PT.PARTY_TYPE_ID AS PARTY_TYPE_ID FROM PARTY PT WHERE (UPPER(PT.PARTY_ID) LIKE UPPER('%admin%')) (Illegal mix of collations (latin1_general_cs,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like') (The current transaction is marked for rollback, not beginning a new transaction and aborting current operation; the rollbackOnly was caused by: Service Error [findParty]: Failure in party find operation, rolling back transaction: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DISTINCT PT.PARTY_ID AS PARTY_ID, PT.PARTY_TYPE_ID AS PARTY_TYPE_ID FROM PARTY PT WHERE (UPPER(PT.PARTY_ID) LIKE UPPER('%admin%')) (Illegal mix of collations (latin1_general_cs,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation 'like')))
New Yahoo! Messenger with Voice.
Call regular phones from your PC and save big.
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users