Error collecting changes for VCS repository - Encoding
i got some commits (changed file / commits messges) with non standatd chars
in the VCS log i get this error:
this stops the VCS from proccesing commit and
Error collecting changes for VCS repository '"GitHub EMU" {instance id=86, parent internal id=129, parent id=Af_GitHubEmu, description: "https://github.com/Company/Repo#master"}'
jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception: SQL error when doing 'Execute batch for tuples'
ERROR: character with byte sequence 0xd7 0xaa in encoding "UTF8" has no equivalent in encoding "WIN1252"
Where: unnamed portal parameter $3 while performing SQL query: insert into vcs_change ( modification_id, file_num, vcs_file_name, vcs_file_name_hash, relative_file_name_pos, relative_file_name, relative_file_name_hash, change_type, change_name, before_revision, after_revision ) values ( :myModificationId, :myFileNum, :myVcsFileName, :myVcsFileNameHash, :myRelFileNamePos, :myRelFileName, :myRelFileNameHash, :myChangeType, #TRUNC{:myChangeName;64}, #TRUNC{:myBeforeRevision;200}, #TRUNC{:myAfterRevision;200} ) : org.postgresql.util.PSQLException: ERROR: character with byte sequence 0xd7 0...
Hide stacktrace
jetbrains.buildServer.vcs.VcsRootVcsException: Error collecting changes for VCS repository '"GitHub EMU" {instance id=86, parent internal id=129, parent id=Af_GitHubEmu, description: "https://github.com/Company/Repo#master"}'
jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception: SQL error when doing 'Execute batch for tuples'
ERROR: character with byte sequence 0xd7 0xaa in encoding "UTF8" has no equivalent in encoding "WIN1252"
Where: unnamed portal parameter $3 while performing SQL query: insert into vcs_change ( modification_id, file_num, vcs_file_name, vcs_file_name_hash, relative_file_name_pos, relative_file_name, relative_file_name_hash, change_type, change_name, before_revision, after_revision ) values ( :myModificationId, :myFileNum, :myVcsFileName, :myVcsFileNameHash, :myRelFileNamePos, :myRelFileName, :myRelFileNameHash, :myChangeType, #TRUNC{:myChangeName;64}, #TRUNC{:myBeforeRevision;200}, #TRUNC{:myAfterRevision;200} ) : org.postgresql.util.PSQLException: ERROR: character with byte sequence 0xd7 0xaa in encoding "UTF8" has no equivalent in encoding "WIN1252" Where: unnamed portal parameter $3
Please sign in to leave a comment.
i fixed it by creating new database with UTF-8 Encoding.
than pointing TeamCity to the new one
Documentation describes that the PostgreSQL database must use UTF8:
https://www.jetbrains.com/help/teamcity/set-up-external-database.html#On+PostgreSQL+Server+Side
Best regards,
Anton