---
# System prepended metadata

title: 會員 J01 串接報錯

---

# 會員 J01 串接報錯
![](https://i.imgur.com/S40vMSP.jpg)

|=------------------------+------------------------------------------------=|
|﻿#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               |brianh@fiti.com.tw                               |
|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 "brianh@fiti.com.tw"
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 = fiti@greenvines.com.tw
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]