Project export error

[gerhard_hundsberger]

We are developing our project on MII 12.2.3 Build(177). Now we want to transport the project to the QA system.

The problem is, that the project export ZIP file does not contain all files. It is not empty, but some IRPT and some BLS files (trx, qry, ..) are missing. I've tried the export several times.
The project is under source control since the very begining (this means already before upgrading to our current version of MII). The export of shared projects did also not work properly before the upgrade (former version was MII 12.2.0). Hopping for a improvement was the reason for upgrading MII.

Did anyone experience the same problem?

best regards
Gerhard

[gerhard_hundsberger · Accepted solution]

I accidently found now a solution for my export problem:

One need to synchronize the project in the workbench (right click on the project), in order that the export ZIP is fully built.

[agentry_src · Accepted solution]

Thanks for posting your solution, no matter how you stumbled upon it! 

[Former Member]

I have the same problem and this solution does not work for me.

Our MII 12.2 SP7 does not give any option to synchronize when right clicking project.

However, Tools => Sync file to Tree is there.

It does run without any output on all but the catalog tab.

But with Catalog tab the "Sync file to Tree" results in the following Error pop up box:

" 2

[OK]"

Whatever that means, it doesn't help the corrupted export tree, 98% of our most important project is still missing.

Its sad that our manual version control system is now completely corrupted as the zip file is not reliable.

[Former Member]

FYI I have now found the reason and solution.

One file had been moved and existed twice with the same file name and path name, that is the same file name was present two times in the same folder. This resulted in the export being corrupted without any error message at all, and the Sync Tree to File to fail with the above mentioned error "2".

To find any and all of the culprit files i used the following MS SQL, where X0P is "your SAP system ID - SID":

select p.FULLPATH, f.[NAME], COUNT(f.ID) total,  MIN(f.ID) id1, MAX(f.ID) id2
from X0P.SAPX0PDB.XMII_FILES f
inner join
  X0P.SAPX0PDB.XMII_PATHS p
on
  f.PATHID = p.ID
WHERE p.FULLPATH LIKE '%'
GROUP BY p.FULLPATH, f.[NAME]
HAVING COUNT(f.ID) > 1

I then used the file ID found to display the details about the 2 files to select the one record for deletion:

SELECT *
FROM SAPX0PDB.XMII_FILES
WHERE ID IN (584, 1086)
ORDER BY NAME, CREATED

After deleting the chosen version (i.e. oldest one) a new export did include all the expected files.

Further suggestions:

As we in our case rely on the export function to work correctly it would be very nice if it would at least display a descriptive error message if it encountered errors.

Also the sync file to tree error message "2" should be improved.

Br, Mogens

[Former Member]

Hi Gerhard,

Have all the files being checked in properly?This may happen sometimes if you export the project with some files checked out and the zip may get corrupted.Check and from SAP MII Menu -> Projects,export the project once more.The export of projects works pretty fine in SAP MII 12.2.3(Build 167) which we are currently using.

Thanks & Regards,

Shawna