java.sql.SQLException

object name already exists: PORTAL_REVENUEAMOUNTS in statement [create table PORTAL_REVENUEAMOUNTS(BRM_GL_ID NUMERIC(10) NULL, BRM_GL_IDORDER NUMERIC(10) NULL, ELEMENT NUMERIC(10) NOT NULL, GENERALLEDGERREPORTFK NUMERIC(10) NULL, RESOURCEID NUMERIC(10) NULL, RESOURCEIDORDER NUMERIC(10) NULL, REVENUEAMOUNTSORDER NUMERIC(10) NULL, REVENUEAMOUNTSPK NUMERIC(10) NOT NULL)]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web12631

  • object name already exists: PORTAL_REVENUEAMOUNTS in statement [create table PORTAL_REVENUEAMOUNTS(BRM_GL_ID NUMERIC(10) NULL, BRM_GL_IDORDER NUMERIC(10) NULL, ELEMENT NUMERIC(10) NOT NULL, GENERALLEDGERREPORTFK NUMERIC(10) NULL, RESOURCEID NUMERIC(10) NULL, RESOURCEIDORDER NUMERIC(10) NULL, REVENUEAMOUNTSORDER NUMERIC(10) NULL, REVENUEAMOUNTSPK NUMERIC(10) NOT NULL)]
  • via Google Groups by Dgenius, 1 year ago
    Numeric Overflow
  • via Coderanch by Mohnish Saini, 7 months ago
    Numeric Overflow java.sql.SQLException: Numeric Overflow
  • Stack trace

    • java.sql.SQLException: object name already exists: PORTAL_REVENUEAMOUNTS in statement [create table PORTAL_REVENUEAMOUNTS(BRM_GL_ID NUMERIC(10) NULL, BRM_GL_IDORDER NUMERIC(10) NULL, ELEMENT NUMERIC(10) NOT NULL, GENERALLEDGERREPORTFK NUMERIC(10) NULL, RESOURCEID NUMERIC(10) NULL, RESOURCEIDORDER NUMERIC(10) NULL, REVENUEAMOUNTSORDER NUMERIC(10) NULL, REVENUEAMOUNTSPK NUMERIC(10) NOT NULL)] at com.sunopsis.jdbc.driver.xml.SnpsXmlStatementRedirector.execute(SnpsXmlStatementRedirector.java:125)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.