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)  

Sat Jun 16, 2018 12:06 pm: The BOB server was upgraded (O/S and database) today. If you encounter any errors, please post on the board. Posting has been tested and seems to be working. Thanks.
General Notice: Upcoming Events: IBIS 2018: Jun 18, BI & HANA 2018 Prague: Jun 29.

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
Senior Member
Senior Member

Joined: 19 Jan 2011
Posts: 60
Location: India

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;

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.0100 seconds using 17 queries. (SQL 0.0022 Parse 0.0002 Other 0.0076)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo