hi all,
I am facing following issue during data deployment.
The tuple processor is throwing null exception after building the tuple.
the error is:
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={Position Families Analyzed/0/LOOKUP_JOB_GROUP_IDS=, Survey Schedule/0/DT_SURVEY_AVAILABLE=12-September-2006, IND_PAGES=1, Position Families Analyzed/0/NME_JOB_LISTING_PATH=, NME_ASSOCIATION_MEMBER=, FLG_IMMEDIATE_ACCESS=0, Survey Schedule/0/DT_EFFECTIVE=12-September-2006, Position Families Analyzed/0=, RELATED_CONT_IDS=1068730, id_content=1047946, IND_FULFILLMENT_METHOD=0, 0, Job Participants/0/IND_POSITIONS=1, IND_IMP_GLOBAL_HOME=0, REVENUE_OWNER_READONLY=, Survey Schedule/0/Survey_Schedule=, RELATED_SERVICES_IDS=, PRICING=, FLG_MEMBER=0, TRANSLATED_CONT_READONLY=, Data Submission Tools/0/DATA_SUBMISSION_TOOLS=, nme_keyword=fdg, Job Participants/0/IND_INCUMBENTS=1, Job Participants/0/IND_ORGANIZATIONS=1, REVENUE_OWNER_IDS=, Related External Links=, RELATED_CROSS_SELLS_READONLY=, RELATED_CONT_READONLY=[1068730] SRI implications for Mercer clients and industry, FLG_EXCEPTION_PRICING=0, REVENUE_OWNER_EMAILS=, GEOGRAPHY_IDS=201000000, NME_PUB_PRI_FLAG=0, Data Analyzed/0/DATA_ANALYZED_IDS=, Survey Schedule/0=, IND_CATEGORIES=7, Position Families Analyzed/0/SIB5=f, Position Families Analyzed/0/LOOKUP_JOB_GROUP_READONLY=f, FLG_ONLINE_FULFILLER=GIS, Job Participants/0/SIB4=df, Position Families Analyzed/0/Position_Families_Analyzed=, nme_cms_coordinator=Manish Joshi, Survey Schedule/0/DT_QUESTIONNAIRE=12-September-2006, NME_SURVEY_PARTICIPANT=, FEE_SCHEDULE_TEXT=f, Attachments=, TOPICS_READONLY=Global Mobility compass, FLG_AVAILABLE_NOW=0, Data Submission Tools/0/Data_Submission_Tools=, dt_expiration=12-March-2009, Data Analyzed/0/Data_Analyzed=, ind_survey_type=A, id_language=500, ind_survey_group=1, nme_file_path_hp_thumbnail=, EULA=hf, TOPIC_IDS=140200040, flg_display_SIPYear=1, nme_file_path_hp_lead_story=, Data Submission Tools/0/SIB10=dfg, path=templatedata\gis\Survey\data\test_survey, NME_BILLBOARD_SUMMARY=cvd, ind_content_type=2001, TRANSLATED_CONT_IDS=, Marketing_Component=, Job Participants/0/Job_Participants=, Data Analyzed/0/DATA_ANALYZED_READONLY=f, nme_file_path=, Contact Details=, FLG_PARTICIPANT=0, Position Families Analyzed/0/LOOKUP_JOB_LISTING_IDS=, Survey Schedule/0/DT_PARTICIPATION=12-September-2006, Data Collected/0/DATA_COLLECTED_READONLY=f, Data Analyzed/0/SIB7=f, Position Families Analyzed/0/FREEFORM_JOB_LISTING=f, IND_PAYMENT_METHOD=, NME_BILLBOARD_HEADLINE=ttt, Job Participants/0/JOB_PARTICIPANTS=f, TeamSite/Templating/DCR/Type=gis/Survey, nme_image_alt_text=, ind_survey_country=139, Survey Schedule/0/flg_show_dates=, flg_content_restriction=F, NME_DETAILED_BODY_PATH=/body/english/2006/1047946_gis_detailed_body.html, Job Participants/0/flg_show_statistics=, IND_IMP_MAGAZINE_PAGE=0, Data Collected/0/SIB6=f, NME_LONG_SUMMARY=vxcvxcvxcv
xcvxcv
cxvxcv, Data Analyzed/0=, RELATED_CROSS_SELLS_IDS=, DT_SURVEY=12-September-2006, Data Collected/0/DATA_COLLECTED_IDS=, PRICING_READONLY=, Download=, GEOGRAPHY_READONLY=*Global, SIB8=dfg, Right Marketing Component/0=, Data Collected/0=, Author Reviewer Info=, RELATED_SERVICES_READONLY=, Data Collected/0/Data_Collected=, SIB3=df, Job Participants/0/NME_JOB_PARTICIPANT_PATH=, Job Participants/0=, NME_LONG_HEADLINE=vxcvxcv, Data Submission Tools/0=, NME_EULA_PATH=/eula/1047946_eula.html, IWOV_PROC_FLAG=true, state=Original, Position Families Analyzed/0/LOOKUP_JOB_LISTING_READONLY=df, Survey Schedule/0/SIB9=df, MCG_ACCESS_PERIOD=, Right Marketing Component/0/Right_Marketing_Component=}
DBD: ERROR:Exception occured: null
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.GetColumnValuesFromTuple(TDbSchemaGroupCfg.java:2170)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmtForExistCheck(TDbSchemaGroupCfg.java:2128)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2054)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1063)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1042)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:419)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:334)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:974)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:261)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:194)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:545)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/gis/Survey/data/test_survey
DBD: ERROR:deployment [iMercerSurvey] FAILED
I have attached the DCR and the datadeploy configuration is down below.
area ="$area">
db = ""
user = ""
password = ""
vendor = "microsoft-inetuna"
timeout="10" max-id-length = "128"
update-type="standalone" state-field="state"
delete-tracker="yes" enforce-ri="no">
thx in advance
MJ
