IBM Support

Oracle Error - ErrorDescription="ORA-00917: missing comma"

Troubleshooting


Problem

Oracle Error - ErrorDescription="ORA-00917: missing comma"

Symptom

Set up cannot complete the install.

[java] <Attribute Name="ErrorDescription" Value="ORA-00917: missing comma"

Attribute Name="SQLStatement" Value="INSERT INTO MDLR_PAL_ITEM_DESC
(DISPLAY_NAME,LOCALE,PALETTE_ITEM_NAME,ICON_NAME,DESCRIPTION) values
('??????','ja_JP','COMPRESSION','generic_adapter.jpg','??????')"

Cause

Character set was not set properly within Oracle.

Resolving The Problem

Find out what character set is being used by the database with the following command:

select * from sys.props$ where name='NLS_CHARACTERSET';

This should return NLS_CHARACTERSET AL32UTF8.
This is defined in the installation guide in the section "Configure the Database".

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.4;5.2.3;5.2.2;5.2.1;5.2;5.1;5.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

PRI49831

Document Information

Modified date:
16 June 2018

UID

swg21534568

Page Feedback