Error Number 29549
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev centers Retired content Samples We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: Problem applying SQL KB955706, MSP Error: 29549 Using Forums > Off-Topic Posts (Do Not Post Here) Question 0 Sign in to vote Failed to upgrade an SQL 2005 SP2 to SP3 with MSP Error: 29549 returned. KB Number: KB955706 OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790) Package Language: 1033 (ENU) Package Platform: x64 Package SP Level: 3 Package Version: 4035 Command-line parameters specified: Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.3.4035 x64 Database Services (MSSQLSERVER) ENU SP3 2005.090.4035.00 x64 ENTERPRISE SQL Server Native Client ENU 9.00.4035.00 x64 Client Components ENU SP2 9.2.3042 x64 ENTERPRISE MSXML 6.0 Parser ENU 6.20.2003.0 x64 SQLXML4 ENU 9.00.4035.00 x64 Microsoft SQL Server VSS Writer ENU 9.00.4035.00 x64 ********************************************************************************** ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 3042 Product Version (Final) : Status : Failure Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB955706_sqlrun_tools.msp.log Error Number : 29549 Error Description : MSP Error: 29549 Failed to install and configure assemblies C:\Program Files (x86)\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087 Error message: Unknown error 0x80131501
Internet of Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private Cloud Information Governance Information https://social.msdn.microsoft.com/Forums/en-US/6319d8e6-3856-4cda-8268-c2c618424b74/problem-applying-sql-kb955706-msp-error-29549?forum=Offtopic Management IT Service Management Operations Management Server Management Software as a Service (SaaS) Software-Defined Data Center Storage Management All Software Servers Rack Servers Tower Servers Blade Servers Density Optimized Mission Critical Servers Servers for Cloud Server Management All Servers Storage All-flash and Hybrid Storage Midrange http://h20564.www2.hpe.com/hpsc/doc/public/display?docId=emr_na-c01846352&lang=en-us&cc=us and Enterprise Storage Entry Storage Systems Data Availability, Protection and Retention Software Defined Storage Management and Orchestration Storage Networking All Storage Networking Switches Routers Access Points and Controllers Wireless LAN Campus and Branch Networking Data Center Networking Wide Area Network Software Defined Networking Network Functions Virtualization Network Management All Networking About UsSupportClearType to search2086159Solutions Transform to a Hybrid Infrastructure Protect Your Digital Enterprise Empower the Data-Driven Organization Enable Workplace Productivity Cloud Security Big Data Mobility Infrastructure Internet of Things Small and Medium Business Service Providers All Solutions Services Advise, Transform and Manage Financing and Flexible Capacity IT Support Services Education and Training Services All Services Products Integrated Systems Composable Systems Converged Systems Hyper Converged Systems Blade Systems Infrastructure Management Software Application Lifecycle Management Application Delivery Management Big Data Analytics DevOps Enterprise Security Hybrid and Private Cloud Information Gove
and execute it in the same session. E.g. (from http://forums.oracle.com/forums/thread.jspa?threadID=856644) (Oracle 10gR2) SQL> CREATE OR REPLACE AND RESOLVE JAVA SOURCE NAMED "testc" AS public class testc { public http://mostlyoracle.blogspot.com/2010/09/ora-29549-java-session-state-cleared.html static int testm() { return 0; } } / --create plsql wrapper function create or replace FUNCTION TEST RETURN NUMBER IS LANGUAGE JAVA NAME 'testc.testm() return int'; cat call_test.sql declare result http://psoug.org/oraerror/ORA-29549.htm number; begin result :=test; end; / SQL> @call_test PL/SQL procedure successfully completed. Now alter the java object ... SQL> alter java source "testc" compile; Java altered. SQL> @call_test declare * ERROR at line 1: error number ORA-29549: class USER1.testc has changed, Java session state cleared ORA-06512: at "USER1.TEST", line 1 ORA-06512: at line 4 Call it again and it executes sucessfully: SQL> @call_testPL/SQL procedure successfully completed. Note that to produce the error, testc must be called first. If the java code is not called before the alter java, then the error does not occur, ie login, do some sql not involving testc, then error number 29549 alter java. After the alter java, calling testc does not produce any errors. Looks like running the code sets some sort of session state for the java object, and this state conflicts with the results of the alter java, producing the error. If the state is not set first, then altering the java code does not cause any errors. Running testc in a separate session never produces errors, whether run before or after the alter java. SQL> alter system set events '29549 TRACE NAME ERRORSTACK LEVEL 3'; ... generates trace file with the calling code (contents of call_test.sql). Change to ERRORSTACK OFF when not required. Posted by orcladmin at 3:23 PM No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Followers Blog Archive ► 2015 (1) ► November (1) ► 2014 (1) ► June (1) ► 2013 (1) ► January (1) ► 2012 (3) ► December (2) ► August (1) ▼ 2010 (3) ▼ September (2) ORA-29549 Java session state cleared Invalid Objects From Dropping Function Based Index... ► May (1) ► 2009 (8) ► December (1) ► November (2) ► October (2) ► September (3) About Me orcladmin View my complete profile
Library mySQL Code Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-29549 Error Description: Class string.string has changed, Java session state cleared Error Cause: A class in use by the current session was redefined or dropped, invalidating the current Java session state and requiring that it be cleared. Action: No action required. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 166 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?