DBSQL exception :The server principal "SAPPP1DB" is not able to access.

[Former Member]

Hello

Below is the error while deploying sca file .. Please help to resolve it.

-

---

Exception:

com.sap.engine.services.dc.api.deploy.DeployException: [ERROR CODE DPL.DCAPI.1027] DeploymentException.

Reason: ASJ.dpl_dc.001085 [ERROR CODE DPL.DC.3077] An error occurred while deploying the deployment item [hsbc.com_properties_dict].

; nested exception is:

com.sap.engine.services.dc.gd.DeliveryException: [ERROR CODE DPL.DC.3298] An error occurred during deployment of [hsbc.com_properties_dict]. Cannot deploy it.

at com.sap.engine.services.dc.api.deploy.impl.DeployProcessorImpl.deployItems(DeployProcessorImpl.java:836)

at com.sap.engine.services.dc.api.deploy.impl.DeployProcessorImpl.deploy(DeployProcessorImpl.java:226)

at com.sap.ide.eclipse.deployer.dc.deploy.DeployProcessor70.deploy(DeployProcessor70.java:112)

at com.sap.ide.eclipse.j2ee.engine.deploy.view.deploy.action.DeployAction$DeployActionJob.run(DeployAction.java:225)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)

Caused by: com.sap.engine.services.dc.cm.deploy.DeploymentException: ASJ.dpl_dc.001085 [ERROR CODE DPL.DC.3077] An error occurred while deploying the deployment item [hsbc.com_properties_dict].

; nested exception is:

com.sap.engine.services.dc.gd.DeliveryException: [ERROR CODE DPL.DC.3298] An error occurred during deployment of [hsbc.com_properties_dict]. Cannot deploy it.

at com.sap.engine.services.dc.cm.deploy.impl.OnlineDeployProcessor.performDelivery(OnlineDeployProcessor.java:188)

at com.sap.engine.services.dc.cm.deploy.impl.BulkOnlineDeployProcessor.deploy(BulkOnlineDeployProcessor.java:57)

at com.sap.engine.services.dc.cm.deploy.impl.AbstractDeployProcessor$DeployProcessorHelper.visit(AbstractDeployProcessor.java:229)

at com.sap.engine.services.dc.cm.deploy.impl.DeploymentItemImpl.accept(DeploymentItemImpl.java:83)

at com.sap.engine.services.dc.cm.deploy.impl.AbstractDeployProcessor.deploy(AbstractDeployProcessor.java:91)

at com.sap.engine.services.dc.cm.deploy.impl.DeployThread.run(DeployThread.java:34)

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)

Caused by: com.sap.engine.services.dc.gd.DeliveryException: [ERROR CODE DPL.DC.3298] An error occurred during deployment of [hsbc.com_properties_dict]. Cannot deploy it.

at com.sap.engine.services.dc.gd.impl.ApplicationDeployer.deploy(ApplicationDeployer.java:118)

at com.sap.engine.services.dc.gd.impl.InitialApplicationDeployer.performDeployment(InitialApplicationDeployer.java:108)

at com.sap.engine.services.dc.gd.impl.InitialGenericDeliveryImpl.deploy(InitialGenericDeliveryImpl.java:51)

at com.sap.engine.services.dc.cm.deploy.impl.OnlineDeployProcessor.performDelivery(OnlineDeployProcessor.java:163)

... 8 more

Caused by: com.sap.engine.services.deploy.server.utils.DSRemoteException: [ERROR CODE DPL.DS.6193] Error while ; nested exception is:

com.sap.engine.services.dbcontainer.DBContainerException: [ERROR CODE DPL.DBC.204] failed to deploy dbschemacontainer : hsbc.com_{properties_dict}hsbc.com_{properties_dict.sda E:\usr\sap\PP1\DVEBMGS01\j2ee\cluster\server0\temp\deploy\hsbc.com}properties_dict_hsbc.comproperties_dict.sda1271278128253\hsbc.com_{properties_dict}hsbc.com~properties_dict.sda. Return code from dictionary library is ERROR.

at com.sap.engine.services.deploy.server.DeployServiceImpl.catchDeploymentExceptionWithDSRem(DeployServiceImpl.java:4712)

at com.sap.engine.services.deploy.server.DeployServiceImpl.deploy(DeployServiceImpl.java:373)

at com.sap.engine.services.dc.gd.impl.ApplicationDeployer.deploy(ApplicationDeployer.java:95)

... 11 more

Caused by: com.sap.engine.services.dbcontainer.DBContainerException: [ERROR CODE DPL.DBC.204] failed to deploy dbschemacontainer : hsbc.com_{properties_dict}hsbc.com_{properties_dict.sda E:\usr\sap\PP1\DVEBMGS01\j2ee\cluster\server0\temp\deploy\hsbc.com}properties_dict_hsbc.comproperties_dict.sda1271278128253\hsbc.com_{properties_dict}hsbc.com~properties_dict.sda. Return code from dictionary library is ERROR.

at com.sap.engine.services.dbcontainer.DBSchemaContainer.deploy(DBSchemaContainer.java:116)

at com.sap.engine.services.deploy.server.utils.container.ContainerWrapper.deploy(ContainerWrapper.java:195)

at com.sap.engine.services.deploy.server.application.DeploymentTransaction.makeComponents(DeploymentTransaction.java:526)

at com.sap.engine.services.deploy.server.application.DeployUtilTransaction.commonBegin(DeployUtilTransaction.java:249)

at com.sap.engine.services.deploy.server.application.DeploymentTransaction.begin(DeploymentTransaction.java:188)

at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhasesOnOneServer(ApplicationTransaction.java:493)

at com.sap.engine.services.deploy.server.application.ApplicationTransaction.makeAllPhases(ApplicationTransaction.java:544)

at com.sap.engine.services.deploy.server.DeployServiceImpl.makeGlobalTransaction(DeployServiceImpl.java:2534)

at com.sap.engine.services.deploy.server.DeployServiceImpl.deploy(DeployServiceImpl.java:380)

at com.sap.engine.services.deploy.server.DeployServiceImpl.deploy(DeployServiceImpl.java:371)

... 12 more

Caused by: com.sap.engine.services.dbcontainer.lib.DBDeployLibExceptionJDDError: [ERROR CODE DPL.DBC.901] Deploy operation finished with ERROR code.

The following messages were collected by DBModificationController during deployment:

E R R O R ******* (DbSqlStatement)

16:48:48 2010-04-14 dbs-Error: Exception caught during SQL execution The server principal "SAPPP1DB" is not able to access the database "DBUSPDC01" under the current security context. CREATE TABLE [TMP_PROP]

(

"PROPERTY" NVARCHAR(100) DEFAULT N' ' NOT NULL,

"PROPERTY_VALUE" NVARCHAR(255) DEFAULT N' ' NOT NULL

)

E R R O R ******* (DbModifier)

16:48:48 2010-04-14 dbs-Error: Statements could not be executed

More details can be found in the trace and log files.

at com.sap.engine.services.dbcontainer.lib.DBDeployLibImpl.deployDbSchemaInternal(DBDeployLibImpl.java:135)

at com.sap.engine.services.dbcontainer.DBSchemaContainer.deploy(DBSchemaContainer.java:82)

... 21 more

-

---

[Former Member]

Hi ,

Check your Server instance is this PP1.

Regards

Trilochan