Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

NetWeaver Sneak ... SP 16: table PVC_ACTVERSVIEW missing

Hi all,

I came across some problem when trying to execute <b>scenario 2+ of JDI development (use DTR, components and tracks)</b>.

My situation is as follows:

Installation of Sneakpreview NW 04 SP 16, the one with problems in step 6, then exchanged the database version with the one from before ( 7.5.0 Build 018-123-079-776 )

<b>Installation is successful, everything seems fine.</b>

I create users, setup SLD, etc.

Finally I setup a simple track with a SC, define a runtime system.

<b>Then I try to download configuration from NetWeaver Developer Studio. And I end up with the error in the logs that you can see at the end of this.</b>

Ok, some table or view is missing. I reinstall the whole thing. This time I check for the table right after the installation. It is not there! But <b>jload.log written during installation claims it has been loaded successfully</b>:

26.04.06 19:52:15 com.sap.inst.jload.Jload dbImport

INFO: trying to create table PVC_ACTVERSVIEW

26.04.06 19:52:15 com.sap.inst.jload.Jload dbImport

INFO: table PVC_ACTVERSVIEW created

As reinstallation does not help, can someone please post a definition of this view? Or is there another way to resolve this? Can somebody please check whether his/her installation contains this view or table?

I even tried to run jload data import for this single table again. "Succeeded" in that jload reported the same as in the first runs but nothing shows up in my database.

WebAccess via http://:50000/dtr shows my workspaces are there, command line access to dtr seems to work fine. Only NW Dev Studio access seems to have problems.

As you all know, it takes a considerable amount of time to run the installation and configure the system to the point where it crashed for me. I would appreciate any hint how to get round this problem.

Thanks

Markus

Date : 04/27/2006

Time : 13:19:13:453

Message : Exception com.sap.sql.log.OpenSQLException: The SQL statement "UPDATE "DAV_RESOURCE" SET "RESOURCETYPE" = ?,"MODIFICATIONTIME" = ? WHERE "RESOURCEID" IN (SELECT "VSE1"."VERSIONID" FROM "PVC_ACTVERSVIEW" "VSE1" INNER JOIN "PVC_ACTVERSVIEW" "VSE2" ON "VSE1"."VERSIONID" = "VSE2"."VERSIONID" WHERE "VSE1"."VERSIONSETID" = ? AND "VSE2"."VERSIONSETID" = ?) AND "RESOURCETYPE" <> ?" contains the semantics error[s]: <b>table "PVC_ACTVERSVIEW" unknown</b>at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:106)

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:145)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:46)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:126)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.preprepareStatement(StatementAnalyzerImpl.java:109)

at com.sap.sql.jdbc.common.CommonPreparedStatement.<init>(CommonPreparedStatement.java:155)

at com.sap.sql.jdbc.common.CommonConnectionImpl.prepareStatement(CommonConnectionImpl.java:315)

at com.sap.engine.services.dbpool.cci.ConnectionHandle.prepareStatement(ConnectionHandle.java:81)

at com.tssap.dtr.pvc.basics.transaction.SharedConnection.prepareStatement(SharedConnection.java:123)

at com.tssap.dtr.pvc.util.sql.GenericStatementProvider._getPreparedStatement(GenericStatementProvider.java:57)

at com.tssap.dtr.pvc.util.sql.GenericStatementProvider._getPreparedStatement(GenericStatementProvider.java:48)

at com.tssap.dtr.pvc.util.sql.GenericStatementProvider.getPreparedStatement(GenericStatementProvider.java:43)

at com.tssap.dtr.server.deltav.integrate.impl.UpdateResourceTypesTask.updateResourceTypesAfterCheckin(UpdateResourceTypesTask.java:39)

at com.tssap.dtr.server.deltav.integrate.impl.UpdateResourceTypesTask._execute(UpdateResourceTypesTask.java:34)

at com.tssap.dtr.server.deltav.integrate.impl.AbstractIntegrationTask.execute(AbstractIntegrationTask.java:40)

at com.tssap.dtr.server.deltav.impl.DeltaVIntegrator.integrate(DeltaVIntegrator.java:62)

at com.tssap.dtr.server.deltav.impl.DeltaVIntegrator.integrate(DeltaVIntegrator.java:51)

at com.tssap.dtr.server.deltav.impl.Activity._checkin(Activity.java:483)

at com.tssap.dtr.server.deltav.impl.Resource._createResource(Resource.java:1524)

at com.tssap.dtr.server.deltav.impl.Resource._createCollection(Resource.java:1567)

at com.tssap.dtr.server.deltav.impl.Resource.createCollection(Resource.java:1302)

at com.tssap.dtr.server.servlet.MkcolMethod.execute(MkcolMethod.java:70)

at com.tssap.dtr.server.servlet.WebdavMethod._runWebdavMethod(WebdavMethod.java:332)

at com.tssap.dtr.server.servlet.WebdavMethod.runWebdavMethod(WebdavMethod.java:290)

at com.tssap.dtr.server.servlet.WebdavServlet.executeMethodWithoutXMLMarshaller(WebdavServlet.java:135)

at com.tssap.dtr.server.servlet.WebdavServlet.service(WebdavServlet.java:176)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Caused by: com.sap.sql.sqlparser.CommonSQLParserException: table "PVC_ACTVERSVIEW" unknown

at com.sap.sql.sqlparser.CommonSQLStatement.checkSemantics(CommonSQLStatement.java:186)

at com.sap.sql.jdbc.common.StatementAnalyzerImpl.check(StatementAnalyzerImpl.java:42)

... 38 more<b></b>

Highlighting for key points because this is a lot of text.

Message was edited by: Markus Wissmann

Former Member
Not what you were looking for? View more on this topic or Ask a question