Camunda Tomcat throws error while getting started with schema name

Camunda 7 Topics Discussion & Questions
1

We were trying to start the camunda tomcat application with tables pointing to new schema name.
But throwing error as
create table ACT_GE_PROPERTY (
NAME_ NVARCHAR2(64),
VALUE_ NVARCHAR2(300),
REV_ INTEGER,
primary key (NAME_)
)'. Cause: 'ORA-01031: insufficient privileges

We already have all these tables under the schema with select ,insert and update grants.

bpm_platforms.xml:

full true true true test

Please advise how to resolve this issue

2

Hi @Asvitha,

one option is to hand over the DB create scripts to your database admins and ask them to run them for you. You can find them either in your downloaded distribution in the sql folder or, in case you use the camunda-bpm-spring-boot-starter, here: Index of /org/camunda/bpm/distro/camunda-sql-scripts

Another option is to ask for the create tables privileges. But not every DB admin grants them to developers…

Hope this helps, Ingo

3

Hi @Ingo_Richtsmeier ,

We have created all the tables under that schema XYZ with the help of DBA admins,
Now we are trying to bring up the app pointing to that tables under the schema XYZ, Still throws same error for creation of table
Application user has select, insert and update access.

Below is the configuration used under bpm_platform.xml

<?xml version="1.0" encoding="UTF-8"?>
<bpm-platform xmlns="http://www.camunda.org/schema/1.0/BpmPlatform"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.camunda.org/schema/1.0/BpmPlatform http://www.camunda.org/schema/1.0/BpmPlatform ">
   <properties>
      <property name="history">audit</property>
      <property name="databaseSchemaUpdate">true</property>
      <property name="authorizationEnabled">true</property>
      <property name="jobExecutorDeploymentAware">true</property>
	  <property name="databaseTablePrefix">XYZ</property>
    </properties> 
</bpm-platform>

Please advise .

4

Hi @Asvitha,

please see my reply here: Camunda Tables under schema name - #4 by Ingo_Richtsmeier