DataStage培訓(xùn)的項(xiàng)目錯(cuò)誤總結(jié)

1.導(dǎo)入表結(jié)構(gòu)導(dǎo)入表BI_ERP.HZ_CUST_ACCT_SITES_ALL,BI_ERP.HZ_LOCATIO的表結(jié)構(gòu)，出現(xiàn)報(bào)錯(cuò)提示:點(diǎn)擊“是”后，出現(xiàn)如下提示:Errorexecutingcomand:orchdbutilshow01_￡^?-H^CUST^CCT_$ifES_fiLL-^btjipeoracle-serveriwytest-dboptiihns?■■■■????ititiifchouoooi16:28:09(009)<wain_program>AscentialOdtaStageCtn)EnterpriseEdition7.5.2Copyright(c)2曲奴1997-2fl0iiftscentialSoftwareCorporation.tillRightsflesertfed聃IICOBimiTCDUnttl聃IICOBimiTCDUnttlTCDUttttFTUXKnuooda00060?9000050000021^:28:09(002)U;28;09(003)16228:&$(@02i)<main_program><jiain_prograiin><nainprogtam>Oi-acle:loadedDatabaseconnectoptions:<unspeciFl￡d>.serwr='Iwytest"Bdboptions=■<user-"BI_ERP*.DdldbdSect>ikiiei;l：Options：ULhM內(nèi)e=<uiispe￡iFied>fstrwer='lwylest"Bdb(tpl±v^=■<US&r='BI_E：RP1sUInternalError;(EDl&esc):oraut.ilSu.C;1809:^etColDescfailed.■iPm11r!innf*nhF3*■nc1*arir3f□?>■rhorbl-lh3I-4ndlh*mH*cad!43iirck~in>c-F311airlsn/lnnmmxTill問(wèn)題原因：這兩張表有些字段的類(lèi)型(例如CLOB)在DataStage中不被識(shí)別。解決辦法：不用導(dǎo)入辦法第一個(gè)OrchestrateSchemaDefinition而使用Plup-inMetaDataDefinitions2.數(shù)據(jù)庫(kù)數(shù)據(jù)庫(kù)連接問(wèn)題在開(kāi)發(fā)作業(yè)時(shí)候，使用viewdata出現(xiàn)報(bào)錯(cuò)提示Outputfromjobrun:際WraplinesWViewerrorlinesonlyttttETFOP00000017:10:32(000)<Src_FND_FLEX_UALUES_UL>connectfailedforenu:orac,user:oracle,Ipassword:*****Oracleerror:-12514ORA-12514：TNS：監(jiān)聽(tīng)程序當(dāng)前無(wú)法識(shí)別連接描述符中請(qǐng)求的服務(wù)##ETFOP00014017:10:32(001)<Src_FND_FLEX_UALUES_UL>APT_OraReadOperator:connectFailed.ttttETCOS00002917:10:32(002)<mainproqran>Creationofastepfinishedwithstatus=FAILED.ttttETFOP08000017:17:06(000)<Src_FND_FLEX_UfiLUES_UL>connectFailedForenu:oracl,user:oracle,Ipassword:*****Oracleerror:-12154ORA-12154：TNS：無(wú)法解析指定的連接標(biāo)識(shí)符ttttETFOP00014017:17:06(001)<Src_FND_FLEX_UfiLUES_UL>fiPT_OraReadOperator:connectFailed-TCOS06002917:17:06(002)<nain_progran>CreationoFastepFinishedwithstatus=FAILED.問(wèn)題原因：第一個(gè)提示是數(shù)據(jù)庫(kù)沒(méi)啟動(dòng)。第二個(gè)提示服務(wù)器DATASTAGE的服務(wù)器里面沒(méi)有配置TNS，或者填錯(cuò)DATASOURCE名字。解決方法：?jiǎn)?dòng)數(shù)據(jù)庫(kù)服務(wù)，配置好DataStage中的TNS數(shù)據(jù)庫(kù)用戶(hù)權(quán)限⑴.把數(shù)據(jù)從業(yè)務(wù)庫(kù)導(dǎo)入到ODS層，源數(shù)據(jù)OracleEnterpriseStage使用viewdata時(shí)，出現(xiàn)報(bào)錯(cuò)提示：

ErsorexecutingViewDatacommand:ItitETDORSu17209:42:51(1：39)<FND_FLEX_VALUES_VL>Accesstosvs.dba_extentsisrequiredbutnotavailable;pleaseCopytoclipboard!OK.問(wèn)題原因：用戶(hù)權(quán)限不足，賦予select權(quán)限解決方法：賦予用戶(hù)select權(quán)限，⑵.開(kāi)發(fā)JOBBL_PUB_SALER_DIM作業(yè)時(shí)，使用VIEWDATA時(shí)，出現(xiàn)報(bào)錯(cuò)提示:[tt#ETD0R00817217:37:42(082)<0racle_Enterprise_26>Accesstosys.dbaextentsisrequiredbutnotauailable;pleaseseeyourdatabaseadministratorForselectpriuileges.問(wèn)題原因：未對(duì)BI_PUB用戶(hù)賦予dba_extents權(quán)限解決辦法：賦予BI_PUB用戶(hù)dba_extents權(quán)限⑶?開(kāi)發(fā)JOB'銷(xiāo)售員維’，JOB運(yùn)行后，出現(xiàn)報(bào)錯(cuò)提示：racle_Enterprise_3U:Insertpreparefailed:sertis:INSERT-ITU__PUB_SALER_DIMEI2_SALESFIEFLID..SALESFIEF'_ID..SALESFIEFLNUMBEFI..SALESFIEF'_NAME..REGION..STAFIT_DATE..END_DATE..Li.ST_MODIFIED_DATEl虬LIESLapp.BL_PUB_SALEFl_DIM_S.newtval..:SALESFlEF'_lD..:SALESFlEF'_NUMBEFl:SALESFlEF'_NAME:FlEG10N..SYSDATE..T0_DATE('20501231,,YrYr,MMDD，LSYSDATE]]lcodeis:-942jalcomolaint:ORA-00942:表成視陶不存布問(wèn)題原因：BI_PUB沒(méi)有BI_APP使用權(quán)限解決辦法：把使用權(quán)限賦予BI_PUB用戶(hù)grantallonBI_APP.BL_PUB_PRODUCT_DIM_Stobi_pub⑷.在開(kāi)發(fā)JOB時(shí)，出現(xiàn)報(bào)錯(cuò)提示：Sfc^0DS_FND_L00KUP_VALUE^-.VL_C,0:Exe^utelmmediatefailedforBEGINDELETEFROMBI_PUB.BL_PUB_INDUSTFIYLdIM_C;COMMIT;END;問(wèn)題原因：USER的SRC表和OPENCOMMAND的表USER沖突，權(quán)限不足解決解決：用BI_PUB用戶(hù)登錄授權(quán)：GRANTDELETEONBL_PUB_INDUSTRY_DIM_CTOBI_ODS;^dbaentente|德requiredbut⑸.在開(kāi)發(fā)JOB時(shí)，出現(xiàn)報(bào)錯(cuò)提示:^dbaentente|德requiredbutL_PUB_TERRIT0RY^DIM_C:Acces^tonotavailable;pleaseseeyourdatabaseadministratorforselect'privileges；問(wèn)題原因：BI_PUB權(quán)限不足解決描述：用DBA用戶(hù)登錄授權(quán)GRANTSELECTONSYS.DBA_EXTENTSTOBI_PUB3.加載字段中間落地stage為DATASET，作為另一個(gè)JOB源數(shù)據(jù)時(shí)的時(shí)候，VIEWDATE看不到數(shù)據(jù)

問(wèn)題原因：源數(shù)據(jù)缺少字段1of71of7Importfrom:FileonLocalsystem洋FileonServer:192.160.171.200Databasetable(viaorchdbutil)Selectthenameofthefiletobesearchedforschemadefinitions:|/home/dsadm/Ascential/DataStage/fact_locateAFileisdatasetorfileset4.Viewdata開(kāi)發(fā)ODS_OE_ORDER_HEADERS_ALL作業(yè)時(shí)，使用VIEWDATA時(shí)出現(xiàn)報(bào)錯(cuò)提示:##ETFOP00000014:08:59(000)<Src_OE_ORDER_HEADERS_ALL>connectFailedforenu:ERPPROD,user:mytemp,passwor|d:*****IOracleerror:-12538ORfi-12538:TNS：沒(méi)有此協(xié)議適配器##ETFOP00014014:08:59(001)<Src_OE_ORDER_HEfiDERS_ALL>APT_0raRead0perator:connectfailed.##ETCOS00002914:08:59(802)<main_program>CreationofastepFinishedwithstatus=FAILED.問(wèn)題原因：工程參數(shù)配置錯(cuò)誤解決辦法：JOB參數(shù)進(jìn)行修改在OracleEnterprisestage中VIEWDATA，出現(xiàn)報(bào)錯(cuò)提示：ttttETFCC00800311=19:53(000)<fiPT_CombinedOperatorController,0>U_TRUNCATED_CHAR_F0UNDencountered.ttttET0PK80000111=19:53(001)<_PEEK_IDENT_,0>FailureduringexecutionoFoperatorlog讓.ttttFTUXX00000111:19:53(004)<fiPT_Combined叩EratorControllEr/〉InternalError:(stat==APTCharsetComTraceback:Couldnotobtainstacktrace;checkthat*gdb'and*sed'areinstalledandonyourPATH聃ETFPM00019211：19:53(00B)ttttETFPM00033811=19:53(004)TFOP00000111：19:53(00B)ttttFTFIO00015311=19:53(002)TFPM00019211：19:53(001)ttttETFPM00033811=19:53(005)腳ETFSR00001111：19:58(00B)<node_node1>Player2terminatedunexpectedly.<main_program>Unexpectedexitstatus1<0ra_FND_L00KUP_UALUES_UL,0>Failureduringexecutionofoperatorlogic.<0ra_FND_L00KUP_UALUES_UL,0>FatalError:Unabletoallocatecommunication<node_node1>Player1terminatedunexpectedly.<main_program>Unexpectedexitstatus1<main_prog^am>StepexecutionFinishedwithstatus=FAILED.問(wèn)題原因：可能是源數(shù)據(jù)字段類(lèi)型問(wèn)題，可能有問(wèn)題字段解決方法：1.問(wèn)題字段，.不VIEWDATA，直接進(jìn)行next落地.2.用自定義SQL抽取源表字段。選擇全部的字段，不過(guò)別用select*fromtable方式，有時(shí)會(huì)報(bào)錯(cuò)。Menage:BL_PUB_TERRITORY_DIM_D:Couldnotobtainaschemabec?sepreparefailed;thequery.was-:select'KfromBL_PUB_TERRlTORY_.DIM_D.5.落地?cái)?shù)據(jù)量問(wèn)題數(shù)據(jù)變多在DataStage重跑表從業(yè)務(wù)層到ODS層的數(shù)據(jù)，發(fā)現(xiàn)落地?cái)?shù)據(jù)變多。發(fā)現(xiàn)不會(huì)刪掉之前的

數(shù)據(jù)。問(wèn)題原因：重新插入數(shù)據(jù)前（重新跑一遍JOB），沒(méi)有再源數(shù)據(jù)設(shè)計(jì)opencommand支持重跑解決方法：源表獲取方式選擇user_definedSQL,再在opencommand編寫(xiě)truncatetabletablenameo在開(kāi)發(fā)銷(xiāo)售員維的緩慢變化時(shí)，每執(zhí)行一次都會(huì)增加兩條數(shù)據(jù)問(wèn)題原因：關(guān)聯(lián)關(guān)鍵字不唯一解決方法：建立索引開(kāi)發(fā)JOB'合同維'時(shí)，使用Lookupstage關(guān)聯(lián)后落地?cái)?shù)據(jù)多于測(cè)試數(shù)據(jù)。問(wèn)題原因：銷(xiāo)售員維的SALESREP_ID數(shù)據(jù)重復(fù)解決方法：按圖所示設(shè)置屬性StableInputname:DSLink15GeneralPartitioningColumns-1AdvancedAvailable:HSALESREP_NAMEPartitioning/CollectingPartitiontype:SortingVPerformsort5UniqueStableInputname:DSLink15GeneralPartitioningColumns-1AdvancedAvailable:HSALESREP_NAMEPartitioning/CollectingPartitiontype:SortingVPerformsort5Unique數(shù)據(jù)不確定調(diào)試事實(shí)表和客戶(hù)維的時(shí)候都出現(xiàn)ETL抽取數(shù)據(jù)和實(shí)際插進(jìn)數(shù)據(jù)庫(kù)的數(shù)據(jù)不一致。問(wèn)題原因：落地?cái)?shù)據(jù)表結(jié)構(gòu)有問(wèn)題解決方法：對(duì)照表結(jié)構(gòu)的空值屬性，不該設(shè)主鍵的不要設(shè)主鍵。開(kāi)發(fā)'區(qū)域維'的時(shí)候，記錄數(shù)不一致。問(wèn)題原因：JOB兩個(gè)表先做lookup關(guān)聯(lián)后，再做過(guò)濾。解決方法：先對(duì)兩個(gè)表做過(guò)濾，再進(jìn)行l(wèi)ookup。數(shù)據(jù)變少開(kāi)發(fā)job'銷(xiāo)售員維‘的時(shí)候，落地?cái)?shù)39條，實(shí)際記錄為41條。問(wèn)題原因：因?yàn)楣芾砭S度的關(guān)鍵字不唯一，而joinstage設(shè)置排序解決方法：刪去排序設(shè)置?；蛘咪N(xiāo)售員維建立主鍵和索引。JOB運(yùn)行成功后發(fā)現(xiàn)數(shù)據(jù)有丟失時(shí)，客戶(hù)維中的子查詢(xún)sql，用sql跑出來(lái)是10476條數(shù)據(jù)，在job中跑出來(lái)后是3519條數(shù)據(jù)。問(wèn)題原因：在源數(shù)據(jù)表獲取方式自定義SQL沒(méi)考慮去重。因loolup控件只會(huì)匹配相

同數(shù)據(jù)的第一個(gè)。解決方法：在源數(shù)據(jù)表獲取方式自定義SQL是添加distincto在JOB中可以看到有3557條數(shù)據(jù)是流到目標(biāo)表的。但是查看數(shù)據(jù)庫(kù)的時(shí)候，卻發(fā)現(xiàn)只有2447條數(shù)據(jù)插入。問(wèn)題原因：可能插入的數(shù)據(jù)某些字段為空，而目標(biāo)表字段設(shè)置不允許為空。或者可能是因?yàn)樵谀繕?biāo)表中設(shè)置了主鍵，但是導(dǎo)入該字段的數(shù)據(jù)值不唯一，導(dǎo)致很多值不能導(dǎo)入。這時(shí)候可以選擇不要設(shè)置主鍵。解決問(wèn)題：落地時(shí)如果選擇upset方式，處理空值，不設(shè)置的主鍵。也可以選擇load日已1Target磁Table=BL_SA_ANALYSE_FACTQWriteMethod=LoadQWrite日已1Target磁Table=BL_SA_ANALYSE_FACTQWriteMethod=LoadQWriteMode=TruncsteWriteMode:TruncateAppendCreate-也Connection方毗

耳叫方毗

耳叫在驗(yàn)證job數(shù)據(jù)時(shí)，發(fā)現(xiàn)數(shù)據(jù)與sql查詢(xún)的數(shù)據(jù)不一致，如客戶(hù)維中的子查詢(xún)sql，用sql跑出來(lái)是10476條數(shù)據(jù)，在job中跑出來(lái)后是3519條數(shù)據(jù)。問(wèn)題原因：查詢(xún)數(shù)據(jù)差異發(fā)現(xiàn)，因?yàn)殛P(guān)聯(lián)字段不唯一BL_SELLERS_DIM_TSINGK-E0C1IMS100WB3961D065&10083測(cè)試sql：JOB運(yùn)行成功解決方法：改用join控件了或者在客戶(hù)維度設(shè)置代理鍵落地文件為OracleEnterpriseStage，viewdata，出現(xiàn)報(bào)錯(cuò)信息岔.ErrorexecutingViewDatacommand:JOB運(yùn)行成功IttttETFCC"W9:55:41(^1)<APT_Cnmbined9peratorControllerJ)>UTRUNCATEDCHARFOUNDencnurtered.Copytoclipboard點(diǎn)擊OK后，數(shù)據(jù)只有幾條，中文的數(shù)據(jù)出現(xiàn)亂碼問(wèn)題原因：導(dǎo)進(jìn)某些字段導(dǎo)致的，導(dǎo)進(jìn)去的某些字段不能被DataStage識(shí)別，亂碼是因?yàn)镈ataStage中的字符集（默認(rèn)Projectdefault（ASCL_GB2312））和oracle數(shù)據(jù)庫(kù)（UTF-8）的不一致。

解決方法：選擇需要的字段是，修改project字符集或者JOB字符集6.stageproject中全部JOB只能read，而不能進(jìn)行其他的操作，工具欄按鈕不可用，全變灰色問(wèn)題原因：工程被保護(hù)project中該JOB只能read，而不能進(jìn)行其他的操作，出現(xiàn)報(bào)錯(cuò)提示:問(wèn)題原因：該作業(yè)給保護(hù)解決方法：導(dǎo)出該JOB，用寫(xiě)字板或別的方式打開(kāi)，把Readonly〃1〃改為Readonly"0"7.作業(yè)損壞在Designer后，點(diǎn)擊某個(gè)JOB，出現(xiàn)報(bào)錯(cuò)提示CannotopenexecutablejobfileRT_C0NFIG29I-Copvtoclipboard:OK問(wèn)題原因：可能是因?yàn)镴OB還在運(yùn)行的時(shí)候，而又強(qiáng)制性地關(guān)閉了正在運(yùn)行的JOB，此時(shí)會(huì)報(bào)這個(gè)錯(cuò)誤，或者是該文件已經(jīng)損壞。解決方法：一般可以先COPY一份，再對(duì)原來(lái)?yè)p壞的文件進(jìn)行重改名，接著刪除這個(gè)JOB。如果出現(xiàn)刪除不了，是損壞太多無(wú)法修復(fù)。同時(shí)也有可能影響到其他JOB的打開(kāi)。這個(gè)時(shí)候可能要考慮刪除該工程，重新建立一個(gè)新的工程。JOB成功，當(dāng)數(shù)據(jù)為空在job跑成功的情況下，數(shù)據(jù)庫(kù)中目標(biāo)表沒(méi)有數(shù)據(jù)。（目標(biāo)表的oracleenterprise中選擇了User-definedUpdateOnly）。問(wèn)題原因：由于沒(méi)有InsertSQL，數(shù)據(jù)沒(méi)有查入目標(biāo)表解決方法：在UpsertMode框中選擇User-definedUpdateOnly，UpdateSQL中用insert語(yǔ)句（Update語(yǔ)句不具備插入表的功能）。在job跑成功的情況下，數(shù)據(jù)庫(kù)中目標(biāo)表沒(méi)有數(shù)據(jù)。問(wèn)題原因：在做Lookup關(guān)聯(lián)時(shí)，選擇fail解決方法：將其改為Drop，開(kāi)發(fā)客戶(hù)維緩慢變化時(shí)，JOB運(yùn)行成功但沒(méi)有數(shù)據(jù)插入，亦沒(méi)出錯(cuò)提示。問(wèn)題原因：change_capture控件中的before和after設(shè)置錯(cuò)誤，

解決辦法：目標(biāo)表為before，關(guān)聯(lián)后合并的表為afterDataStage服務(wù)器配置虛擬機(jī)服務(wù)器配置JOB運(yùn)行失敗，提示錯(cuò)誤：ERP_OE_ORDER_HEADERS_ALL,0:Failureduringexecutionofoperatorlogic.ERP_OE_ORDER_HEADERS_ALL,0:FatalError:APT_Decimal::assignFromString:thesourcestring(9990000000000000000000000000000000000000)isoutofrangeforthedecimalwithprecision38問(wèn)題原因：數(shù)據(jù)量太大。受限本機(jī)的虛擬機(jī)服務(wù)器配置解決方法：根據(jù)需求報(bào)告，選擇需要的字段抽取。DataStage服務(wù)器空間不夠在開(kāi)發(fā)JOB的時(shí)候，用lookup控件關(guān)聯(lián)一個(gè)主表和四個(gè)從表，出現(xiàn)報(bào)錯(cuò)提示Lkp_order_number,0:Errorwritingtablefile〃/home/dsadm/Ascential/DataStage/Datasets/lookuptable.20110613.4mrirxd〃：Nospaceleftondevice問(wèn)題原因：虛擬機(jī)空間不夠。解決問(wèn)題：把lookup控件換成join，換虛擬機(jī)?；蛘甙袹OB進(jìn)行拆分。stage設(shè)置錯(cuò)誤JOB失敗，在director中查看日志，報(bào)錯(cuò)提示：main_program:Whenpreparingoperator:Whensettinguptransferfor“PROVINCE_ID”:Thesourceanddestinationhavedifferingnullability.|mam_program:Whenpreparingoperatoif^/tnen■'settrnguptranterforI''PROylNCE_IDThe^purceanddestinationhavedifferingnullability.V/henpreparingoperator:Whensettinguptransferfor''ENABLED_FLAGThesourceanddestinationhavedifferingnullability.問(wèn)題原因：源和目標(biāo)字段屬性設(shè)計(jì)不一致。解決方法:字段是否為空設(shè)置相同。開(kāi)發(fā)‘區(qū)域維’時(shí)，判斷地區(qū)的國(guó)內(nèi)外屬性時(shí)，寫(xiě)入數(shù)據(jù)庫(kù)的字段只顯示“國(guó)”問(wèn)題原因：在datastage落地?cái)?shù)據(jù)庫(kù)中，UTF-8編碼中每個(gè)漢字占3個(gè)字節(jié)。用戶(hù)“國(guó)內(nèi)外”字段設(shè)置長(zhǎng)度為4。解決方法：修改該字段的長(zhǎng)度使用生成代理關(guān)鍵字列時(shí)，設(shè)置字段類(lèi)型為decimal。落地?cái)?shù)出錯(cuò)問(wèn)題原因：字段類(lèi)型設(shè)置出錯(cuò)解決問(wèn)題：把decimal類(lèi)型設(shè)置為integer目標(biāo)控件：OracleEnterprisestage，數(shù)據(jù)落地在WriteMethon中選擇upset，并且在UpsertMode框中選擇User-definedUpdate&Insert，job運(yùn)行過(guò)程中會(huì)出現(xiàn)Operatorterminatedabnormally:receivedsignalSIGSEGV的錯(cuò)誤。[0racle_Enterprise_1,0:Operatorterminatedabnormally:receivedsignalSIGSEGV~問(wèn)題原因：DataStage本身BUG原因

解決方法：在UpsertMode框中選擇User-definedUpdateOnly，在UpdateSQL中用insert^句開(kāi)發(fā)JOB區(qū)域維的緩慢變化維的時(shí)候，出現(xiàn)報(bào)錯(cuò)提示I,,PRUVINCE_ID":Thesourceanddestiridtiunhavedifferingnullability.Whenpreparingoperato匚'w'h已nsettinguptransferfw"ENAELED_『L&G":Thesourceanddestinationhavedifferingnullability.Whenpreparinguperdtur:Whensettinguptransferfor,,REGlUN_ID,,:Thesourceanddestiridtiunhavedifferingnulldbility.問(wèn)題原因：在changecapture控件中，changevalue的字段在after表與before表中的是否為空字段不一致。解決方法：只要把a(bǔ)fter表的region_id、province_Id、enabled_flag的nullable屬性改成yes數(shù)據(jù)落地時(shí)，在目標(biāo)庫(kù)OracleEnterpriseStage使用viewdata，出現(xiàn)報(bào)錯(cuò)提示點(diǎn)擊‘是'ttttETFCC000003ttttETFOP點(diǎn)擊‘是'ttttETFCC000003ttttETFOP008001ttttFTDOR000252ttttETFPM000192ttttETFPM000338ttttETFOP000001ttttFTFIO000126ttttETFPM000192ttttETFPMO0Q338ttttETFSR00001115:33:19(000)15:33:19(108)15:33:19(110)15:33:19(000)15:33:19(000)15:33:19(000)15:33:19(003)15:33:19(001)15:33:19(001)15:33:24(000)<OE_ORDER_LINES_ALL,0>U_TRUNCATED_CHAR_FOUNDencountered.<OE_ORDER_LINES_ALL,0>Failureduringexecutionofoperatorlogic.<OE_ORDER_LINES_ALL,0>FatalError:TheinputdatacouldnotbeconuertedFr<node_node1>Player1terminatedunexpectedly.<main_progran>Unexpectedexitstatus1<_Head,0>FailureduringexecutionoFoperatorlogic.<APT_CombinedOperatorC(]ntroller,0>FatalError:waitForWriteSignal():Premat<node_node1>Player2terminatedunexpectedly.<main_progran>Unexpectedexitstatus1<main_progran>StepexecutionFinishedwithstatus=FAILED.問(wèn)題原因：落地的目標(biāo)庫(kù)導(dǎo)入的字段為Decimal，其默認(rèn)值為3810：ColumnnameColumnnameKeySQLtypeExtendedLength^calqSuitableDescription1HEADERJDDecimal331CNoHEADERJD:decimal[38.10]II解決方法：將默認(rèn)值改為25599Job運(yùn)行后，出現(xiàn)報(bào)錯(cuò)提示：Message:Change_Capture_7.DSLink10_Part:Errorwhencheckingoperator:Kevfield"REGION_NAME"wasnotfoundintheview-adaptedinput:fechema問(wèn)題原因：目標(biāo)庫(kù)字段名與前面?zhèn)鬏數(shù)膶?duì)應(yīng)字