Database Error 904 At Fet
Contents |
on IBM iWhere is this place located?All Places SAP on IBM i 10 Replies Latest reply: Oct 24, 2013 9:10 AM by Rüdiger Höckel Tweet SQL error "-904" occurred when accessing table sql error in the database when accessing a table in sap "A073 ". Ernesto Castro Feb 29, 2012 11:27 AM Currently Being
Sql Error Sap
Moderated Hi Guys,We have many dumps when run a program in our system R/3 4.6C over V5R3M0.The many sql error sql code: -10108 dumps is:DBIF_RSQL_SQL_ERROR SQL error "-904" occurred when accessing table "A073 ".OSS SAP say that i have to delete SQLPKG when the error appear.I execute this deletion all weekend with DLTR3PKG; sql error -911 when accessing table in sap but the packages overflow quickly and i can close the system only the sunday.Any suggestions? i try delete the A073 SQLPKG with the command: WRKOBJ OBJ(ALL/A073) OBJTYPE(SQLPKG) on-line the last week; and we have many errors after this delete (all process with access to this table not run).I increase the SQLPKG´s size to 1 GB (note 306823), but the problem
Sql Error In The Database When Accessing A Table Sap Bw
persist.Best Regards,Ernesto Castro. 13004Views Re: SQL error "-904" occurred when accessing table "A073 ". Kaushal Malavia Dec 5, 2007 7:46 AM (in response to Ernesto Castro) Currently Being Moderated HI,your problem is solved only by deleting SQLPKG,don't perform this operatation online, you need to shutdown the sap server and delete SQLPKG and restart SAP Server solve your problem,also look at note 306823 to increase SQLPKG Size to 1 GB,regards,kaushal Alert Moderator Like (0) Re: SQL error "-904" occurred when accessing table "A073 ". Volker Gueldenpfennig Dec 5, 2007 7:42 AM (in response to Ernesto Castro) Currently Being Moderated Hi Eresto,in my eyes, you have to fix the root cause:You are having programs written - most likely yourself - that do access this table in a way where millions of different SQLs are generated.You should hunt for these programs and modify them. I know, it might be a bit complicated - but that is the only true solution ...RegardsVolker Gueldenpfennig, consolut international aghttp://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de Alert Moderator Like (0) Re: SQL error "-904" occurred when access
phpBB Group
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB http://www.dba-oracle.com/t_exp_00008_904_error.htm Don Burleson Blog
EXP-00008: ORACLE error 904 encountered tips Oracle tips by Burleson Question: I am trying to export a table and I have this "EXP-00008: ORACLE error 904 encountered" error message: Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production About to export specified tables sql error via Conventional Path ... EXP-00008: ORACLE error 904 encountered ORA-00904: invalid column name Answer: The EXP-0008 with the 904 "invalid column name" will always write a trace file, and you can check the trace file in your UDUMP directory to see the specific cause. The "EXP-00008: ORACLE error 904 encountered" error can happen for several reasons: The most common sql error in cause of the EXP-0008 with the 904 code is a mismatch between the Oracle client and the database. Verify that the version of your exp utility matches the database version. This 904 error can happen if you forget to run catproc.sql. Also see MOSC Note:1017276.102 "Oracle8i Export Fails on Synonym Export with EXP-00008 and ORA-00904". This notes that a synonym named "DBMS_JAVA" or "DBMS_JAVA_TEST" may exist without a corresponding package. Get the Complete Oracle Utility Information The landmark book "Advanced Oracle Utilities The Definitive Reference" contains over 600 pages of filled with valuable information on Oracle's secret utilities. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. �� Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA