Broadleaf Commerce Discussion Forums

Hi,
during exporting schema to Oracle database encountered an error:

[ERROR] 22:17:32 SchemaUpdate - Unsuccessful: create table BLC_ASSET_DESC_MAP (BLC_STATIC_ASSET_STATIC_ASSET_ID number(19,0) not null, STATIC_ASSET_DESC_ID number(19,0) not null, MAP_KEY varchar2(255 char) not null, primary key (BLC_STATIC_ASSET_STATIC_ASSET_ID, MAP_KEY))
[ERROR] 22:17:32 SchemaUpdate - ORA-00972: identifier is too long

[ERROR] 22:17:37 SchemaUpdate - Unsuccessful: alter table BLC_ASSET_DESC_MAP add constraint FKE886BAE3B439EE29 foreign key (BLC_STATIC_ASSET_STATIC_ASSET_ID) references BLC_STATIC_ASSET
[ERROR] 22:17:37 SchemaUpdate - ORA-00972: identifier is too long

[ERROR] 22:17:34 SchemaUpdate - Unsuccessful: create table BLC_SANDBOX_ACTION (SANDBOX_ACTION_ID number(19,0) not null, DATE_CREATED timestamp, DATE_UPDATED timestamp, COMMENT varchar2(255 char), ACTION_TYPE varchar2(255 char), CREATED_BY number(19,0), UPDATED_BY number(19,0), primary key (SANDBOX_ACTION_ID))
[ERROR] 22:17:34 SchemaUpdate - ORA-00904: : invalid identifier


Regards.

... 'COMMENT' is a reserved word on Oracle.

Vara,

Thanks for your post. We've patched the software to account for this error. Version 1.5.2-GA will be released on Monday January 30th. Additionally, you'll want to replace all occurrences of they keywords "TRUE" and "FALSE" in the included .sql files to "1" ad "0" respectively when running against Oracle.

Thanks,