Skip to main content
Solved

Unable to retrive Jira Issues table customes fields

  • January 10, 2025
  • 4 replies
  • 120 views

Forum|alt.badge.img

Hi Team,

 

kindly help me on Jira custom fields are not visible in Cdata connector.

 

Thanks

Chari

Best answer by EroldB

Hi,

 

This error is related to the permissions you have when connecting to your Jira account. Can you set the following properties:

 

Logfile: “C:\Users\Public\log.txt

Verbosity: 3

 

Save the settings, then replicate the problem so that you see the same error again. Then you can send me the file which was created at C:\Users\Public\ in a private message.

 

The log can help me see what authentication settings you have and what API request is being sent to Jira that returns the 403 error. Log will not include any passwords or private tokens.

 

Please dont post the log here. Probably it will get removed.

This topic has been closed for replies.

4 replies

  • Apprentice
  • January 13, 2025

Hi.

 

please check your connection properties. You should specifically look for:

IncludeCustomFields

 

Set it to TRUE.

 

By default, it will be FALSE.


Forum|alt.badge.img

 

 

Hi Erod B,

 

Thanks for your replay.. i have set the property in connection to true.. however i am receiving above error message

 

kidlay help me ASAP

 

Thanks,

Chari


Forum|alt.badge.img

TITLE: Microsoft Visual Studio
------------------------------

Error at Jira_Issues [CData JIRA Source 2]: Unable to process query: "select 
current_date as run_date,
* from Issues where ProjectName = 'BIZAPPSOPS' ".  Exception message: [403] Forbidden error. HTTP protocol error. 403 Forbidden.
Error at Jira_Issues [CData JIRA Source 2 [689]]: bj230L.Vw: [403] Forbidden error. HTTP protocol error. 403 Forbidden.
   at bj230L.hYd.kh(Exception )
   at bj230L.hem.K(String )
   at bj230L.hem.Nx()
   at bj230L.hef.De(pcN )
   at bj230L.pkA.L(BV , pcZ )
   at bj230L.pkA.F(BV , pke )
   at bj230L.pkA.vW(pke , Boolean )
   at bj230L.pke.O(pcj , pwB , jdV , pwB , pwB , String )
   at bj230L.pke.P(BV , pwB , jdV , pwB , pwB )
   at bj230L.pcZ.u(String , BV , pkY , NY )
   at bj230L.pcZ.qp(BV , pkY , NY )
   at bj230L.hhd.m(BV , pkY , NY , heu )
   at bj230L.hej.kz()
   at bj230L.hXO.kz()
   at bj230L.hej.De(pcN )
   at bj230L.pkA.L(BV , pcZ )
   at bj230L.pkA.F(BV , pke )
   at bj230L.pkA.vW(pke , Boolean )
   at bj230L.pcY.H(pcY , pke )
   at bj230L.pcY.lY(pke )
   at bj230L.pOQ.K(pke )
   at bj230L.pOQ.P(pOQ , pke )
   at bj230L.pOQ.lY(pke )
   at bj230L.pOQ.lY(pke )
   at bj230L.pQS.rl(pke )
   at bj230L.tQ.n(pcN , tk )
   at bj230L.tQ.i(pcN , tk , pAl )
   at bj230L.jYt.vM()
   at bj230L.jYl.vM()
   at bj230L.up.d(IDataStatement , SQLQuery , QueryParameterCollection , Int32 , Object , pAl , Int32 , NX )
   at bj230L.jfd.Q(String , String , String )
   at bj230L.jfd.GetColumns(String , String , String , String )
   at bj230L.jfh.GetColumns(String , String , String , String )
   at bj230L.pVl.R(String , String , String , String )
   at bj230L.pVl.GetColumns(String , String , String , String )
   at bj230L.jiO.GetColumns(String , String , String , String )
   at bj230L.NS.GetColumns(String , String , String , String )
   at CData.Sql.ProxyIDataAccess.GetColumns(String catalog, String schema, String table, String column)
   at bj230L.kt.Nk.GetColumns(String , String , String , String )
   at bj230L.jej.GetColumns(String , String , String , String )
   at bj230L.Nj.GetColumns(String , String , String , String )
   at bj230L.kt.O(String , String , String , String , Rm )
   at bj230L.kt.GetColumns(String , String , String )
   at bj230L.jft.X(SqlTable , Boolean )
   at bj230L.jft.R(SqlTable , Boolean )
   at bj230L.jft.m(SqlColumn , Ap )
   at bj230L.Aj.rQ.Visit[U](SqlCollection`1 )
   at CData.Sql.SqlModifier.ModifyColumns(SqlStatement statement)
   at CData.Sql.SqlModifier.ModifyQueryStatement(SqlQueryStatement statement)
   at CData.Sql.SqlModifier.Modify(SqlStatement statement)
   at bj230L.Aj.rQ.Modify(SqlStatement )
   at CData.Sql.SqlModifier.Modify(SqlParser query)
   at bj230L.Aj.g(SqlParser , AB )
   at bj230L.jXf.ce()
   at bj230L.AB.cq()
   at bj230L.jXY.cq()
   at bj230L.jXf.cq()
   at bj230L.AB.qW(QueryParameterCollection )
   at bj230L.hfh.g(String , String , Boolean , Boolean , Boolean , Boolean )
   at bj230L.hfg.ReinitializeMetaData()
   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostReinitializeMetaData(IDTSManagedComponentWrapper100 wrapper)


------------------------------
ADDITIONAL INFORMATION:

[403] Forbidden error. HTTP protocol error. 403 Forbidden. (Microsoft.SqlServer.DTSPipelineWrap)

------------------------------
BUTTONS:

OK
------------------------------
 


  • Apprentice
  • Answer
  • January 16, 2025

Hi,

 

This error is related to the permissions you have when connecting to your Jira account. Can you set the following properties:

 

Logfile: “C:\Users\Public\log.txt

Verbosity: 3

 

Save the settings, then replicate the problem so that you see the same error again. Then you can send me the file which was created at C:\Users\Public\ in a private message.

 

The log can help me see what authentication settings you have and what API request is being sent to Jira that returns the 403 error. Log will not include any passwords or private tokens.

 

Please dont post the log here. Probably it will get removed.