Error During Sql Execution Da0003
Analytics Conference: Oct 18, Mastering SAP BI, Melbourne: Oct 23. Error during SQL execution (DA0003) Search this topic...|Search Desktop Intelligence...|Search Box Select a search Explain These Choices... --------------------Recent Topics (All Forums) Unanswered Posts Register or Login to Post Forum Index -> Building Reports -> Desktop Intelligence Author Message ichrakchouForum MemberJoined: 28 Jan 2009Posts: 21 Posted: Tue Feb 16, 2010 9:20 amPost subject: Error during SQL execution (DA0003) hi, i have error executing a desktop report, when i executed in an interval of 3 months it works but when i executed in an interval of 12 months an errors occurs: Error during SQL execution (DA0003) in sql when i import the sql it works fine and returns results (after 40 min) but in desktop it only stays 20 min and shows this error. i thought it have a relation with the DesktopReport server and DesktopCacheServer in the close connexion after a period but i set it to 300 min also i cheked this option(close connexion after time of inactivity) in the universe. please help Back to top dgpotterSenior MemberJoined: 04 Jan 2010Posts: 96Location: London Posted: Tue Feb 16, 2010 9:34 amPost subject: Re: Error during SQL execution (DA0003) Check the Universe Parameters, Controls tab to see if the "Limit execution time to:" is set._________________Available for contract work April 2011 Business Objects Versions 5, 6, XI R2, 3.1 SP3 Data Integrator 11.7 Oracle, SQL Server, Informix & DB2 Back to top ichrakchouForum MemberJoined: 28 Jan 2009Posts: 21 Posted: Tue Feb 16, 2010 12:30 pmPost subject: Re: Error during SQL execution (DA0003) hi, i check it , its not set. it is uncheked. Back to top ichrakchouForum MemberJoined: 28 Jan 2009Posts: 21 Posted: Wed Feb 17, 2010 3:17 amPost subject: Re: Error during SQL execution (DA0003) in fact i have this error message: Error during SQL execution (DA0003) Exception: DBD,[Microsoft][ODBC SQL Server Driver]Timeout expired State : HY000 Back to top ichrakchouForum MemberJoined: 28 Jan 2009Posts: 21 Posted: Wed Feb 17, 2010 4:10 amPost subject: Re: Error during SQL execution (DA0003) sorry its SQL STATE: HYT00 Back to top ichrakchouForum MemberJoined: 28 Jan 2009Posts: 21 Posted: Thu Feb 18, 2010 5:50 amPost subject: Re: Error during SQL execution (DA0003) i solved the problem. in fact there are quite a few places where the timout can be set so you need to check all of these : 1. Universe - Timout parameter limit in the Universe (Designer) 2. DesktopIntelligenceReportServer Connectio
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 AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing http://www.forumtopics.com/busobj/viewtopic.php?p=698397&sid=94ec09bd4d92c0eed9a7df0998ac6709 NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign 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 https://scn.sap.com/thread/1684400 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 ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsC
Data Services (1) Charts (8) Data Modeling (1) Data Warehouse (8) DBMS (6) Desktop Intelligence (49) Entrepreneur (1) ERP (2) ETL (3) General Knowledge (6) Informatica (1) Interview Questions (29) Jaspersoft (9) Java (4) Linux (1) OBIEE (7) Oracle DBA (28) http://dba1admin.blogspot.com/2014/02/business-objects-deski-error-during-sql.html Oracle PL/SQL (5) Oracle SQL (38) Pentaho (2) Perl (1) PHP (8) PMP (1) Postgres SQL (65) Python (1) Reports (1) SAP BOBJ (19) SAP HANA (2) SQL (15) SQL Server (6) Startup (2) Technologies (5) Universe Designer (9) Unix (5) Web Intelligence (17) WebSphere (41) Blog Archive ► 2015 (64) ► December (20) ► Dec 27 (2) ► Dec 20 (1) ► Dec 18 (4) ► Dec 16 (10) ► Dec 06 (1) ► error during Dec 03 (1) ► Dec 02 (1) ► November (3) ► Nov 29 (3) ► October (41) ► Oct 08 (41) ▼ 2014 (115) ► December (1) ► Dec 18 (1) ► November (3) ► Nov 17 (1) ► Nov 09 (1) ► Nov 07 (1) ► September (9) ► Sep 11 (9) ► August (1) ► Aug 21 (1) ► March (5) ► Mar 21 (5) ▼ February (89) ► Feb 25 (1) ▼ Feb error during sql 07 (80) Business Objects - IRF - Payroll Sequence and Tran... Business Objects - AURA-Grants Reporting - Standar... Business Objects - DeskI - Merge duplicate header ... Business Objects - Deski - Webi - Pulling Active A... Business Objects - WebI - Problem with Report Tabl... Business Objects - DeskI - Error on First Document... Business Objects - Webi - How do I hide a column i... Business Objects - DeskI/ WebI - Embed a Hyperlink... Business Objects - DeskI - Adding a Filter to a Re... Business Objects - WebI - Problem Copying and Past... Business Objects - DeskI - Dynamic Filters - Defin... Business Objects - DeskI - Compare to Previous Val... Business Objects - InfoView - WebI - Error / Issue... Business Objects - DeskI - Problem When Refreshing... Business Objects - Deski - Adding conditions to a ... Business Objects - DeskI - Creating Alternating Ta... Business Objects - InfoView - getting error messag... Business Objects - DeskI - Creating an Aggregate V... Business Objects - Deski - Creating a Exclusion fo... Business Objects- Deski - Advanced - Getting a #Co... Business Objects - DeskI - Open and Refresh Data f... Business Objects - DeskI - Changing the User Docum... Business Objects - Deski - Uploading a Deski Repor... Business Objects - DeskI / WebI - Using Wildcards ... Business
be down. Please try the request again. Your cache administrator is webmaster. Generated Tue, 11 Oct 2016 09:38:33 GMT by s_ac15 (squid/3.5.20)