Failed Due To Error 70401

+ Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23, FLBOUG, Clearwater: Oct 28, ASUG Northern California: Nov 2, ASUG Arizona Chapter: Nov 3, ASUG All Texas Chapter Meeting: Nov 11. Error 70401 in bods 3.2 Search this topic...|Search DI: Designer and Job Design...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Data Integrator -> DI: Designer and Job Design Author Message ursfriend77Principal MemberJoined: 02 Mar 2011Posts: 129 Posted: Tue Dec 17, 2013 1:53 amPost subject: Error 70401 in bods 3.2 Hi, 1636 3012 RUN-050304 12/17/2013 11:35:50 AM Function call failed, due to error 1636 3012 RUN-050304 12/17/2013 11:35:50 AM <70401>: error message for operation : <[Microsoft][ODBC SQL Server Driver][SQL 1636 3012 RUN-050304 12/17/2013 11:35:50 AM Server]Incorrect syntax near 'STARTED'.>.>. Thanks Venki Back to top ErikRForum EnthusiastJoined: 10 Jan 2007Posts: 1012Location: Wellington, NZ Posted: Tue Dec 17, 2013 3:37 amPost subject: Re: Error 70401 in bods 3.2 There's a bracket missing in that log message - or was that a copy and paste error? There should be 2 brackets but only one is shown. This: Quote: sql ( ODS_DS_TRG_SQL, INSERT INTO BODS_TARGET.BATCH VALUES('CUSTOMER_DIM','STARTED' ) Should be: Quote: sql ( ODS_DS_TRG_SQL, INSERT INTO BODS_TARGET.BATCH VALUES('CUSTOMER_DIM','STARTED' )) How many columns does that BATCH table has? I have seen this problem and a similar SQL error occur when the last column name in the query is actually a reserved word. I've had a very similar problem on Oracle and the error message brought back through Data Services showed that the last column, with the reserved word as column name, was missing from the error message. Changing this missing column name into something that was not an Oracle reserved word fixed the problem - hence my question if your table really has only 2 columns? I have created a "BATCH" table on my SQL Server 2008 R2 database server, with 2 varchar(50) columns - "DW_Table", "Job_Status", assuming that's what the purpose is of the columns you are trying to populate in the log message shown above. This works fine: Code: INSERT INTO BATCH VALUES('CUSTOMER_DIM','STARTED') But dropping the last bracket from the statement, like so: Code: INSERT INTO BATCH VALUES('CUSTOMER_DIM','STARTED' ...results in this error: Code: Msg 102, Level 15, State 1, Line 1

and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and http://www.forumtopics.com/busobj/viewtopic.php?p=974857 AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign http://scn.sap.com/thread/3306335 NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional Serv

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 3089921 RSS Channel Showcase 6869970 RSS Channel Showcase http://quality653.rssing.com/chan-14313680/all_p116.html 9988993 RSS Channel Showcase 3373259 Channel Catalog Subsection Catalog Articles on this Page (showing articles 2301 to 2320 of 4237) 09/30/13--14:06: _BW to HANA Migratio... 02/26/13--17:03: _Can Data Services 4... 03/31/15--10:53: _A DATA_BUFFER_EXCEE... 04/09/15--22:41: _Is MS Office 2013 3... 04/10/15--00:37: _RFC_ABAP_RUNTIME_FA... 04/10/15--04:44: _SDK: Uncaught excep... 04/10/15--11:02: _Upgrade to 4.2 SP4 ... 04/08/15--11:37: _Script error - Inse... 04/10/15--11:27: _DataServices loads ... 03/17/15--14:56: _execute an stored p... 03/18/15--06:05: _Data flows are gett... 03/18/15--14:03: failed due _Need an Idea or Logic 09/04/13--12:00: _Installing data qua... 04/09/15--01:40: _Facing a problem wi... 04/07/15--06:20: _facing a problem wh... 02/10/15--06:35: _SIA Error Failed to... 04/13/15--01:24: _Passing values to g... 04/08/15--03:54: _Creating Multiple X... 04/14/15--00:32: _Pros and Cons of In... 04/13/15--06:36: _SAP Data Services j... (showing articles 2301 to 2320 of 4237) Browse the Latest Snapshot Browsing All Articles (4237 Articles) Live Browser Channel Description: Latest Forum Threads in Data Services and failed due to Data Quality older | 1 | .... | 113 | 114 | 115 | (Page 116) | 117 | 118 | 119 | .... | 212 | newer 0 0 09/30/13--14:06: BW to HANA Migration - BODS Error 70401 Contact us about this article Hello,   The error that i've been encountering which i am totally clueless about is   1556 9656 DBS-070401 9/30/2013 4:35:56 PM ODBC data source error message for operation : <[SAP AG][LIBODBCHDB DLL] Integrity constraint violation>.   this occurs when the data is being populated in a table in HANA from BW as source.   Any inputs would be highly beneficial.   Thanks, Govi 0 0 02/26/13--17:03: Can Data Services 4.1 Datastore connect to 32-bit MSSQL 2005 DB? Contact us about this article I cannot seem to find a definitive answer to the following question:  Can a Data Services 4.1 (14.1.1.0000) Datastore connect to a 32-bit MS SQL Server 2005 database?   If the answer is "Yes", can someone point me to the documentation / installation instructions?   Background info:   DS 4.1 is installed on MS Windows 2008 R2 Standard SP1 (64-bit) CMS is installed on MSSQL Server 2008 R2 64-bit on MS Windows 2008 R2 Standard SP1 (64-bit)   We are trying to resol