# 會員 J01 串接報錯

|=------------------------+------------------------------------------------=|
|#Salesforce Connecection|null |
|SFDCWebServiceURL |https://login.salesforce.com/services/Soap/u/45.0|
|DBHost |112.121.106.199 |
|DBPort |52173 |
|DBDatabase |greenvines |
|DBUsername |sa |
|DBPassword | |
|FTPHost | |
|FTPPort |21 |
|FTPUsername |sfc |
|FTPPassword |p8fm |
|LogFilePath |C:\Schedule_Jobs\Production\log\ |
|CSVFilePath |C:\Schedule_Jobs\Production\log\ |
|BKUPFilePath |C:\Schedule_Jobs\Production\log\ |
|SendMailTo |[e-mail] |
|SendMailFrom | |
|SendMailSendername |Talend Job |
|SendMailCc | |
|SendMailBcc | |
|SendMailSMTPHost |smtp.googlemail.com |
|SendMailSMTPPort |587 |
|SendMailUsername | |
|SendMailPassword | |
'-------------------------+-------------------------------------------------'

.-------------+--------------------------------.
| LogRow_Keys |
|=------------+-------------------------------=|
|key |value |
|=------------+-------------------------------=|
|SQL_UserName |aQ2vE/HwZUj5zXyP51OXAA== |
|SQL_PWD |EWQw/16iIpUCYaBMsTTbmg== |
|SFDC_UserName|Ynclub1uQMSKXivlw4rZv6RkQx9ZoQG0|
|SFDC_PWD |AdULNrcyEFEjZvHRu0kL0EJHl0G7olA+|
'-------------+--------------------------------'

tContextLoad_1 set key "#Salesforce Connecection" with value "null"
tContextLoad_1 set key "SFDCWebServiceURL" with value "https://login.salesforce.com/services/Soap/u/45.0"
tContextLoad_1 set key "DBHost" with value "112.121.106.199"
tContextLoad_1 set key "DBPort" with value "52173"
tContextLoad_1 set key "DBDatabase" with value "greenvines"
tContextLoad_1 set key "DBUsername" with value "sa"
tContextLoad_1 set key "DBPassword" with value ""
tContextLoad_1 set key "FTPHost" with value ""
tContextLoad_1 set key "FTPPort" with value "21"
tContextLoad_1 set key "FTPUsername" with value "sfc"
tContextLoad_1 set key "FTPPassword" with value "p8fm"
tContextLoad_1 set key "LogFilePath" with value "C:\Schedule_Jobs\Production\log\"
tContextLoad_1 set key "CSVFilePath" with value "C:\Schedule_Jobs\Production\log\"
tContextLoad_1 set key "BKUPFilePath" with value "C:\Schedule_Jobs\Production\log\"
tContextLoad_1 set key "SendMailTo" with value "[e-mail]"
tContextLoad_1 set key "SendMailFrom" with value ""
tContextLoad_1 set key "SendMailSendername" with value "Talend Job"
tContextLoad_1 set key "SendMailCc" with value ""
tContextLoad_1 set key "SendMailBcc" with value ""
tContextLoad_1 set key "SendMailSMTPHost" with value "smtp.googlemail.com"
tContextLoad_1 set key "SendMailSMTPPort" with value "587"
tContextLoad_1 set key "SendMailUsername" with value ""
tContextLoad_1 set key "SendMailPassword" with value ""
tContextLoad_1 set key "SQL_UserName" with value "aQ2vE/HwZUj5zXyP51OXAA=="
tContextLoad_1 set key "SQL_PWD" with value "EWQw/16iIpUCYaBMsTTbmg=="
tContextLoad_1 set key "SFDC_UserName" with value "Ynclub1uQMSKXivlw4rZv6RkQx9ZoQG0"
tContextLoad_1 set key "SFDC_PWD" with value "AdULNrcyEFEjZvHRu0kL0EJHl0G7olA+"
SFURL = https://login.salesforce.com/services/Soap/u/45.0
SFUsr = [e-mail]
SFPWD = !3e4r5t6y@Greenvines
SQLUsr = greenvinesSup01
SQLPWD = gv20201206
myNow = Tue Dec 28 01:54:32 CST 2021
myJob = J01_SQL_SF_ACC
Today = 20211228
Last2Days = 2021-12-26
TotalCount = 0
SuccessCount = 0
ErrorCount = 0

.------------------------+------------------+-------+-----------------.
| LogRow_Interface_Log |
|=-----------------------+------------------+-------+----------------=|
|Last_Sync_Date__c |Id |Name |Interface_Name__c|
|=-----------------------+------------------+-------+----------------=|
|2021-12-28T01:53:39.000Z|a022w00000KYwUNAA1|JL00000|J01_SQL_SF_ACC |
'------------------------+------------------+-------+-----------------'

LastSyncDate = Tue Dec 28 01:53:39 CST 2021
MyLastSyncDate = 2021-12-28 09:53:39
MyLastSyncDate_1 = 2021-12-28 08:53:39
LogId = a022w00000KYwUNAA1

<p style="color:red">
Exception in component tDBInput_1 (J01_SQL_SF_ACC)
java.sql.SQLException: Value 水源路215巷12號 cannot be converted to INTEGER.
at net.sourceforge.jtds.jdbc.Support.convert(Support.java:752)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getInt(JtdsResultSet.java:675)
at greenvines_sfdc_10912.j01_sql_sf_acc_0_3.J01_SQL_SF_ACC.tDBInput_1Process(J01_SQL_SF_ACC.java:12017)
at greenvines_sfdc_10912.j01_sql_sf_acc_0_3.J01_SQL_SF_ACC.runJobInTOS(J01_SQL_SF_ACC.java:21116)
at greenvines_sfdc_10912.j01_sql_sf_acc_0_3.J01_SQL_SF_ACC.main(J01_SQL_SF_ACC.java:20823)
</p>
PostJob
[statistics] disconnected

Job J01_SQL_SF_ACC ended at 09:54 28/12/2021. [exit code=1]