What is the supported oracle dialect for RHPAM 7?

Solution Verified - Updated -

Issue

  • What is the supported oracle dialect for RHPAM 7?
  • Why "ORA-00902: invalid datatype" is occurred when table is getting created in RHPAM 7?
Caused by: Error : 902, Position : 835, Sql = create table Task (id number(19,0) not null, archived number(5,0), allowedToDelegate varchar2(255), description varchar2(255), formName varchar2(255), name varchar2(255), priority number(10,0) not null, subTaskStrategy varchar2(255), subject varchar2(255), activationTime date, createdOn date, deploymentId varchar2(255), documentAccessType number(10,0), documentContentId number(19,0) not null, documentType varchar2(255), expirationTime date, faultAccessType number(10,0), faultContentId number(19,0) not null, faultName varchar2(255), faultType varchar2(255), outputAccessType number(10,0), outputContentId number(19,0) not null, outputType varchar2(255), parentId number(19,0) not null, previousStatus number(10,0), processId varchar2(255), processInstanceId number(19,0) not null, processSessionId number(19,0) not null, skipable boolean not null, status varchar2(255), workItemId number(19,0) not null, taskType varchar2(255), OPTLOCK number(10,0), taskInitiator_id varchar2(255), actualOwner_id varchar2(255), createdBy_id varchar2(255), primary key (id)), OriginalSql = create table Task (id number(19,0) not null, archived number(5,0), allowedToDelegate varchar2(255), description varchar2(255), formName varchar2(255), name varchar2(255), priority number(10,0) not null, subTaskStrategy varchar2(255), subject varchar2(255), activationTime date, createdOn date, deploymentId varchar2(255), documentAccessType number(10,0), documentContentId number(19,0) not null, documentType varchar2(255), expirationTime date, faultAccessType number(10,0), faultContentId number(19,0) not null, faultName varchar2(255), faultType varchar2(255), outputAccessType number(10,0), outputContentId number(19,0) not null, outputType varchar2(255), parentId number(19,0) not null, previousStatus number(10,0), processId varchar2(255), processInstanceId number(19,0) not null, processSessionId number(19,0) not null, skipable boolean not null, status varchar2(255), workItemId number(19,0) not null, taskType varchar2(255), OPTLOCK number(10,0), taskInitiator_id varchar2(255), actualOwner_id varchar2(255), createdBy_id varchar2(255), primary key (id)), Error Msg = ORA-00902: invalid datatype

    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
    ... 51 more

Environment

  • Red Hat Process Automation Manager
    • 7.X

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content