Menu

SmartPOS synchronization error

2012-06-01
2012-06-01
  • Giovanny Vizcaya

    I'm Trying make a synchronization of SmartPOS and ActiveMQ and Smart ERP, but the problem is when i start the synchronization this error appears: "connection with the queuing system (JMS) could have problems, check your log files and check with your administrator".

    How can i solve it?

     
  • Giovanny Vizcaya

    This is the content of log file from SmartPOS

    jun 01, 2012 8:08:59 AM com.openbravo.pos.forms.AppConfig init
    Información: Reading configuration file: C:\users\gvizcaya\smartpos.properties
    jun 01, 2012 8:09:14 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT VERSION FROM APPLICATIONS WHERE ID = ?
    jun 01, 2012 8:09:15 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:16 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT HOST, HOSTSEQUENCE, DATESTART, DATEEND FROM CLOSEDCASH WHERE MONEY = 'e336fb5a-42c5-4bbb-b25e-cf3c506f99c5'
    jun 01, 2012 8:09:16 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: UPDATE RESOURCES SET NAME = ?, RESTYPE = ?, CONTENT = ? WHERE NAME = ?
    jun 01, 2012 8:09:17 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:17 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:17 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:17 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT NAME FROM LOCATIONS WHERE ID = '0'
    jun 01, 2012 8:09:17 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = True
    jun 01, 2012 8:09:17 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:22 AM com.openbravo.pos.smj.ERPListener run
    Grave: ** Connected to ACTIVEMQ url:>failover:tcp://localhost:61616<smart

    jun 01, 2012 8:09:49 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT PERMISSIONS FROM ROLES WHERE ID = ?
    jun 01, 2012 8:09:49 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:51 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT ID, NAME, IMAGE FROM FLOORS ORDER BY NAME
    jun 01, 2012 8:09:52 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT ID, NAME, X, Y, FLOOR FROM PLACES ORDER BY FLOOR
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:53 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:09:54 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT ID, NAME, CATEGORY, VALIDFROM, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME
    jun 01, 2012 8:09:54 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME
    jun 01, 2012 8:09:54 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID
    jun 01, 2012 8:09:54 AM com.openbravo.data.loader.StaticSentence openExec
    Información: Executing static SQL: SELECT ID, NAME, CATEGORY, VALIDFROM, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME
    jun 01, 2012 8:09:54 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT ID, NAME, IMAGE FROM CATEGORIES WHERE PARENTID IS NULL AND VISIBLE = TRUE ORDER BY NAME
    jun 01, 2012 8:10:13 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: UPDATE RESOURCES SET NAME = ?, RESTYPE = ?, CONTENT = ? WHERE NAME = ?
    jun 01, 2012 8:10:13 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: UPDATE RESOURCES SET NAME = ?, RESTYPE = ?, CONTENT = ? WHERE NAME = ?
    jun 01, 2012 8:15:56 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: select ID, NAME, RESTYPE, CONTENT from RESOURCES order by NAME
    jun 01, 2012 8:18:30 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: update RESOURCES set ID = ?, NAME = ?, RESTYPE = ?, CONTENT = ? where ID = ?
    jun 01, 2012 8:18:33 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: UPDATE RESOURCES SET NAME = ?, RESTYPE = ?, CONTENT = ? WHERE NAME = ?
    jun 01, 2012 8:18:33 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: UPDATE RESOURCES SET NAME = ?, RESTYPE = ?, CONTENT = ? WHERE NAME = ?
    jun 01, 2012 8:18:35 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:18:35 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:18:35 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:18:35 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?
    jun 01, 2012 8:18:35 AM com.openbravo.data.loader.PreparedSentence openExec
    Información: Executing prepared SQL: SELECT CONTENT FROM RESOURCES WHERE NAME = ?

     
  • pedrorozo

    pedrorozo - 2012-06-01

    Giovanny

    Please move this thread to the technical forum, and please include the complete step-by step process performed by you and both smartpos and ERP log files for further analisys.

    Without a complete and detail information from your side, it is not possible for us to help you

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.