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".
Historical Number
PRI49831
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21534568