jvgr019 opened a new issue, #8897: URL: https://github.com/apache/devlake/issues/8897
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened When running Collect Data for a specific project through the Jenkins connector, an error is raised and the data import process stops. Data collection from Jenkins works successfully for other projects. If I enable the "Skip failed tasks (Recommended when collecting a large volume of data, e.g. 10+ GitHub repositories, Jira boards, etc.)" option, the collection process completes, but the Jenkins data for this project is not imported, that is normally because skip errors is selected. The error message indicates that the value is **too long for the primary_view column**. This column is column for **_tool_jenkins_jobs** that seems to contains url's. Actually this column is **varchar(255)** that is **insuficient** for containing url's This is the error `attached stack trace -- stack trace: | github.com/apache/incubator-devlake/core/runner.RunPluginSubTasks | /app/core/runner/run_task.go:341 | [...repeated from below...] Wraps: (2) subtask extractApiJobs ended unexpectedly Wraps: (3) attached stack trace -- stack trace: | github.com/apache/incubator-devlake/impls/dalgorm.(*Dalgorm).convertGormError | /app/impls/dalgorm/dalgorm.go:547 | github.com/apache/incubator-devlake/impls/dalgorm.(*Dalgorm).CreateOrUpdate | /app/impls/dalgorm/dalgorm.go:265 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*BatchSave).flushWithoutLocking | /app/helpers/pluginhelper/api/batch_save.go:131 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*BatchSave).Close | /app/helpers/pluginhelper/api/batch_save.go:147 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*BatchSaveDivider).Close | /app/helpers/pluginhelper/api/batch_save_divider.go:102 | github.com/apache/incubator-devlake/helpers/pluginhelper/api.(*Api Extractor).Execute | /app/helpers/pluginhelper/api/api_extractor.go:141 | github.com/apache/incubator-devlake/plugins/jenkins/tasks.ExtractApiJobs | /app/plugins/jenkins/tasks/job_extractor.go:81 | github.com/apache/incubator-devlake/core/runner.runSubtask | /app/core/runner/run_task.go:433 | github.com/apache/incubator-devlake/core/runner.RunPluginSubTasks | /app/core/runner/run_task.go:338 | github.com/apache/incubator-devlake/core/runner.RunPluginTask | /app/core/runner/run_task.go:173 | github.com/apache/incubator-devlake/core/runner.RunTask | /app/core/runner/run_task.go:147 | github.com/apache/incubator-devlake/server/services.runTaskStandalone | /app/server/services/task_runner.go:114 | github.com/apache/incubator-devlake/server/services.RunTasksStandalone.func1 | /app/server/services/task.go:187 | runtime.goexit | /usr/local/go/src/runtime/asm_amd64.s:1598 Wraps: (4) Error 1406 (22001): Data too long for column 'primary_view' at row 11 (500) Wraps: (5) Error 1406 (22001): Da ta too long for column 'primary_view' at row 11 Error types: (1) *withstack.withStack (2) *errutil.withPrefix (3) *withstack.withStack (4) *errutil.withPrefix (5) *mysql.MySQLError ` ### What do you expect to happen The data collection should complete successfully and import all Jenkins data for the project even the path to jenkins view is long as url specification ### How to reproduce - In jenkins create a long path to job creating subfolders and long name jobs - Collect data form Jenkins connection ### Anything else _No response_ ### Version v1.0.3-beta12@1d21f19 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
