Due To Error 70301
Contents |
Services and Data QualityWhere is this place located?All Places Data Services and Data Quality 5 Replies Latest reply: Nov 13, 2013 6:53 PM by Ganesh Narayanan Tweet
Sap Data Services Sql Function
Issue with SQL function in SAP BODS Ganesh Narayanan Oct 16, bods sql script syntax 2013 6:52 PM Currently Being Moderated Hi All,I am looking for SQL help in BODS v4.0I have given the below sql in a script and trying to run in BODS. While execution i am getting an error as Failed due to error <70301> Ora-90005 missing key word; sql('DS_STG', '(select Branch_Plant, dataset_name INTO Gv_Branch_Plant, $Gv_DSName from(select Rgn_Mkt_Cntry,Branch_Plant, dataset_name,row_number() over (partition by Rgn_Mkt_Cntryorder by Rgn_Mkt_Cntry, Branch_Plant) AS Row_IdFromSTG_SCM_BRANCH_PLANT_PARAMETER)where Rgn_Mkt_Cntry = {$Gv_Rgn_Mkt_Cntry} and ROW_ID = {$Gv_Row_ID} ');FYI: The syntax is validated in the JOB.Only run time it is giving error. I tried giving begin end and no positive result.I know by assning to global variable individually as Gv_Branch_Plant = Sql or Gv_DSName will work.But i want the value to be taken in one sql instead of two.Can some one tell me assigning two variables into in the sql will be possible. Thanks in advanceRegards,Gannu 3619Views Re: Issue with SQL function in SAP BODS Titto Antony Oct 17, 2013 5:12 AM (in response to Ganesh Narayanan) Currently Being Moderated Hi Ganesh,Can you provide the error message that you are getting while executing the job.Also Try [] instead of {} around the global variable. Also provide ' around the global variable if it is passing the string valueEg:\'[$Gv_Rgn_Mkt_Cntry]\' Alert Moderator Like (1) Re: Issue with SQL function in SAP BODS Ganesh Narayanan Oct 17, 2013 5:24 PM (in response to Titto Antony) Currently Being Moderated Hi Tito,I am getting below while callingonChangeDocID How to pass value of Input control to othertabs → Data flow is terminated due to error. December 4, 2014 1 Comment SAP BODS job is running till the end but at the last data flow failing with the below error: Data flow is terminated due to error <70301>. Further error: Execution of about this channel Embed this content in your HTML Search confirm cancel Report adult content: click to rate: Account: (login) More Channels Showcase RSS Channel Showcase 4597836 RSS Channel Showcase 2348505 RSS Channel Showcase http://quality1288.rssing.com/chan-14313665/all_p26.html 5307711 RSS Channel Showcase 2847523 Channel Catalog Subsection Catalog Articles on this Page (showing articles 501 to 520 of 4013) 11/04/13--04:49: _Help me in Intervie... 12/03/13--03:59: _Code Page conversio... 11/29/13--02:28: _Write(load) data in... 10/02/08--15:00: _SAP Data http://www.walgreens.com/locator/walgreens-195+n+canal+blvd-thibodaux-la-70301/id=4140 Services B... 12/02/13--23:45: _Error when DS loads... 12/05/13--03:46: _Value- Aid to Busin... 12/04/13--21:38: _SAP Data Services 4.2 11/27/13--23:14: _Prerequisite check ... 12/05/13--17:26: _why it is loading t... 12/01/13--21:46: _ORA-01480: trailing... 12/06/13--00:01: _BODS Extraction fro... 12/05/13--22:07: due to _Sizing guide for BO... 05/30/13--06:48: _AL_RWJobLauncher re... 12/06/13--00:18: _How to specify the ... 12/06/13--09:17: _Data Services 4.0 P... 11/18/13--04:43: _Data Services 4.0 S... 12/10/13--22:40: _Installation of Dat... 12/10/13--22:14: _Append rows in SAP ... 12/10/13--10:48: _RFC BAPI import par... 12/11/13--06:24: _Query sorting doesn... (showing articles 501 to 520 of 4013) Browse the Latest Snapshot Browsing All Articles (4013 Articles) Live Browser Channel Description: All Content in Data Services and Data Quality older | due to error 1 | .... | 23 | 24 | 25 | (Page 26) | 27 | 28 | 29 | .... | 201 | newer 0 0 11/04/13--04:49: Help me in Interview Preparetion Tips Contact us about this article Hi, I have done SAP DS course from a small institute. I am very new to SAP field, previously I was working on JAVA. Now I have the best overall idea about DS and BW concept, and now proficient to work in DS. But I didn't work in real time projects and don't have any idea about the SAP interviews.How can I tackle the interviews. Or any suggestion to get a job in DS. I have 4 years of experience. Advance Thanks, Sabat 0 0 12/03/13--03:59: Code Page conversion error - ECC to HANA Contact us about this article Hi, While trying to move data from SAP ECC to HANA via BODS we get the following error - 'System number <12: CRFC error: RFC_CONVERSION_FAILURE- Could not convert from 4103 codepage to 1100 codepage rc = 2048[SAP 20712 7180 R3C-150101 12/3/2013 4:29:49 PM Partner]>. Make sure the SAP server is running and the login information is correct' The code page field for ECC data store is set to 'D Rewards start main content Your Walgreens Store Invalid Input Entry. Please go back to storelocator page Error: Service is temporary unavailable for this store. Patient care services at Healthcare Clinic locations at Walgreens are provided by Take Care Health Services, an independently owned professional corporation whose licensed healthcare professionals are not employed by or agents of Walgreen Co., or its subsidiaries, including Take Care Health Systems, LLC. Patient care services at DR Walk-in Medical Care locations at Duane Reade are provided by Take Care Medical Health New York, P.C., an independently owned professional corporation and provider practice whose licensed healthcare professionals are not employed by or agents of Walgreen Co., or its subsidiaries, including Duane Reade and Take Care Health Systems, LLC. Walgreen Co. and Take Care Health Systems, LLC provide management services to in-store clinics and provider practices. {{surveyMessage}} Find everything you wanted to know about this store? Yes No Tell us how we can improve this page: Tell us how we can improve this page: Submit omnitureLink1 Beginning of dialog content Close Are You Still There? Due to inactivity, you will be signed out of Walgreens.com soon.Please choose to continue your session or sign out now. Continue session Sign out End of dialog content