PI Design object import fails

[Former Member]

Hi all,

I have a problem with Designobjects that have been exported from the Development system and need to be imported

to the test environment. But I get some strange errors like this and it fails via CTS+:

SQL error occurred on connection devserver:T50:SAPSR3DB: code=-4,228, state="null", message="[jcc][t4][102][10040][3.58.91] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.

Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4228, SQLSTATE=null

=> (-803,23505,Error for batch element #1: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;SAPSR3DB.XI_DIRCACHERCLVIEW, DRIVER=3.58.91)

=> (-803,23505,Error for batch element #2: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;SAPSR3DB.XI_DIRCACHERCLVIEW, DRIVER=3.58.91)

=> (-803,23505,Error for batch element #3: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;SAPSR3DB.XI_DIRCACHERCLVIEW, DRIVER=3.58.91)

=> (-803,23505,Error for batch element #4: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=1;SAPSR3DB.XI_DIRCACHERCLVIEW, DRIVER=3.58.91)";

SQL statement is "INSERT INTO "XI_DIRCACHERCLVIEW" ("CHANGELIST","TYPE_ID","OBJECT_ID","SW_COMPONENT","SP") VALUES (?,?,?,?,?)".

I checked google an it says that the DB tries to insert a value with the same unique ID twice. But I don't know what that could be. I have created and deleted some objects in the DEV environment. But shouldn't the PI get what has to be overwritten and what should be deleted? I exported the objects with deleted objects and without. Both does fail.

Has somebody had a similar problem or knows what that could be?

Some further errors are specific to some namespace objects (But the objects are in the transport, I exported everything!) :

com.sap.aii.ib.core.roa.RoaObjectAccessException: Attempt to read object Message Mapping DownloadFileResponse_to_StyretFiloverfoerselModtagAnmod_I | urn:namespace, type XI_TRAFO from application REPOSITORY on system REPOSITORY failed. Object does not exist. Detailed informatio n: Object Message Mapping DownloadFileResponse_to_StyretFiloverfoerselModtagAnmod_I | urn:namespace not found

Thanks and best regards,

Dennis

[baskar_gopalakrishnan2 · Accepted solution]

>>But I don't know what that could be. I have created and deleted some objects in the DEV environment

Looks like Cache issue. Do Refresh cache and if the problem persists., give us more details. When you delete objects, you do delete followed by activate I believe.

[Former Member · Accepted solution]

Hi,

I activted all objects after deletion. But also there are objects in the list that have never been in the target system.

There are also no open change lists anymore in the Dev environment.

We restarted the Server and cleared all caches (sxi_cache, CPA_CACHE, SLD_CACHE).

We always want to use CTS+ for importing from now on. It also worked already for some objects. But in the beginning we did manual Export -> Import between the systems.

I tried also now a manual import, the excption thrown here is:

[Former Member · Accepted solution]

Root Exception:

Thrown:

com.sap.aii.utilxi.misc.api.BaseRuntimeException: Missing value for objVersion!

at com.sap.aii.ib.gui.tools.transport.ContentImportProgressDialog.executeConcurrentAction(ContentImportProgressDialog.java:448)

at com.sap.aii.utilxi.swing.toolkit.ConcurrentProgressDialog$ProgressDialogRunnable.run(ConcurrentProgressDialog.java:251)

at com.sap.aii.utilxi.misc.thread.ThreadPool$ThreadPoolThread.run(ThreadPool.java:392)

Caused by: com.sap.aii.utilxi.misc.api.ResourceException: Missing value for objVersion!

at com.sap.aii.ib.sbeans.gen.BaseSessionBean.wrap(BaseSessionBean.java:138)

at com.sap.aii.ib.sbeans.gen.BaseSessionBean.wrap(BaseSessionBean.java:111)

at com.sap.aii.ib.server.transport.TransportServiceBean.importFromImportSource(TransportServiceBean.java:210)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:71)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

at $Proxy1754.importFromImportSource(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.engine.services.rmi_p4.P4DynamicSkeleton.dispatch(P4DynamicSkeleton.java:234)

at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:355)

at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:69)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:67)

at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:41)

at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:977)

at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:57)

at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:55)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:115)

at com.sap.engine.core.thread.execution.Executable.run(Executable.java:96)

at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:314)

Serialized cause: com.sap.aii.ib.sbeans.gen.WrapperClientServerException: Missing value for objVersion!

... 41 more

Serialized cause: com.sap.aii.ib.server.propagation.XIPropagationException: Missing value for objVersion!

at com.sap.aii.ib.server.propagation.XIPropagationException.createFromException(XIPropagationException.java:54)

at com.sap.aii.ib.server.propagation.PropagatorImpl.integrateObjectVersions(PropagatorImpl.java:270)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.aii.ib.server.pvcadapt.PvcTransactionControlProxy.invoke(PvcTransactionControlProxy.java:79)

at $Proxy3118.integrateObjectVersions(Unknown Source)

at com.sap.aii.ib.server.propagation.Propagator.integrateObjectVersions(Propagator.java:103)

at com.sap.aii.ib.server.workspace.WorkspaceManager.integrateClosedVSetFromImport(WorkspaceManager.java:3085)

at com.sap.aii.ibrep.server.transport.impl.pvc.RepPvcTransport.pvcIntegrateImportedVersionset(RepPvcTransport.java:119)

at com.sap.aii.ib.server.transport.impl.service.TransportServiceImpl.integrateVersionset(TransportServiceImpl.java:902)

at com.sap.aii.ibrep.server.transport.impl.service.RepTransportServiceSeImpl.autoIntegrate(RepTransportServiceSeImpl.java:459)

at com.sap.aii.ib.server.transport.impl.service.TransportServiceImpl.importZippedStream(TransportServiceImpl.java:1229)

at com.sap.aii.ib.server.transport.impl.service.TransportServiceImpl.importZippedStream(TransportServiceImpl.java:1096)

at com.sap.aii.ib.server.transport.impl.service.TransportServiceImpl.importFromImportSource(TransportServiceImpl.java:791)

at com.sap.aii.ib.server.transport.TransportServiceBean.importFromImportSource(TransportServiceBean.java:207)

... 38 more

Serialized cause: com.sap.aii.ib.core.versioning.integration.VersionSetIntegrationException: Missing value for objVersion!

at com.sap.aii.ib.core.versioning.integration.VersionSetIntegrationException.createFromException(VersionSetIntegrationException.java:35)

at com.sap.aii.ib.server.versioning.integration.VersionSetIntegratorImpl.integrateClosedVersionSet(VersionSetIntegratorImpl.java:140)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.aii.ib.server.pvcadapt.PvcTransactionControlProxy.invoke(PvcTransactionControlProxy.java:79)

at $Proxy3125.integrateClosedVersionSet(Unknown Source)

at com.sap.aii.ib.server.versioning.integration.VersionSetIntegrator.integrateClosedVersionSet(VersionSetIntegrator.java:52)

at com.sap.aii.ib.server.propagation.PropagatorImpl.integrateObjectVersions(PropagatorImpl.java:259)

... 53 more

Serialized cause: java.lang.IllegalArgumentException: Missing value for objVersion!

at com.sap.aii.ib.server.versioning.XiRefCreationHelper.createXiReference(XiRefCreationHelper.java:120)

at com.sap.aii.ib.server.versioning.integration.VersionConflictFactory.createXiRefForCollVersion(VersionConflictFactory.java:304)

at com.sap.aii.ib.server.versioning.integration.VersionConflictFactory.createXiRefForCollVersion(VersionConflictFactory.java:292)

at com.sap.aii.ib.server.versioning.integration.VersionConflictFactory.createFromClosedVSIntegration(VersionConflictFactory.java:115)

at com.sap.aii.ib.server.versioning.integration.VersionSetIntegratorImpl.processNewPersistentPvcCollisions(VersionSetIntegratorImpl.java:433)

at com.sap.aii.ib.server.versioning.integration.VersionSetIntegratorImpl.processConflictsAfterUnconditionalIntegrate(VersionSetIntegratorImpl.java:406)

at com.sap.aii.ib.server.versioning.integration.VersionSetIntegratorImpl._integrateUnconditionallyClosedVS(VersionSetIntegratorImpl.java:365)

at com.sap.aii.ib.server.versioning.integration.VersionSetIntegratorImpl.onUnconditionalIntegration(VersionSetIntegratorImpl.java:170)

at com.sap.aii.ib.server.versioning.integration.VersionSetIntegratorImpl.integrateClosedVersionSet(VersionSetIntegratorImpl.java:133)

... 61 more

====================================================================

== Content from the LogHandler =====================================

====================================================================

#5 19:44:40 [AWT-EventQueue-2] ERROR com.sap.aii.utilxi.swing.toolkit.ExceptionDialog: Throwable

Thrown:

com.sap.aii.utilxi.misc.api.BaseRuntimeException: Missing value for objVersion!

at com.sap.aii.ib.gui.tools.transport.ContentImportProgressDialog.executeConcurrentAction(ContentImportProgressDialog.java:448)

at com.sap.aii.utilxi.swing.toolkit.ConcurrentProgressDialog$ProgressDialogRunnable.run(ConcurrentProgressDialog.java:251)

at com.sap.aii.utilxi.misc.thread.ThreadPool$ThreadPoolThread.run(ThreadPool.java:392)

Caused by: com.sap.aii.utilxi.misc.api.ResourceException: Missing value for objVersion!

at com.sap.aii.ib.sbeans.gen.BaseSessionBean.wrap(BaseSessionBean.java:138)

at com.sap.aii.ib.sbeans.gen.BaseSessionBean.wrap(BaseSessionBean.java:111)

at com.sap.aii.ib.server.transport.TransportServiceBean.importFromImportSource(TransportServiceBean.java:210)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:585)

at com.sap.engine.services.ejb3.runtime.impl.RequestInvocationContext.proceedFinal(RequestInvocationContext.java:46)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:166)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatesTransition.invoke(Interceptors_StatesTransition.java:19)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Resource.invoke(Interceptors_Resource.java:71)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.doWorkWithAttribute(Interceptors_Transaction.java:38)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_Transaction.invoke(Interceptors_Transaction.java:22)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:189)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_StatelessInstanceGetter.invoke(Interceptors_StatelessInstanceGetter.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_SecurityCheck.invoke(Interceptors_SecurityCheck.java:21)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.Interceptors_ExceptionTracer.invoke(Interceptors_ExceptionTracer.java:16)

at com.sap.engine.services.ejb3.runtime.impl.AbstractInvocationContext.proceed(AbstractInvocationContext.java:177)

at com.sap.engine.services.ejb3.runtime.impl.DefaultInvocationChainsManager.startChain(DefaultInvocationChainsManager.java:133)

at com.sap.engine.services.ejb3.runtime.impl.DefaultEJBProxyInvocationHandler.invoke(DefaultEJBProxyInvocationHandler.java:164)

Edited by: Dennis Junker on Mar 8, 2011 7:52 PM

[Former Member · Accepted solution]

Did you check the Cache notification in IR? Are there any red entries? If so, try restarting those entries, refresh and ensure the green status and then do a cache refresh.

[Former Member · Accepted solution]

Hi,

I now just made smaller transport packages (one for each namespace) and imported it again. This time it worked. As I refreshed all caches I think it was an indirect problem. Might be because I have the same object in different namespaces that conficts then while importing. I guess the issue was because the PI doesn't care that much about the namespace definitions and thought that I have the same object twice.

So this issue is solved now, thanks for your replies.

[Former Member]

try using .tpz import.

[Former Member]

Have you tried to refresh the cache?

It seems like there's the same object id in cache