PW Admin table conversion error after update - 08.11.11.590 to 10.00.02.99

Offline Sean Keene Sun, Jun 4 2017 10:25 AM

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

Parents

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
Up 0 Down

Verify Answer

Cancel
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
Up 0 Down

Verify Answer

Cancel
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
Up 0 Down

Verify Answer

Cancel
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
Up 0 Down

Verify Answer

Reject Answer

Cancel
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
Up 0 Down

Verify Answer

Cancel
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
Up 0 Down

Verify Answer

Cancel
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
Up 0 Down

Verify Answer

Cancel

Reply

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
Up 0 Down

Verify Answer

Cancel

Children

No Data