Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ProjectWise
  • Product Communities
ProjectWise
ProjectWise Design Integration Forum PW Admin table conversion error after update - 08.11.11.590 to 10.00.02.99
    • Sign In

    • State Verified Answer
    • +1 person also asked this people also asked this
    • Replies 13 replies
    • Subscribers 65 subscribers
    • Views 7952 views
    • Users 0 members are here
    • administrator
    • Conversion

    PW Admin table conversion error after update - 08.11.11.590 to 10.00.02.99

    Sean Keene
    Offline Sean Keene over 6 years ago

    After a successful DMSCONV of projectwise database I am getting the error in the screenshot below.  I have also attached log files from the DMSCONV, dmskrnl, and pwadmin.  The issue seems to be coming from the spatial tables.  Any help is appreciated.

     LogFiles.zip

    • Sign in to reply
    • Cancel
    Parents
    • Kevin van Haaren
      0 Offline Kevin van Haaren Sun, Jun 4 2017 3:28 PM

      in the pwadmin log looks like it's failing to upload a file called "world.dpr" but it doesn't say where it is trying to upload it to. Might try boosting logging levels on the pwise.ft category to debug level and see it'll give more details.

      I checked my server and we don't have this file, but we only upgraded to 10.00.01.67. lots of changes in the 02.xx updates.

      pwise.dms - Error 100 reported at func: dmsSpatialSRSListSelect line: 1651
      pwise.ft - Error -11040 at func: FTnet_sendFile line: 752
      pwise.ft - Error -11040 "failed to send file to server" at func: putfile_proc line: 549
      pwise.spatial.schema.creation - CreateDefaultMap: Error creating "world.dpr" document

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Sean Keene
      0 Offline Sean Keene Sun, Jun 4 2017 6:45 PM in reply to Kevin van Haaren
      Thanks for the reply Kevin.

      The log file for pwadmin is a result of turning up the debug level.
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Kevin van Haaren
      0 Offline Kevin van Haaren Mon, Jun 5 2017 11:30 AM in reply to Sean Keene

      whoops, my bad, didn't read down far enough. File upload fails sending file to server bentley2016.banning-eng.local trying to store it on that server at D:/pwstorage/projects/d0109232/world.dpr.

      it gets a ip address for the server so that's ok, it seems to send the file ok. so i would verify the path it's trying to write to exists and has appropriate file permissions for the account that your pw server is using.

      2017-06-04 02:42:16,125 INFO [0x00003b50] pwise.ft - dmsFTSendFileToServer(0x1, 'bentley2016.banning-eng.local','C:/Program Files (x86)/Bentley/ProjectWise/bin/world.dpr','D:/pwstorage/projects/d0109232/world.dpr')

      Bentley might have more details if they could tell us what error -11040 was.

       

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Sean Keene
      0 Offline Sean Keene Mon, Jun 5 2017 1:40 PM in reply to Kevin van Haaren
      Response to MWr and Kevin,

      I checked the storage area and folder where "Documents\dmsSystem\Spatial\Root folder where DPR files used as background map layers are stored\" points to, which is folder id "D:/pwstorage/projects/d0109232" and the file world.dpr already exists. The access control is set correctly on that folder or no restrictions on file creation.

      After combing the log file a bit more, it is interesting that this error comes up "pwise.server - Error 100 "select o_csid,o_name from dms_coordinatesystems AS a where 1 >= (select count(*) from dms_coordinatesystems AS b where b.o_csid >= a.o_csid)" reported at func: dmdSpatialSRSListSelect line: 3057" shortly before the pwise.ft error comes up. Even stranger is that throughout the log file the pwise.database and pwise.spatial.schema.validation which is what the original PWAdmin error was complaining about "Spatial tables creation failed" does not report an error.

      If the upgrade is expecting the file world.dpr to not exist that could be the issue but I am not for sure.
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Marty.Nickel
      0 Offline Marty.Nickel Tue, Jun 6 2017 1:10 PM in reply to Sean Keene
      turn up the dmskrnl.log files and try it again. that way we can see what it's erroring out on.



      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Sean Keene
      0 Offline Sean Keene Thu, Jun 8 2017 8:33 AM in reply to Marty.Nickel
      Ok, I will be attempting this again over the weekend.
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Molly Watts
      0 Offline Molly Watts Thu, Jun 8 2017 9:14 AM in reply to Sean Keene
      the error -11040 is that it can't overwrite object, and it sounds like you found the file already exists in the storage area. I would bet it doesn't exist in the PW folder structure, so PW is trying to create it and running into a conflict. Try renaming the world.dpr in the storage area and try again. I just saw this recently with another user, and it was the case for a few files before it worked.



      Answer Verified By: Sean Keene 

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject Answer
      • Cancel
    Reply
    • Molly Watts
      0 Offline Molly Watts Thu, Jun 8 2017 9:14 AM in reply to Sean Keene
      the error -11040 is that it can't overwrite object, and it sounds like you found the file already exists in the storage area. I would bet it doesn't exist in the PW folder structure, so PW is trying to create it and running into a conflict. Try renaming the world.dpr in the storage area and try again. I just saw this recently with another user, and it was the case for a few files before it worked.



      Answer Verified By: Sean Keene 

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Reject Answer
      • Cancel
    Children
    • Sean Keene
      0 Offline Sean Keene Thu, Jun 8 2017 9:46 AM in reply to Molly Watts
      Molly, you are correct! The file exists in the storage area but not visible in PW Explorer. I will try your suggestion as well as turn up the logging on the dmskrnl.

      Thanks for the reply.
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Sean Keene
      0 Offline Sean Keene Sun, Jun 11 2017 9:03 PM in reply to Molly Watts
      Thank you Molly! That was the issue. There were 2 files in the storage area but not listed in PWE or no record in the database. There both refered to the spatial system and once I renamed them the PW Admin table upgrade worked.

      Thanks again.
      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel
    • Vivek Baraiya
      0 Offline Vivek Baraiya Fri, Mar 30 2018 10:20 PM in reply to Molly Watts

      HI Molly and Kevin,

      This discussion really help me a lot.

      Regards,

      Vivek

      • Cancel
      • Vote Up 0 Vote Down
      • Sign in to reply
      • Verify Answer
      • Cancel

    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