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 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

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


ERROR
---------
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(T4CTTIoer.java:445)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
  at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
  at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
  at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)
  at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665)
  at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352)
  at com.primavera.er.util.PopulateFeatureProperties.a(Unknown Source)
  at com.primavera.er.util.PopulateFeatureProperties.a(Unknown Source)
  at com.primavera.er.util.PopulateFeatureProperties.a(Unknown Source)
  at com.primavera.er.util.PopulateFeatureProperties.start(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:497)
  at com.primavera.er.util.JavaClassInvokerAction.doAction(Unknown Source)
  at com.primavera.er.util.CommandInvoker.a(Unknown Source)
  at com.primavera.er.util.CommandInvoker.invoke(Unknown Source)
  at com.primavera.er.util.CommandInvoker.main(Unknown Source)
staretl [INFO] (Progress) - Step 13/59 Part 1/1 - DONE (0 hours, 0 minutes, 1 seconds, 178 milliseconds)

STEPS
-----------------------
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

Cause

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