BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: BI + Analytics conference: Aug 9.

Getting Error in DQM real-time job


 
Search this topic... | Search DI: Data Quality... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Data Quality  Previous TopicPrint TopicNext Topic
Author Message
rajeev_khokhar1
Senior Member
Senior Member



Joined: 19 Jan 2011
ASUG Icon
Posts: 60
Location: India


flag
PostPosted: Mon Oct 17, 2016 4:41 am 
Post subject: Getting Error in DQM real-time job

Hi All,

We are facing below error in Real time job service after postal directory upload and SAP data service restart-
Job name: Service_RealTime_DQ_SAP_Name_And_Address_Ext_Match

Please assist me how I can resolve it and in which transform I can track this error .
Error Message;

Job_Realtime_DQ_SAP_Name_And_Address_Ext_Match
Syntax error at line <967>: <SELECT Prep_Records.DATA_SOURCE_ID, ((Prep_Records.Name_First || ' ') || Prep_Records.Name_Last),
((Prep_Records.Name_Last || ' ') || Prep_Records.Name_First), Prep_Records.firstname1, Prep_Records.lastname1,
Prep_Records.rec_num, Prep_Records.Name_First, Prep_Records.Name_Last, Prep_Records.house_num1, Prep_Records.Street,
Prep_Records.City1, Prep_Records.Country, Prep_Records.Post_Code1, Prep_Records.region, Prep_Records.threshold,
cf_dq_sap_get_generic_field('F1', MA), cf_dq_sap_get_generic_field('F2', MA),
cf_dq_sap_get_generic_field('F3', MA), cf_dq_sap_get_generic_field('F4', MA),
cf_dq_sap_get_generic_field('F5', MA), Prep_Records.PO_BOX, Prep_Records.POST_CODE2 FROM Prep_Records>: near <;> found
<SUBVARIABLE> expecting <')', ','>.

_________________
Rajeev khokhar
SAP-BODS Developer
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Data Quality  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0087 seconds using 17 queries. (SQL 0.0020 Parse 0.0002 Other 0.0065)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo