joshuabezaleel opened a new issue, #8666:
URL: https://github.com/apache/incubator-devlake/issues/8666

   ### 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
   
   I was trying to pull data from JIRA Cloud of my company's. My goal is 
particularly to fill the `incidents` table/entity for the DORA metrics.
   
   Got this error instead.
   ```
   time="2025-12-19 14:26:07" level=error msg=" [pipeline service] [pipeline 
#15] [task #3620] [collectIssuleField] end api collection error\n\tcaused by: 
error inserting raw rows into _raw_jira_api_issue_fields (500)"
   time="2025-12-19 14:26:07" level=info msg=" [pipeline service] [pipeline 
#15] [task #3620] subtask collectIssuleField finished in 2331 ms"
   time="2025-12-19 14:26:07" level=error msg=" [pipeline service] [pipeline 
#15] [task #3620] subtask collectIssuleField ended unexpectedly\n\tWraps: (2) 
Error waiting for async Collector execution\n\tWraps: (3) error inserting raw 
rows into _raw_jira_api_issue_fields (500)\n\tError types: (1) 
*hintdetail.withDetail (2) *hintdetail.withDetail (3) *errors.errorString"
   ```
   
   <img width="455" height="299" alt="Image" 
src="https://github.com/user-attachments/assets/672d0212-7aed-4598-a91d-68c51f658ac3";
 />
   
   ### What do you expect to happen
   
   Table `_raw_jira_api_issue_fields`, `_tool_jira_issues`, and `incidents` to 
be filled, so later I could observe the DORA dashboard on Grafana of Change 
Failure Rate and Median Time to Restore Service.
   
   ### How to reproduce
   
   1. Latest version of `v1.0.3-beta8`
   2. Create connection to JIRA Cloud
   3. Scope config for `Incidents` is `Task` (which I think is default given by 
JIRA)
   4. Execute the pipeline to Collect Data
   
   ### Anything else
   
   1. Is there anything that I can do to debug/fix this? Or do I need to use 
the dbt/customize plugin? I saw that the customize only support issues but not 
incidents.
   2. I already changed the log level of `lake` to `debug` instead of `info` 
but there doesn't seem to be any additional helping log. 
   3. I'm attaching the JIRA Scope Config (transformation for Incident) and the 
corresponding JIRA card (which shows the Task work type) if needed.
   
   <img width="898" height="649" alt="Image" 
src="https://github.com/user-attachments/assets/22f3449b-7fd9-42ed-b586-cb42705ee323";
 />
   
   <img width="613" height="168" alt="Image" 
src="https://github.com/user-attachments/assets/7d5b0488-dc65-45e4-a6cc-4ad718c76cba";
 />
   
   4. The ICM itself is actually a JIRA project (I haven't been converting it 
Board since it needs the Admin to do that). Is it possible that it might be the 
cause? Since I see previous issues that mentions for JIRA connection it only 
able to retrieve from Board and not Project. 
   - 
https://github.com/apache/incubator-devlake/issues/8196#issuecomment-2484039714
   - https://github.com/apache/incubator-devlake/discussions/6832
   
   ### Version
   
   v1.0.3-beta8
   
   ### Are you willing to submit PR?
   
   - [x] 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]

Reply via email to