After using the migration wizard, I am getting a number of "data type not supported" errors. I will post the full error listing below but the issue is with the following two data types:
Code: Select all
The data type 'BigInt NOT NULL IDENTITY' is not supported.
Code: Select all
The data type 'NVarChar(50)' is not supported.
It looks like either I have something set up wrong in linqconnect or my schema on the mysql server needs to be modified. Can anyone give me a suggestion for how to proceed with either option?
thanks a lot,
Max
Full list of errors:
Code: Select all
Error 108 The ServerDataType value of the Column element 'WavFileName' in the Type element 'Video' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 104 The ServerDataType value of the Column element 'VideoSourceId' in the Type element 'VideoSource' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 111 The ServerDataType value of the Column element 'VideoShotId' in the Type element 'VideoShot' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 112 The ServerDataType value of the Column element 'VideoShotFileName' in the Type element 'VideoShot' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 106 The ServerDataType value of the Column element 'VideoIdAtSource' in the Type element 'Video' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 105 The ServerDataType value of the Column element 'VideoId' in the Type element 'Video' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 109 The ServerDataType value of the Column element 'VideoFrameId' in the Type element 'VideoFrame' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 110 The ServerDataType value of the Column element 'VideoFrameFileName' in the Type element 'VideoFrame' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 107 The ServerDataType value of the Column element 'VideoFileName' in the Type element 'Video' is not valid. The data type 'NVarChar(50) NOT NULL' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 117 The ServerDataType value of the Column element 'UserFriendlyName' in the Type element 'Concept' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 125 The ServerDataType value of the Column element 'TextMetaData' in the Type element 'ConceptInstanceView' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 119 The ServerDataType value of the Column element 'TextMetaData' in the Type element 'ConceptInstance' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 127 The ServerDataType value of the Column element 'SpatioTemporalMetaData' in the Type element 'ConceptInstanceView' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 121 The ServerDataType value of the Column element 'SpatioTemporalMetaData' in the Type element 'ConceptInstance' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 126 The ServerDataType value of the Column element 'SpatialMetaData' in the Type element 'ConceptInstanceView' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 120 The ServerDataType value of the Column element 'SpatialMetaData' in the Type element 'ConceptInstance' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 123 The ServerDataType value of the Column element 'MetaData' in the Type element 'ConceptThreshold' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 102 The ServerDataType value of the Column element 'MetaData' in the Type element 'ConceptEvidence' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 115 The ServerDataType value of the Column element 'MetaData' in the Type element 'Algorithm' is not valid. The data type 'NVarChar(MAX)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 113 The ServerDataType value of the Column element 'FileDirectoryId' in the Type element 'FileDirectory' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 103 The ServerDataType value of the Column element 'DataSourceId' in the Type element 'DataSource' is not valid. The data type 'Int NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 101 The ServerDataType value of the Column element 'ConceptTypeId' in the Type element 'ConceptType' is not valid. The data type 'Int NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 124 The ServerDataType value of the Column element 'ConceptInstanceId' in the Type element 'ConceptInstanceView' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 118 The ServerDataType value of the Column element 'ConceptInstanceId' in the Type element 'ConceptInstance' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 116 The ServerDataType value of the Column element 'ConceptId' in the Type element 'Concept' is not valid. The data type 'Int NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 122 The ServerDataType value of the Column element 'ComparisonOperator' in the Type element 'ConceptThreshold' is not valid. The data type 'NVarChar(50)' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1
Error 114 The ServerDataType value of the Column element 'AlgorithmId' in the Type element 'Algorithm' is not valid. The data type 'BigInt NOT NULL IDENTITY' is not supported. C:\Users\mehrlich\Projects\AladdinWeb\AladdinWeb\Server\Database\AladdinModel.lqml 1 1