H! has any of you encountered this problem before?
The funny thing is that is says problems that the fields are not unique but actually they are before we created a build from visual studio. MSBuild complains between three fields. 2 fields conflicts with the "column names in each table must be unique" issue and 1 field with the "root element is missing" issue.
Appreciate you thoughts on this.
Monica
17/02/2009 19:42:53: =============== Deploy smartobjects and associations: Task completed ===============
Done building target "Deploy SmartObjects and Associations" in project "StaffSuggestionSystem.msbuild" -- FAILED.
Done building project "StaffSuggestionSystem.msbuild" -- FAILED.
Build FAILED.
C:DeploymentStaffSuggestionSystem.msbuild(166,5): error : Deploy smartobjects: Task error: SmartObjectServer Exception: Could not publish SmartObjectDefinition to server: SmartObjectServer Exception: Column names in each table must be unique. Column name 'PersonNo' in table 'dbo.PProfile' is specified more than once.
C:DeploymentStaffSuggestionSystem.msbuild(166,5): error : . SmartObject: 'PProfile'
C:DeploymentStaffSuggestionSystem.msbuild(166,5): error :
0 Warning(s)
1 Error(s)
In the K2 server console, this is what happens :
Error 10521 SmartObject Runtime.Management General Error: 'SmartObjectServer Exception: Column names in each table must be unique. Column name 'PersonNo' in table 'dbo.PProfile' is specified more than once.'
Error 10521 SmartObject Runtime.Management General Error: 'Could not publish SmartObjectDefinition to server: SmartObjectServer Exception: Column names in each table must be unique. Column name 'PersonNo' in table 'dbo.PProfile' is specified more than once.. SmartObject: 'PProfile''
Error 2025 Error Marshalling SourceCode.SmartObjects.Runtime.SmartObjectManagementServer.PublishSmartObjects, Could not publish SmartObjectDefinition to server: SmartObjectServer Exception: Column names in each table must be unique. Column name 'PersonNo' in table 'dbo.PProfile' is specified more than once.. SmartObject: 'PProfile'Error
2025 Error Marshalling SourceCode.SmartObjects.Runtime.SmartObjectManagementServer.PublishSmartObjects, Could not publish SmartObjectDefinition to server: SmartObjectServer Exception: Column names in each table must be unique. Column name 'PersonNo' in table 'dbo.PProfile' is specified more than once.. SmartObject: 'PProfile'
Error 8060 ProcessPacket Error, Could not publish SmartObjectDefinition to server: SmartObjectServer Exception: Column names in each table must be unique. Column name 'PersonNo' in table 'dbo.PProfile' is specified more than once.. SmartObject: 'PProfile'
