|
Alan Jones
|
|
|
Group: StrataFrame Users
Posts: 7,
Visits: 32
|
Hey guys, I've ran into an issue deploying package files from a dvd. The meta-data phase works smoothly, but then errors when attempting to deploy the actual data. The error message is 'Access to path D:\mypackage.pkg' is denied. I was able to get around this by changing the code in DbEngine -> DatabaseMigrator -> EnumDeploymentPackages where it was attempting to open it with FileAccess.ReadWrite (the default for a new PackageFile). from:
Dim loPackage As New PackageFile(MetaDataPkgPathAndFileName, True, False, PkgPassword) to this:
Dim lopackage As New PackageFile()
lopackage.FileOpenAccess = FileAccess.Read
lopackage.Open(MetaDataPkgPathAndFileName, True, False, PkgPassword) Any chance of including this in your next update/release?
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
|
Actually this isn't an issue. There is another thread or two out here about this, but it has to do with the access to the PKG file already being open via the previous process. Just FYI, this is something that we do as well and so I am very confident in this process.
One thing that you can do to make sure that the issue is resolved is to totally close the DatabaseMigrator class and re-created it and re-open the package. So when the meta-data is completed, you will close the migrator, re-create it and then start the data deployment phase. This is one way to ensure that the PKG file is not being held open.
|
|
|
|
|
Kenneth Langley
|
|
|
Group: StrataFrame Users
Posts: 26,
Visits: 1.5K
|
We implimented the recommendations you explained. We are not having an issue with the package file being open but that the file cannot be opened from a read only drive. If I make my directory "with the package file" on the harddisk readonly, I get the same error as if it were on a DVD. This happens when we try to deploy data, not metadata from same package file. What do you think about this error ?  TIA Kenneth
|
|
|
|
|
Kenneth Langley
|
|
|
Group: StrataFrame Users
Posts: 26,
Visits: 1.5K
|
We have also checked the data deployment through the DDT and we are getting the same issue. I believe that when you are opening the package for data deployment that it is trying to open as readwrite. Make a package file readonly on your machine. Try to deploy data from said package file. You will get the same error from the DDT. Error message below: ">
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
|
What is the stack trace that you are getting? It sounds like it is trying to extract something to the source drive, which doesn't sound right. If you don't mind, post the stack trace so I can see where it is being called. Thanks.
|
|
|
|
|
Kenneth Langley
|
|
|
Group: StrataFrame Users
Posts: 26,
Visits: 1.5K
|
Here is the Stack trace error.
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
|
Ken, You can already do exactly what you want. If you are going to use the standard meta data deployment class, then we will have to make a change to that dialog, but I went back and looked at our notes and we added the ability to open as read-only specifically for you for this purpose. Here is the code to open a package file as read-only: PackageFile x = new PackageFile();
x.FileOpenAccess = System.IO.FileAccess.Read;
x.Open(@"C:\Temp\StrataFlix.pkg", true, false);
x.Close(); I reproduced the error you received first, then I executed the code above and it opens as advertised.
|
|
|
|
|
Kenneth Langley
|
|
|
Group: StrataFrame Users
Posts: 26,
Visits: 1.5K
|
Here is the code that we are using. Do you have any suggestions for a change ? ''' <summary>''' Assumes that the meta-data has already been deployed and will deploy the''' deployment data packages within the package file.''' </summary>''' <remarks></remarks>Private Sub StartDataDeploymentPhase()'-- Establish LocalsDim laPKs As New List(Of Integer)Dim loItem As DeployDataInfo'-- Build a collection with all of the deployment primary keys. For Each loItem In DatabaseMigrator.EnumDeploymentPackages(_Package, "sunshine")laPKs.Add(loItem.PrimaryKey) Next '-- Create the DatabaseMigrator instanceIf _SQLUserName.Length = 0 Then_DatabaseSetupData = New DatabaseMigrator(_SQLServer, True, Me)Else_DatabaseSetupData = New DatabaseMigrator(_SQLServer, False, Me, _SQLUserName, _SQLPassword)End If'-- Set the Logfile location_DatabaseSetupData.LogFilePathAndFileName = MicroFour.StrataFrame.Strings.StringBasics.AddBS( My.Computer.FileSystem.SpecialDirectories.Temp) & "tcms_install.log"Me._DatabaseSetupData.EnableLogging = True'-- Create the DatabaseTargetName ArrayCreateDatabaseTargetNames() '-- Start the deployment of the dataMe._DatabaseSetupData.DeployData(_Package, "sunshine", laPKs.ToArray(), Me._DTNames)End Sub
|
|
|
|
|
Trent Taylor
|
|
|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
|
I see one place in the code not setting the package to be Read-Only (and will b ea 30 second fix), but before I can just send you a DLL, what version are you on? If you are not on 1.7, then me sending you a DLL to try won't work. In this example, you will need to just open the 1.6 SF code, make the change in the EnumDeploymentPackages method, and then use that assembly and then the next update will address this (so you don't have to maintain the source code). In the DatabaseMigrator class in the DBEngine, the code should look like this to ensure it is opened as Read-Only (EnumDeploymentPackages method): '-- Establish locals
Dim laReturn As New List(Of DeployDataInfo)
Dim loPackage As New PackageFile()
Dim loRow As DataRow
Dim loItem As DeployDataInfo
Dim loDeployDataDS As DataSet = Nothing
loPackage.FileOpenAccess = System.IO.FileAccess.Read
loPackage.Open(MetaDataPkgPathAndFileName, True, False, PkgPassword)
'-- Iterate through the records in the deployment data of the server and get them
loPackage.ExtractFiles(loPackage.GetIndexesByFilename("DeploymentData.xml"), PackageExtractionType.Relative, GetTemporaryFolder, True)
'-- We're done, so close the package file
loPackage.Close()
Once that change is made, the error should go away. I will make that change on this side, but if you are not on 1.7 then the change will have to be made on your side as well. If you don't get it going, let me know and I will go back in history and get the 1.6.6 build sucked down.
|
|
|
|
|
Kenneth Langley
|
|
|
Group: StrataFrame Users
Posts: 26,
Visits: 1.5K
|
Well Done. We are not using 1.7 release yet. We have a release pending and have locked the code. We will make this change to the DLL and use this for our deployment on the install CD. After this release we can move to 1.7 and get the fix from you then. By the way we have moved to InstallShield from InstallAware. It was just not cutting it for our install requirements. Thanks Kenneth
|
|
|
|