Staretl Process Fails On Step 13 With Error "ORA-02083: database name has illegal character '-'" (Doc ID 2051766.1)

Last updated on SEPTEMBER 04, 2015

Applies to:

Primavera Analytics - Version and later
Information in this document applies to any platform.


When running the starETL process, the following error occurs during step 13 of the process, causing the ETL process to fail: 

staretl [INFO] (Progress) - Step 13/59 Part 1/1 - [TIMESTAMP] PopulateFeatureProperties -- Populate STAR feature parameters (PopulateFeatureProperties)
staretl [INFO] (Message) - === Step 13, Part 1 ====================================================
staretl [INFO] (Message) - === Populate STAR feature parameters (PopulateFeatureProperties)
staretl [INFO] (Message) - No Set Properties
staretl [ERROR] (Message) - Error setting feature properties.
java.sql.SQLSyntaxErrorException: ORA-02083: database name has illegal character '-'
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4CTTIoer.processError(
  at oracle.jdbc.driver.T4C8Oall.processError(
  at oracle.jdbc.driver.T4CTTIfun.receive(
  at oracle.jdbc.driver.T4CTTIfun.doRPC(
  at oracle.jdbc.driver.T4C8Oall.doOALL(
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(
  at Source)
  at Source)
  at Source)
  at Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
  at java.lang.reflect.Method.invoke(
  at Source)
  at Source)
  at Source)
  at Source)
staretl [INFO] (Progress) - Step 13/59 Part 1/1 - DONE (0 hours, 0 minutes, 1 seconds, 178 milliseconds)

The issue can be reproduced at will with the following steps:

  1. Execute staretl (.bat/.sh)
  2. Note the failure which occurs during step 16, which can be seen by examining the staretlprocess.log


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms