Skip to end of metadata
Go to start of metadata

Problem

Deployment of application fails with an error like :

Cannot persist XXX information in location XXX

Keywords

  • [ERROR CODE DPL.DC.3243]
  • Cannot persist
  • information in location

Solution

This error can occur during persistence operations. All the persistence operations of the Deploy Controller are performed through the Config Manager.
There have been cases when the problem occured due to problems with the database. You can examine the stack trace you find in the default trace, following these guidelines to discover the cause. If you need assistance, please, report the problem to us.
Here is an example stack trace for database connectivity problem

com.sap.engine.services.dc.api.deploy.DeployException: [ERROR CODE DPL.DCAPI.1027] DeploymentException.
Reason: [ERROR CODE DPL.DC.3063] An error occurred in the online deployment phase by the time of post processing the deployment data.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dc.cm.deploy.storage.DeplDataStorageException: [ERROR CODE DPL.DC.3243] Cannot persist 1681 information in location deploy_controller/offline/deploy/1681.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.
at com.sap.engine.services.dc.api.deploy.impl.DeployProcessorImpl.deployItems(DeployProcessorImpl.java:833)
at com.sap.engine.services.dc.api.deploy.impl.DeployProcessorImpl.deploy(DeployProcessorImpl.java:223)
at com.sap.engine.services.dc.test.AbstractDATest.deployPrerequisiteStuff(AbstractDATest.java:255)
at com.sap.engine.services.dc.test.undeploy.mixed.success.dependence.TestCase8.prepare(TestCase8.java:107)
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.ats.system.testjvm.impl.TestMethodRunner.start(TestMethodRunner.java:184)
at com.sap.ats.system.testjvm.impl.PerformanceTestMethodRunnable.start(PerformanceTestMethodRunnable.java:101)
at com.sap.ats.system.testjvm.impl.TestJVMCommonExecutorImpl$2.run(TestJVMCommonExecutorImpl.java:254)
at com.sap.ats.core.utils.ThreadHelper.run(Utilities.java:708)
Caused by: com.sap.engine.services.dc.cm.deploy.DeploymentException: [ERROR CODE DPL.DC.3063] An error occurred in the online deployment phase by the time of post processing the deployment data.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dc.cm.deploy.storage.DeplDataStorageException: [ERROR CODE DPL.DC.3243] Cannot persist 1681 information in location deploy_controller/offline/deploy/1681.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.
at com.sap.engine.services.dc.cm.deploy.impl.OfflineDeployPostProcessor.persistDeploymentData(OfflineDeployPostProcessor.java:143)
at com.sap.engine.services.dc.cm.deploy.impl.OfflineDeployPostProcessor.postProcess(OfflineDeployPostProcessor.java:77)
at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.doPostProcessing(DeployerImpl.java:739)
at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.performDeploy(DeployerImpl.java:730)
at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.doDeploy(DeployerImpl.java:574)
at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.deploy(DeployerImpl.java:268)
at com.sap.engine.services.dc.cm.deploy.impl.DeployerImpl.deploy(DeployerImpl.java:193)
at com.sap.engine.services.dc.cm.deploy.impl.DeployerImplp4_Skel.dispatch(DeployerImplp4_Skel.java:875)
at com.sap.engine.services.rmi_p4.DispatchImpl._runInternal(DispatchImpl.java:351)
at com.sap.engine.services.rmi_p4.server.ServerDispatchImpl.run(ServerDispatchImpl.java:70)
at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:59)
at com.sap.engine.services.rmi_p4.P4Message.execute(P4Message.java:36)
at com.sap.engine.services.cross.fca.FCAConnectorImpl.executeRequest(FCAConnectorImpl.java:883)
at com.sap.engine.services.rmi_p4.P4Message.process(P4Message.java:50)
at com.sap.engine.services.cross.fca.MessageReader.run(MessageReader.java:57)
at com.sap.engine.core.thread.execution.Executable.run(Executable.java:108)
at com.sap.engine.core.thread.execution.CentralExecutor$SingleThread.run(CentralExecutor.java:302)
Caused by: java.rmi.RemoteException: class com.sap.engine.services.dc.cm.deploy.storage.DeplDataStorageException: [ERROR CODE DPL.DC.3243] Cannot persist 1681 information in location deploy_controller/offline/deploy/1681.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.
at com.sap.engine.services.dc.cm.deploy.storage.impl.DeploymentDataStorageManagerImpl.handlePersistError(DeploymentDataStorageManagerImpl.java:1068)
at com.sap.engine.services.dc.cm.deploy.storage.impl.DeploymentDataStorageManagerImpl.persistDeploymentData(DeploymentDataStorageManagerImpl.java:190)
at com.sap.engine.services.dc.cm.deploy.impl.OfflineDeployPostProcessor.persistDeploymentData(OfflineDeployPostProcessor.java:140)
... 16 more
Caused by: java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseSQLException: ResourceException occurred in method ConnectionFactoryImpl.getConnection(): com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.
at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:59)
at com.sap.engine.services.dc.cm.deploy.storage.impl.DeploymentDataStorageManagerImpl.getDBConnection(DeploymentDataStorageManagerImpl.java:1043)
at com.sap.engine.services.dc.cm.deploy.storage.impl.DeploymentDataStorageManagerImpl.persistDeploymentData(DeploymentDataStorageManagerImpl.java:846)
at com.sap.engine.services.dc.cm.deploy.storage.impl.DeploymentDataStorageManagerImpl.persistDeploymentData(DeploymentDataStorageManagerImpl.java:168)
... 17 more
Caused by: java.rmi.RemoteException: class com.sap.engine.services.dbpool.exceptions.BaseResourceException: SQLException is thrown by the pooled connection: com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.; nested exception is:
java.rmi.RemoteException: class com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.
at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:156)
at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:209)
at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:265)
at com.sap.engine.services.connector.jca.ShareableConnectionManager.allocateConnection(ShareableConnectionManager.java:54)
at com.sap.engine.services.dbpool.cci.ConnectionFactoryImpl.getConnection(ConnectionFactoryImpl.java:51)
... 20 more
Caused by: java.rmi.RemoteException: class com.sap.sql.log.OpenSQLException: No connection available for data source SAPLKGDB.
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:95)
at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:188)
at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.matchPooledConnection(DBDataSourcePoolImpl.java:928)
at com.sap.sql.connect.datasource.DBDataSourcePoolImpl.getConnection(DBDataSourcePoolImpl.java:65)
at com.sap.engine.core.database.impl.DatabaseDataSourceImpl.getConnection(DatabaseDataSourceImpl.java:36)
at com.sap.engine.services.dbpool.spi.ManagedConnectionFactoryImpl.createManagedConnection(ManagedConnectionFactoryImpl.java:121)
... 24 more

Sample Logs

N/A

Related SAP Notes

N/A

  • No labels