Skip to content

GitLab

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
    • Switch to GitLab Next
  • Sign in / Register
Accounting
Accounting
  • Project overview
    • Project overview
    • Details
    • Activity
  • Issues 10
    • Issues 10
    • List
    • Boards
    • Labels
    • Service Desk
    • Milestones
    • Iterations
  • Requirements
    • Requirements
    • List
  • Operations
    • Operations
    • Metrics
    • Incidents
  • Packages & Registries
    • Packages & Registries
    • Container Registry
  • Analytics
    • Analytics
    • Insights
    • Issue
    • Repository
    • Value Stream
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Activity
  • Create a new issue
  • Issue Boards
Collapse sidebar
  • solidplm
  • solidcad
  • AccountingAccounting
  • Issues
  • #24

Closed
Open
Opened Nov 30, 2020 by MyoThet@Myo_ThetOwner

Column name INDEXED_ON is specified more than once

ERROR when Import into Demo 12SP9 database

<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
    <SOAP-ENV:Body>
        <SOAP-ENV:Fault xmlns:af="http://www.aras.com/InnovatorFault">
            <faultcode>SOAP-ENV:Server</faultcode>
            <faultstring><![CDATA[Column names in each table must be unique. Column name 'INDEXED_ON' in table 'innovator.CUSTOMER' is specified more than once. in SQL: ALTER TABLE [innovator].[CUSTOMER] ADD [INDEXED_ON] DATETIME NULL]]></faultstring>
            <detail>
                <af:legacy_detail><![CDATA[Column names in each table must be unique. Column name 'INDEXED_ON' in table 'innovator.CUSTOMER' is specified more than once. in SQL: ALTER TABLE [innovator].[CUSTOMER] ADD [INDEXED_ON] DATETIME NULL]]></af:legacy_detail>
                <af:exception message="Column names in each table must be unique. Column name 'INDEXED_ON' in table 'innovator.CUSTOMER' is specified more than once. in SQL: ALTER TABLE [innovator].[CUSTOMER] ADD [INDEXED_ON] DATETIME NULL" type="Aras.Server.Core.InnovatorDatabaseException">
                    <af:innerException message="Column names in each table must be unique. Column name 'INDEXED_ON' in table 'innovator.CUSTOMER' is specified more than once." type="System.Data.SqlClient.SqlException" />
                </af:exception>
            </detail>
        </SOAP-ENV:Fault>
    </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Edited Nov 30, 2020 by MyoThet
Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
Reference: solidplm/solidcad/accounting#24