Advertisement
Guest User

Untitled

a guest
Nov 1st, 2014
163
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.75 KB | None | 0 0
  1. "E:TestDeploymentTest.proj" (UpgradeDatabase target) (1) ->(dbDeploy target) ->
  2. E:TestDeploymentTest.proj(212,5): error : Unexpected System.IO.FileNotFoundException
  3. error executing SQL command: -- BEGINNING TRANSACTIONr
  4. E:TestDeploymentTest.proj(212,5): error : PRINT 'Beginning transaction'r
  5. E:TestDeploymentTest.proj(212,5): error : BEGIN TRANSACTION r
  6. E:TestDeploymentTest.proj(212,5): error : GOr
  7. E:TestDeploymentTest.proj(212,5): error : r
  8. E:TestDeploymentTest.proj(212,5): error : -- Drop Table ChangeLogr
  9. E:TestDeploymentTest.proj(212,5): error : Print 'Checking for Table ChangeLog'r
  10. E:TestDeploymentTest.proj(212,5): error : IF (NOT EXISTS(SELECT * FROM sys.objects WHER
  11. E [object_id] = OBJECT_ID(N'[dbo].ChangeLog') AND [type]='U'))r
  12. E:TestDeploymentTest.proj(212,5): error : BEGINr
  13. E:TestDeploymentTest.proj(212,5): error : CREATE TABLE dbo.ChangeLog r
  14. E:TestDeploymentTest.proj(212,5): error : (r
  15. E:TestDeploymentTest.proj(212,5): error : change_number INTEGER NOT NUL
  16. ,r
  17. E:TestDeploymentTest.proj(212,5): error : delta_set VARCHAR(10) NOT NUL
  18. ,r
  19. E:TestDeploymentTest.proj(212,5): error : start_dt DATETIME NOT NULL,r
  20. E:TestDeploymentTest.proj(212,5): error : complete_dt DATETIME NULL,r
  21. E:TestDeploymentTest.proj(212,5): error : applied_by VARCHAR(100) NOT N
  22. LL,r
  23. E:TestDeploymentTest.proj(212,5): error : description VARCHAR(500) NOT
  24. ULLr
  25. E:TestDeploymentTest.proj(212,5): error : )r
  26. E:TestDeploymentTest.proj(212,5): error : r
  27. E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
  28. IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
  29. E:TestDeploymentTest.proj(212,5): error : r
  30. E:TestDeploymentTest.proj(212,5): error : ALTER TABLE ChangeLog ADD CONSTRAINT
  31. PK_ChangeLog PRIMARY KEY (change_number, delta_set)r
  32. E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN
  33. IF @@TRANCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
  34. E:TestDeploymentTest.proj(212,5): error : ENDr
  35. E:TestDeploymentTest.proj(212,5): error : GOr
  36. E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRA
  37. NCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
  38. E:TestDeploymentTest.proj(212,5): error : GOr
  39. E:TestDeploymentTest.proj(212,5): error : r
  40. E:TestDeploymentTest.proj(212,5): error : UPDATE dbo.ChangeLog SET complete_dt = getdat
  41. e() WHERE complete_dt IS NULLr
  42. E:TestDeploymentTest.proj(212,5): error : GOr
  43. E:TestDeploymentTest.proj(212,5): error : r
  44. E:TestDeploymentTest.proj(212,5): error : IF @@ERROR<>0 OR @@TRANCOUNT=0 BEGIN IF @@TRA
  45. NCOUNT>0 ROLLBACK SET NOEXEC ON ENDr
  46. E:TestDeploymentTest.proj(212,5): error : GOr
  47. E:TestDeploymentTest.proj(212,5): error : r
  48. E:TestDeploymentTest.proj(212,5): error : -- COMMITTING TRANSACTIONr
  49. E:TestDeploymentTest.proj(212,5): error : IF @@TRANCOUNT>0r
  50. E:TestDeploymentTest.proj(212,5): error : BEGINr
  51. E:TestDeploymentTest.proj(212,5): error : PRINT 'Committing transaction'r
  52. E:TestDeploymentTest.proj(212,5): error : COMMIT TRANSACTION r
  53. E:TestDeploymentTest.proj(212,5): error : ENDr
  54. E:TestDeploymentTest.proj(212,5): error : GOr
  55. E:TestDeploymentTest.proj(212,5): error : r
  56. E:TestDeploymentTest.proj(212,5): error : SET NOEXEC OFFr
  57. E:TestDeploymentTest.proj(212,5): error : GOr
  58. E:TestDeploymentTest.proj(212,5): error :
  59. E:TestDeploymentTest.proj(212,5): error : Could not load file or assembly 'Microsoft.Sq
  60. lServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
  61. The above script is working fine in my Dev box and also on a box (Windows Server 2008 R2) where SQL SERVER 2008 R2 is installed. Issues started once I tried to test it on a new box where SQL SERVER 2012 is installed.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement