Package build frustrations–SSE

I was getting the following errors in the clientPkgBuild.log file:

Wed Aug 08 09:10:57  -  PkgMisc.cpp:1926 PKGMSC0014 ERROR: Failed to create MSDE spec repository.
Wed Aug 08 09:10:57  -  Repository created/attached.
Wed Aug 08 09:10:57  -  pkgSpec.cpp:2018 PKGSPC0013 ERROR: Failed to create spec repository on the build machine.
Wed Aug 08 09:10:57  -  Detaching the local repository on the build machine. This will take some time.
Wed Aug 08 09:10:57  -  Detaching local repository SPEC__PY900OSL.

If you follow [ID 867954.1] it’ll get you to uninstall and reinstall SSE – but probably to no avail (like in my situation).  My fix was actually to run the commands below:  Although, I did not get the error message that was alluded to in the logs that oracle point to.

It’s a little frustrating that you need to enable debug to get logs like the ones below:  Surely these are log worthy!

4676/3576 WRK:Starting jdeCallObject            Wed Aug 08 09:10:57.869003    MSDEDBAPI.cpp993
    MSDE000013 - SQLCreateDatabase failed for 'SPEC__PY900OSL'

4676/3576 WRK:Starting jdeCallObject            Wed Aug 08 09:10:57.869005    MSDEDBAPI.cpp1124
    [Microsoft][Microsoft SQL Server Driver]CREATE DATABASE failed. Primary file must be at least 3 MB to accommodate a copy of the model database. SQLSTATE: 42000 HRESULT:0X80040E14  Native Error:1803.

4676/3576 WRK:Starting jdeCallObject            Wed Aug 08 09:10:57.869009    spkgutil.c527
    [PKGBLD] - Wed Aug 08 09:10:57  -  PkgMisc.cpp:1926 PKGMSC0014 ERROR: Failed to create MSDE spec repository.

 

c:\>sqlcmd -E -S (local)\JDESSELocal
1> dbcc shrinkdatabase (model)
2> go