Forum Replies Created
-
kishor.j_88Participant8 years, 9 months ago in reply to: Error: INVALID_OPERATION_WITH_EXPIRED_PASSWORD #5598
This occurs because the password is expired for your Salesforce account, change your password by logging into your Salesforce account and then restart the sync.
kishor.j_88Participant8 years, 9 months ago in reply to: Error:Connection url #5597This is because the connection of the jdbc connection URL is wrong. The correct URL is “jdbc:mysql://localhost:3306/errors”.
kishor.j_88Participant8 years, 9 months ago in reply to: ERROR: PoolableCOnnectionFactory #5596This occurs commonly occurs when the password for the given username is wrong, try reentering the correct password and then validate and you can proceed further.
kishor.j_88Participant8 years, 9 months ago in reply to: ERROR:Unknown database #5595The specified database “replication” does not exist in the database, so please use the correct name or create the database with name “replication” to avoid this error.
kishor.j_88Participant8 years, 9 months ago in reply to: ERROR:Unknown database #5594The specified database “replication” does not exist in the database, so please use the correct name or create the database with name “replication”. to avoid this error.
kishor.j_88Participant8 years, 9 months ago in reply to: Data type size in database and salesforce are not the same for some fields #5593Suppose on the “Account” object for the field “Tradestyle” with size and datatype as “Text(255)”, if the size and datatype needs do be modified to a size of “VARCHAR(500)”, use the property “FORCE.TRADESTYLE=varchar(500)” in the system.properties file.
system.properties file can be found under <
>/ dbsync-repl /WEB-INF / db /conf / Once the property is added please restart the dbsync server.
kishor.j_88Participant8 years, 10 months ago in reply to: SEVERE: Run FAILED :Pool not open #5587It is the issue with Tomcat server, restarting the server will fix the issue.
kishor.j_88Participant8 years, 10 months ago in reply to: Alter Field Size in Database #5586In the system.properties file under <
>dbsync-replWEB-INFdbconf, include the command alter.schema.size=true.
For more information refer the link,
http://help.mydbsync.com/docs/display/CloudReplication/Alter+Field+Size+in+Databasekishor.j_88Participant8 years, 10 months ago in reply to: ERROR:Data too long #5585For more information regarding increase of the field size in database, refer the following link.
http://help.mydbsync.com/docs/display/CloudReplication/Alter+Field+Size+in+Databasekishor.j_88Participant8 years, 10 months ago in reply to: Rename option in replication #5561Select an object for which columns needs to be renamed, in the replication window it will highlight the columns which are too long and which can be renamed.
You can also just leave the rename option then the replication tool takes care of it by shortening the name for you.kishor.j_88Participant8 years, 10 months ago in reply to: Change of Size #5560In the system.properties file under <
>dbsync-replWEB-INFdbconf, include the command alter.schema.size=true which lets you to alter the column size. kishor.j_88Participant8 years, 10 months ago in reply to: D in do_sync_flag #5559‘D’ in database field do_sync_flag suggests that the record is deleted in Salesforce.
kishor.j_88Participant8 years, 10 months ago in reply to: ERROR:Data too long #5558Quick fix is to increase the size of the field under your target database
kishor.j_88Participant8 years, 10 months ago in reply to: Object Case #5557As it is a keyword in MYSQL you cannot use Case as object name, but you can still replicate this object by prefixing it with some name.
For more information on prefixes go through the link:
http://help.mydbsync.com/docs/pages/viewpage.action?pageId=7078471kishor.j_88Participant8 years, 10 months ago in reply to: Salesforce Login Error #5556The exception is due to the usage of the wrong soap endpoint URL. For a production instance, the soap endpoint URL will be :
https://login.salesforce.com/services/Soap/u/32.0 and for sandbox instance the URL will be: https://test.salesforce.com/services/Soap/u/32.0