URGENT!!! Need technical support for SQL Packager command-li

hswami

Hi.

The invoice # for the software purchase is 28167 - I believe we have a support agreement in place. I would appreciate a speedy response and resolution/workaround to this problem.

The error seems to be something to do with the file path.

My PATH environment variable is set to the following, with the bold highlighting the path for the SQL Toolkit:

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\UnxUtils\bin;C:\UnxUtils\usr\local\wbin;C:\Program Files\Perforce;C:\Program Files\Microsoft SQL Server\80\Tools\BINN;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\pocketsoft\rtpatch;[b]C:\Program Files\Red Gate\SQL Bundle 5[/b];C:\Program Files\VisBuildPro6;C:\Program Files\Macrovision\IS11.5\System

The command-line I am attempting to execute is as follows:

SQLPackager.exe /verbose /force /database1:TechAccess /username1:TechAccess /password1:technet /nocompression /makeexe /name:TechAccessDatabaseInstall /location:C:\Development\TechAccess\client\Configuration.Manager /schemascript:TechAccess.Database.Schema.9.4.0.12.sql /datascript:TechAccess.Database.Data.9.4.0.12.sql

The toolkit runs fine until it hits the compilation stage, so the tool is generating the .sql files mentioned in the above command-line correctly. At the compilation state the tool stops and spits out an error message.

I am receiving the following message when attempting to run the above command-line:

Error: Error occurred whilst creating package 'TechAccessDatabaseInstall' in'C:\Development\TechAccess\client\Configuration.Manager': Compilation errors: error CS2001: Source file'Gate\PE929a7e3a-be17-4b9e-9e21-50b00d5a2bb0.resx,Package.TechAccessDatabaseInstall.FormAbout.resources' could not befound error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE834854f9-a65a-4bbe-84f6-937d78cc2639.resx,Package.TechAccessDatabaseInstall.FormDatabaseProperties.resources'could not be found error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Sourcefile 'Gate\PE8a8a3ab5-a77a-4131-99dc-4c0a66750c11.resx,Package.TechAccessDatabaseInstall.FormHelp.resources' could notbe found error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE79dcc875-f2e9-4219-b30a-d08f68a6e821.resx,Package.TechAccessDatabaseInstall.FormSelectDatabase.resources' couldnot be found error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE29aa552d-1f86-49bc-a8d2-e6e8a96428b9.resx,Package.TechAccessDatabaseInstall.MessageBox.resources' could not befound error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE8ff42ac0-9058-4619-8187-98e8fd81cb0f.resx,Package.TechAccessDatabaseInstall.MessageBoxIcon.resources' could notbe found error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEc0639304-350a-47e7-978c-98d382133764.resx,Package.TechAccessDatabaseInstall.ProgressDialog.resources' could notbe found error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE490d1135-c656-4ecd-8f56-a7931f3a4619.resx,Package.TechAccessDatabaseInstall.SQLExceptionForm.resources' couldnot be found error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE45199c13-f232-4366-96ad-ce5d7c8ae7d1.dll,TechAccessDatabaseInstall.RedGate.Compression.ZLib.dll' could not befound error CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEc1d4265f-3036-421c-9ea5-234ab0e9eb7f,TechAccessDatabaseInstall.Package1.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEb2565513-60f9-45fd-8fe5-fda5096cc1aa,TechAccessDatabaseInstall.Package2.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE126015ac-4b1a-4c2f-9ae5-89aa287cd80f,TechAccessDatabaseInstall.Package3.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEe628aa73-ac83-4710-92ba-a82aa854aabf,TechAccessDatabaseInstall.Package4.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE9f1a3ba6-af98-4329-9f0b-9d5557fe724f,TechAccessDatabaseInstall.Package5.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE389e0ef7-9209-42c7-ae75-77dff950fc5d,TechAccessDatabaseInstall.Package6.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE02ab64a8-d30c-4fb9-9667-ceea1fd6e855,TechAccessDatabaseInstall.Package7.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE05528b00-653f-4341-807a-3f84a9a3cb6e,TechAccessDatabaseInstall.Package8.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEc77c0011-9b3e-49c3-bb94-896eab6fa7de,TechAccessDatabaseInstall.Package9.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE144c29da-ece4-4da5-be99-392cc001c10d,TechAccessDatabaseInstall.Package10.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE46ecc333-2d85-440a-9640-9f4703a0fad5,TechAccessDatabaseInstall.Package11.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEcd46ab85-692c-4c82-941b-f5265476b7a8,TechAccessDatabaseInstall.Package12.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEe372555e-5d74-4803-98a9-f08e300a0aeb,TechAccessDatabaseInstall.Package13.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE59f7fde7-672b-4e51-92bf-2c4407ea6bb2,TechAccessDatabaseInstall.Package14.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEb367cdb5-6695-4fe8-a88c-1568fca56e80,TechAccessDatabaseInstall.Package15.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE22e67157-638e-404f-8ec7-4f9ced928589,TechAccessDatabaseInstall.Package16.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE60d6e9c3-bae8-4d96-a183-06bea8122184,TechAccessDatabaseInstall.Package17.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE15499e4d-2947-467a-80ac-5acefdee7323,TechAccessDatabaseInstall.Package18.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE2e368042-8c08-4adb-9461-8c97fb2fa8d0,TechAccessDatabaseInstall.Package19.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE3a6dd868-c4c6-4f14-b390-4002440fc937,TechAccessDatabaseInstall.Package20.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE3fcb4de2-21af-437a-b490-25de2e827f1e,TechAccessDatabaseInstall.Package21.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE65cf522c-373d-4d02-a76f-e9966c9673f4,TechAccessDatabaseInstall.Package22.resources' could not be found errorCS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PE94632d91-09f9-47b2-9364-7092f3793550,TechAccessDatabaseInstall.PackageSummary.resources' could not be founderror CS1508: Resource identifier 'Red' has already been used in this assembly error CS2001: Source file'Gate\PEe5a8f9ef-6056-4842-806d-d2798135da93,TechAccessDatabaseInstall.PackageProperties.resources' could not be founderror CS1566: Error reading resource file 'c:\Documents and Settings\Builder\Local Settings\Temp\Red' -- 'The systemcannot find the file specified. '

---

Himanshu R. Swami
Software Engineer
hswami@itsits.com
Innovative Technology Solutions, Inc.
15 Corporate Pl S, Ste 101
Piscataway, NJ 08854
Work: (732) 400-0004 ext. 41
Cell: (732) 986-2573
Fax: (425) 930-0452

Tom Harris

Hello,

I'm really sorry that you have run into such a nasty problem with the SQL Packager command line. I will get someone to look into this issue right away. Hopefully, we will be able to get a fix out to you as soon as we find it.

Apologies,

Tom Harris

Red Gate Software

hswami

Could you provide a more detailed answer? Is this a confirmed bug? Can you provide a timeline for a fix? I needed this working yesterday - I need to know if I should revert the entire toolkit to version 4 or if you will be providing me with a resolution within the next 24 hours.

Tom Harris

Hi,

you are the first person to run into this issue. We will investigate and come back with a detailed answer tomorrow. First glance indicates some problem with the temp path and it splitting 'Red Gate' into 2 words.

Sorry I can't be of any more help right now

Tom

Tilman

Hi hswami,

Sorry about the problems you're having.

I tried running your command, but couldn't get the exception.

Could you try not switching off compression, and let me know if the error also happens. Also, could you try creating a C# project, rather than an executable?

Thanks,

Tilman

Brian Donahue

It's because the path specified in the %TMP% environment variable has spaces in it and Packager can't handle it. When it creates the Visual Studio project in TMP and tries to compile it, these errors are generated.

This is not a problem on 99.9% of Windows installations because TMP is squished down into old DOS 8-dot-3 compliant format by default. For instance:

c:\>ECHO %TMP%
c:\>c:\docume~1\brian\Locals~1\Temp

If the system is set up not to entertain this, and the TMP path is something like c:\documents and settings\brian\local settings\temp, then Packager blows up when trying to compile the package. I think you can cahnge your system's bahaviour using fsutil, but I couldn't use that to reproduce the problem for some reason. Possibly your system had to be set up like this from the beginning?

fsutil behavior set disable8dot3 1
fsutil behavior set allowextchar 1