[C#] aaApi_OpenDocument And aaApi_CheckOutDocument not releasing object to excel

You are opening the document from a session of Microstation using ProjectWise Explorer which launches Excel, then leaving it up to the end user to do something. That seems to be a lot of handles on the document.  It becomes more complex if the Microstation document was opened from ProjectWise.

well yes it is a microstation addin. im integrating it with ProjectWise. So yes the user opens the microstation dgn file from ProjectWise (we have a managed workspace). now within microstation the user launches the addin. this addin will already have the session of ProjectWise since microstation was opened from ProjectWise (so no need to log in).

Now this addin does things like pull info from the dgn file, then when the user is ready they hit a button to output this info to an excel file. the excel file already exists in PW (its a template that gets filled out for every project).

I have limited my code to only open the document and do nothing else. all I do is use the aaApi_OpenDocument() api call. that should not be holding onto anything but it is.

I don't think that's a lot of handles on the document. and its not that out of the question to want to open a document.

I defiantly seems like its not releasing the excel COM object property.

not ruling out its something in my code but I removed everything except opening the file.

Robert Hook

is this on a schedule to be fixed? still doesn't seems to be fixed yet.

Hi John Drsek,

Arnab Gogoi informed me of your follow up question here.

Defect 1086379 has been addressed with a fix.

Configuration variable PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST Added and Documented in ..\ProjectWise\bin\mcm.user.cfg; in ProjectWise Explorer Client MCM Integration in 10.00.03.326 and later builds.

Please note the version referenced is an internal build and a public release should become available shortly; likely end of 2021-Q1 (Related).

For further product release information make sure to follow the Content Management Announcements Forum and/or feel free to Search and Ask questions on the Content Management Forum.

HTH,
Bob

Robert Hook said:

The defect has been addressed with a fix (new configuration variable being added) in ProjectWise Explore

 I installed 10.00.03.434 of PW explorer and tested and the problem still exists. you mention a configure variable. is this something in the MCM.cfg file? 

Hi John Drsek,

Please note I have updated my suggested answer above to contain all information to resolve the issue (today) in that one spot.

HTH,
Bob

Thanks Robert!

IT WORKS!!!!

for people doing this in c# the mcm.user.cfg file has the example of what to do but not in C#...it would look something like this..

using BD = Bentley.DgnPlatformNET;
...

                    string strValFetchedDocsVar = "";
                    if (BD.ConfigurationManager.IsVariableDefined("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST"))
                    {
                        strValFetchedDocsVar = BD.ConfigurationManager.GetVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST");
                    }
                    
                    BD.ConfigurationManager.DefineVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST", "0");

                    //open selected file
                    bool isOpen = PWWrappers.aaApi_OpenDocument(projectID, DocID, false);
                    if(isOpen == true)
                    {
                        MessageBox.Show("Successfully opened selected document");
                    }
                    else
                    {
                        string errormsg = PWWrappers.aaApi_GetLastErrorMessage() + " \n " + PWWrappers.aaApi_GetLastErrorDetail();
                        MessageBox.Show("Failed to open selected document \n " + errormsg);
                    }
                    if (strValFetchedDocsVar == "")
                    {
                        BD.ConfigurationManager.UndefineVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST");
                    }
                    else
                    {
                        BD.ConfigurationManager.DefineVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST", strValFetchedDocsVar);
                    }

Thanks Robert!

IT WORKS!!!!

for people doing this in c# the mcm.user.cfg file has the example of what to do but not in C#...it would look something like this..

using BD = Bentley.DgnPlatformNET;
...

                    string strValFetchedDocsVar = "";
                    if (BD.ConfigurationManager.IsVariableDefined("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST"))
                    {
                        strValFetchedDocsVar = BD.ConfigurationManager.GetVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST");
                    }
                    
                    BD.ConfigurationManager.DefineVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST", "0");

                    //open selected file
                    bool isOpen = PWWrappers.aaApi_OpenDocument(projectID, DocID, false);
                    if(isOpen == true)
                    {
                        MessageBox.Show("Successfully opened selected document");
                    }
                    else
                    {
                        string errormsg = PWWrappers.aaApi_GetLastErrorMessage() + " \n " + PWWrappers.aaApi_GetLastErrorDetail();
                        MessageBox.Show("Failed to open selected document \n " + errormsg);
                    }
                    if (strValFetchedDocsVar == "")
                    {
                        BD.ConfigurationManager.UndefineVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST");
                    }
                    else
                    {
                        BD.ConfigurationManager.DefineVariable("PW_ADD_FETCHED_DOCS_TO_IN_USE_LIST", strValFetchedDocsVar);
                    }