Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Wiki Sequence number is not increasing in document code / document code case sensitive
    • Sign In
    • ProjectWise Design Integration Wiki
    • ProjectWise Software Download
    • +ProjectWise Learning
    • +Projectwise Licensing
    • ProjectWise Programming and PowerShell
    • +Projectwise Documentation
    • -ProjectWise Explorer Client
      • +ProjectWise Client
      • +Featured Articles - Projectwise Explorer
      • +Audit Trail - ProjectWise Explorer Client
      • +Bentley IMS Login
      • +BS1192 Rules Engine - ProjectWise Explorer Client
      • +Check In Dialog - ProjectWise Explorer Client
      • -Document Code - ProjectWise Explorer Client
        • How to combine two select queries
        • Incorrect / wrong serial number is generated in document code
        • Last Error 58129: Can not create the document. Document Code serial number is invalid.
        • User is trying to format a number for hi... (Solution 500000101441)
        • Sequence number / serial number is not increasing in document code
        • Sequence number is not increasing in document code / document code case sensitive
      • +Document Creation - ProjectWise Explorer Client
      • +Documentation & Help - ProjectWise Explorer Client
      • +Environments and Attributes - PWE
      • +Export / Import Tool - ProjectWise Explorer Client
      • +Folders / Subfolders - ProjectWise Explorer Client
      • +GUI - ProjectWise Explorer Client
      • +Installation - ProjectWise Explorer Client
      • +Integration - General
      • +Integration - AutoCAD - ProjectWise Explorer Client
      • +Integration - Civil 3D - ProjectWise Explorer Client
      • +Integration - DGN Platform - ProjectWise Explorer Client
      • +Integration - MicroStation - ProjectWise Explorer Client
      • +Integration - Office - ProjectWise Explorer Client
      • +Integration - Revit - ProjectWise Explorer Client
      • +Logs Troubleshooting- ProjectWise Explorer Client
      • +Messaging Service - ProjectWise Explorer Client
      • +MISC - ProjectWise Explorer Client
      • +Open / Save / Copy / Move - ProjectWise Explorer Client
      • +Photo Preview - ProjectWise Explorer Client
      • +ProjectWise Managed Workspaces
      • +Project - ProjectWise Explorer Client
      • +Search - ProjectWise Explorer Client
      • +Security and Permissions - ProjectWise Explorer Client
      • +User Tools - ProjectWise Explorer Client
      • +Views - ProjectWise Explorer Client
      • +Workflows & States - ProjectWise Explorer Client
    • +ProjectWise Administrator
    • +ProjectWise Integration Server
    • +ProjectWise Caching Server
    • +ProjectWise Gateway Server
    • +ProjectWise User Synchronization Service
    • +ProjectWise Orchestration Framework
    • +ProjectWise Connected Services
    • +Working from Home with ProjectWise
    • +ProjectWise Glossary
    • ProjectWise Hosting - Manage Services

     
     Questions about this article, topic, or product? Click here. 

    Sequence number is not increasing in document code / document code case sensitive

    Product(s): ProjectWise Explorer Client
    Version(s): 08.11.11.574
    Environment: Oracle database, Windows Server 2008 R2
    Area: Document Code
    Original Author: Arturas Zidonis, Bentley Technical Support Group

    Problem Description

    Sequence number is not increasing in document code and is created with the same document code. This happens when ProjectWise is used with Oracle database. If there is a document in ProjectWise that  has attribute from document code in lowercase (e.g. ABC-mm-001) and user creates new document where the same attribute is in uppercase (e.g. ABC-MM-001) it will generate sequence number 001 and will allow to create this document code.

    So using Oracle database with ProjectWise document code is case sensitive.

    Steps to Resolve

    To avoid this situation it would be the best to have document code attributes in lowercase or in uppercase. And if there are many documents with lowercase and uppercase attributes mixed up already then you should run some scripts in Oracle to equalize lower/uppercase or use ProjectWise  Export / Import tool and change attributes for the documents in Excel file.

    • ProjectWise Explorer Client
    • Document Code
    • SELECTsupport
    • Problem Solving
    • Share
    • History
    • More
    • Cancel
    • Arturas Zidonis Created by Bentley Colleague Arturas Zidonis
    • When: Wed, Mar 5 2014 12:19 PM
    • Dana Guthrie Last revision by Bentley Colleague Dana Guthrie
    • When: Wed, Oct 19 2022 3:42 PM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies