Solved: RWD 4.3 Error -Jakarta/ISAPI/isapi_redirector/1.2....

Former Member · ‎12-23-2011

Hello Experts,

I have installed the RWD SPP 4.3 with 2 servers from DVD 51039413, one for the sql 2008 database and other for search and vignette server on windows 2008.

Search server installed successfully however I received 2 errors in vignette installation but finally it shows that server is installed successfully. These are the 2 errors-

1) An Error was detected during database schema upgrade (however connection test was successfull fr the sql database).
2) Error Occured while editing the glossary database.

I have created the new user for glossary database during installation but when I select create new database it gives me the error "The SA user credentials that you have presented doesn't apear to have sufficient rights" even I tried with sa user as well so I choose the option "Upgrade Existing Glossary Database" and provide the database name that I created for glossary/publishing database.

I also ran the below commands as described in admin guide-

1) Install the supported version of ASP.NET, 32-bit version by entering the following command on the command line:cscript
%SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET
W3SVC/AppPools/Enable32bitAppOnWin64 1. (Do not include the period.)

2) Install 32-bit ASP.NET 2.0 using the 32-bit framework folder:
%SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i. (Do
not include the period.)

After the installation I tried to access the server hostname in mozilla browser but I received the below error-

Service Temporary Unavailable!

The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
 
  Jakarta/ISAPI/isapi_redirector/1.2.30

I will paste the collaboration log in next comment-

Also how can we create a message with SAP and how to register this ancile in SMP.

Kindly advice.

Regards

Saurabh Mishra

Former Member · ‎01-15-2012

Hi Saumishr,

For message creation please see following link.

https://websmp110.sap-ag.de/~sapidp/011000358700000905192010E/

The errors you receive may be due to using the DBA account

credentials for the Collaboration Database user account during the

installation. To resolve the issue, please uninstall uPerform by

performing the steps listed in Chapter 8 of the Administration Manual.

You can leave the Solr installation alone. Next, have your DBA re-create

the Collaboration and Glossary Databases by performing the steps listed

in Chapter 3 of the Administration Manual (Section: Creating Microsoft

SQL Server Databases, page 19). Finally, re-install uPerform, making

sure that you do not use the SQL DBA account for the Collaboration User

as the Collaboration User and Glossary User cannot have system admin

rights. The SQL DBA account will automatically create the accounts

during the install. If you have any questions, please let us know.

Hope this helps,

Best Regards,

Matthew

622536

Former Member · ‎01-16-2012

Thanks Matthew,

Issue was resolved by after creating the database option in vignette but as per the admin guide they have choose the update the existing database so the table was not created in the Collaboration database.

Regards

Saurabh Mishra

Former Member · ‎12-23-2011

[Dec 23, 2011 7:11:46 AM (main)]: SQL Server database adaptor initialized.

[Dec 23, 2011 7:11:46 AM (main)]: Connected to Microsoft SQL Server Microsoft SQL Server 2008 - 10.0.4000

java.sql.SQLSyntaxErrorException: [Vignette Corp.][SQLServer JDBC Driver][SQLServer]Invalid object name 'CL_PROPERTIES'.

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BasePreparedStatement.postImplExecute(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BaseStatement.executeQueryInternal(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.vignette.jdbc.sqlserverbase.BasePreparedStatement.executeQuery(Unknown Source)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.objrel.db.jdbc.JDBCPropertiesHandler.getProperties(JDBCPropertiesHandler.java:58)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.ITSConfig.initCachedProps(ITSConfig.java:190)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.ITSConfig.getITSProp(ITSConfig.java:338)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.ITSConfig.getProperty(ITSConfig.java:1052)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.ITSConfig.initProperties(ITSConfig.java:379)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.ITSConfig.initProperties(ITSConfig.java:370)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.StartupService.init(StartupService.java:238)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager$1.run(ServiceManager.java:240)

[Dec 23, 2011 7:11:46 AM (main)]: at java.security.AccessController.doPrivileged(Native Method)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager.doInitialize(ServiceManager.java:236)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.AbstractKernel.doInitializableInit(org/apache/avalon/engine/AbstractKernel.java:503)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager.loadBlock(ServiceManager.java:193)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.AbstractKernel.loadDependancies(org/apache/avalon/engine/AbstractKernel.java:347)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager.loadBlock(ServiceManager.java:140)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.AbstractKernel.loadDependancies(org/apache/avalon/engine/AbstractKernel.java:347)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager.loadBlock(ServiceManager.java:140)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.AbstractKernel.loadDependancies(org/apache/avalon/engine/AbstractKernel.java:347)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager.loadBlock(ServiceManager.java:140)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.AbstractKernel.loadDependancies(org/apache/avalon/engine/AbstractKernel.java:347)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager.loadBlock(ServiceManager.java:140)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.AbstractKernel.loadBlocks(org/apache/avalon/engine/AbstractKernel.java:220)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.AbstractKernel.init(org/apache/avalon/engine/AbstractKernel.java:105)

[Dec 23, 2011 7:11:46 AM (main)]: at org.apache.avalon.engine.Avalon.init(Avalon.java:42)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.ServiceManager.init(ServiceManager.java:306)

[Dec 23, 2011 7:11:46 AM (main)]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[Dec 23, 2011 7:11:46 AM (main)]: at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

[Dec 23, 2011 7:11:46 AM (main)]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

[Dec 23, 2011 7:11:46 AM (main)]: at java.lang.reflect.Method.invoke(Method.java:597)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:224)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.management.CBSMBeanServer.invoke(CBSMBeanServer.java:320)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.ITSMain.execute(ITSMain.java:65)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.ITSMain.main(ITSMain.java:159)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.NTSMain.<init>(NTSMain.java:32)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.main.NTSMain.main(NTSMain.java:38)

( (:initial java.sql.SQLSyntaxErrorException: [Vignette Corp.][SQLServer JDBC Driver][SQLServer]Invalid object name 'CL_PROPERTIES'.)(:msg [Vignette Corp.][SQLServer JDBC Driver][SQLServer]Invalid object name 'CL_PROPERTIES'.) )

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.objrel.db.jdbc.JDBCUtil.wrapException(JDBCUtil.java:83)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.objrel.db.jdbc.JDBCUtil.wrapException(JDBCUtil.java:27)

[Dec 23, 2011 7:11:46 AM (main)]: at com.intraspect.objrel.db.jdbc.JDBCPropertiesHandler.getProperties(JDBCPropertiesHandler.java:84)